Introduction to Excel Formulas

What is one of the most powerful features in Excel?

• Drawing graphs

• Calculating numerical information

• Designing presentations

• Writing essays

What is the result of changing a value in a cell that is part of a formula?

• The formula result remains unchanged.

• The formula result updates automatically.

• The formula is deleted.

• The spreadsheet crashes.

What is the purpose of selecting a cell before typing a formula?

• To change the cell color

• To enter data

• To contain the formula

• To delete the cell

What is the first step in creating a formula using the point-and-click method in Excel?

• Type the equals sign (=)

• Select the cell that will contain the formula

• Type the mathematical operator

• Select the cell you want to reference

What symbol is used to start a formula in Excel?

• +

• *

• /

• =

What should you do if Excel does not tell you about an error in your formula?

• Ignore it

• Check all of your formulas

• Delete the formula

• Save the document

What is the name of the tutorial mentioned for learning about Excel formulas?

• Excel Basics

• Excel Formulas

• Excel Charts

• Excel Formatting

Which cell is selected in the example to edit the formula?

• D9

• D10

• D12

• C4

What appears around any referenced cells when editing a formula?

• A highlight

• A border

• A shadow

• A dotted line

In the example, which cell is the formula changed to reference instead of D9?

• D8

• D10

• D11

• D12