Excel Review

What is the formula to calculate the average of a set of numbers?

• =MEAN

• =AVERAGE

• =AVG

• =COUNTA

What is the formula to find the highest value in a set of cells?

• =HIGH

• =HIGHEST

• =MAXIMUM

• =MAX

What is the correct way to write cells A1 through C10?

• A1-C10

• A1:C10

• A1,C10

• A1;C10

What is the correct way to write cells A1 AND C10?

• A1,C10

• A1&C10

• A1;C10

• A1 and C10

Which tabs do you find the AutoSum (Σ) function on? PICK TWO

• Home

• Insert

• Page Layout

• Formulas

What is it called when an equation remains constant no matter where it is copied to?

• Constant Cell Reference

• Relative Cell Reference

• Same Cell Reference

• Absolute Cell Reference

You have a ranged table from B2:D8 named "Sales". How would you reference this range in an equation? (Pick 2)

• =sum(B2:D8)

• =sum(B2:D8,Sales)

• =sum(Sales)

• =sum(B2Sales)

If you wanted to combine the first name column and the last name column to create a new, first and last name column, which function would you use?

• =MERGE

• =CONCAT

• =COMBINE

• =TOGETHER

How do you insert a "Doughnut" pie chart?

• Home>Tables>Pie Charts>Doughnut Pie

• Insert>Tables>Pie Charts>Doughnut Pie

• Home>Charts>Pie Charts>Doughnut Pie

• Insert>Charts>Pie Charts>Doughnut Pie

How do you change a chart legend from the bottom to the top?

• Chart Elements>Legend>Top

• Chart Format>Legend> Top

• Chart Design>Legend> Top

• Chart Format>Edit> Legend>Top