NEW
Font size
WorksheetsYear 8 - Spreadsheets - L6
Total questions: 16
Worksheet time: 8mins
Why might we add shapes and images to a spreadsheet?
To use more memory.
To distract the user.
To keep the spreadsheet interesting.
To waste time.
How could we add data validation to a spreadsheet in Microsoft Excel/Google Sheets?
From the home tab/formatting menu.
From the data tab/menu.
From the view tab/menu.
From the formulas tab/menu.
How do we add conditional formatting to a spreadsheet in Microsoft Excel/Google Sheets?
From the home tab or formatting menu.
From the data tab/menu.
From the insert tab/menu.
From the formulas tab/menu.
Which of these refer to a collection of cells?
A workbook
An Excel
A worksheet
A formula
Which of these refer to a collection of worksheets?
A workbook
An Excel
A worksheet
A formula
To change a cell's formatting based on it's value is known as?
Data Validation
Formula
Formatting Cells
Conditional Formatting
To restrict the values entered into a cell to a selection from a list is known as?
Data Validation
Formula
List Selection
Conditional Formatting
What formula must be written in cell G6 to divide cell C3 by C6?
=C3/C6
="C3"/"C6"
C3/C6
"C3"/"C6"
What symbol can we use to make a cell reference absolute?
£
%
$
^
When a cell reference is locked so that it does not move with the formula it is known as?
An absolute reference
A relative reference
A locked reference
A non moving reference
When a cell reference is unlocked so that it moves with the formula it is known as?
An absolute reference
A relative reference
An unlocked reference
A moving reference
An "If Statement" will:
guess a result
return a condition based on a result
return a result based on a condition
guess a condition
What will the following "If Statement" return?
Yes
No
Good
Bad
What will the following "If Statement" return?
Yes
No
Good
Bad
What formula is written in C20 to calculate the total hours needed?
=SUM(C6:C19)
=MAX(C6:C19)
=Total(C6:C19)
=MIN(C6:C19)
What formula is written in F20 to calculate the average target %?
=SUM(F6:F19)
=MAX(F6:F19)
=AVERAGE(F6:F19)
=MIN(F6:F19)
