One of the software of Microsoft Office that enables the users to clean, aggregate and visualize data.

• Excel

• Word

• Sway

• Forms

What does Data Design refer to?

• The analysis and coding of data

• The procedure of addressing and structuring data

• The processing and output of data reports

• The storage and retrieval of data

What is Predictive Analytics?

• Atype of data analytics that examines past trends without forecasting future outcomes

• Atype of data analytics that predicts the future base

• Atype of data analytics focused solely on visualizing

• Atype of data analytics that only identifies patterns

What does a timeline determine in data collection?

• The scope and type of data to be analyzed

• The time-period of the data to be collected depending on the decision to be made

• The methods and tools to be used for data processing

• The storage location for collected data

How does Business Intelligence support businesses?

• By integrating data into various technologies to support decision-making

• By storing data for long-term record-keeping

• By enhancing employee productivity through training programs

• By automating processes without analyzing data

What role does Data Analysis play in Business Intelligence?

• It enables businesses to explore, analyze, and interpret data to identify patterns, trends, and correlations

• tI focuses solely on storing data for future reference

• I automates business processes without examining data

• tI emphasizes employee training over data examination

What is the purpose of the Formula Bar in Microsoft Excel

• It allows users to insert formulas for data processing

• t displays only static text without any data processing

• It serves as a tool for formatting cells and changing colors

What does the function SUM(A1:10) do?

• Multiplies the values ni A1 to A10

• Calculates the average of the values ni A1 to A10

• Adds al the values in A1 to A10

• Counts the number of

  cells ni A1 to A10

What does the function SUM(A1:10) do?

• Multiplies the values ni A1 to A10

• Calculates the average of the values ni A1 to A10

• Adds al the values in A1 to A10

• Counts the number of

  cells ni A1 to A10

What will the formula =A1+B1 return if A1 is 5 and B1 is 10?

• 15

• 510

• 10

• 5