1|Page
EXCEL IKM EXAM 2025/2026 BANK COMPLETE EXAM
QUESTIONS WITH DETAILED VERIFIED ANSWERS
(100% CORRECT ANSWERS) /ALREADY GRADED A+
Selecting multiple columns, especially if they run into the
hundreds or thousands, can take a long time if you do this the
manual way by using your mouse. What is a shortcut for quickly
selecting a range of contiguous columns?
a) Select the first column. Hold down Ctrl and press the right
arrow on the keyboard.
b) Select the first column. Hold down Ctrl and drag the mouse
cursor towards the right.
c) Select the first column. Hold down Shift and press the right
arrow on the keyboard.
d) All of the above options are correct. ......answer.....c
,2|Page
Which of the following functions are you likely to find under the
Insert tab on the Ribbon?
a) Insert a page break.
b) Insert a formula.
c) Insert a table.
d) Insert track changes. ......answer.....c
The Recent Workbooks list located in the Backstage View shows all
workbooks recently opened. What action can I take to ensure a
workbook remains on this list regardless of how many workbooks I
opened subsequent to opening this workbook?
a) I can save the Workbook to the Recent Workbooks folder.
b) By adding the Workbook to My Favorites on the Quick Access
Toolbar.
c) The Recent Workbooks list automatically keeps all workbooks
that have been opened and I do
not need to do anything.
d) By 'pinning' the workbook to the Recent Workbooks list by
clicking the pin icon located next
,3|Page
to it. ......answer.....d
What is the keyboard shortcut to select a row of active cells?
a) Ctrl + Spacebar
b) Shift + Spacebar
c) Shift + End
d) Ctrl + End? ......answer.....b
Most workbooks in Excel contain multiple worksheets (noted on
the tabs at the bottom righthand side of the Excel screen). Which
of the following is the keyboard shortcut to for switching between
worksheets in Microsoft Excel?
a) Alt+Tab
b) Alt+PgDn/PgDn
c) Ctrl+PgDn/PgUp
d) Ctrl+UpArrow/DownArrow ......answer.....c
, 4|Page
Jason has a workbook open that his colleague created. The
workbook is titled: "Management Budget". John wants to use this
workbook as a base for creating a workbook called "Project
Management". Which of the following is the correct sequence of
actions for him to take?
a) File Tab - Save - File Name - "Project Management" - Save.
b) File Tab - Save As - File Name - "Project Management" - Save.
c) File Tab - Save New - File Name - "Project Management" - Save.
d) File Tab - Save As - File Name - "Management Budget" - Save as
Type - "Project
Management". ......answer.....b
What happens when you select cells and press Ctrl+2?
a) Text in the selected cells are underlined.
b) Italic formatting is applied to the text in the selected cells.
c) Bold formatting is applied to the text in the selected cells.
d) A duplicate of the selected cells will be inserted directly below
the selection. ......answer.....c
EXCEL IKM EXAM 2025/2026 BANK COMPLETE EXAM
QUESTIONS WITH DETAILED VERIFIED ANSWERS
(100% CORRECT ANSWERS) /ALREADY GRADED A+
Selecting multiple columns, especially if they run into the
hundreds or thousands, can take a long time if you do this the
manual way by using your mouse. What is a shortcut for quickly
selecting a range of contiguous columns?
a) Select the first column. Hold down Ctrl and press the right
arrow on the keyboard.
b) Select the first column. Hold down Ctrl and drag the mouse
cursor towards the right.
c) Select the first column. Hold down Shift and press the right
arrow on the keyboard.
d) All of the above options are correct. ......answer.....c
,2|Page
Which of the following functions are you likely to find under the
Insert tab on the Ribbon?
a) Insert a page break.
b) Insert a formula.
c) Insert a table.
d) Insert track changes. ......answer.....c
The Recent Workbooks list located in the Backstage View shows all
workbooks recently opened. What action can I take to ensure a
workbook remains on this list regardless of how many workbooks I
opened subsequent to opening this workbook?
a) I can save the Workbook to the Recent Workbooks folder.
b) By adding the Workbook to My Favorites on the Quick Access
Toolbar.
c) The Recent Workbooks list automatically keeps all workbooks
that have been opened and I do
not need to do anything.
d) By 'pinning' the workbook to the Recent Workbooks list by
clicking the pin icon located next
,3|Page
to it. ......answer.....d
What is the keyboard shortcut to select a row of active cells?
a) Ctrl + Spacebar
b) Shift + Spacebar
c) Shift + End
d) Ctrl + End? ......answer.....b
Most workbooks in Excel contain multiple worksheets (noted on
the tabs at the bottom righthand side of the Excel screen). Which
of the following is the keyboard shortcut to for switching between
worksheets in Microsoft Excel?
a) Alt+Tab
b) Alt+PgDn/PgDn
c) Ctrl+PgDn/PgUp
d) Ctrl+UpArrow/DownArrow ......answer.....c
, 4|Page
Jason has a workbook open that his colleague created. The
workbook is titled: "Management Budget". John wants to use this
workbook as a base for creating a workbook called "Project
Management". Which of the following is the correct sequence of
actions for him to take?
a) File Tab - Save - File Name - "Project Management" - Save.
b) File Tab - Save As - File Name - "Project Management" - Save.
c) File Tab - Save New - File Name - "Project Management" - Save.
d) File Tab - Save As - File Name - "Management Budget" - Save as
Type - "Project
Management". ......answer.....b
What happens when you select cells and press Ctrl+2?
a) Text in the selected cells are underlined.
b) Italic formatting is applied to the text in the selected cells.
c) Bold formatting is applied to the text in the selected cells.
d) A duplicate of the selected cells will be inserted directly below
the selection. ......answer.....c
