Excel Formulas Quiz

What is the first character that all formulas in Excel must begin with?

• -

• *

• =

• +

Which mathematical operator is used for multiplication in Excel formulas?

• /

• *

• +

• -

What happens if the result of a formula is too large to be displayed in a cell?

• It shows an error message.

• It disappears completely.

• It appears as pound signs (#######).

• It automatically adjusts the cell size.

What is the advantage of using cell references in formulas?

• They require less memory.

• They make formulas more complex.

• They can only be used in certain cells.

• They allow for automatic recalculation when values change.

Which key combination shows all formulas in a spreadsheet?

• Shift + `

• Ctrl + F

• Ctrl + `

• Alt + F

What is the purpose of the fill handle in Excel?

• To delete formulas.

• To copy formulas to adjacent cells.

• To format cells.

• To create new worksheets.

What should you do if you want to edit a formula in Excel?

• Right-click and choose 'Edit'.

• Double-click the cell or use the formula bar.

• Select the cell and press Delete.

• Press the Esc key.

Which operator is used for addition in Excel formulas?

• ^

• /

• +

• -

What is the point-and-click method used for in Excel?

• To format text.

• To create formulas without typing cell addresses.

• To enter data.

• To create charts.

What does modifying a value in a referenced cell do to the formula?

• It requires rewriting the formula.

• It deletes the formula.

• It changes the cell color.

• It automatically updates the calculated value.