Microsoft Excel module 1 & 2 quiz
fully solved & updated
What is the process of using the mouse to move or copy cells called?
- answer Drag and drop
Which Microsoft Excel feature automatically inserts data into a cell
that begins with the same characters as a previous entry? - answer
AutoComplete
What is the name of the list of frequently used Excel commands
available when a user right-clicks an item in the worksheet? -
answer Shortcut Menu
Alicia needs to delete the data in cell B5. Which command would she
select? - answer Clear
Alicia needs to move the data in cell B5 to cell E5. Which command
would she select? - answer Cut
Which command on the "Home Ribbon" allows data to be moved
from one worksheet location to another? - answer Cut
David wants to key the numbers 1 to 1,000 in Column A of his
spreadsheet. What command should he use to complete this task? -
answer AutoFill
Which term refers to a group of selected cells that may be
formatted, moved, copied or deleted as a group? - answer Range
In an Microsoft Excel worksheet, how do you change the width of a
column so that the widest entry will fit? - answer AutoFit
, Jennifer needs to identify the values in column B for a sales report.
Which type of entry should she use in the column header? - answer
Labels
Joyce has updated the data in an existing spreadsheet. Which
command would she select to preserve the data for future use? -
answer Save
In Microsoft Excel, which feature makes an exact replica of the cell
data and format while keeping the original cell intact? - answer
Copy
To help organize and identify Microsoft Excel files by providing
details about the files, which of the following would you use? -
answer Document Properties
Which command on the Fill options dialog box is the default option
if you enter a month or day? - answer Fill Series
Sharon's spreadsheet contains information about the number of
music downloads in F1:F25. F1:F25 represents a: - answer Range
When entering data into a cell, which keyboard key is used to
remove characters to the left of the insertion point? - answer
Backspace Key
John wants to print only the Inventory worksheet that he is
currently working on in his workbook. Which option should he
choose? - answer Print Active Sheet
Which tab on the ribbon do you select to view Backstage options? -
answer File
fully solved & updated
What is the process of using the mouse to move or copy cells called?
- answer Drag and drop
Which Microsoft Excel feature automatically inserts data into a cell
that begins with the same characters as a previous entry? - answer
AutoComplete
What is the name of the list of frequently used Excel commands
available when a user right-clicks an item in the worksheet? -
answer Shortcut Menu
Alicia needs to delete the data in cell B5. Which command would she
select? - answer Clear
Alicia needs to move the data in cell B5 to cell E5. Which command
would she select? - answer Cut
Which command on the "Home Ribbon" allows data to be moved
from one worksheet location to another? - answer Cut
David wants to key the numbers 1 to 1,000 in Column A of his
spreadsheet. What command should he use to complete this task? -
answer AutoFill
Which term refers to a group of selected cells that may be
formatted, moved, copied or deleted as a group? - answer Range
In an Microsoft Excel worksheet, how do you change the width of a
column so that the widest entry will fit? - answer AutoFit
, Jennifer needs to identify the values in column B for a sales report.
Which type of entry should she use in the column header? - answer
Labels
Joyce has updated the data in an existing spreadsheet. Which
command would she select to preserve the data for future use? -
answer Save
In Microsoft Excel, which feature makes an exact replica of the cell
data and format while keeping the original cell intact? - answer
Copy
To help organize and identify Microsoft Excel files by providing
details about the files, which of the following would you use? -
answer Document Properties
Which command on the Fill options dialog box is the default option
if you enter a month or day? - answer Fill Series
Sharon's spreadsheet contains information about the number of
music downloads in F1:F25. F1:F25 represents a: - answer Range
When entering data into a cell, which keyboard key is used to
remove characters to the left of the insertion point? - answer
Backspace Key
John wants to print only the Inventory worksheet that he is
currently working on in his workbook. Which option should he
choose? - answer Print Active Sheet
Which tab on the ribbon do you select to view Backstage options? -
answer File
