WorksheetsSpreadsheets Quiz 1
Total questions: 18
Worksheet time: 9mins
What is one reason to use cell references in a formula?
The answer will change if the numbers in referenced cells change.
You need cell references to use functions.
Only formulas with cell references can be copied and pasted.
You need cell references to use operators.
Which of these adds two referenced cells?
=B3+C3
=B+C+3+3
=(B3,C3)
=B+C
What is the operator used to multiply?
@
^
/
*
If you type =1+1 in the formula bar, what will show in the cell after you hit Enter or Return?
=1+1
2
1+1
=2
Cell C1 has =A1+B1 in it. If you copy and paste cell C1 into cell C2, what will show in the formula bar for C2?
=A1+B1
=C1+C2
=A2+B2
=A1+B1+A2+B2
What would you type to find the sum of the cells D4 through D6?
=SUM(D4/D6)
=SUM(D4,D6)
=SUM(D4:D6)
=SUM(D4-D6)
How do you copy a formula from one cell into a large group of cells?
Select the group of cells and type the formula into the formula bar.
Retype the formula into each cell.
Copy the formula, select the group of cells, and paste.
Select the group of cells and hit Enter or Return.
What icon is used to add up selected cells?
In which table will the formula in cell B5 find the average distance of the player's two tosses?
Which of these will always divide the value of a cell A1 by 2?
=A1*B1
=A1/B1
=A1*2
=A1/2
What spreadsheet tool could be used to add together the numbers in a selected group of cells?
Sum
Merge
Sort
Hyperlink
Why would you choose to use a pie chart to show your data?
To show change over time.
To show trends in multiple data sets.
To show each axis point.
To show parts in terms of the whole.
Which chart has a vertical axis titled Cookies?
Which answer shows a correctly written absolute reference?
$A$20
$20.00
A20
(A20)
When using formulas in spreadsheet software, which of these operations happens first?
-
+
*
()
Which of these would find the average of cells A1 through A6 if it were typed into the formula bar for another cell?
$Average(A1:A6)
=(Average..A1:A6)
Average$A$1..$A$6
=Average(A1:A6)
Which answer is a good reason to save a spreadsheet to the cloud?
To publish the data directly to the Internet.
To find specific data quickly and easily.
To allow others to enter data and make changes in the spreadsheet.
To sort your data in descending or ascending other.
What symbol is needed to use functions in spreadsheet software?
#
=
$
()
