wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Year 9 end of Autumn 1 quiz (Spreadsheet/ google-sheet)

Total questions: 88

Worksheet time: 1hrs 2mins

Name
Class
Date
1.

Which of the following is considered a cell reference?

a)

C3

b)

=

c)

*

d)

+

2.

What formula should be placed in cell D2?

a)

=C2-B2

b)

=F2-B2

c)

=A2-B2

d)

=C2

3.

What formula should be placed in cell D6?

a)

=SUM(D2:D5)

b)

=SUM(F2:F5)

c)

=SUM(All)

d)

=C2-D3

4.

How many products are in this spreadsheet?

a)

4

b)

2

c)

1

d)

16

5.

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.

6.

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.

7.
Spreadsheet rows are easily identified by:
a)
a. numbers.
b)
b. letters.
c)
c. Roman numerals.
d)
d. colors.
8.
Spreadsheet columns are easily identified by:
a)
a. Roman numerals.
b)
b. numbers.
c)
c. letters.
d)
d. colors.
9.
A ___________________ is a visual representation of data
a)
a. spreadsheet
b)
b. border
c)
c. chart
d)
d. table
10.
Sum, average, count, maximum value, and minimum value are examples of what?
a)
a. Formulas
b)
b. Calculations
c)
c. Functions
d)
d. Spreadsheet data
11.
Addition, subtraction, multiplication, division, and exponentiation are examples of what?
a)
a. Formulas
b)
b. Conditional formatting
c)
c. Functions
d)
d. Spreadsheet data
12.

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

a)

=sum(C2:C11)

b)

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

c)

=sum(D2:D11)

d)

$13,442.90

13.

If I wanted to know the average annual salary earned by the employees I would write the following formula in cell C12:

a)

=sum(C2:C11)

b)

=average(C2,C11)

c)

=average(C2:C11)

d)

=average(B2:B11)

14.
Putting cells into A-Z order is called?
a)
Sort Ascending
b)
Sort Descending
c)
Filter Ascending
d)
Filter Descending
15.
 A spreadsheet program is used to store data in: 
a)
a. a database.
b)
b. a text document.
c)
c. rows and columns.
d)
d. letters and numbers.
16.
Which of the following is an example of a cell reference?
a)
a. Column C
b)
b. =SUM
c)
c. Row 1
d)
d. A5
17.
What is the purpose of spreadsheets?
a)
a. To present information on different engaging slides
b)
b. To deliver a speech to a crowd
c)
c. To perform basic and complex math computations in an organized way
d)
d. To excel your research papers and citations
18.
What does this symbol represent in MS Excel?
a)
a. Subtract
b)
b. AutoSum
c)
c. Formula
d)
d.    Average
19.

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

a)

=sum(C2:C11)

b)

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

c)

=sum(D2:D11)

d)

$13,442.90

20.

If I wanted to know the average annual salary earned by the employees I would write the following formula in cell C12:

a)

=sum(C2:C11)

b)

=average(C2,C11)

c)

=average(C2:C11)

d)

=average(B2:B11)

21.

Every formula needs to begin with...

a)

=

b)

()

c)

;

d)

FORMULA

22.
What value would you get if you put in the formula: =A1*B1
a)
2
b)
3
c)
4
d)
Error
23.
If I want to add a Chart, one way is to select the ____________ tab.
a)
Home
b)
Insert
c)
Page Layout
d)
Data
24.

When data in a column or row is hidden, is it deleted too?

a)

Yes

b)

No

25.

What are the individual rectangles on a worksheet called?

a)

Rows

b)

Columns

c)

Cells

d)

Formulae

26.

A vertical line of cells in a spreadsheet is a what?

a)

Row

b)

Column

27.

A horizontal line of cells in a spreadsheet is a what?

a)

Row

b)

Column

28.

If you wanted to change the colour of the text inside a cell, which tool would you use?

a)

Text colour

b)

Fill colour

c)

Borders

d)

Bold

29.

If you wanted one cell or a number of cells to stand out from the rest which tool could you use?

a)

Bold

b)

Fill Colour

c)

Currency

d)

Borders

30.

If you wanted to change the size of the text inside a cell which tool would you use?

a)

Cell width

b)

Cell height

c)

Text colour

d)

Font size

31.

Something that automatically calculates something for you using the data in cells is a:

a)

Formula

b)

Formatting

32.

Which mathematical operator (symbol) would you use if you are adding the values in cells together?

a)

/

b)

-

c)

+

d)

=

33.

Which mathematical operator (symbol) would you use to divide the values in two cells?

a)

/

b)

-

c)

*

d)

=

34.

Which mathematical operator (symbol) would you use when subtracting a value in a cell from a value in another cell?

a)

/

b)

-

c)

*

d)

=

35.

Which mathematical operator (symbol) would you use to multiply the values in two cells together?

a)

/

b)

-

c)

*

d)

=

36.

What is the cell reference of the cell with value Coca-Cola inside?

a)

A3

b)

3A

c)

C5

d)

D7

37.

What is the cell reference of the cell with value Sprite Lite inside?

a)

8A

b)

C5

c)

A8

d)

B8

38.

What is the cell reference of the cell with value Sprite Lite inside?

a)

8A

b)

C5

c)

A8

d)

B8

39.

To calculate the Total sales for Coca-Cola, what would you need to multiple the price by?

a)

Item

b)

Price

c)

Number Sold

d)

Total

40.

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

41.

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

42.

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

(a)  

43.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

44.

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

a)

+

b)

-

c)

%

d)

=

45.

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

46.
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
47.
An absolute reference is designated in a formula by the addition of a _______ sign. 
a)
%
b)
$
c)
&
d)
#
48.
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
49.
(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
50.
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)
51.

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

a)

+

b)

-

c)

=

d)

*

e)

/

52.

What has happened to Superheros in cells B2:D2?

a)

Merged

b)

Joined

c)

Fused

d)

Nothing

53.

True or False: all formula starts with =SUM

a)

True

b)

False

54.

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

55.

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

a)

Relative

b)

Absolute

c)

Magic

d)

Heart

56.

What type of graph is this?

a)

Bar

b)

Line

c)

Pie

d)

Scatter

57.

What formula should be placed in cell D2?

a)

=C2-B2

b)

=F2-B2

c)

=A2-B2

d)

=C2

58.

What formula should be placed in cell D6?

a)

=SUM(D2:D5)

b)

=SUM(F2:F5)

c)

=SUM(All)

d)

=C2-D3

59.

What formula should be placed in cell D2?

a)

=C2-B2

b)

=F2-B2

c)

=A2-B2

d)

=C2

60.

What formula should be placed in cell D6?

a)

=SUM(D2:D5)

b)

=SUM(F2:F5)

c)

=SUM(All)

d)

=C2-D3

61.

What does this button do?

a)

Add pound signs to numbers (currency)

b)

Align text

c)

Add borders to cells

d)

Change the fill colour

e)

Change the text colour

62.

What does this button do?

a)

Add pound signs to numbers (currency)

b)

Align text

c)

Add borders to cells

d)

Change the fill colour

e)

Change the text colour

63.

What does this button do?

a)

Add pound signs to numbers (currency)

b)

Align text

c)

Add borders to cells

d)

Change the fill colour

e)

Change the text colour

64.

If you make a mistake you can press this button. What is it called?

(a)  

65.

Type in the value in the cell A11.

(a)  

66.

Type in the value in the cell C5.

(a)  

67.

Which formula would be used to calculate the largest number?

a)

=MAX(B5:B10)

b)

=SUM(B5:B10)

c)

=AVGERAGE(B5:B10)

d)

=SUM(B5*B10)

68.

Which formula would be used to calculate a total?

a)

=MAX(B5:B10)

b)

=SUM(B5:B10)

c)

=AVGERAGE(B5:B10)

d)

=SUM(B5*B10)

69.

A spreadsheet program is used to store data in:

a)

a database.

b)

a text document.

c)

rows and columns.

d)

letters and numbers.

70.

Spreadsheet rows are easily identified by:

a)

Numbers.

b)

Letters.

c)

Roman numerals.

d)

Colours.

71.

Spreadsheet columns are easily identified by:

a)

Roman numerals.

b)

numbers.

c)

letters.

d)

colors.

72.

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

a)

Column C

b)

=SUM

c)

Row 1

d)

A5

73.

Sum, average, count, maximum value, and minimum value are examples of what?

a)

Formulas

b)

Calculations

c)

Functions

d)

Spreadsheet data

74.

Addition, subtraction, multiplication, division are examples of what?

a)

Formulas

b)

Conditional formatting

c)

Functions

d)

Spreadsheet data

75.

What is the purpose of spreadsheets?

a)

To present information on different engaging slides

b)

To deliver a speech to a crowd

c)

To perform basic and complex mathematical calculations in an organized way

d)

To excel your written work

76.

Which formula would be used to calculate a total?

a)

=MAX(B5:B10)

b)

=SUM(B5:B10)

c)

=AVGERAGE(B5:B10)

d)

=SUM(B5*B10)

77.

Which formula would be used to calculate average?

a)

=MAX(B5:B10)

b)

=SUM(B5:B10)

c)

=AVGERAGE(B5:B10)

d)

=SUM(B5*B10)

78.

Which formula would be used to calculate the largest number?

a)

=MAX(B5:B10)

b)

=SUM(B5:B10)

c)

=AVGERAGE(B5:B10)

d)

=SUM(B5*B10)

79.

A spreadsheet program is used to store data in:

a)

a database.

b)

a text document.

c)

rows and columns.

d)

letters and numbers.

80.

Spreadsheet rows are easily identified by:

a)

Numbers.

b)

Letters.

c)

Roman numerals.

d)

Colours.

81.

Spreadsheet columns are easily identified by:

a)

Roman numerals.

b)

numbers.

c)

letters.

d)

colors.

82.

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

a)

Column C

b)

=SUM

c)

Row 1

d)

A5

83.

Sum, average, count, maximum value, and minimum value are examples of what?

a)

Formulas

b)

Calculations

c)

Functions

d)

Spreadsheet data

84.

Addition, subtraction, multiplication, division are examples of what?

a)

Formulas

b)

Conditional formatting

c)

Functions

d)

Spreadsheet data

85.

What is the purpose of spreadsheets?

a)

To present information on different engaging slides

b)

To deliver a speech to a crowd

c)

To perform basic and complex mathematical calculations in an organized way

d)

To excel your written work

86.

Which formula would be used to calculate a total?

a)

=MAX(B5:B10)

b)

=SUM(B5:B10)

c)

=AVGERAGE(B5:B10)

d)

=SUM(B5*B10)

87.

Which formula would be used to calculate average?

a)

=MAX(B5:B10)

b)

=SUM(B5:B10)

c)

=AVGERAGE(B5:B10)

d)

=SUM(B5*B10)

88.

Which formula would be used to calculate the largest number?

a)

=MAX(B5:B10)

b)

=SUM(B5:B10)

c)

=AVGERAGE(B5:B10)

d)

=SUM(B5*B10)

Similar Resources on Wayground

Com Sci End of Term Test Form One

90 questions

Com Sci End of Term Test Form One

quiz

Worksheet

•

7th - 8th Grade

EOC Review

90 questions

EOC Review

quiz

Worksheet

•

8th Grade

Spreadsheets: all Qs

90 questions

Spreadsheets: all Qs

quiz

Worksheet

•

6th - 8th Grade