Microsoft Excel Quiz

What is the purpose of the Quick Access Toolbar in Microsoft Excel?

• To provide a convenient resting place for Excel's most frequently used commands

• To display the current status of the active cell

• To organize related commands into groups

• To switch among various sheet views

What is the maximum limit of rows in Microsoft Excel?

• 1,048,576 rows

• 16,384 rows

• 256 rows

• 65,536 rows

What does the function AVERAGE in Excel do?

• Adds all of the values of the cells in the argument

• Determines the average of the values included in the argument

• Determines the highest cell value included in the argument

• Counts the number of cells with numerical data in the argument

When would you use the COUNTIF function in Excel?

• To count the total number of data having both alphabets and numbers

• To count the number of cells with numerical data in the argument

• To determine the highest cell value included in the argument

• To find the total of given data with a given condition

What is the significance of basic cell formatting in Excel?

• To provide a convenient resting place for Excel's most frequently used commands

• To organize related commands into groups

• To determine the average of the values included in the argument

• To format cells for better readability and presentation

What is the difference between a workbook and a worksheet in Excel?

• A workbook is a large container that holds multiple worksheets

• A workbook stores data in a grid of cells

• A worksheet is a collection of rows and columns

• A workbook is a single tab within the worksheet

How do you collect and clean data before analysis in Excel?

• By removing duplicates and errors from the data

• By pulling in information from other Google services

• By inserting the most common functions into your formula

• By using the AutoSum command

What is the purpose of the View Buttons in Microsoft Excel?

• To provide a convenient resting place for Excel's most frequently used commands

• To organize related commands into groups

• To switch among various sheet views

• To display the current status of the active cell

Why would you choose Google Sheets over Excel?

• Because it's free

• Because it's cloud-based

• Because it's a collection of worksheet

• Because it's a spreadsheet program

What are the key steps in data analysis using Excel?

• To count the total number of data having both alphabets and numbers

• To determine the average of the values included in the argument

• To collect, clean, analyze, and visualize data

• To format cells for better readability and presentation