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

20 x 10 = 200

200 / 5 = 40

40 x 8 = 320

So, Excel evaluates the formula and returns 320.

Explanation

A value in Excel refers to numerical data, dates, or text that can be used in calculations.

"Obtained marks - 87" is a text string, not a value directly usable in calculations.

Explanation

Microsoft Excel is a spreadsheet software widely used for creating tables of columns and rows for statistical or mathematical calculations.

It provides various features such as formulas, functions, charts, and pivot tables to manage and analyze data.

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

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

A spreadsheet is also known as a workbook.

A workbook is a file that contains one or more spreadsheets, which are made up of cells, rows, and columns.

The terms "spreadsheet" and "workbook" are often used interchangeably, but a workbook can contain multiple spreadsheets, while a spreadsheet is a single sheet within a workbook.

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.