June batch excel

What is Microsoft Excel?

• Microsoft Excel is a word processing program.
• Microsoft Excel is a database management system.
• Microsoft Excel is a graphic design software.
• Microsoft Excel is a spreadsheet program developed by Microsoft.

What is the default file extension for an Excel workbook?

• .xlsx
• .xlsx1
• .xls
• .xlsm

What is the purpose of the Filter feature in Excel?

• To display only the rows that meet specific criteria in a dataset.
• To sort data in ascending order.
• To create charts and graphs from data.
• To calculate the sum of a dataset.

function is used to count the number of numerical values in a range?

• COUNT()

• COUNTBLANK()

• COUNTIF()

• COUNTA()

What is an Excel Spreadsheet?

• A physical document used for handwritten calculations.
• A type of software for creating presentations.
• A database management system for storing large datasets.
• An Excel Spreadsheet is a digital document used for data organization and analysis in Microsoft Excel.

What is an Excel Range?

• An Excel Range is a selection of two or more cells in a worksheet.
• An Excel Range is a type of chart in Excel.
• An Excel Range is a formula used in calculations.
• An Excel Range is a single cell in a worksheet.

What does the VLOOKUP function do?

• Searches for data in rows

• The VLOOKUP function calculates the sum of a range of cells.
• Searches for data in columns

• The VLOOKUP function deletes rows from a table.

What is an Excel Dashboard?

• An Excel Dashboard is a visual tool that displays key metrics and data for analysis.
• A spreadsheet that only contains text data.
• A tool for creating complex formulas and calculations.
• A feature that automatically generates charts from data.

Which Excel function is used to join two or more text strings?

• JOIN
• CONCATENATE
• MERGE
• LINK

What does the TRIM function do?

• The TRIM function counts the number of characters in a string.
• The TRIM function removes leading and trailing whitespace from a string.
• The TRIM function adds extra spaces to a string.
• The TRIM function converts a string to uppercase.