Font size
WorksheetsData Analysis Quiz - IGCSE
Total questions: 13
Worksheet time: 10mins
the intersection of a single
row and a single column
range
reference
cell
argument
cell reference
is the column letter followed by the row number
the intersection of a single row and a single column
graphical representation of your worksheet data
function tallies the number of occurrences of numerical data
to select an entire column, click the
CTRL+A
ALT+A
column heading
the first cell of column twice
Absolute cell reference
is group of selected cells which are highlighted
is reference which is automatically fills other cells
does not change when the formula is copied or moved to a new location
The equation used to calculate values in a cell using operators.
function
formula
argument
When you select a group
of cells, the group is called
a _________
reference
highlight
range
sheet
worksheet is always stored
in a _______________ that
contains one or more
worksheets.
workpage
workpaper
workbook
workpool
There are two types of references:
1._____________ : (B2:B6), C4
2.Absolute : $A$2, ($B$2:$B$6),
Changing
Fluctuate
Relative
Linked
Which function is used to add up values of cats from the given price list?
=SUMIF(B2,D7:D14)
=SUM(D7:D14)
=SUMIF(D7:D14,C2,B7:B14)
=SUMIF(B7:B14,B2,D7:D14)
If the mark is more than 50, the student passes. Which function we should use in D3? (We will use AutoFill for others)
=IF($B$3>50,"YES","NO")
=IF($C$3>50,"YES","NO")
=IF(C3>50,"YES","NO")
=IF(B3>50,YES,NO)
We create a _________________ and use it. These are reasons why we would create and use them:
Using a spreadsheet model/you change spreadsheet data
to explore different possible answers.
they are often financial, mathematic or scientific.
This is sometimes called ‘what if’ modelling/scenario.
It allows you to change variables and get answers without doing the real thing.
Mathematical model
Excel sheet
Data System
Data Model
The contents of cells A1 and A2 are multiplied together in A3. Explain why cell A3 shows this answer.
Format of cell is designed to show the number as in the picture
Formulae in A3 is wrong
A1 and A2 numbers are electronic passwords
The contents of A3 are too large to fit into the cell/column width.
The contents of spreadsheet cell can be:
label
program
formula
number
script
