Excel Formula Questions
The purpose of this mini quiz is to make sure that students can apply the basic formula construction used in Excel.
It assumes a working knowledge of those functions and concepts discussed and taught in introductory level information Systems classes.
A student should be able to correctly construct all of these formulas; this mini quiz includes fundamental concepts and functions necessary to complete accounting and finance classes.
Simply multiply the quantity delivered by the price
Calculate the tax using the tax rate (B12) and the line subtotal.
Make sure that the formula in H4 can be copied "down" by using absolute and relative references where appropriate
Make sure that the formula in H4 figures the tax only when the customer has bought taxable items represented by a "yes" in the taxable column
Create the subtotal value by adding the line Sub Totals
Create the Tax value
Create the Total Invoice Amount
Calculate the lost sales (number of items NOT delivered)
Use a function to create the average number of items ordered
Calculate the average price of all items delivered
Why are the values in F7 (700.77) not 700 (7 * 100)?
Attachment:- Questions.rar