WorksheetsIGCSE ICT - Data Analysis
Total questions: 35
Worksheet time: 6mins
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
You can use this feature to fill in a series of numbers and dates.
AutoCorrect
AutoFill
AutoComplete
AutoFix
With the __________________ feature, Excel
compares the first few characters
you enter in a cell to existing entries
in the same column and proposes
the existing entry. You can press
Enter to accept the proposed entry.
AutoFill
AutoComplete
AutoCorrect
AutoFix
This feature in
Excel corrects common
mistakes as you enter data.
AutoFix
AutoCorrect
AutoComplete
AutoFill
The ______________ feature
enables you to repeat the
same data in a column or
row.
AutoFix
AutoComplete
AutoCorrect
AutoFill
a value, a cell reference, a
range, or text that acts as an
operand in a function formula
and it is enclosed in
parentheses after the function
name.
argument
criteria
reference
function
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
When you _______ data, the
data that does not meet
the criteria is hidden, and
only the data that meets
the criteria is shown.
hide column
hide row
filter
edit
The equation used to calculate values in a cell using operators.
function
formula
argument
Items on either side of an operator in a formula. In Excel, __________s can be values, cell references, names, labels, and functions.
operand
function
formula
operator
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
Rounds a number down to the nearest integer that is less than or equal to it.
ROUND
INT
MODE
FULL
Which one is correct formula for IF function?
=IF(value if true, value if false)
=IF(logical expression, value if false, value if true)
=IF(logical expression, value if true, value if false)
=IF(reference, value if true, value if false)
=__________(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact match).
HLOOKUP
VLOOKUP
COUNITF
SEARCHIF
Which are correct formulas for nested ifs with 3 criteria?
=IF(logical expression, value if true, IF(logical expression, value if true, value if false))
=IF(logical expression, value if true, IF(logical expression, value if true, IF(logical expression, value if true, value if false))
=IF(logical expression, value if true, IF(logical expression, value if true, IF(logical expression, value if true))
=IF(logical expression, value if true, IF(logical expression, value if false)
Which are types of test data?
extreme data
ordinary data
normal data
error data
abnormal data
Extreme data is
Are normal data, lowest possible values
Are abnormal data, lowest and highest possible values
Are normal data, lowest and highest possible values
Are normal data, highest possible values
System was designed to
accept and process marks and grades
in percentages. Which are abnormal data for this system?
0,100,43
-1,102,210
93,12,48
21,2,99
There are two types of references:
1._____________ : (B2:B6), C4
2.Absolute : $A$2, ($B$2:$B$6),
Changing
Fluctuate
Relative
Linked
Which button is used to bring INSERT FUNCTION window?
1
2
3
4
We use ______________ to find how many numbers are in a range?
COUNTA
COUNTIF
COUNTING
COUNT
______________ function is used to find the nearest whole number to a numeric value
INT
ROUND
WHOLE
NEAREST
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 we want to use AutoFill feature to calculate value of Dogs and Goats what function we should use in cell D2?
=SUMIF($B$7:$B$14,$B$2,$D$7:$D$14)
=SUMIF($B$7:$B$14,B2,$D$7:$D$14)
=SUMIF(B7:B14,B2,D7:D14)
=SUMIF($D$7:$D$14,D2,$B$7:$B$14)
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)
Which wildcard filter combination is used?
*ons
~ons~
*ons*
?ons?
Which wildcard filter combination is used?
*on*
?on?
?on???
*on
Which are simple mathematical operators used in a spreadsheet.
Operator: / Name: Division
Operator: * Name: Multiplication
Operator: + Name: Addition
Operator: - Name: Subtraction
Operator: ^ Name: Indices/Powers
ALL
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
A range/array of cells given a pre-defined name ...
... which is short and meaningful
... which is understood by the spreadsheet to refer to those cells.
It is easier to remember and use this name (e.g. VAT) than the cell references (e.g. $F$14:$G$16).
named cells
active range
named ranges
named reference
