ICT Mid-semester Exam

What function would you use to find the average of a range of cells?

• =SUM()

• =AVERAGE()

• =COUNT()

• =MAX()

Which of the following formats can you apply to a cell in Excel?

• Currency

• Percentage

• Date

• All of the above

What is the correct formula to calculate the total price if the unit price is in cell A1 and the quantity is in cell B1?

• =A1 + B1

• =A1 * B1

• =A1 - B1

• =A1 / B1

Which chart type would be best for showing the relationship between two variables?

• Pie Chart

• Line Chart

• Bar Chart

• Scatter Plot

To apply a filter on your data in Excel, you would go to which tab?

• Home

• Data

• Insert

• View

The formula to calculate the percentage increase is _________.

To create a new worksheet in Excel, you click on the _________ icon.

The shortcut to copy a cell is _________.

A _________ is a graphical representation of data.

The function that counts the number of cells that contain numbers is called _________.