Spreadsheets WGU Questions with
Accurate Answers
Comments section on four J's painting correct answer
=IF(AND(E16<=C16),"Good Job",IF(H16<1,"Poor
Quality",IF(E16>C16,"Too Much Time","Poor Quality")))
DAY function? correct answer =DAY(timestamp)
How do we calculate COGS? correct answer =SALES * COGS Percent
(this was given to us)
How do we calculate Gross Profit? correct answer SALES - COGS=
GROSS PROFIT
How do we calculate Total Operating Expenses? correct answer This is
the SUM of Salary expenses, Comissions and Fixed Costs.
How do we find how many employees we need? correct answer Total
before Arena Fee * Employee Percent Expected (this was given),
REMEMBER to round up.
How do we find Profit before the Arena Fee? correct answer Gross
Profit - Total Operating Expenses
, How do we use AVERAGEIF? correct answer AVERAGEIF(range, criteria,
range average)
How do we use the AND function? correct answer AND(One condition,
another condition)
How do we use the IF function? correct answer IF(logical test, value if
true, value if false)
How do we use the OR function? correct answer =OR(One condition,
another condition)
How do we/why do we use LEN? correct answer =LEN(the statement)
This returns the number of characters in a string
How to do Sum Check Calulation? correct answer Total amount paid -
initial balance (Checking to make sure the result for total interest paid
is correct)
How to do we use H look up? Why do we use it? correct answer We use
it to transfer table data into the active spreadsheet.
=HLookup(what were looking up, where the information lies, which row
we are extracting the information from, )
Accurate Answers
Comments section on four J's painting correct answer
=IF(AND(E16<=C16),"Good Job",IF(H16<1,"Poor
Quality",IF(E16>C16,"Too Much Time","Poor Quality")))
DAY function? correct answer =DAY(timestamp)
How do we calculate COGS? correct answer =SALES * COGS Percent
(this was given to us)
How do we calculate Gross Profit? correct answer SALES - COGS=
GROSS PROFIT
How do we calculate Total Operating Expenses? correct answer This is
the SUM of Salary expenses, Comissions and Fixed Costs.
How do we find how many employees we need? correct answer Total
before Arena Fee * Employee Percent Expected (this was given),
REMEMBER to round up.
How do we find Profit before the Arena Fee? correct answer Gross
Profit - Total Operating Expenses
, How do we use AVERAGEIF? correct answer AVERAGEIF(range, criteria,
range average)
How do we use the AND function? correct answer AND(One condition,
another condition)
How do we use the IF function? correct answer IF(logical test, value if
true, value if false)
How do we use the OR function? correct answer =OR(One condition,
another condition)
How do we/why do we use LEN? correct answer =LEN(the statement)
This returns the number of characters in a string
How to do Sum Check Calulation? correct answer Total amount paid -
initial balance (Checking to make sure the result for total interest paid
is correct)
How to do we use H look up? Why do we use it? correct answer We use
it to transfer table data into the active spreadsheet.
=HLookup(what were looking up, where the information lies, which row
we are extracting the information from, )
