EX Case 5-1Maria's grandfather has agreed to help her invest her $2,000 savings account in the stock market. He asked that she create an Excel worksheet to track how her stocks are doing. Because he is coming over in a few days, she wants to update the worksheet. Maria wants to use relative references to calculate the initial cost of her various stocks. Which of the following formulas in Maria's worksheet is an example of a relative reference?
A. =$B$4*B11
B. =$B$4*C11
C. =$B$4
D. =SUM(B7:B10)
Answer: D
You might also like to view...
A train protection system automatically applies the brakes of a train if the speed limit for a segment of track is exceeded, or if the train enters a track segment that is currently signaled with a red light (i.e. the segment should not be entered). Giving reasons for your answer, chose a reliability metric that might be used to specify the required reliability for such a system.
What will be an ideal response?
In the Forms group, the Form tool creates a new blank form in Design view
Indicate whether the statement is true or false
Which key is used to move from cell to cell in a Word table?
A) Enter B) Spacebar C) Backspace D) Tab
If a major error is made when typing data into a cell, click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning.
Answer the following statement true (T) or false (F)