Question

Part 1: Create a spreadsheet with the following data.
Item Description Purple Stock White Linen Half Cream Stock 5x7 Greeting
Item Number 0059 0067 0098 1021
Unit Ream Ream 20 Dozen
Current Number of Units 346 456 908 546
Item Description 4x6 Greeting Black Stock 11x14Office 8x10 Office
Item Number 1022 0068 2033 2032
Unit Ream Ream 20 Dozen
Current Number of Units 346 456 908 546

Part 2: Solve Steve's business problem. Add two rows. Label them "Purchased Today" and "Total in Stock." Add formulas to the spreadsheet so that Steve can keep the inventory current by adding new purchases and subtracting orders. (Fill in the "Purchased Today" row with numbers of your choice.)


i just need part 2

Answer 1

Select the box u would like to have display end of day total in.
Press =
Select the box that has current number box in it.

Press -

Select the box u have number sold today in.

Press enter. This gives the total.