Which of the following is an absolute cell reference? – McqOptions

MCQOPTIONS

1.	Which of the following is an absolute cell reference?
A.	!A!1
B.	$A$1
C.	#a#1
D.	A1
Answer» C. #a#1

Discussion

No Comment Found

Related MCQs

<p>Which among the following will not set text in selected cells to italics?</p>
<p>Youar German supplier still invoices for parts in deutsche marks. How does Excel convert those sums to Euros?</p>
<p>Which among the following methods can not be used to enter data in a cell?</p>
<p>How should you print a selected area of a worksheet if a different area needs to printed ?</p>
<p>What is a function inside another function is called ?</p>
<p>Which among the following is a correct order of precedence in a formula calculation?</p>
<p>What kind of charts can an excel produce ?</p>
<p>You can open the Highlight Changes dialog box by choosing Track Changes from the . Menu.</p>
<p>To protect a worksheet, you can choose Protection and the Protect Sheet from the .. menu</p>
<p>You can quickly change the appearance of your work by choosing Auto Format from the . Menu</p>