What happens when the dollar sign ($) is entered in a cell address? (ex. $B$2:$B$10) - Microsoft Excel MCQs

A

Admin • 37.06K Points
Coach

Q. What happens when the dollar sign ($) is entered in a cell address? (ex. $B$2:$B$10)

(A) An absolute cell address is created.
(B) The address of the cell will change when it is copied to another cell.
(C) The sheet’s tab is changed.
(D) The state-bar does not display the cell address.

Correct Answer - Option(A)
Views: 123
Filed under category Microsoft Excel

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on Microsoft Excel

Q. The cell labeled 23.54 the cell labeled F5 refers to ?

Q. There are three types of data found in a spreadsheet ?

Q. Which types of charts can excel produce?

Q. In Excel when you use the fill effects in the format data series dialog box, you cannot

Q. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

Q. Comments can be added to cells using

Q. A ___________ is an equation that performs calculations, such as addition, subtraction, multiplication and division.

Q. Maximum column width in Excel sheet is

Q. Microsoft Excel is a powerful………..

Q. In Excel which of the following is a correct order of precedence in formula calculation?

Learn All Microsoft Excel MCQs

Question analytics