Excel Test
QUESTION 1
- The ways that HLOOKUP formula works is searching down instead of across data. True
False
0.9 points
QUESTION 2
- The AND formula takes a list of Booleans and returns TRUE if all of them are true, and FALSE otherwise. True
False
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.TRUEFALSEIt would return an errorThere is insufficient information to answer this question
1.4 points
QUESTION 4
- 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
0.9 points
QUESTION 5
- Use the brewery.xlsx file to answer the following question: How many total transactions took place at Beerland Amherst?3527425844258542194315939
0.9 points
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: What s the name of the beer with the highest Alcohol by Volume (ABV)?Half LordGear ShiftSheep MojoRed Salty HoserGnu Breath
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 between 3000 and 12000?75689
1.4 points
QUESTION 10
- Which of the following functions returns a range of cells?OFFSETCOUNTAMATCHREDEFINENone of the given choices
0.9 points
QUESTION 11
- A named range can be usedwhen creating chartsin formulasin functionsnone of the given choicesall of the given choices
0.9 points
QUESTION 12
- Which of the following statements is correct if new data will be attached as a new row to the existing table?OFFSET( base cell, 0, 0, 1, COUNTA (larger range in row where potential data may appear) )OFFSET( base cell, 0, 0, COUNTA (larger range in row where potential data may appear),1)OFFSET( base cell, COUNTA (larger range in row where potential data may appear), 0, 0,1)OFFSET( base cell, 0, COUNTA (larger range in row where potential data may appear), 0,1)None of the given choices
1.4 points
QUESTION 13
- One of the primarily characteristics of Solver is the mathematical relationship between the objective, the constraints, and the decision variables. 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 manufacturing concern wishes to minimize its shipping costs between its 4 factories and 3 warehouses. Factory 1 supplies 1000 units per week and costs $5, $3, and $4 to ship each unit to Warehouses 1, 2, and 3 respectively. Factory 2 supplies 1200 units each week and costs $4, $3, and $3 to ship to Warehouses 1, 2, and 3. Factory 3 supplies 1500 units and costs $6, $2, and $5 to ship to the three warehouses. Factory 4 supplies 1800 units and costs $6, $2, and $4.
If Warehouse 1 requires 3000 units per week, Warehouse 2 demands 1000, and Warehouse 3 demands 1500, what is the minimum it would cost them in shipping to fulfill each warehouse’s demand?