BIS Week 4 Workshop

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)