File Home
Insert
Formulas
Data
Review
View
Automate
Help
Editing
Calibri Light
16
B
Bra Av
2
CS
General
G
A
B
С
D
E
F
L
H
1
3
3 In cell D7, create a formula that calculates the tax for the invoice. Us
a
sales tax rate of 7.5%
SABROSA
Catering Invoice
Sabrosa Empanadas & More
1202 Biscayne Bay Drive
Orlando, FL 32804
Invoice #:
6710A Date:
10/15/20
In cell Ds, create a formula that finds the total for the order. In other
this formula should add cells D3:07.
Empanadas & More
1
In cell D9 create a formula that calculates the total after a 10% disco
you need help understanding how to take a percentage off of a total
LINE TOTAL
2 MENU ITEM
3 Empanadas: Buffalo Chicken
4 Empanadas: Braised Short Rib
5 Empanadas: Fig and Goat Cheese
6 Sides: Black beans and rice
7
UNIT PRICE
$2.98
$2.98
$3.75
$1.98
QUANTITY
20
30
25
40
TAX
8
TOTAL
TOTAL AFTER DISCOUNT:
9
+
Catering Invoice Catering Subtotal challenge
C Mode tomate Workbook to
Helo improve Office
100%
-