Excel IKM test Latest Update 2025-2026 100
Questions and 100% Verified Correct Answers
Guaranteed A+
. What is the purpose of LEFT or RIGHT formula? - CORRECT ANSWER: to extract
words from the left or right side of Cell
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. -
CORRECT ANSWER: b
A SmartArt graphic provides an audible representation of information. (T/F) - CORRECT
ANSWER: F
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. - CORRECT ANSWER: d
An Excel file is called a workbook? (T/F) - CORRECT ANSWER: T
Before printing a worksheet, you should preview it and check for spelling errors.
Completing these tasks before you print can save time and paper. (T/F) - CORRECT
ANSWER: T
Cell values can include numbers, text or formulas? (T/F) - CORRECT ANSWER: T
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
Entering =A7+A9 into cell will subtract the two cells? (T/F) - CORRECT ANSWER: F
Excel offers the "Spell Check" function? (T/F) - CORRECT ANSWER: T
Excel provides the following functions to be used except: a) AVERAGE b) MIN c) MAX
d) TOTAL - CORRECT ANSWER: d
How can you duplicate Excel Worksheet? - CORRECT ANSWER: right click on
worksheet > select Move or Copy
, How can you ensure that all the rows in an address list you created in Excel are the
same height?
a) To ensure that all the rows in the worksheet are the same height, use the Excel ruler
to set row and column tab stops.
b) It is not possible to make all rows in an Excel worksheet the same height.
c) Select all the rows or the whole worksheet and drag the row label line of any of the
selected rows downwards or upwards to adjust the row height.
d) In the Format group on the Ribbon select the Set Table Height option to ensure the
worksheet rows are the same height. - CORRECT ANSWER: c
How can you increase the font size for the selected cell in Excel from size from current
size to 105?
a) This option is not available since maximum font size in Excel is 72.
b) Press the Increase Font Increase button repeatedly until you reach 95.
c) Change font type to Times New Roman, since this is the only font that supports
sizesabove 72.
d) Type 105 into the Font size box and press Enter - CORRECT ANSWER: d
How can you protect Workbook in Excel and why you might consider doing it? -
CORRECT ANSWER: We can use the protect workbook option to prevent users from
viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and
renaming worksheets.
How to update data on a PivotTable after changing the data in database? - CORRECT
ANSWER: press a refresh button on pivotable because after that data will be update in
PivotTable
How user can check whether the Pivot Table is modified or not? - CORRECT ANSWER:
use the "PivotTableUpdate" in worksheet containing the Pivot Table
Questions and 100% Verified Correct Answers
Guaranteed A+
. What is the purpose of LEFT or RIGHT formula? - CORRECT ANSWER: to extract
words from the left or right side of Cell
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. -
CORRECT ANSWER: b
A SmartArt graphic provides an audible representation of information. (T/F) - CORRECT
ANSWER: F
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. - CORRECT ANSWER: d
An Excel file is called a workbook? (T/F) - CORRECT ANSWER: T
Before printing a worksheet, you should preview it and check for spelling errors.
Completing these tasks before you print can save time and paper. (T/F) - CORRECT
ANSWER: T
Cell values can include numbers, text or formulas? (T/F) - CORRECT ANSWER: T
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
Entering =A7+A9 into cell will subtract the two cells? (T/F) - CORRECT ANSWER: F
Excel offers the "Spell Check" function? (T/F) - CORRECT ANSWER: T
Excel provides the following functions to be used except: a) AVERAGE b) MIN c) MAX
d) TOTAL - CORRECT ANSWER: d
How can you duplicate Excel Worksheet? - CORRECT ANSWER: right click on
worksheet > select Move or Copy
, How can you ensure that all the rows in an address list you created in Excel are the
same height?
a) To ensure that all the rows in the worksheet are the same height, use the Excel ruler
to set row and column tab stops.
b) It is not possible to make all rows in an Excel worksheet the same height.
c) Select all the rows or the whole worksheet and drag the row label line of any of the
selected rows downwards or upwards to adjust the row height.
d) In the Format group on the Ribbon select the Set Table Height option to ensure the
worksheet rows are the same height. - CORRECT ANSWER: c
How can you increase the font size for the selected cell in Excel from size from current
size to 105?
a) This option is not available since maximum font size in Excel is 72.
b) Press the Increase Font Increase button repeatedly until you reach 95.
c) Change font type to Times New Roman, since this is the only font that supports
sizesabove 72.
d) Type 105 into the Font size box and press Enter - CORRECT ANSWER: d
How can you protect Workbook in Excel and why you might consider doing it? -
CORRECT ANSWER: We can use the protect workbook option to prevent users from
viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and
renaming worksheets.
How to update data on a PivotTable after changing the data in database? - CORRECT
ANSWER: press a refresh button on pivotable because after that data will be update in
PivotTable
How user can check whether the Pivot Table is modified or not? - CORRECT ANSWER:
use the "PivotTableUpdate" in worksheet containing the Pivot Table
