Skills Covered
Problem solving including formulas with unit conversions
Round down a value
Copy/Paste values from one workbook to another
Calculate difference between 2 values, percent of total, percent difference
Switch between 2 worksheets in a workbook
Microsoft Excel 15.0 Answer Report
Worksheet: [RadioAds.xlsx]Radio
Report Created: 2/12/2013 10:43:31 PM
Result: Solver found an integer solution within tolerance. All Constraints are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.015 Second
Skills Covered
Insert rows in a worksheet
SUM function
Boolean logical functions - AND, OR, NOT
Relational Expressions
IF functions & Nested Ifs with nested Boolean Logical functions &
relational expressions
MAX function
None of construct - nesting Boolea
Skills covered
Nesting functions
Relative/Absolute cell referencing
Arithmetic formulas
ISBLANK function
VLOOKUP function
IF function
INDEX function
MATCH function
AVERAGE function
SUM function
Using Range Names
Car Operating Cost Estimate Form
Data Input
Student's Name
TheZone
TZEdge Labor Analysis
Production
Description
Rate
Unit
Delivery of Boxes to Product line
14.00 boxes/hr
Cutting of Leather
20.00 shoes/hr
Attachment of Appliques
30.00 appliques/hr
Sewing of Logos to Leather
16.50 pieces/hr
Assembly
Problem 9-47
Name:
Instructor
Enter the appropriate amount or formula in the shaded cells.
An asterisk (*) will appear in the column to the right of an incorrect amount.
1. a.
Woodruff Manufacturing
Sales Budget (Schedule 1)
For the Quarter Ended March 31
Skills covered:
HLOOKUP function (type TRUE)
VLOOKUP function (types TRUE & FALSE)
Relative and Absolute cell referencing
Arithmetic formulas
IF function with nested Relational Expressions
SUM function
Flat Tax Rate
Base Income
Alternate 1
Alternate 2
$0
Skills covered in this problem:
Analyze data by creating and running a Solver model
Use arrays and the SUMPRODUCT function
Save and load Solver models
Build a Solver model that uses binary constraints
Microsoft Excel 15.0 Answer Report
Worksheet: [Puma As
Skills Covered
Creating your own workbook, inserting a worksheet
Writing formulas using arithmetic operators - unit conversions
Relational expressions
IF functions & Nested Ifs
SUM function
Formatting cells
Relative & Absolute cell referencing
NT Painting
Quality Control Data - Ski Bindings
Failure
Temperature
o
CFailure
Temperature
o
CFailure
Binding
Pressure
Component Pressure Temperature
ID# Type Date/Time
Test (Lbs) Temperature oC
Value
Rankings Rankings
3823
1 11/1/2016 10:26
10.745
-66.5
$33.59 #NAME
Executive Transport, Inc.
Rental Car Cost Analysis
As of June 30, 2016
Car Rental Contract Terms
Car type:
Weekly rental car charge:
Charge per mile:
Gas-related data
Average miles per gallon for car
Average cost per gallon of gas
Quote Customer Projected
Skills Covered
Creating your own lookup tables
VLOOKUP & HLOOKUP type false VLOOKUP type true
Relative/Absolute cell referencing
Referencing multiple worksheets
WEEKDAY function (explained in problem)
LOOKUP function
INDEX function
ROUND function
Arithmet
Skills Covered
Boolean Logical Functions - AND, OR, NOT
Relational expressions nested in Boolean Logical Functions
Conditional Formatting - data bars, highlight cell
COUNTIF function
ApplicationforEmployment
Name
Anderson
Ryan
Greg
Jackie
Sandra
Lindsey
C
Chapter10:ConceptualReviewQuestionsAnswers
1. What is a decision support system?
A decision support system is a type of information system designed to help managers solve problems
and make decisions related to business strategies. It helps managers model
Chapter1:ConceptualReviewAnswers
1. What formula could you write to calculate the mean of the following data set: 4, 10,
8, 6, 2, 4, 14? (Note that a resulting value is not required.)
=AVERAGE(4,10,8,6,2,4,14)
2. What is the median value of the data set g
Skills Covered:
Relative & Absolute Cell Referencing
Insert new worksheets into the workbok
Ranking values on a list - RANK.EQ function
Calculate mean, standard deviation
LARGE & SMALL functions
Percent Difference formula
Use comparison values to draw con
Chapter 4: Conceptual Question Answers
1. Evaluate the following expressions:
a. = OR(FALSE, TRUE, TRUE) TRUE
b. =AND(3>5, TRUE) FALSE
c. = NOT(OR(FALSE, FALSE, TRUE) FALSE
d. =AND(A2>6, NOT(FALSE) where A2 contains the value 25. TRUE
2. Describe how you
Answers to Concepts Questions: Chapter 5
Answer Questions 110 as True or False.
1. F The lookup_value of a HLOOKUP function can be a continuous cell range.
2. T In a VLOOKUP formula with a TRUE lookup type, the lookup table referenced must
be in ascending
Chapter 3: Conceptual Review Answers
1. List and describe the significance of each of Tuftes five data graphics principles.
Above all else show the data
Maximize the data-ink ratio, within reason
Erase non-data-ink, within reason
Erase redundant data ink,
Chapter1:ConceptualReviewAnswers
1. What formula could you write to calculate the mean of the following data set: 4, 10,
8, 6, 2, 4, 14? (Note that a resulting value is not required.)
=AVERAGE(4,10,8,6,2,4,14)
2. What is the median value of the data set g
Chapter1:ConceptualReviewAnswers
1.
What is the meaning of each of the following error messages:
#NAME? - Unrecognized text in a formula
#N/A No answer
#REF! Invalid cell reference
#VALUE! Wrong argument type of operand
#NUM! Invalid numeric values in a f
Problem 2-46
Name:
Instructor
Enter the appropriate amount in the shaded cells.
An asterisk (*) will appear in the column to the right of an incorrect amount.
1.
Hayward Company
Statement of Cost of Goods Manufactured
For the Month of May
Direct materials
Exercise 12-20
Name: Instructor
In the gray-shaded cells, enter the appropriate amounts or formulas.
An asterisk (*) will appear in the column to the right of an incorrect amount.
1.
2.
Sales
Less expense
Operating income
Operating
income
$35,000
$350,000