Font size
WorksheetsYr 7 - Spreadsheet / KEQ
Total questions: 20
Worksheet time: 12mins
In a spreadsheet is a group of cells located horizontally on the worksheet, they are represented by numbers
(a)
In a spreadsheet is a group of cells located vertically on the worksheet, they are represented by letters
Is a place in the spreadsheet, which is a small box, where values can be entered
(a)
Is a specific location in the spreadsheet, it is a name of an individual cell, such as B5
Where colours, fonts and borders are used to make the spreadsheet look more professional
They calculate values in a spreadsheet, they always start with equals. E.g =A1+A2, this would add the values in the two cells
(a)
These are preset formulas, which are used to calculate certain values in the cells
A function used to add up the total of all values
A function used to find the lowest value
A function used to find the highest value
A function used to find the average value
A function used as a condition
IF
What is the term for a horizontal group of cells in a spreadsheet?
Column
Row
Cell
Sheet
Which function is used to count the number of entries in a range?
SUM
COUNT
AVERAGE
MAX
What is the name of the feature that allows you to apply the same formula to multiple cells?
AutoFill
Copy-Paste
Drag and Drop
Format Painter
What is the function used to concatenate text strings in a spreadsheet?
CONCATENATE
JOIN
MERGE
COMBINE
Which feature allows you to lock specific rows or columns in place while scrolling?
Freeze Panes
Lock Cells
Anchor
Pin
What is the term for a pre-defined set of formatting options in a spreadsheet?
Template
Style
Theme
Layout
What is the feature that allows you to quickly fill cells with repetitive or sequential data?
AutoFill
QuickFill
DataFill
FastFill
What is the term for a vertical group of cells in a spreadsheet?
Row
Column
Cell
Sheet
