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!

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Computer Hardware

Explore the tangible components of computers with our Computer Hardware MCQs. Learn...

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

Software Engineering

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

Python

Dive into one of the most popular languages with our Python MCQs. Understand...

MATLAB

Hone your computational mathematics skills with our MATLAB MCQs. Understand...

Compiler Design

Unravel the process of translating source code into executable programs with our...

JavaScript

Strengthen your web development skills with our JavaScript MCQs. Understand core...

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...