Joospa 2

Who is the father of computer?

• Steve Jobs

• Elon Musk

• Charles Babbage

• Bill Gates

Which of the following functions is used to find the highest value in a range of cells

• Highest

• Maximum

• Max

• Average

Which of the following functions is used to find the average of a range of cells?

• AVG

• Mean

• Average

• Count

Which of the following functions is used to find the smallest value in a range of cells?

• Small

• Min

• Low

• Smallest

Which of the following functions is used to find the total of a range of cells

• Total

• Sum

• Answer

• Count

Which of the following functions is used to round a number to a specified number of decimal places?

• Trunc

• RoundDown

• RoundUp

• Round

What is a worksheet in Excel?

• A chart used to represent data

• A range of cells selected for data analysis

• A function used to manipulate data

• A single page within a workbook where data is entered and analyzed

Which of the following is NOT a type of reference in Excel?

• Absolute mixed reference

• Absolute reference

• Mixed reference

• Relative reference

What is the shortcut key to save an Excel workbook?

• Shift + S

• Alt + Shift + S

• Ctrl + S

• Ctrl + A

Which of the following Excel text functions can be used to remove leading and trailing spaces from a cell

• TRIM

• PROPER

• LOWER

• REMOVE