Excel Practice Test UPDATED Actual
Exam Questions and CORRECT Answers
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select? -
CORRECT ANSWER✔✔- Open
Which command among the window control buttons is used to close an open file and
completely exit the Microsoft Excel program? - CORRECT ANSWER✔✔- Close
Which ribbon option opens a related dialog box? - CORRECT ANSWER✔✔- Launcher
What command do you you to increase or decrease the view of a selected cell or range of
cells to fill the Excel Window area for better visibility? - CORRECT ANSWER✔✔- Zoom
to Selection
What occurs when the cursor is moved over a cell and a user clicks? - CORRECT
ANSWER✔✔- The cell is selected
What feature was created for users who prefer to use the keyboard rather than the mouse, and
provides keyboard code icons that may be used in conjunction with the ALT key? -
CORRECT ANSWER✔✔- Key Tips
Which notebook-like feature organizes the sheets for use in Excel? - CORRECT
ANSWER✔✔- Workbook
Which view is the default view used in Microsoft Excel? - CORRECT ANSWER✔✔-
Normal
Sharon's spreadsheet contains information about the number of music downloads in F25. In
this address, '25' identifies the: - CORRECT ANSWER✔✔- row
What command will arranged Microsoft Excel windows so that they appear side-by-side on
the screen? - CORRECT ANSWER✔✔- Arrange All
, What is the name of the list of frequently used Excel commands available when a user right-
clicks an item in the worksheet? - CORRECT ANSWER✔✔- Shortcut Menu
Which command on the Home ribbon allows data to be moved from one worksheet location
to another? - CORRECT ANSWER✔✔- Cut
What is the process of using the mouse to move or copy cells called? - CORRECT
ANSWER✔✔- Drag and Drop
John wants to print only the Inventory worksheet that he is currently working on in his
workbook. Which option should he choose? - CORRECT ANSWER✔✔- Print Active Sheet
Which command on the Fill options dialog box is the default option if a month or day is
entered? - CORRECT ANSWER✔✔- Fill Series
Alicia needs to delete the data in cells B5. Which command would she select - CORRECT
ANSWER✔✔- Clear
Which would be used to help organize and identify Microsoft Excel files by providing details
about the files? - CORRECT ANSWER✔✔- Document properties
When entering data into a cell, which keyboard key is used to remove characters to the left of
the insertion point? - CORRECT ANSWER✔✔- Backspace Key
What is the name of the small black square in the lower-right corner of the heavy border of an
active cell that repeats a cell's value in adjacent cells? - CORRECT ANSWER✔✔- Fill
Handle
Joyce has updated the data in an existing spreadsheet. Which command would she select to
preserve the data for future use? - CORRECT ANSWER✔✔- Save
Exam Questions and CORRECT Answers
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select? -
CORRECT ANSWER✔✔- Open
Which command among the window control buttons is used to close an open file and
completely exit the Microsoft Excel program? - CORRECT ANSWER✔✔- Close
Which ribbon option opens a related dialog box? - CORRECT ANSWER✔✔- Launcher
What command do you you to increase or decrease the view of a selected cell or range of
cells to fill the Excel Window area for better visibility? - CORRECT ANSWER✔✔- Zoom
to Selection
What occurs when the cursor is moved over a cell and a user clicks? - CORRECT
ANSWER✔✔- The cell is selected
What feature was created for users who prefer to use the keyboard rather than the mouse, and
provides keyboard code icons that may be used in conjunction with the ALT key? -
CORRECT ANSWER✔✔- Key Tips
Which notebook-like feature organizes the sheets for use in Excel? - CORRECT
ANSWER✔✔- Workbook
Which view is the default view used in Microsoft Excel? - CORRECT ANSWER✔✔-
Normal
Sharon's spreadsheet contains information about the number of music downloads in F25. In
this address, '25' identifies the: - CORRECT ANSWER✔✔- row
What command will arranged Microsoft Excel windows so that they appear side-by-side on
the screen? - CORRECT ANSWER✔✔- Arrange All
, What is the name of the list of frequently used Excel commands available when a user right-
clicks an item in the worksheet? - CORRECT ANSWER✔✔- Shortcut Menu
Which command on the Home ribbon allows data to be moved from one worksheet location
to another? - CORRECT ANSWER✔✔- Cut
What is the process of using the mouse to move or copy cells called? - CORRECT
ANSWER✔✔- Drag and Drop
John wants to print only the Inventory worksheet that he is currently working on in his
workbook. Which option should he choose? - CORRECT ANSWER✔✔- Print Active Sheet
Which command on the Fill options dialog box is the default option if a month or day is
entered? - CORRECT ANSWER✔✔- Fill Series
Alicia needs to delete the data in cells B5. Which command would she select - CORRECT
ANSWER✔✔- Clear
Which would be used to help organize and identify Microsoft Excel files by providing details
about the files? - CORRECT ANSWER✔✔- Document properties
When entering data into a cell, which keyboard key is used to remove characters to the left of
the insertion point? - CORRECT ANSWER✔✔- Backspace Key
What is the name of the small black square in the lower-right corner of the heavy border of an
active cell that repeats a cell's value in adjacent cells? - CORRECT ANSWER✔✔- Fill
Handle
Joyce has updated the data in an existing spreadsheet. Which command would she select to
preserve the data for future use? - CORRECT ANSWER✔✔- Save
