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
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