EXCEL IKM CORE REVIEW QUESTIONS AND
ANSWERS SET A+
✔✔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. - ✔✔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". - ✔✔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. - ✔✔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. - ✔✔d
✔✔Which shortcut key combination can be used to insert the current date into a cell?
Ctrl+... - ✔✔;
✔✔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. -
✔✔b
✔✔Excel provides the following functions to be used except: a) AVERAGE b) MIN c)
MAX d) TOTAL - ✔✔d
✔✔If you look at a worksheet and cannot see certain columns, it is probably because
the worksheethas ___ columns.
a) Hidden
b) Unhidden
c) Deleted
d) Cut
e) Deprioritized - ✔✔a
✔✔Which of the following tabs you will find on Excel's ribbon?
a) The Insert tab, the Page tab and the Formulas tab.
b) The Insert tab, Functions tab, Review tab and View tab
c) The Home tab, the Page Alignment tab, the Data tab and the View tab.
d) The Home tab, the Formulas tab and the VBA tab.
e) All the options listed above are tabs on the Excel 2019 Ribbon. - ✔✔b
✔✔What is the function of Format Painter in Microsoft Excel?
a) It deletes all formatting in a worksheet
.b) It formats excel worksheet by erasing all content.
ANSWERS SET A+
✔✔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. - ✔✔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". - ✔✔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. - ✔✔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. - ✔✔d
✔✔Which shortcut key combination can be used to insert the current date into a cell?
Ctrl+... - ✔✔;
✔✔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. -
✔✔b
✔✔Excel provides the following functions to be used except: a) AVERAGE b) MIN c)
MAX d) TOTAL - ✔✔d
✔✔If you look at a worksheet and cannot see certain columns, it is probably because
the worksheethas ___ columns.
a) Hidden
b) Unhidden
c) Deleted
d) Cut
e) Deprioritized - ✔✔a
✔✔Which of the following tabs you will find on Excel's ribbon?
a) The Insert tab, the Page tab and the Formulas tab.
b) The Insert tab, Functions tab, Review tab and View tab
c) The Home tab, the Page Alignment tab, the Data tab and the View tab.
d) The Home tab, the Formulas tab and the VBA tab.
e) All the options listed above are tabs on the Excel 2019 Ribbon. - ✔✔b
✔✔What is the function of Format Painter in Microsoft Excel?
a) It deletes all formatting in a worksheet
.b) It formats excel worksheet by erasing all content.
