adplus-dvertising
frame-decoration

Question

If the cell B1 contains the formula = $A$1, which of the following statements is true

a.

There is a relative reference to cell A1

b.

There is an absolute reference to cell A1

c.

Further changes in value of A1 will not affect the value of B1

d.

Further changes in value of B1 will affect the value of A1

Posted under MS Office

Answer: (b).There is an absolute reference to cell A1

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. If the cell B1 contains the formula = $A$1, which of the following statements is true
Add Comment

Similar Questions

Discover Related MCQs

Q. Worksheet can be renamed by

View solution

Q. What is the shortcut key to hide entire row?

View solution

Q. What is the shortcut key to insert a new comment in a cell?

View solution

Q. Which option allows you to Bold all the negative values within the selected cell range:

View solution

Q. What is the shortcut key to insert new sheet in current workbook?

View solution

Q. Which one is the last column header in Excel 2007?

View solution

Q. In maximum, how many sheets can be set as default while creating new workbook?

View solution

Q. “New Comment” option can be found under _________ tab

View solution

Q. In Excel, by default Numeric Values appears in

View solution

Q. To show/hide the grid lines in Microsoft Excel 2007

View solution

Q. What will be the result if you type =A1=B1 in cell C1?

View solution

Q. In Excel _______ may not contain in Formula

View solution

Q. A function inside another function is called _______

View solution

Q. Which of the following is not an underline option in the format cells dialog box?

View solution

Q. Formulas in Excel start with

View solution

Q. The default header for a worksheet is

View solution

Q. Which of the following is not an option of the spelling dialog box?

View solution

Q. Which of the following methods will not enter data in a cell?

View solution

Q. The cell reference for cell range of G2 to M12 is _______

View solution

Q. What is the keyboard shortcut for creating a chart from the selected cell range?

View solution
View All MCQs on MS Office

Suggested Topics

Are you eager to expand your knowledge beyond MS Office? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

Wireless and Mobile Communications

Get to grips with modern communication technologies with our Wireless and Mobile...

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

CompTIA PenTest+ Certification Exam PT0 002

Prepare for the CompTIA PenTest+ PT0-002 exam with our targeted MCQs. Covering...

Data Warehousing and OLAP

Strengthen your knowledge of Data Warehousing and OLAP with our specialized MCQs....

Software Engineering

Learn about the systematic approach to developing software with our Software...

Java Programming

Level up your coding skills with our Java Programming MCQs. From object-oriented...

PHP

Venture into server-side scripting with our PHP MCQs. Cover everything from syntax...