FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following options specifies cell B5 as an absolute reference?

A	$B$5
B	#B#5
C	%B%5
D	(B5)

Explanation:

Detailed explanation-1: -There is a shortcut for placing absolute cell references in your formulas! When you are typing your formula, after you type a cell reference-press the F4 key. Excel automatically makes the cell reference absolute!

Detailed explanation-2: -Cell reference contains one or more letters or the alphabet followed by a number where the letter or alphabet indicates the column and the number represents the row. Each cell can be located or identified by its cell reference or address, e.g., B5.

Detailed explanation-3: -Excel absolute cell reference (with $ sign) The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.

There is 1 question to complete.