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. To determine the gain/loss of each stock, Maria creates a formula that includes an absolute reference and a relative reference. This type of reference is referred to as a(n) ____ cell reference.

A. combined
B. mixed
C. advanced
D. nested


Answer: B

Computer Science & Information Technology

You might also like to view...

______ are used to store values, which can be updated and retrieved when the program is running.

A. Variables B. Functions and procedures C. Arguments D. Statements E. Data types

Computer Science & Information Technology

The keyword ________ is used in a function header to indicate that a function does not return a value or to indicate that a function contains no parameters.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

To display the dialog box shown in the accompanying figure, in the ____________________ category of the Insert panel, click the Master Detail Page Set button.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

The purpose of a(n) ____ is to accept data as input and transform the data in some manner to produce a specific result as an output.

A. opcode B. procedure C. algorithm D. program

Computer Science & Information Technology