EXCEL IKM TEST 2025 WITH ACTUAL
CORRECT QUESTIONS AND VERIFIED
DETAILED ANSWERS |FREQUENTLY TESTED
QUESTIONS AND SOLUTIONS|ALREADY
GRADED A+|LATEST UPDATE |GUARANTEED
PASS
What is the order of operations used to evaluate formulas in Excel?
a) Multiplication, Parentheses, Exponents, Division, Addition, Subtraction
b) Exponents, Parentheses, Multiplication, Division, Addition, Subtraction
c) Parentheses, Exponents, Multiplication, Division, Addition, Subtraction
d) Division, Exponents, Parentheses, Multiplication, Addition, Subtraction
e) Exponents, Multiplication, Parentheses, Division, Addition, Subtraction
c (PEMDAS)
Select which of the following lists most accurately represent functions found in the Backstage
View in Excel (Backstage view is displayed when you click File tab on the Ribbon):
a) Save, Page Layout, Document Preview, Print, Recent Workbooks and Review.
b) Save, Save As, Open, Recent Print, Print Preview, Page Layout, Options and Access.
c) Save, Save As, Open, Close, Info, Recent Workbooks, Recent Places, New, Print and Options.
d) None of the above lists are entirely correct.
b
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.
1|Page
,c
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.
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
to it.
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?
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
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?
2|Page
, 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".
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.
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.
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
3|Page
CORRECT QUESTIONS AND VERIFIED
DETAILED ANSWERS |FREQUENTLY TESTED
QUESTIONS AND SOLUTIONS|ALREADY
GRADED A+|LATEST UPDATE |GUARANTEED
PASS
What is the order of operations used to evaluate formulas in Excel?
a) Multiplication, Parentheses, Exponents, Division, Addition, Subtraction
b) Exponents, Parentheses, Multiplication, Division, Addition, Subtraction
c) Parentheses, Exponents, Multiplication, Division, Addition, Subtraction
d) Division, Exponents, Parentheses, Multiplication, Addition, Subtraction
e) Exponents, Multiplication, Parentheses, Division, Addition, Subtraction
c (PEMDAS)
Select which of the following lists most accurately represent functions found in the Backstage
View in Excel (Backstage view is displayed when you click File tab on the Ribbon):
a) Save, Page Layout, Document Preview, Print, Recent Workbooks and Review.
b) Save, Save As, Open, Recent Print, Print Preview, Page Layout, Options and Access.
c) Save, Save As, Open, Close, Info, Recent Workbooks, Recent Places, New, Print and Options.
d) None of the above lists are entirely correct.
b
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.
1|Page
,c
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.
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
to it.
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?
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
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?
2|Page
, 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".
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.
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.
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
3|Page
