Excel IKM Test 2025, IKM Excel assessment, Excel
functions and formulas, data analysis exam, pivot tables,
Excel skills test, verified Excel answers
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
to it. - ans -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? - ans -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 - ans -c
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". - ans -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. -
ans -c
The following shortcut key combinations will allow you to Open, Close and create
a Newworkbook, respectively:
a) Pressing Alt + O to Open, Alt + C to Close, Alt + N for New.
b) Pressing Control + O for Open, Control + C for Close, Control + N for New.
c) Pressing Control + O for Open, Control + W for Close, Control + N for New.
d) None of the above options are correct. - ans -c
Mikhala made some changes to a workbook called "Sept 2018". She then clicked
Save As, typed"Sept_2018_New" in the File Name box and clicked Save. Which of
the following statements are true?
a) The changes Lucy made to "Sept 2014" will be reflected in the new
workbook,"Sept_2019_New" only.
b) The changes Lucy made will be reflected in both versions, "Sept 2014" and
"Sept_2019_New".
c) By using the Save As function Lucy replaced the file "Sept 2014" with
"Sept_2019_New". The original file no longer exists.
d) The changes Lucy made will stay in "Sept 2014" and will not be reflected
in"Sept_2019_New". - ans -a
Which of the following functions is NOT associated with the Review Tab on the
Ribbon?
a) The spelling checker.
b) The sort data function.
, c) The comment function.
d) The track changes function. - ans -b
Allen is using a colleague's PC. He is curious as to how much his colleague earns
and when he sees a folder with the title "Budget", he decides to snoop. He opens
the folder and views a few of the workbooks in this folder. Will his colleague be
able to know he snooped, and if yes, how?
a) No, Ben is safe. Unless his colleague is an IT specialist, he will never find out.
b) Yes, if his colleague presses the Data tab on the Ribbon, this will reveal a list of
recently displayed documents.
c) No, Excel automatically deletes recently access workbook and file history if you
close and shutdown the PC.
d) Yes, if his colleague opens the Backstage View and go to the Recent Workbooks
and RecentPlaces area. - ans -d
Which shortcut key combination can be used to insert the current date into a cell?
Ctrl+... - ans -;
A client emails you and informs you that they were unable to open a workbook
you sent them as they still use MS Excel 2010. Which of the following options will
quickly resolve this issue and allow the client to open the workbook?
a) They will need to install MS Excel 2010 or use someone else's software in order
to open the workbook.
b) You can use the Save As function to select a Save As Type: Excel 2010
Workbook.
c) If you open the workbook, you can go to the client and copy and paste all the
content into their version of Excel.
d) If you rename your workbook: "Excel 2003", this will allow the client to open
the file. - ans -b
Excel provides the following functions to be used except: a) AVERAGE b) MIN c)
MAX d) TOTAL - ans -d
If you look at a worksheet and cannot see certain columns, it is probably because
the worksheethas ___ columns.
a) Hidden
b) Unhidden
functions and formulas, data analysis exam, pivot tables,
Excel skills test, verified Excel answers
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
to it. - ans -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? - ans -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 - ans -c
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". - ans -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. -
ans -c
The following shortcut key combinations will allow you to Open, Close and create
a Newworkbook, respectively:
a) Pressing Alt + O to Open, Alt + C to Close, Alt + N for New.
b) Pressing Control + O for Open, Control + C for Close, Control + N for New.
c) Pressing Control + O for Open, Control + W for Close, Control + N for New.
d) None of the above options are correct. - ans -c
Mikhala made some changes to a workbook called "Sept 2018". She then clicked
Save As, typed"Sept_2018_New" in the File Name box and clicked Save. Which of
the following statements are true?
a) The changes Lucy made to "Sept 2014" will be reflected in the new
workbook,"Sept_2019_New" only.
b) The changes Lucy made will be reflected in both versions, "Sept 2014" and
"Sept_2019_New".
c) By using the Save As function Lucy replaced the file "Sept 2014" with
"Sept_2019_New". The original file no longer exists.
d) The changes Lucy made will stay in "Sept 2014" and will not be reflected
in"Sept_2019_New". - ans -a
Which of the following functions is NOT associated with the Review Tab on the
Ribbon?
a) The spelling checker.
b) The sort data function.
, c) The comment function.
d) The track changes function. - ans -b
Allen is using a colleague's PC. He is curious as to how much his colleague earns
and when he sees a folder with the title "Budget", he decides to snoop. He opens
the folder and views a few of the workbooks in this folder. Will his colleague be
able to know he snooped, and if yes, how?
a) No, Ben is safe. Unless his colleague is an IT specialist, he will never find out.
b) Yes, if his colleague presses the Data tab on the Ribbon, this will reveal a list of
recently displayed documents.
c) No, Excel automatically deletes recently access workbook and file history if you
close and shutdown the PC.
d) Yes, if his colleague opens the Backstage View and go to the Recent Workbooks
and RecentPlaces area. - ans -d
Which shortcut key combination can be used to insert the current date into a cell?
Ctrl+... - ans -;
A client emails you and informs you that they were unable to open a workbook
you sent them as they still use MS Excel 2010. Which of the following options will
quickly resolve this issue and allow the client to open the workbook?
a) They will need to install MS Excel 2010 or use someone else's software in order
to open the workbook.
b) You can use the Save As function to select a Save As Type: Excel 2010
Workbook.
c) If you open the workbook, you can go to the client and copy and paste all the
content into their version of Excel.
d) If you rename your workbook: "Excel 2003", this will allow the client to open
the file. - ans -b
Excel provides the following functions to be used except: a) AVERAGE b) MIN c)
MAX d) TOTAL - ans -d
If you look at a worksheet and cannot see certain columns, it is probably because
the worksheethas ___ columns.
a) Hidden
b) Unhidden
