wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Component 2 - Spreadsheets

Total questions: 96

Worksheet time: 45mins

Name
Class
Date
1.

Data is...

a)

A series of numbers or letters that have been processed

b)

A series of numbers or letters that have yet to be processed

c)

A series of numbers or letters that make complete sense

d)

A series of shapes and colours

2.

Information is...

a)

Shapes and colours

b)

Data that doesn't need to be processed

c)

Data that has not been processed

d)

Data that has been processed

3.

Which of these would be an example of a field name

a)

Surname

b)

6' 1"

c)

Green

d)

Red

4.

What are the four main characteristics that are added together to make information (one minute timer)

a)

Data

b)

Meaning

c)

Ideas

d)

Structure

e)

Context

5.

Which of these would be an example of data

a)

Millwall progress to the next round of the cup

b)

Lions maul Gunners!

c)

Shock Upset at the Emirates!

d)

Arsenal 1 - 2 Millwall

6.

Which of these would be an example of information

a)

Ireland are Rugby World Champions 2019!

b)

Ireland 17 - 10 New Zealand

c)

Ireland (W)

d)

17 - 10

7.

When data is structured, it is often (not always) split into which two things?

a)

Records

b)

Lines

c)

Fields

d)

Drawers

8.

The name of the single page that contains a quick and useful summary of data within a certain topic

a)

Poster

b)

Fun page

c)

Advert

d)

Infographic

9.

Checking that data conforms to certain rules is known as...

a)

Validation

b)

Verification

c)

Vilification

d)

VAR

10.

Making sure that an input is correct by checking it more than once (for example, when singing up for something, checking the password twice) i sknown as

a)

Validation

b)

Verification

c)

Vilification

d)

VAR

11.

There are two main categories of data collection methods...

a)

Reception

b)

Primary

c)

Nursery

d)

Secondary

12.

Data collected directly from the original source is known as

a)

Nursery

b)

Primary

c)

Reception

d)

Secondary

13.

Data that is collected by organisation other than the people who are actually using the data

a)

Nursery

b)

Primary

c)

Reception

d)

Secondary

14.

Many organisation collect large quantities of data. This is commonly referred to as...

a)

Large data

b)

Small data

c)

Massive data

d)

Big data

15.

Which of these factors affects the quality of the information (check more than one if required)

a)

Source/Collection method

b)

Amount of detail

c)

Accuracy

d)

Age

e)

Completeness

16.

What is the name of the spreadsheet package we have been using?

a)

Google Slides

b)

Microsoft Word

c)

Microsoft Excel

d)

Microsoft Access

17.

What is the term used for each box in a spreadsheet?

a)

Cell

b)

Box

c)

Field

d)

Record

18.

What is the term used for cells which appear going across the spreadsheet?

a)

Column

b)

Record

c)

Field

d)

Row

19.

What is the term used for cells which appear going up and down the spreadsheet?

a)

Field

b)

Row

c)

Column

d)

Record

20.

A cell can contain text, values and what else?

a)

Currency

b)

Percentages

c)

Formulae

d)

Dates

21.

What symbol is used to multiply?

a)

/

b)

-

c)

+

d)

*

22.

What symbol is used to divide?

a)

*

b)

+

c)

/

d)

-

23.

How must a cell containing a formula start?

a)

SUM

b)

=

c)

+

d)

( )

24.

What function is used to add more than 2 cells?

a)

+

b)

=

c)

SUM

d)

( )

25.
Which formula would you use to multiply cell B4 by cell C4?
a)
=B4*C4
b)
=B4xC4
c)
=(B4:C4)
d)
B4xC4=
26.
What does cell A1 contain?
a)
Sweet
b)
Mars
c)
A1
d)
Cost
27.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23
28.
What does cell C3 contain?
a)
23
b)
67
c)
Amount
d)
11.50
29.
What formula is used in cell D3?
a)
B3*C3
b)
B3+C3
c)
=B3*C3
d)
11.50
30.
What formula is used in cell D8?
a)
=D3*D4*D5*D6
b)
SUM(D3:D6)
c)
=69.10
d)
=SUM(D3:D6)
31.
What is displayed in cell A6?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
32.
What is displayed in cell B1?
a)
100
b)
Tickets Sold
c)
Day
d)
B1
33.
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
34.
What TAB allows you to add grid lines to your print out?
a)
Page
b)
Margins
c)
Header/Footer
d)
Sheet
35.
What TAB allows you to add your name to the foot of the  document?
a)
Page
b)
Margins
c)
Header/Footer
d)
Sheet
36.

What is a vertical section of a spreadsheet called?

a)

row

b)

cell

c)

rank

d)

column

37.

What is a horizontal section of a spreadsheet called?

(a)  

38.

What is an individual box where a row and column meet within a spreadsheet called?

a)

square

b)

range

c)

reference

d)

cell

e)

rectangle

39.

Which of the following is the correct way to type the location of a cell?

a)

8B

b)

B8

c)

8-B

d)

BB-8

40.

The location of a cell on a spreadsheet is a column letter followed by a row number. What is this called?

a)

Cell Range

b)

Active Cell

c)

Cell Reference

d)

Row

41.

What is the cell range in this diagram?

a)

A1:F1

b)

A1:A8

c)

A1:F8

d)

A1:1A

42.

Which of the following is an absolute cell reference?

a)

A2

b)

$A$2

c)

#A#2

d)

A:2

43.

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

44.

Which format is best suited to display a whole number including the thousands (comma) separator?

a)

Percentage

b)

Number

c)

General

d)

Currency

45.

All formulas in spreadsheets begin with which of the following symbol?

a)

+

b)

-

c)

=

d)

%

e)

!

46.

Which of these symbols is used for dividing in a spreadsheet?

a)

\

b)

/

c)

*

d)

|

47.

The following formula =6>8 is inserted in to a cell. What will be shown in the cell when this formula is executed?

a)

There is a mistake in the formula

b)

6>8

c)

TRUE

d)

FALSE

48.

Which formula is incorrect?

a)

=C5<>C7

b)

=A4>5

c)

=C2!C3

d)

=A3=A4

49.

How would we type the formula to add the June and July Budgets?

a)

=June+July

b)

=1200+1500

c)

=D10+D11

d)

=C10+C11

50.

What is the difference between a formula and a function?

a)

A function deals with a whole range of cells in one go and has a function name at the beginning, whereas a formula lists each cell individually and puts the correct mathematical operator between them

b)

A formula deals with a whole range of cells in one go and has a function name at the beginning, whereas a function lists each cell individually and puts the correct mathematical operator between them

c)

There is no difference between a formula and a function, they are the same

d)

A formula is something we use in maths, whereas a function is something we use in ICT

51.

What word is used to describe re-organising the order of data in spreadsheets?

a)

search

b)

sort

c)

fill

d)

filter

52.

Choose the correct word for the following: _______ are used to find all records matching a certain criteria at one place.

a)

Sorting

b)

Filters

c)

AutoSum

d)

Searches

53.

What does ascending order mean?

a)

It is the order of my ancestors

b)

Starting at the bottom and going up. For example: 0, 1, 2, 3, 4

c)

Starting at the top and going down. For example: 10, 9, 8, 7, 6

d)

There is no such thing as ascending order

54.

While creating a graph, the main reason to include logical title and axis labels is that

a)

Excel will not save your graph without them

b)

They make your graph look nice

c)

They make your graph to be meaningful to other people

d)

There is no reason to include them

55.

Looking at the image, what part is circled in red?

a)

Chart

b)

Chart Title

c)

Data Labels

d)

Legend

56.

What package do we use when creating spreadsheets?

a)

Excel

b)

PowerPoint

c)

Acess

d)

Publisher

57.

What does a spreadsheet NOT contain?

a)

Rows

b)

Columns

c)

Cells

d)

Word Art

58.

Each column is given a...

a)

Letter

b)

Number

59.

Each row is given a...

a)

Letter

b)

Number

60.

What key do we press to move along our spreadsheet?

a)

Space

b)

Backspace

c)

Tab

d)

Enter

61.

Each cell has a name

a)

True

b)

False

62.

What do we use at the beginning of a formula?

a)

+

b)

=

c)

-

63.

When you hover the mouse you don't click

a)

True

b)

False

64.

What column is this cell in...N17

a)

N

b)

M

c)

I

65.

We can perform sums in a spreadsheet

a)

True

b)

False

66.

We can highlight a selection of cells at one time

a)

True

b)

False

67.

Can we re-name a sheet?

a)

Yes

b)

No

c)

Depends

68.

Can we delete rows and columns?

a)

Yes

b)

No

c)

Sometimes

69.

By holding control B we can...

a)

Makes text larger

b)

Makes text smaller

c)

Makes text bold

70.

What type of chart is this?

a)

Pie

b)

Line

c)

Bar

71.

What type of chart is this?

a)

Line

b)

Bar

c)

Pie

72.
Boxes in Spreadsheets are called
a)
Excels
b)
Cells
c)
Cels
d)
Sells
73.
Data Type for displaying someone's wages
a)
Currency
b)
Text
c)
Number
d)
Date
74.
Data Type for displaying someone's name
a)
Currency
b)
Text
c)
Number
d)
Date
75.
Data Type for displaying someone's age
a)
Currency
b)
Text
c)
Number
d)
Date
76.
Data Type for displaying someone's birthday
a)
Currency
b)
Text
c)
Number
d)
Date
77.
=A4+B7
a)
Formula
b)
Function
78.
=SUM(A3:A17)
a)
Formula
b)
Function
79.
=AVERAGE(B3:B12)
a)
Formula
b)
Function
80.
=C16*10
a)
Formula
b)
Function
81.
=(D1+2.5)*100
a)
Formula
b)
Function
82.
=MAX(A4:A27)
a)
Formula
b)
Function
83.
=IF(F5>50,"Pass","Fail")
a)
Formula
b)
Function
84.
=D7*1.25
a)
Formula
b)
Function
85.
=A4+B7
a)
Adds the values in A4 and B7 together
b)
Multiplies the number in A4 by B7
c)
Multiplies A by 4 and adds it to B multiplied by 7
86.
=SUM(A3:A17)
a)
Adds the values in A3 and A17 together
b)
Finds the total of the numbers between A3 and A17
c)
Tells you how many cells there are between A4 and A17
87.
=AVERAGE(B3:B12)
a)
Tells you which number is closer to the average, B3 or B12
b)
Finds the mean of the numbers from B3 to B12
c)
Adds all the numbers between B3 and B12
88.
=C16*10
a)
Finds 10% of the number in C16
b)
Divides the value in C16 by 10
c)
Increases the number in C16 by 10%
d)
Multiplies the value in C16 by 10
89.
=(D1+2.5)*100
a)
Adds 2.50 to the number in D1 then multiplies by 100
b)
Finds 2.5% of the number in D1
c)
Shows the number in D1 as a percentage of 2.50
d)
Multiplies D1 by 100 then adds 2.50
90.
=MAX(A4:A27)
a)
Tells you which number is in A27
b)
Finds the biggest number in the cells between A4 and A27
c)
Shows the difference between the numbers in A4 and A27
91.
=IF(F5>50,"Pass","Fail")
a)
Displays Pass or Fail depending on whether the number in F5 is bigger than the number in 5O
b)
Displays Pass or Fail depending on whether a score in F5 is equal to 50
c)
Displays Pass or Fail depending on whether a score in F5 is over 50
92.
=D7*1.25
a)
Finds 25% of the number in D7
b)
Multiplies the number in D7 by 25
c)
Shows whether the number in D7 is 25% of another number
d)
Increases the number in D7 by 25%
93.
Which of these is NOT one of the three spreadsheet basics we learned?
a)
Functions
b)
Formulas
c)
Formatting
d)
Forwarding
94.
Which symbol do we use if we want to do a formula/function?
a)
%
b)
$
c)
=
d)
#
95.
If I save a spreadsheet, what file format does it save in?
a)
DOCX
b)
XLSX
c)
PPTX
d)
HTML
96.
Which type of chart/graph shows you the share of the total for each part?
a)
Column Chart
b)
Bar Chart
c)
Pie Chart
d)
Line Graph

Similar Resources on Wayground

NASA Test

101 questions

NASA Test

quiz

Worksheet

•

9th - 12th Grade

TKJ Test

100 questions

TKJ Test

quiz

Worksheet

•

10th - 12th Grade

Tes LCTK Lanjutan

100 questions

Tes LCTK Lanjutan

quiz

Worksheet

•

10th Grade - University

QUIZ KOMKOM

100 questions

QUIZ KOMKOM

quiz

Worksheet

•

9th Grade - University

Quis Siang

93 questions

Quis Siang

quiz

Worksheet

•

9th - 12th Grade

Ics Exam Prep

101 questions

Ics Exam Prep

quiz

Worksheet

•

10th Grade

OCR GCSE Computer Science - J276 1.1 - 1.7

91 questions

OCR GCSE Computer Science - J276 1.1 - 1.7

quiz

Worksheet

•

KG - Professional Dev...

Latihtubi ICT 2016

100 questions

Latihtubi ICT 2016

quiz

Worksheet

•

10th - 12th Grade