In the example below, Lisa has created a spreadsheet for monthly budget. Data are entered into cells like the boxes in a table. The cells are named by the letter of the column along the top and numbered rows down the side. Note that the cell containing the income is referred to as A2, not 2A. A 1 Monthly Budget 2 Income 3 Rent 4 Utilities 5 Food 6 7 Insurance Gas for Car Part A: What is in Cell B4? Answer: B $1,677 $750 $230 $160 $89 $80 Part B: What does the number in Cell B4 represent in Lisa's Budget? O The money she plans to spend on rent each month O The money she plans to spend on utilities each month O The money she plans to spend on food each month O Her estmated income each month O Her total estimate expenditures each month Lisa put the following formula in her spreadsheet: Part C: Calculate the result of this formula Answer: $ 4 B2- B3 B4 B5 B6 B7 THR 27

Calculus: Early Transcendentals
8th Edition
ISBN:9781285741550
Author:James Stewart
Publisher:James Stewart
Chapter1: Functions And Models
Section: Chapter Questions
Problem 1RCC: (a) What is a function? What are its domain and range? (b) What is the graph of a function? (c) How...
icon
Related questions
Question
Need help on practice question
In the example below, Lisa has created a spreadsheet for monthly budget. Data are entered into
cells like the boxes in a table. The cells are named by the letter of the column along the top and
numbered rows down the side. Note that the cell containing the income is referred to as A2, not 2A.
A
1 Monthly Budget
234567
Income
Rent
Utilities
Food
Insurance
Gas for Car
Part A: What is in Cell B4?
Answer:
B
$1,677
$750
$230
$160
$89
$80
Part B: What does the number in Cell B4 represent in Lisa's Budget?
O The money she plans to spend on rent each month
O The money she plans to spend on utilities each month
O The money she plans to spend on food each month
O Her estmated income each month
O Her total estimate expenditures each month
Lisa put the following formula in her spreadsheet:
Answer: $
Part C: Calculate the result of this formula
B2 B3 B4 B5 B6 B7
4
Part D: What does this value represent for Lisa?
O The amount of money she expects to lose each month
O The amount of money she expects to have left after paying bills each month
O The percent of her income that she will be able to save each month
O The value has no meaning for Lisa
Transcribed Image Text:In the example below, Lisa has created a spreadsheet for monthly budget. Data are entered into cells like the boxes in a table. The cells are named by the letter of the column along the top and numbered rows down the side. Note that the cell containing the income is referred to as A2, not 2A. A 1 Monthly Budget 234567 Income Rent Utilities Food Insurance Gas for Car Part A: What is in Cell B4? Answer: B $1,677 $750 $230 $160 $89 $80 Part B: What does the number in Cell B4 represent in Lisa's Budget? O The money she plans to spend on rent each month O The money she plans to spend on utilities each month O The money she plans to spend on food each month O Her estmated income each month O Her total estimate expenditures each month Lisa put the following formula in her spreadsheet: Answer: $ Part C: Calculate the result of this formula B2 B3 B4 B5 B6 B7 4 Part D: What does this value represent for Lisa? O The amount of money she expects to lose each month O The amount of money she expects to have left after paying bills each month O The percent of her income that she will be able to save each month O The value has no meaning for Lisa
Part D: What does this value represent for Lisa?
O The amount of money she expects to lose each month
O The amount of money she expects to have left after paying bills each month
O The percent of her income that she will be able to save each month
O The value has no meaning for Lisa
Part E: Which of the following expressions would give the same result as Lisa's formula? There may
be more than one correct answer.
B2 B3+ B4+ B5+ B6+ B7
B2
(B3+ B4+ B5+ B6 + B7)
(B3+ B4+ B5+ B6+B7) - B2
Part F: What percent of her income does Lisa spend on rent?
Answer:
Part G: If Lisa got a $500 raise per month, what percent of her income would she be spending on
rent?
Answer:
Question Help: Message Instructor
Calculator
Submit Question
%
Reflect in ePortfolio
Task: View this topic
Activity Details
Transcribed Image Text:Part D: What does this value represent for Lisa? O The amount of money she expects to lose each month O The amount of money she expects to have left after paying bills each month O The percent of her income that she will be able to save each month O The value has no meaning for Lisa Part E: Which of the following expressions would give the same result as Lisa's formula? There may be more than one correct answer. B2 B3+ B4+ B5+ B6+ B7 B2 (B3+ B4+ B5+ B6 + B7) (B3+ B4+ B5+ B6+B7) - B2 Part F: What percent of her income does Lisa spend on rent? Answer: Part G: If Lisa got a $500 raise per month, what percent of her income would she be spending on rent? Answer: Question Help: Message Instructor Calculator Submit Question % Reflect in ePortfolio Task: View this topic Activity Details
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps

Blurred answer
Recommended textbooks for you
Calculus: Early Transcendentals
Calculus: Early Transcendentals
Calculus
ISBN:
9781285741550
Author:
James Stewart
Publisher:
Cengage Learning
Thomas' Calculus (14th Edition)
Thomas' Calculus (14th Edition)
Calculus
ISBN:
9780134438986
Author:
Joel R. Hass, Christopher E. Heil, Maurice D. Weir
Publisher:
PEARSON
Calculus: Early Transcendentals (3rd Edition)
Calculus: Early Transcendentals (3rd Edition)
Calculus
ISBN:
9780134763644
Author:
William L. Briggs, Lyle Cochran, Bernard Gillett, Eric Schulz
Publisher:
PEARSON
Calculus: Early Transcendentals
Calculus: Early Transcendentals
Calculus
ISBN:
9781319050740
Author:
Jon Rogawski, Colin Adams, Robert Franzosa
Publisher:
W. H. Freeman
Precalculus
Precalculus
Calculus
ISBN:
9780135189405
Author:
Michael Sullivan
Publisher:
PEARSON
Calculus: Early Transcendental Functions
Calculus: Early Transcendental Functions
Calculus
ISBN:
9781337552516
Author:
Ron Larson, Bruce H. Edwards
Publisher:
Cengage Learning