Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Spread Sheet Basic Revision

Total questions: 40

Worksheet time: 21mins

Name
Class
Date
1.

What symbol do all formula start with in Excel?

a)

+

b)

-

c)

=

d)

*

e)

/

2.

What symbol do you use to add two cells' values in Excel?

a)

+

b)

-

c)

=

d)

*

e)

/

3.

What symbol do you use to times two cells' values in Excel?

a)

+

b)

-

c)

=

d)

*

e)

/

4.

What symbol do you use to subtract two cells' values in Excel?

a)

+

b)

-

c)

=

d)

*

e)

/

5.

What is the value of the active cell?

a)

Y

b)

N

c)

Batman

d)

Superman

6.

What is the cell reference of the active cell?

a)

A1

b)

4B

c)

BB8

d)

B4

7.

What has happened to Superheros in cells B2:D2?

a)

Merged

b)

Joined

c)

Fused

d)

Nothing

8.

What does the function =MAX() do?

a)

Finds the smallest number

b)

Finds the biggest number

c)

Finds the right number

d)

Finds the left number

9.

What does the function =MIN() do?

a)

Finds the biggest number

b)

Finds the smallest number

c)

Finds the correct number

d)

Finds the wrong number

10.

What does the function =SUM() do?

a)

Adds up Cells

b)

Sells Cells

c)

Multiplies Cells

d)

Divides Cells

11.

What feature of a spreadsheet allows text to fill a cell up?

a)

Wrapped Text

b)

Format Text

c)

Merged Text

d)

Trapped Text

12.

What kind of referencing uses $ to keep the cell the same?

a)

Relative

b)

Absolute

c)

Magic

d)

Heart

13.

What type of graph is this?

a)

Bar

b)

Line

c)

Pie

d)

Scatter

14.

A formula to get the total value is _____________ .

a)

=sum(A1:A5)

b)

=product(A1:A5)

c)

=quotient(A1:A5)

d)

=difference(A1:A5)

15.

These are all other content in spreadsheet, usually words and are displayed on the left side of a cell. What is it?

a)

Labels

b)

Values

c)

Formula bar

d)

Cell

16.

These are numbers and calculations and are displayed on the right side of the cell. What is it?

a)

Letters

b)

Values

c)

Labels

d)

Percentage

17.
What does cell A1 contain?
a)
Sweet
b)
Mars
c)
A1
d)
Cost
18.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23
19.
What does cell C3 contain?
a)
23
b)
67
c)
Amount
d)
11.50
20.
What formula is used in cell D3?
a)
B3*C3
b)
B3+C3
c)
=B3*C3
d)
11.50
21.
What formula is used in cell D8?
a)
=D3*D4*D5*D6
b)
SUM(D3:D6)
c)
=69.10
d)
=SUM(D3:D6)
22.
What is displayed in cell A6?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
23.
What is the formula in B9?
a)
=SUM(B3:B7)
b)
=AVERAGE(B3:B7)
c)
=AVERAGE(B3:B6)
d)
=B3+B4+B5+B6+B7/5
24.
What TAB allows you to add grid lines to your print out?
a)
Page
b)
Margins
c)
Header/Footer
d)
Sheet
25.
What TAB allows you to add your name to the foot of the  document?
a)
Page
b)
Margins
c)
Header/Footer
d)
Sheet
26.

Which is NOT a type of chart?

a)

pie

b)

column

c)

bar

d)

axis

27.

Which is NOT a formula?

a)

b2+b3+b4

b)

=b1+b2+b3

c)

=b4*c4

d)

=b5/b7

28.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
29.
A visual representation of worksheet data.
a)
Column
b)
Data
c)
Chart
d)
Legend
30.

When we refer to a contiguous range of cells, we mean that

a)

all the cells in the range are touching.

b)

none of the cells in the range are touching.

c)

a column of cells have been selected.

d)

a row of cells have been selected.

31.

A reference typed into the Name Box as B2:G8 will

a)

select a range of cells with B2 as the top-left cell and G8 as the bottom right cell.

b)

select a range of cells with G8 as the top-left cell and B2 as the bottom right cell.

c)

select only cells B2 and G8.

d)

add all of the values between B2 and G8.

32.
If you don't want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
relative
33.
If you want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
Relative
34.
The most common way to identify a cell reference is 
a)
$D2
b)
$D$2
c)
D$2
d)
D2$
35.

In the picture, why is D2 through D5 placed in paranthesis?

a)

So Excel knows to total the cells before performing the next operation.

b)

So the total of the cells can be multiplied rather than added.

c)

So the calculation will be done last.

36.

An Excel file format extension is

a)

doc

b)

xls

c)

txt

d)

mp3

37.

Name one type of chart.

(a)  

38.

Which chart type shows values as parts of a whole?

a)

Column

b)

Bar

c)

Area

d)

Pie

39.

The basic unit of a worksheet into which you enter data in Excel is called a

a)

cell

b)

table

c)

box

d)

column

40.

What is a Ribbon?

(a)  

Similar Resources on Wayground

quiz informatika

40 questions

quiz informatika

quiz

Worksheet

•

8th Grade - University

Google Applications

37 questions

Google Applications

quiz

Worksheet

•

7th - 12th Grade

แบบทดสอบก่อน-หลังเรียน เรื่อง โปรแกรมภาษา

40 questions

แบบทดสอบก่อน-หลังเรียน เรื่อง โปรแกรมภาษา

quiz

Worksheet

•

9th Grade

1.1 Architecture of CPU

38 questions

1.1 Architecture of CPU

quiz

Worksheet

•

9th - 12th Grade

Year nine revision for summer assessment

36 questions

Year nine revision for summer assessment

quiz

Worksheet

•

9th Grade

GENERAL INTERNET TERMS

42 questions

GENERAL INTERNET TERMS

quiz

Worksheet

•

9th - 11th Grade

Illustrator Exam Review 2

40 questions

Illustrator Exam Review 2

quiz

Worksheet

•

9th - 12th Grade

PLTW CSIM Lesson 1 Assessment

35 questions

PLTW CSIM Lesson 1 Assessment

quiz

Worksheet

•

5th - 9th Grade