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

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

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

Explanation

• ctrl +', keys are used in ms excel to copy formulas from the above cell
• ***
• 
  
  

Explanation

COUNT keyword is used to find out the number of values in a column.