Excel Formula | MCQs

Explanation

Comments can be added to cells using Insert > Comment.

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

Explanation

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.

Explanation

To add two cells (A1 and A2) together, you use the following formula *=A1+A2. 

Explanation

In a computer spreadsheet,

A preprogrammed Formula is basically a function graph range cell.

***

RY24012023

Explanation

In Excel, formulas must begin with an equals sign (=).

Options A, B, and C are all valid formulas.

Option D (C1+15) is not a valid formula because it lacks the = sign.

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

PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate.

Explanation

In MS excel, a range identifies a range by the cells located at diagonally opposed corners.

 A range is a group of cells in a spreadsheet that have been selected. If the cells are all together in a rectangular or square shape, it is an adjacent range.

AGM 17-12-2022