AutoSave O off MidTerm Practice ExamAK2020Update - Protected View - P Search Lesauski, Justin U File Home Insert Page Layout Formulas Data Review View Help Finess Data A Share P Comments O PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing fr No B12 c D E F G H K M R 1 To correctly complete the tasks on this worksheet, do NOT use raw numbers or values in formulas. 2 3 1. Enter a function in the first yellow cell to determine the amount of Sales Tax. 4 2. Copy the formula down the Sales Tax column to calculate Sales Tax, if any, for the other transactions. 5 3. Use the subtotal outline view to total the sales tax for exempt and non exempt transactions 7 8 5% <-- Sales Tax Rate Yes Таx Exempt Not Tax Exempt 9 0% <--Exempt Rate No 10 11 ransaction Tax Exempt (Yes/No) Price Sales Tax Total Due $ 52.60 $ 2.63 $ 55.23 $ 24.00 $ 1.20 $ 25.20 12 2 No 13 4 No 14 No Total $ 3.83 $ 19.95 $ $ 19.95 $ 231.88 15 Yes 16 3 Yes $231.88 $ 17 Yes Total 18 Grand Total $ 3.83 19 20 21 22 23 24 25
AutoSave O off MidTerm Practice ExamAK2020Update - Protected View - P Search Lesauski, Justin U File Home Insert Page Layout Formulas Data Review View Help Finess Data A Share P Comments O PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing fr No B12 c D E F G H K M R 1 To correctly complete the tasks on this worksheet, do NOT use raw numbers or values in formulas. 2 3 1. Enter a function in the first yellow cell to determine the amount of Sales Tax. 4 2. Copy the formula down the Sales Tax column to calculate Sales Tax, if any, for the other transactions. 5 3. Use the subtotal outline view to total the sales tax for exempt and non exempt transactions 7 8 5% <-- Sales Tax Rate Yes Таx Exempt Not Tax Exempt 9 0% <--Exempt Rate No 10 11 ransaction Tax Exempt (Yes/No) Price Sales Tax Total Due $ 52.60 $ 2.63 $ 55.23 $ 24.00 $ 1.20 $ 25.20 12 2 No 13 4 No 14 No Total $ 3.83 $ 19.95 $ $ 19.95 $ 231.88 15 Yes 16 3 Yes $231.88 $ 17 Yes Total 18 Grand Total $ 3.83 19 20 21 22 23 24 25
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Solve all the problems

Transcribed Image Text:AutoSave
MidTerm Practice ExamAK2020Update - Protected View -
P Search
ff
Lesauski, Justin
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
Finess Data
A Share
P Comments
PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
Enable Editing
B12
fx
No
A
В
D
E
F
H
K
M
N
R
U
1 To correctly complete the tasks on this worksheet, do NOT use raw numbers or values in formulas.
3 1. Enter a function in the first yellow cell to determine the amount of Sales Tax.
4 2. Copy the formula down the Sales Tax column to calculate Sales Tax, if any, for the other transactions.
5 3. Use the subtotal outline view to total the sales tax for exempt and non exempt transactions
7
8
5% <-- Sales Tax Rate
Yes
Tax Exempt
9
0% <--Exempt Rate
No
Not Tax Exempt
10
11 ransaction Tax Exempt (Yes/No)
Price
Sales Tax Total Due
$ 52.60
$ 24.00
2.63 $ 55.23
$ 1.20 $ 25.20
$ 3.83
12
2
No
$
13
4
No
14
No Total
$ 19.95
$231.88
15
1
Yes
$
$ 19.95
16
3
Yes
$
$ 231.88
17
Yes Total
$
18
Grand Total
$ 3.83
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
Chart Review
Sub Total
Cell Referencing
Percentage Change
Tax Calculator
Basic Functions_format
Add-ins loaded successfully
囲
100%
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education