Excel Basics Quiz

A visual representation of data in a worksheet that can help you identify patterns and trends is called:

• Ribbon

• Chart

• Quick Access Toolbar

• Name box

How do you start a formula in Excel?

• By typing `=`

• By typing `+`

• By typing `-`

• By typing `*`

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

• `SUM`

• `AVERAGE`

• `MEDIAN`

• `MODE`

What is the shortcut to format cells in Excel?

• `Ctrl + F`

• `Ctrl + 1`

• `Ctrl + C`

• `Ctrl + V`

Which of the following is NOT a type of chart available in Excel?

• Bar Chart

• Line Chart

• Pie Chart

• Flow Chart

How can you apply data validation to a cell in Excel?

• By using the `Data` tab and selecting `Data Validation`

• By using the `Home` tab and selecting `Format Cells`

• By using the `Insert` tab and selecting `Table`

• By using the `Review` tab and selecting `Protect Sheet`

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

• `COUNT`

• `COUNTA`

• `COUNTIF`

• `COUNTBLANK`

What is the purpose of the `VLOOKUP` function in Excel?

• To look up a value in a vertical column

• To look up a value in a horizontal row

• To validate data in a cell

• To format cells based on conditions

How do you create a new chart in Excel?

• Select the data and press `Ctrl + C`

• Select the data and go to the `Insert` tab, then choose a chart type

• Select the data and press `Ctrl + V`

• Select the data and go to the `Home` tab, then choose `Format as Table`