Excel Formulas and Functions Quiz

Which of the following formulas correctly adds the values in cells A1 and A2?

• =A1+A2

• =SUM A1,A2

• =ADD(A1,A2)

• =TOTAL(A1:A2)

What does the formula =AVERAGE(B1:B5) do?

• Sums the numbers in B1 to B5

• Finds the largest value in B1 to B5

• Returns the average of values in B1 to B5

• Counts the values in B1 to B5

Which function returns the highest value from a list?

• =MAX(A1:A10)

• =LARGE(A1:A10)

• =HIGH(A1:A10)

• =BIGGEST(A1:A10)

What will =IF(5>3, "Yes", "No") return?

• 5

• No

• Yes

• Error

Which of the following is a correct way to multiply A1 by B1?

• =A1*B1

• =MULTIPLY(A1,B1)

• =PRODUCT A1 B1

• =A1xB1

Which chart type is best used to show percentages of a whole?

• Line chart

• Pie chart

• Column chart

• Scatter chart

Which tab on the Ribbon allows you to insert a chart?

• Page Layout

• Data

• Insert

• View

What does the dollar sign ($) in a formula indicate?

• A currency format

• An error

• An absolute reference

• A conditional format

Which of the following is an absolute reference?

• A1

• $A$1

• A$1

• A1$

What is a benefit of using named ranges?

• Increases file size

• Makes formulas easier to read

• Slows down calculation

• Prevents chart creation