NEW
Font size
WorksheetsUnit 04 - Produce a range of spreadsheets
Total questions: 20
Worksheet time: 5hrs 0mins
What do all calculations start with?
=
(
-
\
What symbol should be used to perform an adding calculation?
+
-
*
/
What symbol should be used to perform a multiplying calculation?
+
-
*
/
A spreadsheet is made up of one "workbook" and can have have many "worksheets".
True
False
What is the name of each "box" on a spreadsheet?
Cell
Box
Rectangle
What is the name for a line of cells that go across the spreadsheet?
Row
Column
Field
Record
What is the name for a line of cells that go down the spreadsheet?
Cell
Row
Field
Record
Column
A cell reference is the specific location of the active cell (E.g. A1).
True
False
What is the correct order for the parts that make up a Cell Reference?
Letter then Number
Number then Letter
The cell in which you are working, outlined in a darker color than the rest of the cells
Last Cell
Next Cell
Active Cell
Inactive Cell
If I wanted to know the total amount of bonuses given to the employees I would write the following formula in cell D12:
=sum(C2:C11)
=sum(D2,D3,D4,D5,D7,D8,D9,D10,D11)
=sum(D2:D11)
$13,442.90
Excel is a:
database application
spreadsheet application
word processing application
none of the above
