Font size
WorksheetsYear 8 Spreadsheet Quiz
Total questions: 50
Worksheet time: 27mins
What is the name of the "boxes" that you enter data into?
Box
Cell
Reference
address
If I type an "=" symbol into a box I am starting a:
(a)
=SUM() is an example of a:
(a)
What is wrong with this formula? = 1A + B1
It should be =A1 + B1
It should be =1A + 1B
It should be A1 + B1
It should be 1A + 1B
If I "format a cell for currency" will the value of the cell change?
No, the value stays the same but displays the £ sign
Yes, the £ will be stored in the cell address
What is wrong with this function? =SUM(A1,B12)
The function is missing a "
The function is missing a ;
The functions should be =add
The function is missing a :
The software to create a spreadsheet is called:
Office 365
Sheets
Excel
Access
=AVERAGE() will do what?
Calculate the mean
Calculate the mode
Calculate the median
Calculate the range
In Excel, if I want to create a bar chart I click "insert", then click...
(a)
Changing how a spreadsheet displays data is known as "F (a) g"?
In Excel, if I want to create a bar chart I click "insert", then click...
(a)
What is the green square in the corner of a cell called on a spreadsheet?
(a)
What is wrong with this function? =SUM(A1 + B1)
Needs a ,
Needs another bracket
Needs a : not a +
Needs a ;
Changing how a spreadsheet displays data is known as (a) .
What is wrong with this function? =AVARAGE(A1:B1)
Should be =AVE
Should be spelt "AVERAGE"
Nothing, it's fine
Needs a ;
In Excel, if I want to create a formula I must start with what?
(a)
What is wrong with this function? =MINIMUM(A1:B1)
Should be =MIN()
Should be =MINI()
Nothing is wrong with it
Should be ==Min()
Examples of cell references might be...
2A, H8, 19K
A2, H8, K19
The name given to a collection of cells going along in a straight line is:
Row
Column
What special name is given to a number in a spreadsheet?
Cell numbers
Value
Digits
Figures
What symbol do all formulas begin with?
-
+
?
=
A quick formula to add cells A3, A4, A5, A6, A7 and A8 would be:
=A8:A8
=sum(A3+A4+A5+A6+A7+A8)
=sum(A3:A8)
sum(A3:A8)
To multiply with a spreadsheet formula, you must use a different symbol. On your keyboard, this is:
£
X
*
?
Identify the type of formatting being described below:
Placing this around the cell makes it stand out by having a thick line around the cell or having a colour in the background of the cell.
Alignment of Data
Different fonts, styles, sizes
Formatting sales to currency/number/percentage to specified decimal places.
Borders and shading
Identify the type of formatting being described below:
Text can be placed horizontally in the left, right or centre. In the spreadsheet text is automatically left aligned and numbers and values are automatically right aligned.
The direction of the text within a cell can be rotated. Or the text can be wrapped to be shown over more than one line within a cell and also aligned horizontally. Wrapping text is more useful than inserting a long column heading.
Alignment of Data
Different fonts, styles, sizes
Formatting sales to currency/number/percentage to specified decimal places.
Borders and shading
Identify the type of formatting being described below:
A cell can be formatted to show any number entered to appear automatically with a £, % or with a specific number of decimal places for example two.
Alignment of Data
Different fonts, styles, sizes
Formatting sales to currency/number/percentage to specified decimal places.
Borders and shading
What is a workbook in spreadsheet software?
A collection of worksheets
A tool for creating graphs and charts
A formula that performs a calculation
A cell that contains data
What is the name of the cell that is currently selected or highlighted in a worksheet?
Active cell
Cell reference
Formula bar
Value
What is the name of the combination of letters and numbers that identifies the location of a cell in a worksheet?
Active cell
Cell reference
Formula bar
Value
What is the name of the area at the top of a worksheet that displays the contents of the active cell?
Active cell
Cell reference
Formula bar
Value
The values we enter into the table is called _________.
words
Data
A graphic representation of data. Can you guess the name of this chart?
Column Chart
Line Chart
What is the purpose of the MIN function
Add the numerical values in a range of cells
Find the lowest number in a range of cells
Find the highest number in the range of cells
Finds the average from a range of cells
What is the purpose of the MAX function
Add the numerical values in a range of cells
Find the lowest number in a range of cells
Find the highest number in the range of cells
Finds the average from a range of cells
Is the below a function or formula?
=SUM(A1:A5)
Function
Formula
Is the below a function or formula?
=(A1+A5)-(A5*A7)
Function
Formula
What is the purpose of spreadsheets?
To present information on different engaging slides
To deliver a speech to a crowd
To perform basic and complex mathematical calculations in an organized way
To excel your written work
Which formula would be used to calculate a total?
=MAX(B5:B10)
=SUM(B5:B10)
=AVGERAGE(B5:B10)
=SUM(B5*B10)
What data type is shown here: £34.50
Currency
Number
Text
Date
Use the spreadsheet you created, see sample in image. Which function calculates the total for score 1?
=Total(B2:B4)
=Sum(B2:B4)
=Sum(C2:C4)
=Total(C2:C4)
Use the spreadsheet you created, see sample in image. Type the CORRECT function that calculates the average for score 1?
(a)
Using the spreadsheet in the sample in image and a calculator. Type YOUR CORRECT answer as a digit. What is the answer in cell C7?
(a)
Using the spreadsheet in the image ad a calculator. Type YOUR CORRECT answer as a digit. What is the average for score 2? Rounded to 2 decimal places.
(a)
Use the spreadsheet in the image and a calculator. Type YOUR CORRECT answer as a digit. What is the average for score 1? Rounded to 2 decimal places.
(a)
Use the spreadsheet you created, see sample in image. Type YOUR CORRECT answer as a digit. What is the total for score 1?
(a)
Use the spreadsheet you created, see sample in image. Who got the highest number for score 2?
Pam
Shawna
Bobby
Floyd
Use the spreadsheet you created, see sample in image. Comparing their score 1 with score 2. Who got the greatest increase?
Pam
Shawna
Bobby
Green
Use the spreadsheet you created, see sample in image. Comparing their score 1 with score 2. Who showed a decline in their score?
Pam
Shawna
Bobby
Nobody
