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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Solve all the problems

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%
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Value Chain Analysis
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education