Excel Functions and Features Quiz(Class Test)

Which of the following is used to calculate the total of a range of cells in Excel?

• =AVG()

• =SUM()

• =COUNT()

• =TOTAL()

In Excel, what does a cell reference like A$1 indicate?

• Both column and row are fixed

• Only the row is fixed

• Only the column is fixed

• Neither the row nor the column is fixed

Which feature allows you to automatically fill cells with data that follow a specific pattern (e.g., dates or numbers)?

• AutoFilter

• AutoFormat

• AutoComplete

• AutoFill

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

• MAX()

• LARGE()

• HIGH()

• TOP()

Which of the following best describes a PivotTable in Excel?

• A chart type used for data visualization

• A tool for sorting and summarizing data dynamically

• A method for cell referencing

• A function for calculating percentages

How do you quickly add a new worksheet to an Excel workbook?

• Right-click on an existing sheet tab and select "Insert"

• Use the shortcut Ctrl + N

• Go to the "File" menu and choose "New Worksheet"

• Double-click on an existing sheet tab

What does the VLOOKUP function do?

• It searches for a value in the leftmost column of a table and returns a value in the same row from a specified column.

• It looks up a value in a vertical list and sorts it alphabetically.

• It validates data entry in a list.

• It converts text to numbers.

Which shortcut key combination is used to create a chart from selected data in Excel?

• Alt + F1

• Ctrl + Shift + C

• F2

• Alt + C

What type of chart would be best to show proportions of a whole?

• Bar Chart

• Line Chart

• Pie Chart

• Scatter Plot

In Excel, what is conditional formatting used for?

• To apply formatting to cells based on specific criteria

• To sort data in ascending or descending order

• To merge multiple cells into one

• To lock cells from editing