wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

G5 Final 2 MS Excel Review 20/21

Total questions: 36

Worksheet time: 18mins

Name
Class
Date
1.

Spreadsheet rows are easily known by:

a)

numbers.

b)

letters.

c)

Roman numerals.

d)

colors.

2.

Spreadsheet columns are easily known by:

a)

Roman numerals.

b)

numbers.

c)

letters.

d)

colors.

3.

An single box in a worksheet is known as?

a)

square

b)

range

c)

reference

d)

cell

4.

What is used to do calculations in a spreadsheet?

a)

Variable

b)

Formula

c)

Conditional formating

d)

Macro

5.

When we write formulas, which do we start with?

a)

Subtraction sign

b)

Equal Sign

c)

Addition sign

d)

Division sign

6.

In Excel, what do all formulas begin with?

a)

!

b)

-

c)

+

d)

=

7.

What is the address of this cell?

a)

B10

b)

5B

c)

B5

d)

you cannot know the name from this picture

8.

What is in cell A6?

a)

Monday

b)

Tuesday

c)

Wednesday

d)

Thursday

9.

What is in cell B1?

a)

100

b)

Tickets Sold

c)

Day

d)

B1

10.

Which of the following operators (symbols) represent adding in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

11.

Which of the following operators (symbols) represent subtracting in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

12.

Which of the following operators (symbols) represent multiplication in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

13.

Which of the following operators (symbols) represent division in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

14.

What type of chart is this?

a)

Donut

b)

Radar

c)

Bar

d)

Pie

15.

What key is used to select multiple ranges of cells?

a)

Shift

b)

CTRL

c)

ALT

d)

Shift+ALT

16.

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

a)
b)
c)
d)
17.

Drag to widen or narrow the width of a column.

a)
b)
c)
d)
18.

###### means:

a)

You've entered a number wrong.

b)

You've misspelled something.

c)

The cell is not wide enough.

19.

Which formula can add all the values in a range of cells?

a)

COUNT

b)

COUNTA

c)

SUM

d)

AVERAGE

20.

Why do you start a formula with an = sign?

a)

to tell Excel you are entering a formula

b)

just because

c)

you are entering text

21.

Do you need an = sign to start a formula?

a)

no

b)

yes

c)

never

22.

Which of the following is the correct formula to calculate 8 divided by 2?

a)

=8/2

b)

8/2

c)

=8*2

d)

8%2

23.

In what format should a cell with a money value entered into be in?

a)

Currency

b)

Text

c)

Numbers

d)

Date

24.

Cells that run horizontally on a spreadsheet

a)

Row

b)

Column

c)

Workbook

d)

Range

25.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
26.
Which of the following is a valid formula?
a)
=C7*C8
b)
=(C7\C8)
c)
=(C7xC8)
d)
=AVERAGE(C7*C8)
27.
Which of the following is a valid formula?
a)
=sum(A1:A6)
b)
sum=(A1:A6)
c)
=sum[A1:A6]
d)
=sum(A1,A6)
28.
You can present your data graphically, using a 
a)
chart
b)
print
c)
font
d)
sort
29.
To show the quantities in particular categories use a?
a)
Column Chart
b)
Line Graph
c)
Scatter Graph
d)
Sort Chart
30.
Which chart should you use to show changes over time?
a)
Line
b)
Scatter
c)
Pie
d)
Bar
31.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23
32.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

33.

The letters in Excel represent the _______?

a)

columns

b)

rows

c)

data

d)

functions

34.

The numbers in Excel represent the _____?

a)

columns

b)

rows

c)

data

d)

functions

35.

When making a graph, what's the first thing you need to do?

a)

Pick the type of Graph

b)

Use the function = sign

c)

Highlight your data being used.

d)

Double click the active cell

36.

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

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

Similar Resources on Wayground

ÔN TẬP HỌC KÌ I - TH5

35 questions

ÔN TẬP HỌC KÌ I - TH5

quiz

Worksheet

•

5th Grade

Excel Skills Review

31 questions

Excel Skills Review

quiz

Worksheet

•

KG - University

GCSE ICT U1 Topics 1-6 Revision

36 questions

GCSE ICT U1 Topics 1-6 Revision

quiz

Worksheet

•

5th - 9th Grade

Tiểu học THCS Lê Quý Đôn - Key Application - haily.it@gmail.com

40 questions

Tiểu học THCS Lê Quý Đôn - Key Application - haily.it@gmail.com

quiz

Worksheet

•

3rd - 5th Grade

Word Básico 2

35 questions

Word Básico 2

quiz

Worksheet

•

1st - 5th Grade

PAT Tahun 4

41 questions

PAT Tahun 4

quiz

Worksheet

•

4th - 6th Grade

Spreadsheet Basics

35 questions

Spreadsheet Basics

quiz

Worksheet

•

4th - 6th Grade

Gr5 practice Quiz

33 questions

Gr5 practice Quiz

quiz

Worksheet

•

5th Grade