Excel | MCQs

Explanation

C11 and D29 are cell addresses in a spreadsheet, specifically in Microsoft Excel.

• C11 refers to the cell located in column C and row 11.
• D29 refers to the cell located in column D and row 29.

Cell addresses are used to identify specific cells in a spreadsheet, and are typically written in the format "ColumnLetterRowNumber" (e.g., A1, B2, C3, etc.).

Explanation

In MS Excel, moving from cell C9 to C11 means selecting cell C9 and then moving the selection to cell C11.

This can be done using the arrow keys, mouse, or keyboard shortcuts.

Explanation

In MS Excel, a function is a pre-defined formula that performs a specific calculation or operation.

Examples of functions in Excel include SUM, AVERAGE, COUNT, IF, and many others.

Functions are used to manipulate data, perform calculations, and analyze information in a spreadsheet.

Explanation

In Excel, the spacing in a column is referred to as "Column Width."

This allows you to adjust how much space is available for text and numbers in a particular column.

You can modify the column width through the Format option under the Home tab.

Explanation

• Tab key should be pressed continuously while moving a column in MS Excel.
• A tab key is generally used in a document for proper spacing and enhancing readability by adjusting the text in the document.
• It can also be used for moving a cursor across the screen and for indenting a paragraph while the user is working with the document.

Explanation

Excel uses three types of references:

1. Relative
2. Absolute
3. Mixed

These determine how cell references adjust when formulas are copied across cells.

Explanation

The formula evaluates as:

(7-3)×(4+3)/4 = 4×7/4 = 28/4 = 7.

Explanation

In MS Excel, an embedded formula can be removed by pressing the DELETE key.

It clears the formula from the selected cell without affecting the formatting or other content in the worksheet.

Explanation

In Excel, each row of a table corresponds to a record.

It is a complete set of data.

Field corresponds to columns in Excel.

Each column represents a field or a specific type of data within the records.

Explanation

Split data into multiple columns

1. Select the "Sales Rep" column, and then select Home > Transform > Split Column.
2. Select Choose the By Delimiter.
3. Select the default Each occurrence of the delimiter option, and then select OK. ...
4. To change the default names, rename them to "Sales Rep First" and "Sales Rep Last".