Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Y7 Spreadsheets (Baseline Test)

Total questions: 36

Worksheet time: 18mins

Name
Class
Date
1.

What are spreadsheets used for?

a)

To store, search and sort information.

b)

To calculate data and create charts

2.

Which is the correct formula to multiply?

a)

=B6*C6

b)

B6*C6

c)

B6C6*

d)

*B6C6

3.

Which is the correct formula to divide?

a)

B6/C6

b)

=B6/C6

c)

/B6C6

d)

B6C6/

4.

What can you NOT do with spreadsheets?

a)

Increase the column width

b)

Increase the row height

c)

Make text within a cell bold, underlined or Italic

d)

Animate text within a cell

5.

What function do you use to add cells together?

a)

SUM

b)

MIN

c)

MAX

d)

AVERAGE

6.

What function do you use to find the lowest number?

a)

SUM

b)

MAX

c)

MIN

d)

AVERAGE

7.

Name this

a)

Cell

b)

Row

c)

Column

8.
What formula is used in cell D8?
a)
=D3*D4*D5*D6
b)
SUM(D3:D6)
c)
=69.10
d)
=SUM(D3:D6)
9.
What is displayed in cell A6?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
10.
What is displayed in cell B1?
a)
100
b)
Tickets Sold
c)
Day
d)
B1
11.

Cells that run horizontally on a spreadsheet

a)

Row

b)

Column

c)

Workbook

d)

Range

12.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
13.
What is normally used to perform calculations in a spreadsheet?
a)
Variable
b)
Formula
c)
Conditional formating
d)
Macro
14.
When you key a formula in a spreadsheet what do you key in first?
a)
Subtraction sign
b)
Equal Sign
c)
Addition sign
d)
Division sign
15.
You can present your data graphically, using a 
a)
chart
b)
print
c)
font
d)
sort
16.
Which formula would subtract D12 from D13?
a)
=D13-D12
b)
=D12-D13
c)
=sum(D12-D13)
d)
=sum(D13-D12)
17.

What symbol should be used to perform an adding calculation?

a)

+

b)

-

c)

*

d)

/

18.

What symbol should be used to perform a subtraction calculation?

a)

-

b)

*

c)

+

d)

/

19.

What symbol should be used to perform a multiplying calculation?

a)

+

b)

-

c)

*

d)

/

20.

What symbol should be used to perform a division calculation?

a)

/

b)

-

c)

*

d)

+

21.

What are spreadsheets used for?

a)

To perform powerful calculations

b)

Make graphs and charts

c)

Analyse patterns in the data

d)

To store information and data

22.

A spreadsheet is made up of one "workbook" and can have have many "worksheets".

a)

True

b)

False

23.

Worksheets appear as tabs at the bottom of the spreadsheet.

a)

True

b)

False

24.

What is the name of each "box" on a spreadsheet?

a)

Cell

b)

Box

c)

Rectangle

25.

A cell reference is the specific location of the active cell (E.g. A1).

a)

True

b)

False

26.

What is the correct order for the parts that make up a Cell Reference?

a)

Letter then Number

b)

Number then Letter

27.
The cell in which you are currently working is known as what?
a)
Active cell
b)
Cell address
c)
Cell reference
d)
Spreadsheet cell
28.

What makes cells change in appearance?

a)

Formula

b)

Formatting

c)

Function

d)

Forgotten

29.

Worksheets are made up of ___________

a)

bars and lines.

b)

tables and charts.

c)

rows and columns.

30.

What will clicking on the icon in the image do?

a)

Make the text size bigger

b)

Make the text colour red

c)

Make the cell background colour red

d)

Underline the text

31.
SUM, AVERAGE, MAX and VLOOKUP are examples of what?
a)
Functions
b)
Tables
c)
Formulae
d)
Statistical tools
32.

Which of the following is a valid function?

a)

=sum(A1:A6)

b)

sum=(A1:A6)

c)

=sum[A1:A6]

d)

=sum(A1,A6)

33.
I can find the lowest number in a range with the ... function
a)
MIN
b)
MAX
c)
AVERAGE
d)
COUNT
34.
Which formula would display "Yes" if D13 is greater than 0?
a)
=IF(D13>0,"Yes","No")
b)
=IF(D13<0,"Yes","No")
c)
=IF(D13>0:"Yes","No")
d)
=IF(D13<0:"Yes","No")
35.
Which formula would subtract D12 from D13?
a)
=D13-D12
b)
=D12-D13
c)
=sum(D12-D13)
d)
=sum(D13-D12)
36.
What function can be used to find the largest number in a range of numbers?
a)
=MIN
b)
=MAX
c)
=AVERAGE
d)
=SUM

Similar Resources on Wayground

DASAR-DASAR MICROSOFT OFFICE

40 questions

DASAR-DASAR MICROSOFT OFFICE

quiz

Worksheet

•

1st Grade - University

Google Docs

31 questions

Google Docs

quiz

Worksheet

•

6th Grade

Have fun with quiz !

39 questions

Have fun with quiz !

quiz

Worksheet

•

3rd Grade - University

CS Basics

35 questions

CS Basics

quiz

Worksheet

•

4th Grade - University

Google Sheets Basics

32 questions

Google Sheets Basics

quiz

Worksheet

•

6th - 9th Grade

Database - Intermediate Level Review

37 questions

Database - Intermediate Level Review

quiz

Worksheet

•

6th - 8th Grade

Excel 2: Fundamentals

37 questions

Excel 2: Fundamentals

quiz

Worksheet

•

6th - 8th Grade

MICROSOFT OFFICE

40 questions

MICROSOFT OFFICE

quiz

Worksheet

•

6th - 8th Grade