NEW
Font size
S
M
L
XL
WorksheetsSpreadsheets Introduction
Total questions: 25
Worksheet time: 13mins
Name
Class
Date
1.
Which of the following is not a popular spreadsheet software?
a)
MS Excel
b)
Google Sheets
c)
Google Spreads
d)
Open Office Calc
2.
What kind of software are spreadsheets?
a)
Modelling
b)
Graphics
c)
Database
d)
Calculator
3.
A spreadsheet is made of cells organised into horizontal rows and vertical?
a)
Columns
b)
Fields
c)
Records
d)
Blocks
4.
G5 is an example of a?
a)
Relative Cell Reference
b)
Cell Coordinate
c)
Absolute Cell Reference
d)
Cell Specification
5.
Cells can contain numeric values, formulas or?
a)
Text Strings
b)
Text Values
c)
Letter Variables
d)
Word Values
6.
SUM, IF, COUNTIF, AVERAGE & VLOOKUP are all examples of?
a)
Functions
b)
Formulas
c)
Filters
d)
Validations
7.
Which of the following is a valid formula?
a)
=sum(A1:A6)
b)
sum=(A1:A6)
c)
=sum[A1:A6]
d)
=sum(A1,A6)
8.
Which of the following is a valid formula?
a)
=C7*C8
b)
=(C7\C8)
c)
=(C7xC8)
d)
=AVERAGE(C7*C8)
9.
To show only data that matches specific criteria use a?
a)
Filter
b)
Sort
c)
Validation
d)
Functiob
10.
Putting cells into A-Z order is called?
a)
Sort Ascending
b)
Sort Descending
c)
Filter Ascending
d)
Filter Descending
11.
To restrict the data that can be entered into a cell e.g. Gender = "M" or "F", is called?
a)
Validation
b)
Verification
c)
Filter
d)
Sort
12.
Changing the appearance of a cell based on a rule is called?
a)
Conditional Formatting
b)
Validation Formatting
c)
Filter Formatting
d)
Sort Formatting
13.
A feature to make data fit inside a cell?
a)
Wrap Text
b)
Warp Text
c)
Conditional Formatting
d)
Filter Text
14.
To show the quantities in particular categories use a?
a)
Column Chart
b)
Line Graph
c)
Scatter Graph
d)
Sort Chart
15.
Column charts should always include?
a)
Title, Axis Labels & Correct Scale
b)
Title, Legend, Correct Scale
c)
Axis Labels & Legend
d)
Correct Scale, Colours & Title
16.
Which chart should you use to show changes over time?
a)
Line
b)
Scatter
c)
Pie
d)
Bar
17.
Which formula would you use to multiply cell B4 by cell C4?
a)
=B4*C4
b)
=B4xC4
c)
=(B4:C4)
d)
B4xC4=
18.
Which formula would you use to add all the cells from D4 to D12?
a)
=sum(D4:D12)
b)
=sum(D4*D12)
c)
=sum(D4+12)
d)
=(D4:D12)
19.
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")
20.
Which formula would subtract D12 from D13?
a)
=D13-D12
b)
=D12-D13
c)
=sum(D12-D13)
d)
=sum(D13-D12)
21.
Which of the following is a valid COUNTIF formula?
a)
=COUNTIF(ZOO,"L")
b)
=COUNTIF(ZOO,'L')
c)
=COUNTIF("L",ZOO)
d)
=COUNTIF('L',ZOO)
22.
A1:D4 is an example of a cell...
a)
Range
b)
Selection
c)
Highlight
d)
Choice
23.
$C$3 is an example of a...
a)
Absolute Cell Reference
b)
Relative Cell Reference
c)
Absolute Cell Coordinate
d)
Relative Cell Coordinate
24.
To join several cells together to make one cell use...
a)
Merge & Center
b)
Fill & Center
c)
Link & Center
d)
Split & Center
25.
Modelling software allows us to change variables and ask...
a)
what if questions
b)
when if questions
c)
where if questions
d)
why if questions
Reset
