Microsoft Excel Basics Quiz

What is a spreadsheet?

• A computer program used to organize and process mathematical data.

• A type of chart used in Microsoft Excel.

• A tool for managing files on a computer.

• A programming language.

How can you close Microsoft Excel?

• Click the FILE tab and select close.

• Click the Close button on the title bar.

• Click the combination Alt + F4.

• All of the above.

What does the Title Bar display?

• The name of the active workbook.

• The location of a cell in a worksheet.

• The contents of the active cell.

• The commands for working with Excel.

What is the function of the Quick Access Toolbar?

• It displays the Save, Undo, and Redo buttons.

• It shows the contents of the active cell.

• It allows you to move vertically and horizontally.

• It changes the size of the document.

What is the formula for addition in Excel?

• =SUM(cell names that you’re going to add)

• =DIFFERENCE(cell names that you’re going to add)

• =PRODUCT(cell names that you’re going to add)

• =QUOTIENT(cell names that you’re going to add)

What type of chart is used to show data trends?

• Area Chart

• Bar Chart

• Column Chart

• Line Chart

What is a Pie Chart used for?

• To show proportions of a whole.

• To compare data across categories.

• To show data trends.

• To display values within a few categories.

What is the shortcut key to create a new workbook in Excel?

• Ctrl + N

• Ctrl + O

• Ctrl + P

• Ctrl + S

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

• =AVERAGE(cell range)

• =MAX(cell range)

• =SUM(cell range)

• =COUNT(cell range)

What is the purpose of the Freeze Panes feature in Excel?

• To keep specific rows or columns visible while scrolling.

• To change the color of the cells.

• To lock the entire worksheet from editing.

• To create a backup of the worksheet.