Data analytics Introduction

Which function adds a range of cells in Excel?

• AVERAGE
  

• SUM
  

• COUNT
  

• MAX

What does $A$1 mean in Excel?

• Absolute reference

• Relative reference

• Mixed reference

• Invalid reference

What Excel function is used to generate a random whole number between 1 and 100?

• =RANDOM(1,100)

• =RAND(1,100)

• =RANDBETWEEN(1,100)

• =RANDOMBETWEEN(1,100)

What Excel feature is used to change cell appearance based on rules?

• Data Validation

• Conditional Formatting

• Pivot Table

• Cell Style

Which of the following is NOT a component of data analytics?

• Data collection

• Data storytelling

• Data modelling

• Data pricing

Which of these is an example of structured data?

• Images

• Videos

• Excel spreadsheets

• Audio files

Which of the following best describes descriptive analytics?

• Forecasting future outcomes

• Explaining why something happened

• Describing what has happened

• Recommending actions

What is the first step in the data analytics process?

• Visualization

• Data Cleaning

• Data Collection

• Report Sharing

We have how many types of data analytics?

What is the difference between structured and unstructured data?