Worksheets04 | Spreadsheets (Assessment)
Total questions: 29
Worksheet time: 24mins
What is the cell reference of the Yellow cell?
A1
C4
B3
C3
To change the Cell Colour of the cell you would click...
A
B
C
D
To change the font style of the selected cells you would click...
A
B
C
D
To change the Font colour of the cell you would click...
A
B
C
D
What does this symbol do? /
Divide
Add up
Subttract
Multiply
What is a spreadsheet function?
A type of software used for creating and editing spreadsheets.
A feature that allows you to change the appearance of cells in a spreadsheet.
A built-in formula that performs calculations and manipulates data in a spreadsheet program.
A tool that allows you to import and export data from a spreadsheet program.
Which of the following is a function used to analyze data in a spreadsheet?
AVERAGE
COUNT
SUM
all of the above
Which of the following chart types is best suited for comparing values across different categories?
line chart
scatter plot
pie chart
bar chart
Which of the following functions can be used to find the highest value in a range of cells in a spreadsheet?
MIN
MAX
SUM
AVERAGE
What does the COUNTA function do?
Counts the number of empty cells
Counts the number of non-empty cells
Counts the number of cells that meet a specific condition
Adds up the values in a range of cells
How would you write a formula to sum the values in cells B1 to B5?
=SUM(B1:B5)
=AVERAGE(B1:B5)
=COUNT(B1:B5)
=IF(B1:B5)
What is the purpose of the IF function in a spreadsheet?
To add up values
To count cells
To perform a logical test and return one value if true and another if false
To find the average
How would you write a formula to count the number of cells in the range C1 to C10 that contain the text "Pass"?
=COUNT(C1:C10, "Pass")
=COUNTA(C1:C10, "Pass")
=COUNTIF(C1:C10, "Pass")
=SUM(C1:C10, "Pass")
Which function would you use to find the lowest value in a range of cells?
MIN
MAX
AVERAGE
SUM
Is Column B being used to filter this spreadsheet?
YES
NO
What is the difference between a formula and a function?
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
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
There is no difference between a formula and a function, they are the same
A formula is something we use in maths, whereas a function is something we use in ICT
What word is used to describe re-organising the order of data in spreadsheets?
search
sort
fill
filter
Choose the correct word for the following: _______ are used to find all records matching a certain criteria at one place.
Sorting
Filters
AutoSum
Searches
What does ascending order mean?
It is the order of my ancestors
Starting at the bottom and going up. For example: 0, 1, 2, 3, 4
Starting at the top and going down. For example: 10, 9, 8, 7, 6
There is no such thing as ascending order
Spreadsheet models can be used to ask ‘What if….’ questions.
They can be used to try out different options by changing figures in the spreadsheet. This will help to predict what will happen and try out different scenarios
False
True
Which is not data validation?
The checking of data, on input or by software to make sure that it is sensible.
The checking of data, on input or by software to make sure that it is reasonable
A way of checking that something has been entered correctly.
The process of establishing the truth, accuracy, or validity of something.
What will this function will do =MAX(B10:B20)
Max up B10 to B20
Max up the cells in the range
Max up the function
It will find and return the maximum value found in the cells between B10 and B20
Checking that the data entered is sensible is called:
(a)
What symbol should be used to perform a multiplying calculation?
+
-
*
/
What are spreadsheets used for?
To perform powerful calculations
Make graphs and charts
Analyse patterns in the data
To store information and data
A cell reference is the specific location of the active cell (E.g. A1).
True
False
Match the following spreadsheet vocabulary.
Range
A selection of cells.
Formula
A complete mathematical expression.
Function
An stored instruction (e.g. SUM)
Cell Reference
e.g. A1, B7 etc.
Modelling
Using a spreadsheet to test scenarios.
