Excel Quiz

Which function in Excel is used to calculate the average of a range of cells?

• SUM

• AVERAGE

• MEDIAN

• COUNT

What is the correct formula to add the values in cells A1 and B1?

• =A1+B1

• =SUM(A1:B1)

• =ADD(A1,B1)

• =A1*B1

Which chart type is best for showing trends over time?

• Pie Chart

• Line Chart

• Bar Chart

• Scatter Plot

How can you apply bold formatting to the text in a cell?

• Right-click the cell and select "Bold"

• Press Ctrl + B

• Use the "Bold" button on the Home tab

• All of the above

Which function would you use to find the highest value in a range of cells?

• MIN

• MAX

• LARGE

• HIGHEST

What is the purpose of the VLOOKUP function in Excel?

• To look up a value in a vertical table

• To look up a value in a horizontal table

• To sum a range of cells

• To find the average of a range of cells

Which type of chart is best for comparing parts of a whole?

• Line Chart

• Pie Chart

• Column Chart

• Area Chart

How do you apply a filter to a column in Excel?

• Use the "Sort" button on the Home tab

• Use the "Filter" button on the Data tab

• Right-click the column and select "Filter"

• Use the "Find" button on the Home tab

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

• COUNT

• COUNTA

• COUNTIF

• COUNTBLANK

What is the shortcut to insert a new worksheet in Excel?

• Ctrl + N

• Shift + F11

• Ctrl + F11

• Alt + N