Formulation of the SUM function

QUESTION 1

1. The IF function has four entries.
   True
   False
   0.9 points
   QUESTION 2
2. Which of the following is not a valid formulation of the SUM function?
   =SUM(3,A2,D5,FALSE)
   =SUM(A10:A20, A10,A10)
   =SUM(A1:D1,B1:B5,6)
   =SUM(6)
   each of the above is valid
   0.9 points
   QUESTION 3
3. How would Excel evaluate the following formula? =OR(7<5, A2=6,NOT("zebra"<="tree"))? Assume that the formula is in cell D4, the workbook contains no circular references, and outside of cell D4 the workbook contains no errors.
   TRUE
   FALSE
   It would return an error
   There is insufficient information to answer this question
   1.4 points
   QUESTION 4
4. Use the brewery.xlsx file to answer the following question: How many total transactions took place at Beerland Amherst?
   35274
   25844
   25854
   21943
   15939
   0.9 points
   QUESTION 5
5. One of the benefits of using the Table feature is that you’ll be able to see the column titles at every moment.
   True
   False
   QUESTION 6
6. Use the file Code_Enforcement_-_Building_and_Property_Violations.xlsx for this question.
   What is the total dollar amount of penalties for closed cases in Charlestown due to residents’ improper storage of trash (improper storage trash:res)?
   ( )
   1.4 points
   QUESTION 7
7. Use the Brewery.xlsx file to answer the following question: In which month does the highest order quantity take place?
   April
   January
   March
   July
   June
   0.9 points
   QUESTION 8
8. The PivotTable functionality is located in the Data tab.
   True
   False
   0.9 points
   QUESTION 9
9. Use the Brewery.xlsx file to answer the following question: How many beers product names have order quantities less than or equal to 5000?
   20
   21
   17
   19
   18
   1.4 points
   QUESTION 10
10. Which of the following functions returns a range of cells?
    OFFSET
    COUNTA
    MATCH
    REDEFINE
    None of the given choices
    0.9 points
    QUESTION 11
11. A named range can be used
    when creating charts
    in formulas
    in functions
    none of the given choices
    all of the given choices
    0.9 points
    QUESTION 12
12. Which of the following OFFSET statements is correct if we want to refer to the range 1 cell right to the base cell and expand the range area to be a 2X3 range?
    OFFSET(base,0,1,2,3)
    OFFSET(base,2,3,1,0)
    OFFSET(base,1,0,2,3)
    OFFSET(base,2,3,0,1)
    OFFSET(base,1,0,3,2)
    1.4 points
    QUESTION 13
13. The Simplex Method is the default solving method in Solver.
    True
    False
    0.9 points
    QUESTION 14
14. The Solver and Analysis Toolpak Add-ins are not built in to Excel.
    True
    False
    0.9 points
    QUESTION 15
15. Use solver to answer the following question: A corrupt shipping concern wishes to maximize the revenue they make from an analytics-bereft manufacturing concern, which has 4 factories and 3 warehouses. Factory 1 supplies 1000 units per week and is charged $5, $3, and $4 to ship each unit to Warehouses 1, 2, and 3 respectively. Factory 2 supplies 1200 units each week and is charged $4, $3, and $3 to ship to Warehouses 1, 2, and 3. Factory 3 supplies 1500 units and is charged $6, $2, and $5 to ship to the three warehouses. Factory 4 supplies 1800 units and is charged $6, $2, and $4.
    If Warehouse 1 requires 3000 units per week, Warehouse 2 demands 1000, and Warehouse 3 demands 1500, what is the maximum it would cost them in shipping to fulfill each warehouse’s demand?

Sample Solution