wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Year 9 Spreadsheet Quiz

Total questions: 54

Worksheet time: 1hrs 1mins

Name
Class
Date
1.

What is a box on a spreadsheet known as?

(a)  

2.

Spot the bug: name = int(input("enter your name"))

4 lines
3.

What is wrong with this function? =AVARAGE(A1:B1)

a)

Should be spelt =AVERAGE()

b)

Nothing, it's fine

c)

The : should be a ;

d)

Needs a closing bracket

4.

What is wrong with this function? =MAXIMUM(A1:B1)

a)

Should be =MAX(1A:1B)

b)

Should be =MAX(A1:B1)

c)

Should be =MAX(A1;B1)

d)

Should be =MAX(1A;1B)

5.

What is the green square in the corner of a cell called on a spreadsheet?

(a)  

6.

What is wrong with this function? =IF(A1 > B1, "A1 is bigger than B1","False"

a)

Nothing, it is correct

b)

If should be lower case

c)

Missing a comma

d)

Missing an end bracket

7.

In Excel, if I want to create a bar chart I click "insert", then click...

(a)  

8.

What is wrong with this function? =IF(A1 > B1, "A1 is bigger than B1, "False")

a)

Missing , after B1

b)

Missing " after B1

c)

Nothing, it's fine

d)

Too few arguments

9.

What does this icon do?

4 lines
10.

In Excel, what does the COUNTIF function do?

a)

Nothing, you have made this function up

b)

Counts the number of cells according to a given value

c)

Counts the number of cells that have any value in them

d)

Nothing, it won't work because it needs to be in lower case

11.

In Excel, what does the COUNTA function do?

a)

Counts cells with any value entered

b)

Counts cells according to a specific value

c)

Counts how many times the letter "A" has been entered into a cell

d)

Counts any cells in a range

12.

What is wrong with this function? =IF(A1 > B1,"True")

a)

Nothing wrong with it

b)

Needs an additional bracket

c)

Too few arguments

d)

Needs to say "false", not true

13.

Why might a cell return "#DIV/0"?

a)

You can't divide anything by zero

b)

The cell isn't large enough to fit the data

c)

You accidentally entered a divide symbol twice

14.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

15.

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

a)

+

b)

-

c)

%

d)

=

16.

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

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

17.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
18.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
19.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
20.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
21.
An absolute reference is designated in a formula by the addition of a _______ sign. 
a)
%
b)
$
c)
&
d)
#
22.
The most common way to identify a cell reference is 
a)
$D2
b)
$D$2
c)
D$2
d)
D2$
23.
Which feature would allow you to change the formatting of any cells that are less than $100.00?
a)
Cell Formatting
b)
Easy Formatting
c)
Auto Formatting
d)
Conditional Formatting
24.
(Let the GIF Play)
How are we sorting the data in this clip?
a)
Custom Sort by T-Shirt Size
b)
Alphabetically by First Name
c)
Alphabetically by Last Name
d)
Numerically by Homeroom Number
25.
What is the cell range in this diagram?
a)
A1:F1
b)
A1:A8
c)
A1:F8
d)
A1:1A
26.
Gerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?
a)
=(C3+C5+C9)/3
b)
=SUM(C2:C10)
c)
=AVERAGE(C2:C10)
d)
=(C3+C5+C9)
27.
A(n) _________ is a prewritten formula that is built into EXCEL. 
a)
function
b)
problem
c)
equation
d)
equal sign
28.

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

a)

+

b)

-

c)

=

d)

*

e)

/

29.

What is the value of the active cell?

a)

Y

b)

N

c)

Batman

d)

Superman

30.

What is the cell reference of the active cell?

a)

A1

b)

4B

c)

BB8

d)

B4

31.

What has happened to Superheros in cells B2:D2?

a)

Merged

b)

Joined

c)

Fused

d)

Nothing

32.

True or False: all formula starts with =SUM

a)

True

b)

False

33.

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

34.

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

a)

Relative

b)

Absolute

c)

Magic

d)

Heart

35.

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

a)

Wrapped Text

b)

Format Text

c)

Merged Text

d)

Trapped Text

36.

What type of graph is this?

a)

Bar

b)

Line

c)

Pie

d)

Scatter

37.

Microsoft Excel is used to ...

a)

Model Financial Scenarios

b)

Model Games

c)

Model Images and Text

d)

Write reports

38.

What formula should be placed in cell D2?

a)

=C2-B2

b)

=F2-B2

c)

=A2-B2

d)

=C2

39.

What formula should be placed in cell D6?

a)

=SUM(D2:D5)

b)

=SUM(F2:F5)

c)

=SUM(All)

d)

=C2-D3

40.

How many products are in this spreadsheet?

a)

4

b)

2

c)

1

d)

16

41.

What is used to add the £ signs to the cells.

a)

Formatting borders

b)

Formatting Currency

c)

Formatting fill colours

d)

formatting text in bold.

42.

What formula should be placed in cell D2?

a)

=C2-B2

b)

=F2-B2

c)

=A2-B2

d)

=C2

43.

What formula should be placed in cell D6?

a)

=SUM(D2:D5)

b)

=SUM(F2:F5)

c)

=SUM(All)

d)

=C2-D3

44.

What is used to add the £ signs to the cells.

a)

Formatting borders

b)

Formatting Currency

c)

Formatting fill colours

d)

formatting text in bold.

45.
An absolute reference is designated in a formula by the addition of a _______ sign. 
a)
%
b)
$
c)
&
d)
#
46.
The most common way to identify a cell reference is 
a)
$D2
b)
$D$2
c)
D$2
d)
D2$
47.
Which feature would allow you to change the formatting of any cells that are less than $100.00?
a)
Cell Formatting
b)
Easy Formatting
c)
Auto Formatting
d)
Conditional Formatting
48.
(Let the GIF Play)
How are we sorting the data in this clip?
a)
Custom Sort by T-Shirt Size
b)
Alphabetically by First Name
c)
Alphabetically by Last Name
d)
Numerically by Homeroom Number
49.

What is the value of the active cell?

a)

Y

b)

N

c)

Batman

d)

Superman

50.

What has happened to Superheros in cells B2:D2?

a)

Merged

b)

Joined

c)

Fused

d)

Nothing

51.

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

52.

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

53.

What type of graph is this?

a)

Bar

b)

Line

c)

Pie

d)

Scatter

54.

Using the correct symbols and cell references, write out the formula to calculate Total (£) sales for Fanta

a)

£1.25 times 12

b)

C5*D5

c)

=C5*D5

Similar Resources on Wayground

Keyboarding EOC Review

50 questions

Keyboarding EOC Review

quiz

Worksheet

•

6th - 7th Grade

Digital Devices

50 questions

Digital Devices

quiz

Worksheet

•

5th Grade - University

Hardware and Software Basics

55 questions

Hardware and Software Basics

quiz

Worksheet

•

6th Grade

Informatics Quiz

50 questions

Informatics Quiz

quiz

Worksheet

•

6th - 8th Grade

FIRST QUARTER TEST IN TLE-ICT (CDP)

50 questions

FIRST QUARTER TEST IN TLE-ICT (CDP)

quiz

Worksheet

•

6th Grade

Ôn tập IC3 GS6 Level 1 (4)

54 questions

Ôn tập IC3 GS6 Level 1 (4)

quiz

Worksheet

•

6th - 8th Grade

Computer Fundamentals

50 questions

Computer Fundamentals

quiz

Worksheet

•

6th Grade

Ulangkaji ASK Ting 2 Bab 3.1 Persekitaran Kod Arahan

52 questions

Ulangkaji ASK Ting 2 Bab 3.1 Persekitaran Kod Arahan

quiz

Worksheet

•

1st - 12th Grade