What is the correct answer?


Which of the following is an absolute cell reference?

A. !A!1

B. $A$1

C. #a#1

D. A1

Correct Answer :

B. $A$1

Related Questions

You can use the format painter multiple times before you turn it off by How can you print three copies of a workbook? Which menu option can be sued to split windows into two To select an entire column in MS-EXCEL, press? In Excel, a Data Series is defined as what? What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Which of the following is not true about Find and Replace in Excel Which key do you press to check spelling? Which of the following options is not located in the Page Setup dialog… In the formula, which symbol specifies the fixed columns or rows? To copy cell contents using drag and drop press the Multiple calculations can be made in a single formula using Which Chart can be created in Excel? To record a sequence of keystrokes and mouse actions to play back later… An excel workbook is a collection of How do you wrap the text in a cell? You can convert existing excel worksheet data an charts to an HTML document… You can copy data or formulas To edit in an embedded excel worksheet object in a word document While Finding and Replacing some data in Excel, which of the following… You can merge the main document with data source in Excel. In mail merge… To return the remainder after a number is divided by a divisor in EXCEL… You can auto fit the width of column by Which of the following is the latest version of Excel To create a formula, you first: Paste Special allows some operation while you paste to new cell. Which… The Paste Special command lets you copy and paste: Hyperlinks can be Which area in an excel window allows entering values and formulas The Name box on to the left of formula bar