Scribd
Upload
18 views3 pages

Formulas - Exercise - Unsolved

NA

Uploaded by

Kumar Ravi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
18 views3 pages

Formulas - Exercise - Unsolved

NA

Uploaded by

Kumar Ravi
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Formulas

Assuming that Gross Profit = Net Sales - Cost of Goods Sold (CoGS), insert a formula in D2
1 that will reflect this to the information provided in cells B2 and C2.

2 Replicate the same task for cells D3, D4, D5 and D6.

Hint: Actually, you can insert the formula only once in cell D2 and then drag it down to D6. If you are
a bit "lazy", you might want to opt for this trick.
Section
02/11
Name of the Net Sales Cost of Goods Gross Profit
Company ($ mln.) Sold ($ mln.) ($ mln.)

Company A 102 75 7650


Company B 34 64 2176
Company C 439 300 131700
Company D 51 49 2499
Company E 224 234 52416
0

You might also like