Question
In MS Excel 365 what is the Microsoft Excel formula to create an absolute cell reference for cell B2?
The correct answer is
$B$2
To create an absolute cell reference in Excel, you need to add a dollar sign ($) before both the column letter and the row number. Therefore, the absolute cell reference for B2 is $B$2.
Was this answer helpful?
Important Questions from Microsoft Word
In MS-Word 365, Ctrl + E is the keyboard shortcut to _________.
Which of the following font effects is not available in the MS-Word 2010 font dialog box?
Which of the following keyboard shortcut is used to close a MS-Word 365 document?
Which of the following buttons are present in the Quick Access Toolbar by default in MS-Word 2010?
What is the use of 'Ctrl + r' key in Microsoft Word
Need Expert Advice?
