NEW
Font size
WorksheetsYear 7 HT2 Spreadsheet Assessment
Total questions: 30
Worksheet time: 15mins
What does the formula =SUM(A1:A10) do?
Returns the SUM of the selected cells
Returns the AVERAGE of the selected cells
Returns the HIGHEST value of the selected cells
Returns the LOWEST value of the selected cells
Which formula returns the AVERAGE of the selected cells?
=SUM(A1:A10)
=AVERAGE(B1:B10)
=MAX(C1:C10)
=MIN(B1:B10)
What does the formula =MAX(C1:C10) do?
Returns the SUM of the selected cells
Returns the AVERAGE of the selected cells
Returns the HIGHEST value of the selected cells
Returns the LOWEST value of the selected cells
Which formula returns the LOWEST value of the selected cells?
=SUM(A1:A10)
=AVERAGE(B1:B10)
=MAX(C1:C10)
=MIN(B1:B10)
What does the formula =COUNT(C1:C10) do?
Returns the number of cells values of the selected cells
Returns the SUM of the selected cells
Returns the AVERAGE of the selected cells
Returns the HIGHEST value of the selected cells
Which operator is used to add two numbers/cells in Excel?
+
-
*
/
Which operator is used to multiply two numbers/cells in Excel?
+
-
*
/
Which operator is used to divide one number/cell from another in Excel?
+
-
*
/
What does the formula =COUNTIF(A1:A10, ">5") do?
Counts the number of cells with values greater than 5
Returns the SUM of the selected cells
Returns the AVERAGE of the selected cells
Returns the HIGHEST value of the selected cells
Which formula returns the number of non-empty cells in a range?
=COUNTA(A1:A10)
=COUNTBLANK(A1:A10)
=COUNTIF(A1:A10, ">0")
=COUNT(A1:A10)
What does the formula =IF(A1>10, "Yes", "No") do?
Returns "Yes" if A1 is greater than 10, otherwise returns "No"
Returns the SUM of the selected cells
Returns the AVERAGE of the selected cells
Returns the HIGHEST value of the selected cells
In a worksheet, the vertical spaces with letter headings are called...
columns
files
rows
formulas
In a worksheet, the vertical spaces with letter headings are called...
columns
files
rows
formulas
When you move information while holding down the mouse button (usually the left) to select a range of cells.
Drag
File
Label
Sheet tab
The cell in your worksheet that has been selected. It will have bolder gridlines around it.
Active cell
Autofill
Cell
Cell grid
A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.
Autofill
Cell Address
Fill down
Worksheet
A function that automatically identifies and adds ranges of cells in your worksheet.
Autosum
Average
Finance
Drag
The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.
Cell
Cell address
Cell grid
Column
The name of the cell is determined by the name of the row and the column intersecting, such as A8.
Cell address
Cell grid
Formula bar
Heading
A document that is stored on your computer. In Excel, a file is also known as a workbook.
File
Fill down
Formula
Grid
A feature that allows you to copy information in an active cell to another cell or range of cells you have selected vertically.
Fill down
Formula
Workbook
Fill right
A combination of numbers and symbols used to express a calculation. Always begins with a = sign.
Formula
Formula bar
Autosum
Average
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
Formula bar
Function
Heading
Label
A drop-down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet.
Function
Fill right
Row
Column
The identifying letters and numbers for columns and rows. Columns are identified with letters and rows with numbers.
Headings
Labels
Rows
Columns
The name that reflects the information contained in a column or row, such as a name or date. Labels are usually letters!
Label
Function
Row
Cell grid
In a worksheet, the horizontal spaces with the headings 1, 2, 3, and so on.
Rows
Columns
Labels
Headings
A feature that allows you to copy information in an active cell to another cell or range of cells you have selected horizontally.
Fill right
Fill down
Formula
Field
An Excel file that contains individual worksheets. Also called a spreadsheet file or file.
Workbook
Sheet
Sheet tab
Formula
Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on. You can rename the tabs. Each represents a worksheet within the workbook.
Sheet tabs
Workbook
File
Formula
