Font size
Worksheetsmore on spreadsheets chapter 6
Total questions: 15
Worksheet time: 11mins
1. THE SUM OF VALUES divided by the number of values is called the_______________.
average
maximum value
percentage
function
2. which of these is another name for a pre-written formula?
reference
function
value
selection
3. which of these is used to find the total of a cell range?
MIN
MAX
SUM
COUNT
4.which of these is a value?
()
+
word
100
5. which of these is not an operator?
+
-
()
/
The default row height is (a) points.
new rows can be inserted from the (a) tab.
a formula always begins with an (a) sign.
we use the (a) function to find the total of a range of values.
the charts group is found on the (a) tab.
A cell reference includes a column letter and a row number.
true
false
The autofill handle is used to copy a formula in adjacent cells.
true
false
The Hide option increases the column width automatically.
true
false
Up to 200 characters can be inserted in a single cell.
true
false
New columns are always inserted to the right of the selected column.
true
false
