202505 AMIS2723 Mid-Term Revision Quiz 1of2

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.