C++ | MCQs

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

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 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

A column chart is ideal for comparing the performance of two employees in 2021 because it allows for a side-by-side comparison of their performance metrics, such as sales, productivity, or revenue.

Pie Chart: Shows how different components contribute to a whole.

Dot Chart: Displays a small number of data points.

Column Chart: Compares performance metrics side-by-side.

Line Chart: Shows trends over time.

Explanation

The formula evaluates as:

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

Explanation

In older versions of Excel (up to 2003), a worksheet contains 256 columns.

Newer versions have expanded this limit to 16,384 columns.

A single worksheet in Excel contains 65,536 rows.

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".

Explanation

The cell margin is the distance between the cell border

Cell contents and is specified for all four sides of a cell

How to Change Margins in Excel?

Click on Page layout tab.