NEW
Font size
WorksheetsSpreadsheet (Quiz 1)
Total questions: 21
Worksheet time: 10mins
Appears at the border of the column letters. Drag to widen or narrow the width of a column.
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.
The cell in your worksheet that has been selected. It will have bolder gridlines around it.
active cell
cell address
cell grid
column
The name of the cell is determined by the name of the column and the row intersecting.
label
heading
active cell
cell address
In a worksheet, the vertical spaces with headings using A,B,C and so on.
cell grid
column
label
row
In a worksheet, the horizontal spaces with headings using 1,2,3 and so on.
row
column
headings
label
The identifying name that reflects the information contained in a column or a row.
workbook
cell
cell grid
label
What does every formula in MS EXCEL start with?
+
-
=
*
What is the symbol for division when using MS EXCEL.
/
+
*
-
What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol.
SUMMING
SUM
ALL
None at all
Which is a formula using MS Excel using addition.
2 + 3 =
= A + B
=A2+B3
A2+B3
What is a way to add up a column of numbers without using the symbol + ?
=SUM(A2:F2)
EQUAL +
=SUM(A2:A7)
=(A2*F2)
Which Formula is written correctly for multiplying cell A1 and A7?
=A1+A7
=A1*A7
A1+A7
A1*A7
When is a MS Excel Spreadsheet used?
Making a Drawing
When Reading
For Collecting Information
For Baking a Cake
