Spreadsheet Formulas And Functions Quiz #3
15 Questions
| Total Attempts: 1542
Spreadsheet Formulas and Functions Quiz #3 from Atomic learning exercises
Questions and Answers
- 1.You do not need to take the time to create a formula for specific set of cells you can use the ________ __________ to do it for you.
- A.
Auto Fix
- B.
Auto Calculate
- C.
Auto Default
- D.
Sum
- 2.The Auto Calculate can be changed to display different features/ functions.
- A.
True
- B.
False
- 3.Creating formulas in Excel begin with using what symbol?
- A.
*
- B.
-
- C.
+
- D.
=
- 4.Each cell address is colored differently.
- A.
True
- B.
False
- 5.By using the cell name, such as C4, you do not have to go back into a formula and make changes when your information is changed or updated.
- A.
True
- B.
False
- 6.The function wizard will help you do what?
- A.
Set up a cell
- B.
Set up a formula
- C.
Set up a number
- D.
Save your work
- 7.Expanding and collasping the function dialoge box allows you to easily select the cell you wish to enter into your formula.
- A.
True
- B.
False
- 8.If there is an error in your formula, Excel will not identify the error.
- A.
True
- B.
False
- 9.What would a formula look like?
- A.
2.38+3.588.25
- B.
(C12:B12)
- C.
=3.65+ (3.65*0.03)
- D.
*A9+B9+C9=
- 10.You can copy and auto fill in a formula. This is called?
- A.
Referencing
- B.
Auto Formatting
- 11.There is no way to set a cell in a formula so that it will not change when using the Auto Fill.
- A.
True
- B.
False
- 12.What icon appears when you are about to Auto Fill
- A.
Black plus sign
- B.
White plus sign
- C.
Question mark
- D.
Hand
- 13.What is added to the formula to create an absolute reference?
- A.
?
- B.
&
- C.
$
- D.
#
- 14.An example of a formula that includes and absolute reference look like?
- A.
=C12+D12+E12
- B.
=C12*D12*E12
- C.
=C12+$B12$
- D.
=C12= B12=D12
- 15.What could you do to add an absolute reference?
- A.
Add dollar signs around the cell
- B.
Click F4
- C.
All of the Above
- D.
None of the ones listed
Back to top