Excel | MCQs

Explanation

In MS Excel, the thin black cross-shaped pointer, known as the Fill Handle.

It is used to automatically fill adjacent cells with data, formulas, or patterns.

Explanation

In MS Excel, cell comments are displayed when you hover over the cell containing the comment.

The comment appears in a small box, providing additional information or context about the cell's contents.

Explanation

The PMT function in Excel calculates the payment for a loan based on constant interest rates and payments, categorizing it under financial functions.

It uses inputs like rate (C10/12), number of periods (CB), and loan amount (C9) to compute the payment.

Explanation

The modulus operator (%) in MS Excel returns the remainder of an integer division operation.

It requires both operands to be integers.

Explanation

The correct answer is:

Right-click the column heading you want to delete and select "Delete" from the shortcut menu.

Alternatively, you can also:

• Select the column heading, go to the "Home" tab, and click "Delete" in the "Cells" group.
• Select the column heading and press "Ctrl" + "-" (minus sign).

Explanation

In MS-Excel, the "Undo" command allows you to reverse recent actions, such as accidental deletions or changes to the data on the sheet.

It is the quickest way to restore a record immediately after it has been erased.

Explanation

The MAX function in Excel returns the highest value in a set of data that you specify.

It can be used to find the maximum value in a range of cells, a list of numbers, or an array.

Example: =MAX(A1:A10) returns the highest value in cells A1 through A10.

Explanation

Line graphs are used to track changes over short and long periods of time.

When smaller changes exist, line graphs are better to use than bar graphs

Explanation

When you type a zero (0) before a fraction, Excel will treat it as a numerical value rather than a date.

This is a quick way to ensure that your fractions are displayed correctly in your spreadsheet.

Example: 0 1/2 (Displays as a fraction)

Explanation

B1*17 is incorrect because it mixes a cell reference (B1) with a direct number (17) in an improper way for a formula. 

Correct formulas should maintain consistent use of cell references or operators.