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 shortcut key combination of Paste special?
a) CTRL + V
b) CTRL + ALT + V
c) CTRL + A
d) CTRL + Shift + V - CORRECT 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.
c) Data Validation is used to apply control (what we want to enter in a cell)
d) None of the above - CORRECT 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.
,2|Page
c) Flash fill is used to generate values.
d) None of the above - CORRECT ANSWER✔✔ b
On which tab you can locate Grouping and Ungrouping option?
a) View Tab
b) Review Tab
c) Data Tab
d) Formula Tab - CORRECT 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 - CORRECT 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
, 3|Page
b) = SUMPRODUCT
c) = SUMIFS
d) = DSUM - CORRECT ANSWER✔✔ a
Determine what is the correct name for the areas, highlighted in red in the
image 1?
a) These are the Excel Formula Bar addresses.
b) These are the Excel column and row labels.
c) These are the Excel Ribbon function groups.
d) These are Excel Grid headers.
e) All the above options are incorrect. - CORRECT ANSWER✔✔ b
What is the correct name of the area outlined in yellow in the image 2?
a) Excel formula Bar
b) Excel Cell Address Bar
c) Excel Address Bar
d) Excel Column and Row Address
e) Excel Name Box - CORRECT ANSWER✔✔ e
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 shortcut key combination of Paste special?
a) CTRL + V
b) CTRL + ALT + V
c) CTRL + A
d) CTRL + Shift + V - CORRECT 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.
c) Data Validation is used to apply control (what we want to enter in a cell)
d) None of the above - CORRECT 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.
,2|Page
c) Flash fill is used to generate values.
d) None of the above - CORRECT ANSWER✔✔ b
On which tab you can locate Grouping and Ungrouping option?
a) View Tab
b) Review Tab
c) Data Tab
d) Formula Tab - CORRECT 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 - CORRECT 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
, 3|Page
b) = SUMPRODUCT
c) = SUMIFS
d) = DSUM - CORRECT ANSWER✔✔ a
Determine what is the correct name for the areas, highlighted in red in the
image 1?
a) These are the Excel Formula Bar addresses.
b) These are the Excel column and row labels.
c) These are the Excel Ribbon function groups.
d) These are Excel Grid headers.
e) All the above options are incorrect. - CORRECT ANSWER✔✔ b
What is the correct name of the area outlined in yellow in the image 2?
a) Excel formula Bar
b) Excel Cell Address Bar
c) Excel Address Bar
d) Excel Column and Row Address
e) Excel Name Box - CORRECT ANSWER✔✔ e
