Using absolute cell referencing, which would be the correct formula to multiply th sales rate in B6? Monthly Sales Total to be Sales Tax Paid Tax Rate 8.25% $ 43,232 $ 3,567 $ 46,799 $ 74,300 $ 6,130 $ 80,430 $ 58,000 $ 4,785 $ 62,785 60,491 $ 4,991 $ 65,482 49,120 $ 4,052 $ 53,172 62,010 $ 5,116 $ 67,126 Café 1 Café 2 Café 3 Café 4 Café 5 Café 6

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

help with this question please 

 

Using absolute cell referencing, which would be the correct formula to multiply the
sales rate in B6?
Monthly
Total to be
Sales
Sales Tax
Paid
Tax Rate
8.25%
3 Café 1
4 Café 2
5 Café 3
5 Café 4
7 Café 5
B Café 6
$ 43,232 $ 3,567 $ 46,799
$ 74,300 $ 6,130 $ 80,430
$ 58,000 $ 4,785 $ 62,785
$ 60,491 $ 4,991 $ 65,482
$ 49,120 S 4,052 $ 53,172
$ 62,010 $ 5,116 $ 67,126
=B6*F2
=$B$6*$F$2
=$B$6*F2
B6*$F$2
Transcribed Image Text:Using absolute cell referencing, which would be the correct formula to multiply the sales rate in B6? Monthly Total to be Sales Sales Tax Paid Tax Rate 8.25% 3 Café 1 4 Café 2 5 Café 3 5 Café 4 7 Café 5 B Café 6 $ 43,232 $ 3,567 $ 46,799 $ 74,300 $ 6,130 $ 80,430 $ 58,000 $ 4,785 $ 62,785 $ 60,491 $ 4,991 $ 65,482 $ 49,120 S 4,052 $ 53,172 $ 62,010 $ 5,116 $ 67,126 =B6*F2 =$B$6*$F$2 =$B$6*F2 B6*$F$2
To decrease the number of decimals we have showing, click the
icon on
the Number section of Excel.
Dollar icon
Down arrow on the Number Format
Decrease decimal
Comma icon
Transcribed Image Text:To decrease the number of decimals we have showing, click the icon on the Number section of Excel. Dollar icon Down arrow on the Number Format Decrease decimal Comma icon
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Payments(ras), Appeals and Secondary Claims
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
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