WorksheetsSpreadsheets
Total questions: 23
Worksheet time: 15mins
What does the button in red mean?
Align the text on the borders of the page
Extend the content on the entire length of the cell.
Group together the selected cells and center the content.
None of the above
If you copy the formula =$B38 into another cell, the result will be:
The column part will remain the same
The row part will remain the same
Both the column and row will remain the same
Both will change
What function offers you the possibility to view different results depending on the entered condition?
=if()
=sumif()
=sum()
=TRUEFALSE()
Which of the following cursor allows you to select a range of cells
Appears at the border of the column letters. Drag to widen or narrow the width of a column.
Used to select a whole row/column when positioned on the row number or column letter.
The fill handle - used for copying formula or extending a data series.
###### means:
You've entered a number wrong.
You've misspelled something.
The cell is not wide enough.
What must all formulas start with?
+
=
#
sum
Each box on a spreadsheet is called a ...
row
column
cell
box
Rows on a spreadsheet are identified by a ...
number
letter
symbol
smiley face
Format cells as ______________ when working with amounts of money.
currency
percent
number
scientific
A ___________ is an equation to solve a mathematical problem.
FUNCTION
FORMULA
CELL
ROW
A group of cells in a worksheet is called a __________________
COLUMN
ROW
RANGE
FORMULA
The selected or highlighted cell in a spreadsheet is called ______________
CELL
SELECTED RANGE
ACTIVE CELL
NONE
