Microsoft Excel Quiz

What is Microsoft Excel primarily used for?

• Creating presentations

• Writing documents

• Creating and analyzing spreadsheets

• Editing images

In Excel, what is a collection of cells called?

• Rows

• Columns

• Worksheets

• Range

What is a cell reference in Excel?

• The text label of a cell

• The row and column location of a cell

• The data entered in a cell

• The color of a cell

Which Excel feature allows users to summarize and analyze data using various functions?

• Charts and graphs

• Formulas

• Data validation

• Conditional formatting

Which Excel function is used to add up a range of numbers?

• AVERAGE

• COUNT

• SUM

• MAX

What is the keyboard shortcut to save an Excel workbook?

• Ctrl + S

• Ctrl + C

• Ctrl + V

• Ctrl + P

Which chart type is used to compare values across different categories in Excel?

• Bar chart

• Pie chart

• Line chart

• Scatter plot

What does the AutoSum button in Excel do?

• It adds a new worksheet to the workbook

• It automatically inserts the SUM formula for the selected range

• It saves the current workbook

• It creates a new workbook

What does the COUNT function in Excel do?

• It calculates the total count of numbers in a range.

• It counts the number of cells that contain text.

• It counts the number of cells that are not empty.

• It calculates the average of a range of numbers.

How can you apply a currency format to a cell in Excel?

• Select the cell and click on the Currency button in the Home tab.

• Right-click the cell, choose Format Cells, and select Currency from the list.

• Press Ctrl + Shift + C.

• Press Ctrl + B.