NEW
Font size
WorksheetsExcel Domain 1 Review
Total questions: 22
Worksheet time: 11mins
What shortcut key can you use to open an existing Excel workbook?
Ctrl + Alt + O
Ctrl +O
Shift + O
Ctrl + Shift + O
Which area of the Excel application has the following three commands: Save, Undo, and Redo?
Status Toolbar
Mini Toolbar
Quick Access Toolbar
Formula Toolbar
How can you access Backstage view?
Windows key
Select File
Select Home
Ctrl + B
What will the keyboard shortcut Ctrl+N do?
Open a new worksheet
Open a new folder
Open a new workbook
Open an existing workbook
Where will you find the formula bar?
File > Open
File > Options
Directly below the ribbon
On the Quick Access Toolbar
If you double-click a ribbon tab twice, what happens to the ribbon?
It disappears
It will show tabs only
It will auto hide
It will move to the bottom of the screen
When you access File > Open, you can switch between workbooks and __________________.
worksheets
other Office documents
folders
formulas
When you are in the Excel application, what method can you use to save an existing workbook with a different name?
File > Save As
File > Save
File > Options
File > New
If you save an Excel workbook as a 97-2003 version, what will the file extension be?
.xlsx
.xlxs
.xlt
.xls
By default, when you select Enter to complete a cell entry, where will the active cell be?
In the row below
In the row above
In the next cell to the left
In the next cell to the right
When you enter data into a cell, where else on-screen will what you have entered display?
The cell below
The cell above
The ribbon
The formula bar
Which format can a workbook be saved in?
.xlsx
.xlxs
.xlt
.xlw
Which statement is true?
There is no difference between using Convert or using Save As to upgrade a workbook to the latest version of Excel.
Converting a file replaces the old version file with a new version file, leaving one copy.
A file saved in an older version of Excel cannot be opened in Excel 2019.
Older Excel files will be slightly corrupted when open in Excel 2019.
The _________________________ key moves one cell position to the right of the currently selected cell.
tab
enter
right arrow
ricght
The box directly under the ribbon, on the left side of the screen, is known as the __________________ box.
formula
identifier
name
file
What is the keyboard shortcut to go to elements of a workbook?
Ctrl+E or F1
Ctrl+F or F7
Ctrl+G or F5
Ctrl+X or F3
If cell A1 contained the number 1 and you used AutoFill to fill the cells automatically down to A20, what number would be in cell A20?
1
2
10
20
If cell A1 contained January and you used AutoFill to fill the cells automatically across to L1, the contents of L1 would be __________________________.
November
December
January
February
What is the keyboard shortcut to search for data in a workbook?
Ctrl+E
Ctrl+F
Ctrl+G
F5
When a cell or a range has a defined name, what is that known as?
Range Defined
Named Range
Range
Defined Cells
Which of the following shortcuts can you use to highlight cells containing formulas?
Ctrl+G or F5
Ctrl+F or F6
Ctrl+R or F7
Ctrl+X or F8
Which is the correct shortcut to access the Replace feature?
Ctrl+G
Ctrl+H
Ctrl+R
Ctrl+I
