Excel Assessment – Practice questions with answers.

Excel Assessment – Practice questions with |\ |\ |\ |\ |\ |\




answers


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. - CORRECT ANSWERS ✔✔c
|\ |\ |\ |\ |\




The following shortcut key combinations will allow you to Open,
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\



Close and create a New workbook, 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. - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



✔✔c

,What is the keyboard shortcut for reversing (undoing) your last
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\



action?


a) Ctrl+U
|\




b) Ctrl+Z
|\




c) Ctrl+X
|\




d) Ctrl+Y - CORRECT ANSWERS ✔✔b
|\ |\ |\ |\ |\




Mikhala made some changes to a workbook called "Sept 2014". She
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



then clicked Save As, typed "Sept_2014_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". - CORRECT ANSWERS ✔✔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. - CORRECT ANSWERS ✔✔b
|\ |\ |\ |\ |\ |\ |\ |\




Selecting multiple columns, especially if they run into the hundreds,
|\ |\ |\ |\ |\ |\ |\ |\ |\



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. - CORRECT ANSWERS ✔✔c
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\




Select which of the following lists most accurately represent
|\ |\ |\ |\ |\ |\ |\ |\ |\



functions found in the Backstage View in Excel:
|\ |\ |\ |\ |\ |\ |\