Random Quiz

Which Excel function is used to find the largest value in a range of numbers?

• =MIN()

• =MAX()

• =LARGE()

• =BIGGEST()

What does the function =SUM(A1:A5) do in Excel?

• Multiplies the values in cells A1 to A5

• Finds the average of cells A1 to A5

• Adds the values in cells A1 to A5

• Divides the values in cells A1 to A5

How can you apply a filter to a table in Excel?

• Use the "Filter" function in the Home tab

• Right-click on the table and choose "Apply Filter"

• Go to the Data tab and click on "Filter"

• Type "=FILTER(table)" in a cell

What is the purpose of the "IF" function in Excel?

• To create a table of contents

• To count the number of cells in a range

• To calculate the sum of a range of numbers

• To perform conditional calculations based on a logical test

What is the purpose of the "VLOOKUP" function in Excel?

• To perform vertical lookup and retrieve data based on a matching value

• To find and replace text in a worksheet

• To add a range of numbers

• To calculate the square root of a number

What is the formula of the monthly collection efficiency report?

• Total Collected Amount / Total Collectibles

• Total Collectibles /Total Collected Amount

• Total Collectibles / Total Unpaid Amount

Atlantic Hardware VISION : To be the customer's ___ building materials and home improvement needs in Cebu by 2027.

What logo is this?

What logo is this?