# 2.3: Sales Tax Calculation Assignment

- Page ID
- 13021

\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

### The purpose of his assignment is to:

Apply Absolute Referencing in a spreadsheet problem

### Preparation: (Items to review from previous lessons)

- Entering data in cells
- Applying attributes (bold, underline)
- AutoSum

### New Terms:

- Absolute Referencing

### Narrative:

Understanding how to calculate using absolute referencing saves a great deal of time in inserting formulas. (THIS ASSIGNMENT IS WORTH 20 POINTS. THE RUBRIC IS ON PAGE 2)

- Start a new spreadsheet
- Put your name in cell A1
- In cell A2, put the title: Accrue Sales Tax, and center it over the table.
- In cell G1 put the words Tax Rate
- In cell H1 put in 0.8612
- In cell B4 put in the heading Sales, and bold it.
- In cell C4 put the heading Sales Tax, and bold it
- In cell A5:A10 put in the words STORE 1 to STORE 6
- In cell A11 put in the word Total and bold it.
- In cells B5:B10 put in some sales amounts that are over between 40,000 to 100,000. Put different totals after each store.
- Absolute Referencing. (Be sure to have read Relative Referencing vs. Absolute Referencing) Starting in C5 insert a formula that uses the absolute reference of H1 and multiplies that to the total sales figure.
- In cell B11, sum column B. and sum Column C.
- Save the document as Sales Calculation
- Submit your document through Blackboard print at your instructor’s suggestion.

### Check the Rubric below to be sure you have completed all tasks.

CC licensed content, Original

- Sales Calculation Assignment.
**Authored by**: Fran Wells.**License**:*CC BY: Attribution*