Search Header Logo
MS Excel Review

MS Excel Review

Assessment

Presentation

•

Education

•

6th - 10th Grade

•

Practice Problem

•

Medium

Created by

LISA WEINERT

Used 56+ times

FREE Resource

1 Slide • 26 Questions

1

MS Excel Review

A review of labs 1-6

media

2

Multiple Choice

An Excel file is called....

1

a spreadsheet

2

a workbook

3

a file

4

a document

3

Multiple Choice

Question image

In MS Excel, this pointer allows you to..

1

autofill cell contents

2

select cells

3

change column width or row height

4

move or copy cell contents

4

Multiple Choice

Columns are

1

horizonal

2

vertical

5

Multiple Choice

The arrow keys can be used to move from cell to cell.

1

True

2

False

6

Fill in the Blank

The _________ has a bold border around it.

7

Fill in the Blank

New rows are inserted ________ the selected row.

8

Multiple Choice

Rows are

1

horizontal

2

vertical

9

Fill in the Blank

Finish this sentence: All formulas must start with a(n) __________

10

Multiple Choice

There is no way to check spelling in an Excel workbook.

1

True

2

False

11

Multiple Choice

What option will allow you to combine cells into one cell and place the text in the middle?

1

Wrap Text

2

Merge & Center

3

Sort & Filter

12

Fill in the Blank

New columns are inserted to the __________ of the selected column.

13

Multiple Choice

The cell that is selected is called the...

1

active cell

2

column

3

row

4

coordinate

14

Multiple Choice

Columns are labeled with...

1

numbers

2

letters

3

symbols

4

cell addresses

15

Fill in the Blank

Fill in the Blank: Typed characters entered in the active cell address appear in the __________ ______.

16

Multiple Choice

Question image

In MS Excel, this pointer allows you to...

1

change the column width or row height

2

select cells

3

autofill cell contents

4

move cell contents

17

Multiple Choice

What does the command "Merge and Center" allow you to do?

1

Sort the information.

2

Place the text in the center horizontally and vertically.

3

Make the text wrap to the next line.

4

Combine cells and place the text in the middle.

18

Multiple Choice

Rows are labeled with...

1

numbers

2

letters

3

symbols

4

cell addresses

19

Multiple Choice

Which of the following is an example of a cell address?

1

2A

2

B

3

D4

4

16

20

Multiple Choice

Question image

What is the area in the upper left side called that displays the active cell address?

1

Formula Bar

2

Name box

3

Function Library

4

Column

21

Multiple Choice

What is the default alignment of numbers?

1

left

2

center

3

right

4

justified

22

Multiple Choice

Question image

The Quick Access Toolbar is...

1

near the tab scrolling buttons.

2

found at the bottom of the screen.

3

customizable

4

None of the above

23

Multiple Choice

Which symbol represents multiplication in a formula?

1

*

2

x

3

+

4

/

24

Multiple Choice

Which ribbon tab do you use to change the orientation (Portrait or Landscape)?

1

Formulas

2

Insert

3

Home

4

Page Layout

25

Multiple Choice

Question image

What should you use to perform the calculation in cell D13?

1

Formula

2

Function

26

Multiple Choice

Question image

Which is the correct function that calculates the total in cell D13?

1

=sum(D3:D12)

2

=D3+D4+D5+D6+D7+D8+D9+D10+D11+D12

3

=total(D3:D12)

4

D3+D4+D5+D6+D7+D8+D9+D10+D11+D12

27

Poll

Which skills do you think you need to review?

Cell Basics

Formulas

Functions

Nothing

Everything

MS Excel Review

A review of labs 1-6

media

Show answer

Auto Play

Slide 1 / 27

SLIDE