Excel Functions and Graphs Quiz

What functions can be used to calculate the average in Excel?

• Sum, Count, Max

• Sumif, Countif, Mode

• If, Min, Mode

• Average, Sum, Max

Which arithmetic formulas can be used in Excel?

• +, -, /, ^

• *, /, %, ^

• *, +, -, /

• *, +, %, ^

What can be created in Excel to represent data visually?

• Tables, Equations, Functions

• Graphs, Charts, Tables

• Functions, Equations, Graphs

• Charts, Equations, Functions

Which function can be used to find the maximum value in Excel?

• Sumif

• Count

• Max

• Mode

What can be displayed in Excel to show the formulas used in the worksheet?

• Graphs

• Print

• Formulas

• Charts