wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Microsoft Excel Review

Total questions: 31

Worksheet time: 22mins

Name
Class
Date
1.

The cell in the worksheet in which you can type data.

a)

Active Cell

b)

Formula

c)

Landscape

d)

Range

2.

The intersection of a column and a row in a table or worksheet.

a)

Workbook

b)

Column

c)

Sheet Tab

d)

Cell

3.

A unique identifier for a cell, which is formed by coming the cells's column letter and row numbers.

a)

IF Function

b)

Cell Reference

c)

Pivot Table

d)

AutoSum

4.

A vertical stack of cells in a table or worksheet.

a)

Sheet Tab

b)

Row

c)

Column

d)

Range

5.

An equation that calculates a new value from values currently in a worksheet.

a)

Formula

b)

Active Cell

c)

Row

d)

Spreadsheet

6.

The box that displays a formula when the cell of a worksheet contains a calculated value.

a)

Portrait Orientation

b)

Formula Bar

c)

Fill Handle

d)

Cell Reference

7.

A page or worksheet rotated so it is wider than it is long.

a)

Landscape Orientation

b)

Portrait Orientation

c)

Spreadsheet

d)

Workbook

8.

A spreadsheet program used to store inventory. Payments, grades, etc

a)

Microsoft Word 2016

b)

Publisher

c)

Microsoft Excel 2016

d)

Google Docs

9.

A page or worksheet rotated so it is longer than it is wide. (Default page orientation)

a)

Range

b)

Landscape

c)

Spreadsheet

d)

Portrait

10.

A group of selected cells.

a)

Absolute Cell Reference

b)

Range

c)

Formula Bar

d)

Cells

11.

The horizontal placement of cells in a table or worksheet.

a)

Column

b)

Row

c)

Sheet

d)

Cell Reference

12.

The worksheet identifier that appears at the bottom of the workbook window

a)

Sheet Tab

b)

Workbook

c)

Border

d)

Number Format

13.

A grid of rows and columns in which you enter text, numbers, and the results of calculations.

a)

Absolute Cell Reference

b)

Cell Style

c)

Theme

d)

Spreadsheet

14.

The file used to store worksheets; usually a collection of related worksheets.

a)

Range

b)

AutoSum

c)

Workbook

d)

Chart

15.

A computerized spreadsheet in Excel.

a)

Worksheet

b)

Workbook

c)

Style

d)

Theme

16.

A line around the edges of a cell.

a)

Cell Reference

b)

Fill Handle

c)

Cut

d)

Border

17.

A collection of formatting characteristics you apply to a cell or range of data.

a)

Cell Style

b)

Font

c)

Workbook

d)

AutoSum

18.

The design of text.

a)

Font

b)

Cell

c)

Range

d)

Merge

19.

To combine multiple cells into one cell.

a)

Absolute Cell Reference

b)

Theme

c)

Merge

d)

Pivot Table

20.

Formatting option that changes the way numbers/data look in a cell.

a)

Copy

b)

Merge

c)

Formula

d)

Number Format

21.

A set of formatting options that have been named and saved.

a)

Worksheet

b)

Style

c)

Cut

d)

Range

22.

A preset collection of design elements, including fonts, colors, and other effects.

a)

Theme

b)

Copy

c)

Merge

d)

IF Function

23.

To place a copy of selected text on the Clipboard or the Office Clipboard.

a)

Paste

b)

Copy

c)

Cut

d)

Formula

24.

To remove selected text and place it on the Clipboard or the Office Clipboard.

a)

Copy

b)

Paste

c)

Fill

d)

Cut

25.

The small square in the lower-right corner of the active cell or range that you drag over the cells you want to fill.

a)

Fill Handle

b)

Sheet Tab

c)

Cell

d)

Formula

26.

A cell reference that does not change when copied or moved to a new cell. Uses the $ symbol. Between the column letter & row number

a)

Cell Reference

b)

Auto Sum

c)

Absolute Cell Reference

d)

Merge

27.

A button on the Ribbon that inserts the Sum function to add long columns or rows of numbers.

a)

Average

b)

IF Function

c)

Formula Bar

d)

AutoSum

28.

An equation that calculates a new value from values currently in a worksheet.

a)

Formula

b)

Chart

c)

Table

d)

Range

29.

A visual representation of worksheet data

a)

Spreadsheet

b)

Chart

c)

Copy

d)

Fill Handle

30.

Allows you to summarize complex data. It makes large collections of data easier to analyze.

a)

Pivot Table

b)

IF Function

c)

Columns

d)

Cell Reference

31.

A logical function that asks Excel to perform one of two different calculations based on whether your data matches a logical test.

a)

Formula

b)

AutoSum

c)

IF Function

d)

NOW()