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

Computer Science & Information Technology

You might also like to view...

Intellectual property is protected by national and international laws

Indicate whether the statement is true or false

Computer Science & Information Technology

Answer the following statement(s) true (T) or false (F)

A short circuit is one where needed connections are missing, such as when a wire breaks.

Computer Science & Information Technology

The help desk received a call from a user who cannot get any print jobs to print on the locally shared printer. While questioning the user, the technician determines that no users can print to the printer, and the printer indicates it is “Offline.” The technician instructs the user on how to place the printer in the “Online” mode, but print jobs are still not printing on the printer.   Which of the following is the next step to take to resolve this issue?

A. Power cycle the printer. B. Replace the printer cable. C. Delete and re-create the printer share. D. Replace the printer toner cartridge.

Computer Science & Information Technology

_____ is a subset of e-commerce that involves electronic transactions between consumers using a third party to facilitate the process.

A. Business-to-business (B2B) e-commerce B. Business-to-consumer (B2C) e-commerce C. Consumer-to-business (C2B) e-commerce D. Consumer-to-consumer (C2C) e-commerce

Computer Science & Information Technology