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 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
,2|Page
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
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
, 3|Page
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
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 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
,2|Page
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
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
, 3|Page
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
