Basic Data Analytics X Power BI quiz!!

What is Data Analytics?

• Data Analytics is the process of creating raw data
• Data Analytics is the process of ignoring data to make decisions
• Data Analytics is the process of analyzing raw data to extract valuable insights and make informed decisions.
• Data Analytics is the process of guessing insights from data

How does data analytics differ from data mining?

• Data analytics and data mining are the same

• Data analytics focuses on analyzing data to extract insights, while data mining focuses on discovering patterns in data

• Data analytics is a subset of data mining

• Data mining is a subset of data analytics

What are the common tools used in data analytics?

• Hammer and nails

• Microsoft Word and Excel

• Python, R, and Tableau

• Screwdriver and wrench

The following are part of the data analytics process except

• Data Updating

• Data analysis
• Data visualization
• Data collection

What Microsoft Office tool is most useful in data analysis?

• Microsoft Word
• Microsoft Excel
• Microsoft PowerPoint
• Microsoft Access

What Excel function is used to search for a certain value in a column to return a value from a different column in the same row?

• HLOOKUP
• INDEX
• VLOOKUP
• MATCH

What do we mean by Relative cell referencing and Absolute cell referencing in MS Excel?

• Relative cell referencing only works in Excel Online, while Absolute cell referencing works in all versions of Excel.
• Relative cell referencing is used for text cells, while Absolute cell referencing is used for numerical cells.
• Relative cell referencing changes the cell references when pasted, while Absolute cell referencing keeps the cell references fixed.
• Relative cell referencing changes the cell references when copied, while Absolute cell referencing keeps the cell references fixed.

How is a Formula different from a Function in Excel?

• A Formula is a built-in expression, whereas a Function is a user-created expression.
• A Formula is a pre-defined expression, whereas a Function is a dynamic expression.
• A Formula is a static expression, whereas a Function is a variable expression.
• A Formula is a user-created expression, whereas a Function is a built-in expression.

How will you write the formula for the following?
Multiply the value in cell A1 by 10, add the result by 5, and divide it by 2.

• (A1 + 10) * 5 / 2
• ((A1 * 10) + 5) / 2
• (A1 * 10) - 5 / 2
• (A1 * 10) + 5 / 2

Given below is a student table. Write a function to add pass/fail to the results column based on the following criteria.

If the student marks > 60 and attendance > 75%, then pass else the student fails.

Write a function for Mia's Result.

(WRITE THE FUNCTION IN ALL CAPS)