A

B

C

D

E

$151.$ Complete the client$-$provided data with SUM formulas for the Everywhere amounts.

$2.$ Complete the apportionment calculations using VLOOKUP formulas to the client provided data in G$1$:L$51$

$($HINT: Use the FAUSE logical value for exact match VLOOKUP formulas. Use absolute referencing for the table array.$)$

California $-100\%$ Sales

Calculate Rent Expense Annualized and Total property. Use formulas.