QUESTION 1

- The IF function has four entries.

True

False

0.9 points

QUESTION 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 - 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 - 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 - 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 - 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 - 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 - The PivotTable functionality is located in the Data tab.

True

False

0.9 points

QUESTION 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 - Which of the following functions returns a range of cells?

OFFSET

COUNTA

MATCH

REDEFINE

None of the given choices

0.9 points

QUESTION 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 - 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 - The Simplex Method is the default solving method in Solver.

True

False

0.9 points

QUESTION 14 - The Solver and Analysis Toolpak Add-ins are not built in to Excel.

True

False

0.9 points

QUESTION 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 **