Excel Formulas and Functions Quiz

What is the first step in creating a formula in Excel?

• Type a forward slash

• Type a minus sign

• Type an equals sign

• Type a plus sign

Why is it better to use cell references instead of typing numbers directly in formulas?

• It prevents errors in calculations

• It is required by Excel

• It allows the formula to update automatically when cell values change

• It makes the formula look cleaner

Which function would you use to add up a range of cells in Excel?

• SUM

• MAX

• COUNT

• AVERAGE

What does the AVERAGE function do in Excel?

• Finds the highest number in a range

• Calculates the mean of a range

• Calculates the sum of a range

• Finds the lowest number in a range

Which function would you use to determine the highest value in a list?

• SUM

• MAX

• AVERAGE

• MIN

What is the purpose of the IF function in Excel?

• To count the number of cells

• To find the average of numbers

• To apply conditional logic

• To perform arithmetic operations

How can you ensure a cell reference does not change when copying a formula?

• Use a relative reference

• Use a dynamic reference

• Use a mixed reference

• Use an absolute reference

What symbol is used to create an absolute reference in Excel?

• Hash (#)

• Asterisk (*)

• Dollar sign ($)

• Ampersand (&)

What happens to a relative reference when a formula is copied to another cell?

• It causes an error

• It remains unchanged

• It adjusts based on the new location

• It becomes an absolute reference

Which key can be used to toggle absolute references in Excel?

• F2

• F4

• F3

• F1