Transcript Question 1

Question 1
(a) Write an Excel formula in cell G6 that can be copied down the column to determine
the total value (excluding tax and shipping) of this order. For example, OSU will buy
2000 copies of the Excel book at $13 a copy plus 500 Access books at $15 a copy,
plus 2500 Power Point books at $9 a copy. Be sure to use cell references.
=C6*C$5+D6*D$5+E6*E$5
(b) If the formula you wrote in cell G6 is copied to cell G10, what formula will result?
=C10*C$5+D10*D$5+E10*E$5
Question 2
(a) Write an Excel formula in cell G6 that can be copied down the column to determine the
total value (excluding tax and shipping) of this order. For example, OSU will buy 2000 copies
of the Excel book at $13 a copy plus 500 Access books at $15 a copy, plus 2500 PPoint books
at $9 a copy. Be sure to use cell references.
=C6*C$5+D6*D$5+E6*E$5
(b) If the formula you wrote in cell G6 is copied to cell G10, what formula will result?
=C10*C$5+D10*D$5+E10*E$5
Question 3
Write a formula in cell H6 that can be copied down the column to determine the sales
tax (total * tax rate) for this order.
=G6*B6
Question 4
Cell B2 has been named ‘Ship’ and contains the cost per book of shipping. Write an Excel
formula in cell I6 that can be copied down the column to determine the cost of shipping.
Use the named range in your formula.
=F6*ship
Question 5
Write an Excel formula in cell J6 which can be copied down the column to determine the
Grand Total of this order (total cost of books, tax, and shipping).
=SUM(G6:I6)
Question 6
(a) Write an Excel formula in cell K6 which can be copied both down the column and across the
row to determine the percentage of each book’s quantity of the total number of books in this
order. Hint: divide the number of this type of book by the total number of books in this specific
order.
=C6/$F6
(b) What formula will result when you copy the formula you wrote in cell K6 to cell M10?
=E10/$F10