MS Excel | MCQs

Explanation

The term Worksheet used in Excel documents is a collection of cells organized in rows and columns.

Explanation

Delete a record

• Open the table in Datasheet View or form in Form View.
• Select the record or records that you want to delete. To select a record, click the record selector next to the record, if the record selector is available. 
• Press DELETE, select Home > Records > Delete, or press Ctrl+Minus Sign (-).

Explanation

The "Edit, Clear" command in spreadsheet software (like Microsoft Excel) allows you to remove different elements from selected cells, such as:

• Contents (values/data)

• Formats (cell formatting)

• Comments/Notes

However, it does not delete the cells themselves—it only clears their contents or attributes.

Explanation

The function key to quickly navigate to a specific cell in MS Excel is F5 or Ctrl+G.

These keys open the "Go To" dialog box, where you can enter the cell reference (e.g., B3) and press Enter to jump to that cell

Explanation

MS Excel offers various chart types, including:

• Line charts
• Pie charts
• Bar charts

However, "Volume" is not a chart type in MS Excel.

Volume is a measure of the amount of three-dimensional space enclosed by a container or a shape, and is not a chart type.

Explanation

Database is the name of the form used to input chart values.

A database is information that is set up for easy access, management and updating.

Explanation

Shift + F2 is the correct answer. 

Comments can be added to cells using Insert > Comment.

Right-click the cell and then click Insert Comment (or press Shift+F2).

Explanation

A Workbook is a group of Worksheets.

A workbook is a file that contains one or more worksheets to help you organize data.

A workbook initially contains three worksheets, which are saved in a single file. 

1. Sheet1

2. Sheet2

3. Sheet3

Explanation

A trendline is added to a chart to show patterns or trends in the data.

It helps in analyzing data over time or predicting future values.

Explanation

The Wrap feature allows text to appear on multiple lines within a single Excel cell.

It improves readability without expanding the cell width.