WorksheetsBIS Week 4 Workshop
Total questions: 11
Worksheet time: 7mins
What form of business analytics was conducted to generate this sentence
Prescriptive analytics
Predictive analytics
Descriptive analytics
Comparative analytics
You can use the format painter multiple times before turning it off by:
Pressing Fn key and clicking on the format painter button.
Double click on the format painter button
Pressing Enter key and clicking on the format painter button.
None are correct because this function will be automatically turned off after one use.
Corresponds to the category labels in a pie chart and series names in other charts.
axes
legend
gridlines
slice
If a store manager wants to compare the percent of contribution of individual items to the total profit, what chart should be used?
column chart
line chart
pie chart
bar chart
A good data visualisation should NOT have
Too much information
Clear layout
Connections between a variety of data
Accurate and consistent information
What ribbon will you choose to create Macro button?
Insert
References
Review
Developer
To save file with Macro buttons, you need to save the workbook as
Excel binary workbook
Excel workbook
Macro-enabled workbook
Excel template
Which of the following is NOT a box in the Pivot table fields list
Column labels
Report filter
Values
Formulas
With the reference to the table below, the formula to find Olivier should read
=VLOOKUP(B3,B2:E7,2,TRUE)
=VLOOKUP(B3,B2:E7,2,FALSE)
=VLOOKUP(B3,B2:E7,B,FALSE)
=VLOOKUP(B3,B2:E7,4,FALSE)
With references to the table below, the formula in cell F2 should read:
=SUMIF (A2:A8,“Bananas”,C2:C8)
=SUMIF (C2:C8,“Bananas”,A2:A8)
=SUMIF (C2:C8,“Bananass”,A2:A8)
=SUMIF (A2:A8,“Philippines”,A2:C8)
[Related to Excel practice you've just done] VLOOKUP formula is used to reference the data from the "Commission data" worksheet to the "Commission" in the "Sales analysis" worksheet for each sales representative by looking up %Variance. To do that for Thompson's commission, the formula should read:
(a)
