Excel Formula Basics Quiz

What is the first step in creating a formula to add two numbers in Excel?

• Type the numbers directly into the cell

• Left-click on the cell where you want the result

• Press the Enter key

• Highlight both cells with numbers

After selecting the first cell in a formula, what symbol should you type next?

• Plus sign (+)

• Equal sign (=)

• Minus sign (-)

• Asterisk (*)

How can you use a formula to add values from multiple cells across a spreadsheet?

• By typing the values directly into the formula

• By using the SUM function

• By selecting each cell and using the plus sign

• By copying and pasting the formula

What is the result of adding the values from cells E2, I1, F4, H3, and G5?

• 200

• 300

• 244

• 150

When typing values directly into a formula, what is the final step to obtain the result?

• Click on another cell

• Press the Tab key

• Type a semicolon

• Press the Enter key