Excel-O-Mania 2023

Which of the following is a valid function in Microsoft Excel?

• =SUM(A1:B2)

• =FORMAT(A1:B2)

• =INSERT(A1:B2)

• =SORT(A1:B2)

 The bar graph presented above displays the total number of patients in five hospitals, namely P, Q, R, S, and T, along with the number of patients suffering from heart ailments in each of these hospitals.

• P

• Q

• R

• S

What is the default file extension for an Excel workbook file?

• .xls

• .xlsx

• .xlsm

• .xlam

Which function in Excel is used to find the highest value in a range of cells?

• MIN

• MAX

• AVERAGE

• SUM

Which chart type in Excel is best suited for showing trends over time?

• Bar chart

• Line chart

• Pie chart

• Scatter chart

What is the keyboard shortcut to autosum a column of numbers in Excel?

• Alt + =

• Ctrl + =

• Shift + =

•  Tab + =

Which function in Excel is used to count the number of cells in a range that contain numbers?

• COUNTA

• COUNTIF

• SUM

• AVERAGE

Which chart type in Excel is used to show the parts of a whole?

• Bar chart

• Line chart

• Pie chart

• Scatter chart

What is the function of the VLOOKUP function in Excel?

• To search for a value in a range of cells and return a corresponding value in the same row.

• To count the number of cells in a range that contain a specific value.

• To find the highest value in a range of cells.

• To calculate the average of a range of cells.

Which function in Excel is used to round a number to a specific number of decimal places?

• ROUND

• ROUNDUP

• ROUNDDOWN

• SUM