Exam (elaborations)
WGU C268 SPREADSHEETS PA exam with questions and answers 2024
- Course
- Institution
WGU C268 SPREADSHEETS PA exam with questions and answers 2024
[Show more]
Content preview
WGU C268 SPREADSHEETS PA exam with questions andanswers 2024
Use the DAY function in cell F18 to calculate the day portion of the "Time Stamp" in cell
B18. Copy and paste your function down to complete the "Day" column of the table. -
=DAY(B18)
Use the HOUR function in cell G18 to calculate the hour portion of the "Time Stamp" in
cell B18. Copy and paste your function down to complete the "Hour" column of the
table. - =HOUR(B18)
Use the MINUTE function in cell H18 to calculate the minute portion of the "Time
Stamp" in cell B18. Copy and paste your function down to complete the "Minute" column
of the table. - =MINUTE(B18)
Use the SECOND function in cell I18 to calculate the second portion of the "Time
Stamp" in cell B18. Copy and paste your function down to complete the "Second"
column of the table. - =SECOND(B18)
Use the CONCAT function (or the CONCATENATE function if you are using Excel 2013
or earlier) in cell J18 to create the "Date" by combining the "Month" in cell E18 with the
"Day" in cell F18. "Date" should use this syntax: "Month/Day". Your function should,
therefore, also insert the "/" character between the "Month" and "Day." Copy and paste
your formula down to complete the "Date" column of the table. - =CONCAT(E18,"/",F18)
Use the CONCAT function (or the CONCATENATE function if you are using Excel 2013
or earlier) to create the "Transaction Statement" in cell K18. The statement in cell K18
should read "I spent $24.06 at merchant #4931 on: 8/1". To make this statement,
combine "Statement P1" in cell D13, the "Amount" in cell D18, "Statement P2" in cell
D14, the "Merchant ID" in cell C18, "Statement P3" in cell D15, and the "Date" in cell
J18. Copy and paste your function down to complete the "Transaction Statement"
column of the table. - =CONCAT($D$13,D18,$D$14,C18,$D$15,J18)
In the "Input Analysis" section of the spreadsheet model, calculate the average
attendance and sales for each type of product from the past events listed in the "Past
Events" worksheet. - =AVERAGE('Past Events'!C4:C103)
In the "Input Analysis" section of the spreadsheet model, calculate the sample standard
deviation for attendance and sales for each type of product from the past events listed
on the "Past Events" worksheet. (Note for Excel 2007 users: Excel 2007 does not
, support a specific function to calculate sample standard deviations. Use the STDEV
function instead.) - =STDEV.S('Past Events'!C4:C103)
In the "Input Analysis" section of the spreadsheet model, calculate the 95% confidence
interval for the sales for each type of product. (You will not calculate a confidence
interval for attendance.) Use the number of events (calculated in cell I3) as part of your
calculations. (Note to Excel 2007 users: the CONFIDENCE.NORM function is not
supported in Excel 2007. Use the CONFIDENCE function instead.) -
=CONFIDENCE.NORM(0.05,J7,$I$3)
In the "Input Analysis" section of the spreadsheet model, calculate the correlations
between the sales of each type of product and event attendance. Use appropriate
ranges from the "Past Event" worksheet for your calculations. - =CORREL('Past
Events'!D4:D103,'Past Events'!C4:C103); use the formula for both Food and
Merchandise; no copy/paste.
The sales for which product type are most highly correlated with attendance? Select the
correct answer from the drop-down list in cell L32. - Food
In the "Input Analysis" section of the spreadsheet model, calculate a sales forecast for
each type of product if expected attendance at the future event is 18000 people.
Reference cell I13 (the attendance forecast) for your calculations. -
=FORECAST($I$13,'Past Events'!D4:D103,'Past Events'!C4:C103)
In the "Input Analysis" section of the spreadsheet model, calculate the upper limit for
your sales forecast for each type of product if expected attendance at the future event is
18000 people. Reference the confidence interval you created for your calculation. -
=I16+J8
In the "Input Analysis" section of the spreadsheet model, calculate the lower limit for
your sales forecast for each type of product if expected attendance at the future event is
18000 people. Reference the confidence interval you created for your calculation. -
=I16-J8
How likely is it that food sales would exceed $220,000 if attendance is 18,000 people?
Select the correct answer from the drop-down list in cell L35. - <5% chance
In the "Event Profitability Analysis" section of the model, enter the projected sales for
each product type for this event by referencing your sales forecast from the "Input
Analysis" section of the model. - =I16
Calculate the payment amount for the loan in cell C15. Reference the cells containing
the appropriate loan information as the arguments for the function you use. Cells C20-
C67 in the "Payment" column are populated with the payment amount from cell C15. [34
Points] - =PMT(Rate/#months of term,LoanAmt)
=PMT(C13/12,C12,C11)
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller chareiezekiel. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $28.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79271 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now