DIAG TEST 2025

Which of the following would NOT yield the correct results when one is attempting to find the total of numbers in various cells?

• Clicking on the AutoSum button

• Using the SUM function

• Clicking on the Function button

• Using the TOTAL function

In a spreadsheet, equations that you create using values and cell references are called:

• Functions

• Calculations

• Values

• Formulas

The function that should be used to find the AVERAGE value among a range of values is:

• =SUM(Average)

• =AGV()

• =AGE()

• =Average()

Which of the following functions should be used to return the number of entries in a range that represents pass or fail?

• =COUNTA()

• =COUNTER IF ()

• =COUNT()

• =COUNT IF ( )

When entering data into spreadsheet software, which of the following is used to move the cursor horizontally across to an active cell?

• CTRL + PgDown

• CTRL + TAB

• ENTER

• TAB

James Haylet was appointed by Go Tech Ltd as their new workplace health and safety officer. What is Mr. Haylet's role in the company?

• Represent the workers' views and reports concerns about the workplace's OH&S practices to the employer.

• Document the workplace's OH&S policies and practices.

• Check on whether all workers are complying with the workplace's OH&S policies and practices.

• Train all workers and assess their knowledge of the workplace's OH&S policies and practices.

The responsibility for erecting safety signs on job sites, and providing safe working conditions, is the responsibility of which of the following?

• Supervisor

• Worker

• Employer

• Manager

A new employee has asked his fellow teammate who should be responsible for ensuring that personal protective equipment is used, if needed. What should the teammate's response be? The:

• Worker

• Union

• Government

• Employer

Mrs. Brown started to complain about experiencing muscle tightness, cramping, discomfort, pain in the shoulders, neck, upper and lower back. Which group of hazards BEST categorizes Mrs. Brown's complaint?

• Biological

• Chemical

• Psychological

• Ergonomic

Our team leader, Joan, has explained to us that employees inside of our organization, who are end-users of our products, are known as _______________ customers.

• personal

• internal

• potential

• external