Excel Refresher - Basic

Which of the following is a basic formula used to add the values in cells A1 and A2 in Excel?

• `=A1-A2`

• `=A1+A2`

• `=A1*A2`

• `=A1/A2`

How can you sort data in Excel from the highest to the lowest value?

• Use the "Sort A to Z" option

• Use the "Sort Z to A" option

• Use the "Filter" option

• Use the "Data Validation" option

Which function would you use to find the average of a range of cells in Excel?

• `=SUM()`

• `=AVERAGE()`

• `=COUNT()`

• `=MAX()`

What type of chart would be most suitable for showing the proportion of different categories in a dataset?

• Line Chart

• Bar Chart

• Pie Chart

• Scatter Plot

In Excel, what is the term for a reference that changes when a formula is copied to another cell?

• Absolute Reference

• Relative Reference

• Mixed Reference

• Static Reference

Which of the following functions would you use to count the number of cells that contain numbers in a range?

• `=COUNTA()`

• `=COUNTIF()`

• `=COUNT()`

• `=COUNTBLANK()`

Which of the following is a method to create a chart in Excel?

• Use the "Insert" tab and select "Chart"

• Use the "Home" tab and select "Format"

• Use the "Page Layout" tab and select "Themes"

• Use the "Review" tab and select "Spelling"

Insert the labels into the correct places in the exercise

a

b

c

d

e

f

=B17-C17

=G17-H17

=B6+C6

Column E

=G6*H6

Row 12