AS IT MCQ

Which of the following functions can be used to calculate the average of a set of numbers in Excel?

• AVERAGE()

• SUM()

• COUNT()

• IF()

What does the 'SUM' function in Excel do?

• Adds the numbers in a range of cells.

• Multiplies the numbers in a range of cells.

• Divides the numbers in a range of cells.

• Finds the maximum value in a range of cells.

Which of the following is the default file extension for Excel 2016 and later versions?

• .xlsx

• .xls

• .csv

• .xlsm

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

• COUNT()

• COUNTA()

• COUNTIF()

• COUNTBLANK()

In Excel, what does the formula =A1+B1*10 calculate?

• It adds the value of cell A1 to the result of multiplying B1 by 10.

• It adds 10 to the values in A1 and B1.

• It multiplies the values in A1 and B1 by 10.

• It multiplies the value of A1 by 10, then adds B1.

Which of the following is NOT a valid Excel function?

• VLOOKUP()

• HLOOKUP()

• LOOKUP()

• FINDLOOKUP()

What does the 'Freeze Panes' option do in Excel?

• Keeps specific rows or columns visible while scrolling through the rest of the worksheet.

• Hides selected rows or columns.

• Deletes rows or columns that are selected.

• Adds borders to the selected rows or columns.

Which of the following is used to combine text from multiple cells into one in Excel?

• CONCATENATE()

• SUM()

• LEFT()

• TRIM()

Which of the following functions is used to return the largest value in a range of cells in Excel?

• MAX()

• MIN()

• SUM()

• COUNT()

Which of the following is used to change the appearance of data in Excel?

• Format Cells

• Edit Cells

• Align Cells

• View Cells