# Spreadsheet Formulas And Functions Quiz #3

15 Questions | Total Attempts: 1295  Settings  Spreadsheet Formulas and Functions Quiz #3 from Atomic learning exercises

• 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.
• A.

Set up a cell

• B.

Set up a formula

• C.

Set up a number

• D.

• 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

Related Topics Back to top