Quiz on Excel

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

• A) MIN

• B) AVG

• C) MAX

• D) SUM

Which keyboard shortcut can you use to select the entire column in Excel?

• A) Ctrl + C

• B) Ctrl + A

• C) Ctrl + Spacebar

• D) Ctrl + Enter

What does the SUM function do in Excel?

• A) Finds the maximum value in a range

• B) Finds the average value in a range

• C) Adds up all the numbers in a range

• D) Finds the minimum value in a range

Which function would you use to count the number of cells containing numerical values in a range?

• A) COUNT

• B) AVERAGE

• C) SUM

• D) MAX

What is the purpose of the ENTER key in Excel?

• A) To confirm an entry or move to the next cell

• B) To delete the contents of a cell

• C) To undo the last action

• D) To save the workbook

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

• A) MIN

• B) AVG

• C) MAX

• D) SUM

What is the purpose of using a named range in Excel?

• A) To assign a specific name to a range of cells for easier reference

• B) To automatically update the range when new data is added

• C) To prevent other users from editing the range

• D) To apply conditional formatting to the range

How would you calculate the average of a range of cells in Excel?

• A) Using the AVG function

• B) Using the AVERAGE function

• C) Using the TOTAL function

• D) Using the MEAN function

What does the MAX function do in Excel?

• A) Returns the largest value in a range of cells

• B) Returns the smallest value in a range of cells

• C) Adds up all the numbers in a range of cells

• D) Finds the average value in a range of cells

What is the purpose of using conditional formatting in Excel?

• A) To apply a consistent formatting style to cells

• B) To visually highlight cells that meet certain criteria based on specified rules

• C) To automatically calculate values based on specified criteria

• D) To lock cells so that they cannot be edited