Case-Based Critical Thinking Questions
?
Case 3-1
Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year.
?
?
Ellen has entered all of her monthly expenses. She needs to create a formula that will deduct her monthly expenses from her monthly income. Since her monthly income is the same amount each month, she uses a(n)____ to identify the cell containing the income value.

A. relative reference
B. absolute reference
C. mixed reference
D. fixed reference


Answer: B

Computer Science & Information Technology

You might also like to view...

Creating a snapshot saves the current status of your work as a new thumbnail at the top of the History panel.

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

Computer Science & Information Technology

When you select a menu option, you give the computer output.

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

Computer Science & Information Technology

It is not possible to delete a color sampler.

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

Computer Science & Information Technology

Which of the following is not one of the factors used in multi-factor authentication?

Computer Science & Information Technology