4.Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20.

Post test question number 9 for entering the job market

Waterway company’s record of transactions for the month of april was as follows. purchases sales april 1 (balance on hand) 672 @ $6.00 april 3 560 @ $11.00 4 1,680 @ 6.08 9 1,568 @ 11.00 8 896 @ 6.41 11 672 @ 12.00 13 1,344 @ 6.51 23 1,344 @ 12.00 21 784 @ 6.61 27 1,008 @ 13.00 29 560 @ 6.79 5,152 5,936 (a) calculate average-cost per unit. (b) assuming that periodic inventory records are kept in units only, compute the inventory at april 30 using lifo and average-cost. (c) assuming that perpetual inventory records are kept in dollars, determine the inventory using (1) fifo and (2) lifo. (d) compute cost of goods sold assuming periodic inventory procedures and inventory priced at fifo.

Each row in a database is a set of unique information called a(n) table. record. object. field.