Mastering Excel: Skills for Success

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

• `=A1 + A2`

• `=ADD(A1, A2)`

• `=SUM(A1, A2)`

• `=TOTAL(A1, A2)`

What function would you use to find the average of the numbers in cells B1 through B10?

• `=AVERAGE(B1:B10)`

• `=MEAN(B1:B10)`

• `=AVG(B1:B10)`

• `=SUM(B1:B10)/10`

Which Excel feature allows you to visually represent data using bars, lines, or pie slices?

• Chart

• Pivot Table

• Data Validation

• Conditional Formatting

What is the purpose of the VLOOKUP function in Excel?

• To look up a value in a vertical column

• To calculate the sum of a range

• To find the maximum value in a dataset

• To create a chart

Which of the following is a method to apply the same formatting to multiple cells in Excel?

• Format Painter

• Copy and Paste

• Data Validation

• Conditional Formatting

How can you quickly sum a column of numbers in Excel?

• Use the AutoSum button

• Use the `=SUM()` function

• Manually add each cell

• Use the `=ADD()` function

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

• `=COUNT()`

• `=COUNTIF()`

• `=COUNTA()`

• `=COUNTBLANK()`

What is the primary use of a Pivot Table in Excel?

• To summarise and analyse data

• To create charts

• To format cells

• To perform calculations

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

• Histogram

• Bar Chart

• Line Chart

• Scatter Plot

What is the shortcut key to open the Format Cells dialog box in Excel?

• `Ctrl + 1`

• `Ctrl + F`

• `Ctrl + C`

• `Ctrl + P`