Answered step by step
Verified Expert Solution
Link Copied!

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 Excel_Module_02.xlsx. Please access the file on Modules 2 page.
In cell F6 enter the following sales tax rate: 0.07 convert to percentage.
In cells F9, F10, F11, F12, F13 and F14 enter a formula that calculates the sales tax for each item (use absolute cell reference).
For example, Amount shown in E9* cell address for the tax rate then copy to cell range F9:F14.
Then total the Amount plus Sales Tax (E9+ F9) and copy to cell range (G9:G14) and then AutoSum to Grand Total.
Enter your Grand Total ___________(include 2 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Management With Website Development Applications

Authors: Greg Riccardi

1st Edition

0201743876, 978-0201743876

More Books

Students also viewed these Databases questions