Which of these statements is true?

How do functions work? Functions use argument and operators, perform calculations, and return a ________________.

Owen is a school teacher. He is preparing a spreadsheet on the marks scored in Math in the first semester. He wants to find out the highest mark scored in Math during the last 3 years. Which function should he use?

Which function adds values from multiple cells and returns a specific numeric value?

What is the formula equivalent to the function =SUM(B1:B5)?

A display screen at the airport shows the arrival and departure information of flights. Which data type is suitable for showing the arrival of a flight? Which data type would be suitable for displaying the reason for flight delay? The date/time is suitable for showing the arrival of flight. The _____________ data type is suitable for displaying the reason for flight delay.

William is an HR manager in a textile-manufacturing 􀃕rm. He is creating a file on the hours each employee worked during the last month. He wants to avoid decimal numbers in the work hours. Which function can he use in the spreadsheet to convert the decimal numbers to the

nearest integers?

Ron is in the process of designing tables for a database that will contain information for all school matches played in a year. What kind of field must he design to prevent users from entering duplicate values? Hint: This is a unique/primary key that computer looks up about a certain record.

Which database item would show details such as a customer’s name, their last purchase, and other details about a customer? Hint: It's like when you go to the doctor, the assistant looks at your record.

Which field data type would you use if you would like to store videos in that field? Hint: binary object

In an employee database, which data type would you use to categorize an employee as either male or female? Hint: Boolean

Jenny is preparing a presentation on the health statistics of the 10 most populated countries. She wants to apply a blinking effect to the names of the countries, and a motion effect between the exit and entry of every slide. Which options should she use? Jenny should use the Animation option to apply a special blinking effect to the

names of the countries and the __________________ option to apply a motion effect between the exit and entry of every slide.

Which slide should you change so that it reflects on all the slides in your presentation?

You received a request to create an urgent presentation with predesigned and preinstalled elements. Which option will you use?

George wants to edit the font of the title text in his presentation. Where can he find the option to edit it?