mooncake9090
05.06.2020 •
Mathematics
The formula in cell B1 is= A$2. Autofill is used by dragging B1’s autofill box across to C1,D1, and E1. What formulas will appear in C1, D1, and E1, respectively?
Solved
Show answers
More tips
- F Family and Home What is a Smart Home System and How Does it Work?...
- F Food and Cooking Do Aphrodisiacs Really Work? Separating Fact from Fiction...
- C Computers and Internet Log-in: what is it and why do you need it?...
- S Style and Beauty Secrets of Tying a Pareo: 5 Ways...
- F Food and Cooking Everything You Need to Know About Pasta...
- C Computers and Internet How to Choose a Monitor?...
- H Horoscopes, Magic, Divination Where Did Tarot Cards Come From?...
- S Style and Beauty How to Make Your Lips Fuller? Ideas and Tips for Beautiful Lips...
Answers on questions: Mathematics
- M Mathematics Mrs. zervan bought pencils from local golf shop she open the box of 250 and 30 of them need to be sharpened at this rate how many should she expect to sharpen a box...
- M Mathematics What is the rounded length of a $1 bill to the nearest millimeter...
- S Social Studies Roberta told her parents that she earned an a on her psychology exam because she had studied hard and knew the material. she told her parents that she only received...
- S Social Studies Aparent calls the nursing triage line during the evening. the parent says that a 7-year-old was found playing in an area with poison ivy and asks what to do. which is...
- M Mathematics X/4-2 5/4 i need help on this equations and inequalities question...
Ответ:
The formulas that will appear in
C1 is =B$2
D1 is = C$2
E1 is = D$2
Step-by-step explanation:
Given
Formula in B1 is = A$2
Required
Formulas in C1, D1 and E1 when dragged from B1.
In Microsoft Office Excel, this is called absolute reference.
But this type of absolute reference requires that only the cell name will be changed or altered, the row number will always remain the same no matter where it's been dragged to.
Since the initial column name is A and the Initial row number is 2 (from A$2),
Cell C1 will take the formula = B$2
Cell D1 will take = C$2
Cell E1 will take = D$2
Notice that only the column name changed for each formula; the row number remain unchanged.
Ответ:
ur problem's solution here.