wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Y9 IT spreadsheets Lesson 3

Total questions: 30

Worksheet time: 18mins

Name
Class
Date
1.
Sum, average, count, and maximum value are examples of what?
a)
Formulas
b)
Calculations
c)
Functions
d)
Spreadsheet Data
2.
What does the term “relative” mean for a formula?
a)
The formula remains unchanged when it is moved.
b)
The formula is related to another spreadsheet.
c)
The formula is related to the cells before it.
d)
The formula changes based on its location.
3.
What does the term “absolute” mean for a formula?
a)
The formula remains unchanged when it is moved.
b)
The formula is related to another spreadsheet.
c)
The formula is related to the cells before it.
d)
The formula changes based on its location.
4.
What character is used to change a cell references from relative to absolute?
a)
$
b)
%
c)
*
d)
+
5.
Which of the following formulas show the correct use of the SUM function?
a)
-SUM(G3-G10)
b)
=SUM(G3...G10)
c)
=SUM(G3:G10)
d)
+SUM(G3:G10)
6.

You can automatically adjust a column width to "fit" the content by:

a)

clicking the column heading

b)

clicking the row heading

c)

double-clicking between the two column headings

d)

double-clicking between the two cells

7.

What special formatting can you use to set your information apart from the other cells on your spreadsheet?

a)

Currency formatting

b)

Date & time formatting

c)

Sorting & filtering

d)

Borders & color shading

8.

Which of the following is the correct reference for a cell range?

a)

A2...E15

b)

F15-J28

c)

B2;F30

d)

A7:D20

9.

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

a)

Column C

b)

=SUM

c)

Row 1

d)

A5

10.

Spreadsheet columns are easily identified by:

a)

Roman numerals

b)

numbers

c)

letters

d)

colors

11.

Spreadsheet rows are easily identified by:

a)

numbers

b)

letters

c)

Roman numerals

d)

colors

12.

What is the cell reference of the active cell?

a)

A1

b)

4B

c)

BB8

d)

B4

13.

True or False: all formula starts with =SUM

a)

True

b)

False

14.

What does the function =SUM() do?

a)

Adds up Cells

b)

Sells Cells

c)

Multiplies Cells

d)

Divides Cells

15.

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

16.

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

17.

This tool is used to _________ the selected text.

a)

Bold face

b)

Colour

c)

Highlight

d)

Underline

18.
Which of the following is a valid formula?
a)
=sum(A1:A6)
b)
sum=(A1:A6)
c)
=sum[A1:A6]
d)
=sum(A1,A6)
19.
If B3:J8 is given, what is it referring to?
a)
range of cells B3 through J8
b)
only cell J8
c)
only cells B3 and J8
d)
only cell B3
20.
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")
21.
Which formula would subtract D12 from D13?
a)
=D13-D12
b)
=D12-D13
c)
=sum(D12-D13)
d)
=sum(D13-D12)
22.

What are the individual boxes on a spreadsheet called?

a)

Squares

b)

Cells

c)

Entry boxes

d)

Rectangles

23.

Why do businesses use modelling?

a)

To work out the monthly wage bill

b)

To predict future trends

c)

To identify how much stock is left at the end of the month

d)

To find out the weather

24.
What is being adjusted in this diagram?
a)
Cell A1
b)
Font Size
c)
Alginment
d)
Spacing
25.
In the diagram a row has been selected. If we Insert a new row into the spreadsheet where will the new row appear?
a)
Beneath the heading
b)
Between row 4 and 5
c)
After row 5
d)
After row 6
26.

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

a)

Font color

b)

Fill color

c)

Borders

d)

Bold

27.

To create an absolute cell reference ___________ sign is used before the parts of formula.

a)

#

b)

$

c)

*

d)

=

28.

In__________referencing the relative address of the cell gets adjusted with respect to the current cell.

a)

Relative

b)

Absolute

c)

Mixed

d)

Nil

29.

Cell address $A$4 in a formula means it is a

a)

Absolute cell reference

b)

Mixed cell reference

c)

Relative cell reference

d)

None of these

30.

The formula in cell A2 is B2+C3.On copying this formula to cell C2, the formula in cell C2 will be.

a)

=B2+C3

b)

=C3+B2

c)

=D2+E3

d)

=E3+D2

Similar Resources on Wayground

Programming Techniques

30 questions

Programming Techniques

quiz

Worksheet

•

8th - 10th Grade

Computer Spec - 10X4

25 questions

Computer Spec - 10X4

quiz

Worksheet

•

9th - 11th Grade

Operating system

25 questions

Operating system

quiz

Worksheet

•

7th Grade - University

Solutions. Test on un5 (Techn, modal perfect,quantifiers)

25 questions

Solutions. Test on un5 (Techn, modal perfect,quantifiers)

quiz

Worksheet

•

9th Grade - University

soal semester 1 kelas 8

25 questions

soal semester 1 kelas 8

quiz

Worksheet

•

7th Grade - University

teknowledge

25 questions

teknowledge

quiz

Worksheet

•

8th - 12th Grade

Computing Fundamentals Pt 2

35 questions

Computing Fundamentals Pt 2

quiz

Worksheet

•

6th - 8th Grade

Assessment Test for 3rd Qtr

25 questions

Assessment Test for 3rd Qtr

quiz

Worksheet

•

7th Grade