Worksheets202505 AMIS2723 Mid-Term Revision Quiz 1of2
Total questions: 15
Worksheet time: 13mins
Data Reliability refers to _____ of data.
consistency
empowerment
completeness
accuracy
Data Validity refers to _____ and _____ of the data that _____ for its intended purpose.
completeness ; storage ; serve
relevancy ; correct use ; fit
writing ; retrieval ; designed
originality ; truthfulness ; relevant
A situation where the outcomes are unknown and probabilities cannot be accurately determined.
(a)
A situation where the possible outcomes and their probabilities are known. It is usually associated to possibility of unpleasant happening.
(a)
Identify suitable factors that make spreadsheet software like Microsoft Excel and GSheet so widely used when it comes to business data analytics.
Ease of data management and manipulation (rows & columns)
Wide range of functions for data analytics.
Visualization capabilities like chart and table to summarize and reveal patterns and trends.
Flexibility and familiarity. Versatile software in doing data analytics. Widely available.
Collaboration and Sharing. Team members can work together remotely. Enjoying the synergy.
Draw anything in your mind that you can associate it to a spreadsheet software like MS Excel or GSheet.
A HR manager is looking through employee data set. Identify a valid reason for the HR manager to sort and filter this data set. Pick the best answer.
To evaluate periodical sales performance.
To identify suitable candidate for promotion to branch head.
To identify the best vendors to outsource HR function of the company.
To identify the best-selling products of the company.
Why do you think experienced Microsoft Excel users often use Table?
Data Sorting and Filtering
Totals Row
Alternating Color Bands ; Automatic Formatting
Structured Table Referencing
Easy Chart Creation
In an Excel workbook, a cell, a range and a table can be named. Why do you think experienced users like to use named cell, named range and named table?
Readability and Clarity
Reduced Errors
Easier to do maintenance
Data Validation and Dropdown List
A field in a data set is also known as (a) . It uniquely describes each data item in all rows below it.
In TAR UMT, there are 7 faculties namely FAFB, FOCS, FSSH, FCCI, FOBE, FOET and FOAS. What is the best chart to use when it comes to comparing student population among faculties?
Pie Chart
Line Chart
Bar Chart
Doughnut Chart
Mixue iced drink franchise business would like to know the overall sales revenue generated during the screening of F1: The Movie from 26 June 2025 to the end of July 2025. What is the best chart to visualize this data?
Pie Chart
Area Chart
Line Chart
Column Chart
In a Texas Chicken fast-food outlet, the Mei Lin as the outlet supervisor has collected data for customer waiting time and customer rating for over a week. She would like to know whether both variables here are related. What is the best chart to use here?
Bubble Chart
Clustered Column Chart
Area Chart
Scatter Plot Chart
McDonald's is rivaling KFC these few years in offering chicken based meals. You have access to 6 months sales data of 2-pc chicken ala-carte for both McDonald's and KFC. What is the best chart to visualize this data so that you can compare both offerings?
Clustered Column Chart
Area Chart
Clustered Bar Chart
Line Chart
Which programme graduate would require in-depth understanding of business analytics to prepare for their future jobs?
DBU
DEM
