wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Domain 1 Review

Total questions: 22

Worksheet time: 11mins

Name
Class
Date
1.

What shortcut key can you use to open an existing Excel workbook?

a)

Ctrl + Alt + O

b)

Ctrl +O

c)

Shift + O

d)

Ctrl + Shift + O

2.

Which area of the Excel application has the following three commands: Save, Undo, and Redo?

a)

Status Toolbar

b)

Mini Toolbar

c)

Quick Access Toolbar

d)

Formula Toolbar

3.

How can you access Backstage view?

a)

Windows key

b)

Select File

c)

Select Home

d)

Ctrl + B

4.

What will the keyboard shortcut Ctrl+N do?

a)

Open a new worksheet

b)

Open a new folder

c)

Open a new workbook

d)

Open an existing workbook

5.

Where will you find the formula bar?

a)

File > Open

b)

File > Options

c)

Directly below the ribbon

d)

On the Quick Access Toolbar

6.

If you double-click a ribbon tab twice, what happens to the ribbon?

a)

It disappears

b)

It will show tabs only

c)

It will auto hide

d)

It will move to the bottom of the screen

7.

When you access File > Open, you can switch between workbooks and __________________.

a)

worksheets

b)

other Office documents

c)

folders

d)

formulas

8.

When you are in the Excel application, what method can you use to save an existing workbook with a different name?

a)

File > Save As

b)

File > Save

c)

File > Options

d)

File > New

9.

If you save an Excel workbook as a 97-2003 version, what will the file extension be?

a)

.xlsx

b)

.xlxs

c)

.xlt

d)

.xls

10.

By default, when you select Enter to complete a cell entry, where will the active cell be?

a)

In the row below

b)

In the row above

c)

In the next cell to the left

d)

In the next cell to the right

11.

When you enter data into a cell, where else on-screen will what you have entered display?

a)

The cell below

b)

The cell above

c)

The ribbon

d)

The formula bar

12.

Which format can a workbook be saved in?

a)

.xlsx

b)

.xlxs

c)

.xlt

d)

.xlw

13.

Which statement is true?

a)

There is no difference between using Convert or using Save As to upgrade a workbook to the latest version of Excel.

b)

Converting a file replaces the old version file with a new version file, leaving one copy.

c)

A file saved in an older version of Excel cannot be opened in Excel 2019.

d)

Older Excel files will be slightly corrupted when open in Excel 2019.

14.

The _________________________ key moves one cell position to the right of the currently selected cell.

a)

tab

b)

enter

c)

right arrow

d)

ricght

15.

The box directly under the ribbon, on the left side of the screen, is known as the __________________ box.

a)

formula

b)

identifier

c)

name

d)

file

16.

What is the keyboard shortcut to go to elements of a workbook?

a)

Ctrl+E or F1

b)

Ctrl+F or F7

c)

Ctrl+G or F5

d)

Ctrl+X or F3

17.

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?

a)

1

b)

2

c)

10

d)

20

18.

If cell A1 contained January and you used AutoFill to fill the cells automatically across to L1, the contents of L1 would be __________________________.

a)

November

b)

December

c)

January

d)

February

19.

What is the keyboard shortcut to search for data in a workbook?

a)

Ctrl+E

b)

Ctrl+F

c)

Ctrl+G

d)

F5

20.

When a cell or a range has a defined name, what is that known as?

a)

Range Defined

b)

Named Range

c)

Range

d)

Defined Cells

21.

Which of the following shortcuts can you use to highlight cells containing formulas?

a)

Ctrl+G or F5

b)

Ctrl+F or F6

c)

Ctrl+R or F7

d)

Ctrl+X or F8

22.

Which is the correct shortcut to access the Replace feature?

a)

Ctrl+G

b)

Ctrl+H

c)

Ctrl+R

d)

Ctrl+I