Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use an absolute cell reference to calculate sales tax and amount of purchase. Linda Young is purchasing a new kayak and related gear, calculate the
Use an absolute cell reference to calculate sales tax and amount of purchase.
Linda Young is purchasing a new kayak and related gear, calculate the Grand Total for her purchase.
Open the Excel workbook ExcelModulexlsx Please access the file on Modules page.
In cell F enter the following sales tax rate: convert to percentage.
In cells F F F F F and F enter a formula that calculates the sales tax for each item use absolute cell reference
For example, Amount shown in E cell address for the tax rate then copy to cell range F:F
Then total the Amount plus Sales Tax E F and copy to cell range G:G and then AutoSum to Grand Total.
Enter your Grand Total include decimals NOTE: Sales Tax is a random number and will change with each attempt.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started