BIS Week 3 Workshop

Look at the example given and identify which concept the example falls into?

• Data

• Information

• Knowledge

• Wisdom

Which of the following could be best classified as “raw data”

• The temperature dropped 15 degrees and then it started raining.

• If the humidity is very high and the temperature drops, it rains.

• The rain

• This is the heaviest rain in the week.

Look at the example given and identify which concept the example falls into?

• Knowledge

• Information

• Wisdom

• Data

Identify analytics method was used to make this statement?

• Prescriptive analytics

• Descriptive analytics

• Narrative analytics

• Predictive analytics

Based the given graph, which statement best described the graph?

• Meat is the most popular calories source amongst men aged 25-49.

• Men aged 50 and over has the highest dairy consumption.

• The graph has a secondary axis.

• Prescriptive analytics is used to conduct the chart.

Once a type of graph is chosen, it cannot be changed?

• True

• False

In Excel, which one denoted a range from B1 through E5?

• B1 - B5

• B1:B5

• B1 to B5

• B1$B5

Data validation is used to

• Sort data

• Generate graph

• Limit entries

• Transpose the content of copied cells

From the given table, the formula to find Fontana’s first name should read

• =VLOOKUP(B3,B2:E7,2,TRUE)

• VLOOKUP(B3,B2:E7,2,FALSE)

• =VLOOKUP(B3,B2:E7,2,FALSE)

• =VLOOKUP(B3,B2:E7,D,FALSE)

The formula to calculate ‘Sales Variance’ is

• Sales variance = Total sales – Target sales

• Sales variance = Total sales + Target sales

• Sales variance = Target sales – Commission

• Sales variance = Total sales/Target sales