Search Header Logo
MS EXCEL REVIEW

MS EXCEL REVIEW

Assessment

Presentation

Computers

University

Medium

Created by

Boyde Hill

Used 27+ times

FREE Resource

0 Slides • 33 Questions

1

Multiple Choice

Question image

What is in cell A6?

1

Monday

2

Tuesday

3

Wednesday

4

Thursday

2

Multiple Choice

Which of the following cursor allows you to select a range of cells

1
2
3
4

3

Multiple Choice

Drag to widen or narrow the width of a column.

1
2
3
4

4

Multiple Choice

How would you write a formula for cell A1 subtracted by Cell C3?

1

A1-C3

2

A1-C3=

3

=A1-C3

4

=C3-A1

5

Multiple Choice

Question image

Identify the numbered #4 part of MS Excel window

1

Column Header

2

Row Header

3

Name box

4

Sheet Tabs

6

Multiple Choice

Question image

Identify the numbered #5 part of MS Excel window

1

Column Header

2

Row Header

3

Name box

4

Sheet Tabs

7

Multiple Choice

Question image

Identify the numbered #6 part of MS Excel window

1

Formula bar

2

Ribbon

3

Sheet tabs

4

Worksheet Window

8

Multiple Choice

Question image
What does this symbol represent in MS Excel?
1
a. Subtract
2
b. AutoSum
3
c. Formula
4
d.    Average

9

Multiple Choice

Question image

If I wanted to know the total amount of bonuses given to the employees I would write the following formula in cell D12:

1

=sum(C2:C11)

2

=sum(D2,D3,D4,D5,D7,D8,D9,D10,D11)

3

=sum(D2:D11)

4

$13,442.90

10

Multiple Choice

What would be a correct formula for SUM in excel?
1
=SUM(B3:B9)
2
=SUMB3+B9
3
SUM(B3:B9)
4
=ADD(B3:B9)

11

Multiple Choice

_____ are vertical. 
1
Rows
2
Columns

12

Multiple Choice

________ are horizontal
1
Rows
2
Columns

13

Multiple Choice

What is the "Active Cell" in Excel?

1

The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

2

The current cell in a worksheet. It is indicated by a dark border onscreen.

3

The top cell in a worksheet. It is indicated by a dark border onscreen.

4

The past cell in a worksheet. It is indicated by a dark border onscreen.

14

Multiple Choice

What is a spreadsheet?

1

An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.

2

An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.

3

An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.

4

An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.

15

Multiple Choice

What is the Sum formula?

1

Sum( )

2

Sum( )=

3

=Sum( )

4

=( )Sum

16

Multiple Choice

When starting a formula what is the first thing you type in the cell?

1

+

2

-

3

%

4

=

17

Multiple Choice

The letters in Excel represent the _______?

1

columns

2

rows

3

data

4

functions

18

Multiple Choice

The numbers in Excel represent the _____?

1

columns

2

rows

3

data

4

functions

19

Multiple Choice

Where is the zoom function located in Excel?

1

Bottom right of spreadsheet document

2

Bottom left of spreadsheet document

3

Top right of spreadsheet document

4

Top left of spreadsheet document

20

Multiple Choice

Excel is part of?
1
Power Point
2
Microsoft Office Suite
3
Access
4
Google

21

Multiple Choice

What do you call the rectangles on a spreadsheet?
1
Cell
2
Button
3
Sentence

22

Multiple Choice

What is the Formula sign for multiply? 
1
\
2
*

23

Multiple Choice

True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?
1
false
2
true

24

Multiple Choice

How do you make a cell the active cell?
1
Click the ACTIVE button
2
Click INSERT CELL
3
Click on the cell
4
Cells are always active

25

Multiple Choice

Question image
What is the name of this cell?
1
B10
2
5B
3
B5
4
A5

26

Multiple Choice

Excel refers to files as
1
Documents
2
Workbooks
3
data bases

27

Multiple Choice

Where rows and columns meet are referred to as
1
Blocks
2
Cells
3
Boxes

28

Multiple Choice

Can you format text with Excel
1
Yes
2
No

29

Multiple Choice

In Excel, what symbol do you use for multiplication?

1

x

2

+

3

/

4

*

30

Multiple Choice

In Excel, what symbol do you use for division?

1

x

2

\

3

/

4

*

31

Multiple Choice

In Excel, where would you go to add gridlines?

1

Borders

2

Charts

3

Graphs

4

Fill Color

32

Multiple Choice

In Excel, how do you combine 2 cells and put the words in the middle?

1

Merge and Center

2

Combine and Center

3

You can't do this

4

Merge and Middle

33

Multiple Choice

Question image

What cell is red?

1

A1

2

C1

3

C4

4

C5

Question image

What is in cell A6?

1

Monday

2

Tuesday

3

Wednesday

4

Thursday

Show answer

Auto Play

Slide 1 / 33

MULTIPLE CHOICE