EXCEL IKM EXAM 2025/2026 BANK
COMPLETE EXAM QUESTIONS
WITH DETAILED VERIFIED AND
WELL RESEARCHED ANSWERS
(100% CORRECT ANSWERS)
/ALREADY GRADED A+
What is the name of area, highlighted in red, in pic 6?
a) Excel Ribbon
b) Excel Ribbon tabs
c) Excel Worksheets tabs
d) Excel Workbook tabs
e) Excel Quick Access Toolbar - ....ANSWER...b
What is the name of the area, highlighted in red, in the Pic
7:
a) Excel Name Box.
b) Excel Title Bar
c) Excel Formula Bar
1
,d) Excel Column Title
e) Excel Cell Details - ....ANSWER...c
What is the name objectives of the section, outlined in red,
in the Picture 8
a) This is the Excel Shortcut List, which provides quick
access only to recently used Excel functions.
b) This is the Quick Access Toolbar, which contains
shortcuts to Excel functions.
c) This is the Name Box, which displays the names of all
the Excel functions used on the Ribbon.
d) This is the File Menu, which displays all the functions
relating to saving, opening and closing a
workbook.
e) This is the Save Menu List, which provides quick access
only to very basic Excel functions. - ....ANSWER...b
What is the function of the small area, highlighted in red
in the image 9 (Red arrow points to the red area):
a) Clicking on this button hides Excel Ribbon
b) It is a decorative grouping in Excel: nothing happens
when this button is clicked
2
,c) Clicking on this button launches Excel Font dialog box
d) Clicking on this button increases the font size
e) Clicking on this button opens Help window, related to
Fonts in Excel - ....ANSWER...c
You can cut and paste data from one cell into another.
Instead of using the mouse to do the cut and paste, you
can use the keyboard. To cut press ; to paste,
press . - ....ANSWER...CTRL+X CTRL+V
What happens if you select a text in the cell and use
CTRL+U keyboard shortcut? - ....ANSWER...It
underlines the content of the selected cell
How would you minimize the ribbon with single mouse
click - ....ANSWER...Click ^ button
Pic 10. What would be the value returned by the
formula=VLOOKUP(839356, A2:E11,2,FALSE)
a) Eleonora Sunday
b)
c) $596.21
3
, d) Taina Gerke
e) - ....ANSWER...a
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)
4
COMPLETE EXAM QUESTIONS
WITH DETAILED VERIFIED AND
WELL RESEARCHED ANSWERS
(100% CORRECT ANSWERS)
/ALREADY GRADED A+
What is the name of area, highlighted in red, in pic 6?
a) Excel Ribbon
b) Excel Ribbon tabs
c) Excel Worksheets tabs
d) Excel Workbook tabs
e) Excel Quick Access Toolbar - ....ANSWER...b
What is the name of the area, highlighted in red, in the Pic
7:
a) Excel Name Box.
b) Excel Title Bar
c) Excel Formula Bar
1
,d) Excel Column Title
e) Excel Cell Details - ....ANSWER...c
What is the name objectives of the section, outlined in red,
in the Picture 8
a) This is the Excel Shortcut List, which provides quick
access only to recently used Excel functions.
b) This is the Quick Access Toolbar, which contains
shortcuts to Excel functions.
c) This is the Name Box, which displays the names of all
the Excel functions used on the Ribbon.
d) This is the File Menu, which displays all the functions
relating to saving, opening and closing a
workbook.
e) This is the Save Menu List, which provides quick access
only to very basic Excel functions. - ....ANSWER...b
What is the function of the small area, highlighted in red
in the image 9 (Red arrow points to the red area):
a) Clicking on this button hides Excel Ribbon
b) It is a decorative grouping in Excel: nothing happens
when this button is clicked
2
,c) Clicking on this button launches Excel Font dialog box
d) Clicking on this button increases the font size
e) Clicking on this button opens Help window, related to
Fonts in Excel - ....ANSWER...c
You can cut and paste data from one cell into another.
Instead of using the mouse to do the cut and paste, you
can use the keyboard. To cut press ; to paste,
press . - ....ANSWER...CTRL+X CTRL+V
What happens if you select a text in the cell and use
CTRL+U keyboard shortcut? - ....ANSWER...It
underlines the content of the selected cell
How would you minimize the ribbon with single mouse
click - ....ANSWER...Click ^ button
Pic 10. What would be the value returned by the
formula=VLOOKUP(839356, A2:E11,2,FALSE)
a) Eleonora Sunday
b)
c) $596.21
3
, d) Taina Gerke
e) - ....ANSWER...a
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)
4
