1|Page
EXCEL IKM TEST 2025, IKM EXCEL ASSESSMENT, EXCEL
FUNCTIONS AND FORMULAS, DATA ANALYSIS EXAM, PIVOT
TABLES, EXCEL SKILLS TEST, VERIFIED EXCEL ANSWERS
What is the purpose of CONCATENATE and & functions? - ANSWER-merge any two or more than
two words in a cell
What is the purpose of TEXT formula? - ANSWER-to change the format of any word into TEXT
Using which function you can convert data in upper/lower case letter? - ANSWER-
UPPER/LOWER
What statement below is relevant to Pivot Table?
a) PIVOT TABLE is used to summarize data
b) PIVOT TABLE is used to find data
c) PIVOT TABLE is used for formatting of the data
d) None of the above. - ANSWER-a
What is the shortcut key combination of Paste special?
a) CTRL + V
b) CTRL + ALT + V
c) CTRL + A
d) CTRL + Shift + V - ANSWER-b
What is the purpose of data validation in Excel?
a) Data Validation is used to calculate the data.
b) Data Validation is used to find the data.
,2|Page
c) Data Validation is used to apply control (what we want to enter in a cell)
d) None of the above - ANSWER-c
What is the purpose of flash fill?
a) Flash fill is used to enter data.
b) Flash fill is used for, auto fill a value based on the patterns of the data you entered before.
c) Flash fill is used to generate values.
d) None of the above - ANSWER-b
On which tab you can locate Grouping and Ungrouping option?
a) View Tab
b) Review Tab
c) Data Tab
d) Formula Tab - ANSWER-c
Which of below path should we follow to locate the option select "Visible cells" only?
a) Home tab > Find and select > Go to
b) Home tab > Find and select > Go to special
c) Home tab > Find and select > Data validation
d) Home tab > Find and select > Constants - ANSWER-b
Which formula can be used to calculate total sales which we can find by multiplying individual
unit sold by unit price for every row across the range C2:D17? (Image 3)
a) = SUMIF
b) = SUMPRODUCT
, 3|Page
c) = SUMIFS
d) = DSUM - ANSWER-a
When selecting the "Margins" your selection is only applicable to the left and right side of the
Worksheet (True/False) - ANSWER-F
You can rename the Excel Sheet on the bottom left corner (True/False) - ANSWER-T
You can make text bold or italic in Excel cell? (True/False) - ANSWER-T
Cell values can include numbers, text or formulas? (T/F) - ANSWER-T
An Excel file is called a workbook? (T/F) - ANSWER-T
If you press the "Tab" key it moves one cell to the left (T/F) - ANSWER-F
Using "Wrap Test" function automatically adjusts row height to accommodate the size of data in
a row. (T/F) - ANSWER-T
you can insert a row by right clicking a column heading (T/F) - ANSWER-F
A SmartArt graphic provides an audible representation of information. (T/F) - ANSWER-F
The "Fill handle" is a small square in the lower-left corner of a selected cell or range of cells.
(T/F) - ANSWER-T
Entering =A7+A9 into cell will subtract the two cells? (T/F) - ANSWER-F
EXCEL IKM TEST 2025, IKM EXCEL ASSESSMENT, EXCEL
FUNCTIONS AND FORMULAS, DATA ANALYSIS EXAM, PIVOT
TABLES, EXCEL SKILLS TEST, VERIFIED EXCEL ANSWERS
What is the purpose of CONCATENATE and & functions? - ANSWER-merge any two or more than
two words in a cell
What is the purpose of TEXT formula? - ANSWER-to change the format of any word into TEXT
Using which function you can convert data in upper/lower case letter? - ANSWER-
UPPER/LOWER
What statement below is relevant to Pivot Table?
a) PIVOT TABLE is used to summarize data
b) PIVOT TABLE is used to find data
c) PIVOT TABLE is used for formatting of the data
d) None of the above. - ANSWER-a
What is the shortcut key combination of Paste special?
a) CTRL + V
b) CTRL + ALT + V
c) CTRL + A
d) CTRL + Shift + V - ANSWER-b
What is the purpose of data validation in Excel?
a) Data Validation is used to calculate the data.
b) Data Validation is used to find the data.
,2|Page
c) Data Validation is used to apply control (what we want to enter in a cell)
d) None of the above - ANSWER-c
What is the purpose of flash fill?
a) Flash fill is used to enter data.
b) Flash fill is used for, auto fill a value based on the patterns of the data you entered before.
c) Flash fill is used to generate values.
d) None of the above - ANSWER-b
On which tab you can locate Grouping and Ungrouping option?
a) View Tab
b) Review Tab
c) Data Tab
d) Formula Tab - ANSWER-c
Which of below path should we follow to locate the option select "Visible cells" only?
a) Home tab > Find and select > Go to
b) Home tab > Find and select > Go to special
c) Home tab > Find and select > Data validation
d) Home tab > Find and select > Constants - ANSWER-b
Which formula can be used to calculate total sales which we can find by multiplying individual
unit sold by unit price for every row across the range C2:D17? (Image 3)
a) = SUMIF
b) = SUMPRODUCT
, 3|Page
c) = SUMIFS
d) = DSUM - ANSWER-a
When selecting the "Margins" your selection is only applicable to the left and right side of the
Worksheet (True/False) - ANSWER-F
You can rename the Excel Sheet on the bottom left corner (True/False) - ANSWER-T
You can make text bold or italic in Excel cell? (True/False) - ANSWER-T
Cell values can include numbers, text or formulas? (T/F) - ANSWER-T
An Excel file is called a workbook? (T/F) - ANSWER-T
If you press the "Tab" key it moves one cell to the left (T/F) - ANSWER-F
Using "Wrap Test" function automatically adjusts row height to accommodate the size of data in
a row. (T/F) - ANSWER-T
you can insert a row by right clicking a column heading (T/F) - ANSWER-F
A SmartArt graphic provides an audible representation of information. (T/F) - ANSWER-F
The "Fill handle" is a small square in the lower-left corner of a selected cell or range of cells.
(T/F) - ANSWER-T
Entering =A7+A9 into cell will subtract the two cells? (T/F) - ANSWER-F
