MS Excel MCQs

Which file extension is used for Excel workbooks?

• .xls

• .xlsx

• .csv

• .docx

What is the function used to calculate the sum of a range in Excel?

• SUM

• TOTAL

• ADD

• COUNT

What does the COUNT function do in Excel?

• Counts all cells

• Counts only numeric values

• Counts empty cells

• Counts characters in a cell

Which function returns the largest number in a given set of values?

• LARGE

• MAXIMUM

• MAX

• BIGGEST

Which function rounds a number down to the nearest integer?

• ROUND

• CEILING

• ROUNDDOWN

• FLOOR

What is the shortcut to create a new workbook in Excel?

• Ctrl + N

• Ctrl + W

• Ctrl + O

• Ctrl + Shift + N

What is the shortcut for AutoSum in Excel?

• Ctrl + S

• Alt + =

• Shift + A

• Ctrl + Alt + S

Which key allows you to edit the content of a cell?

• F1

• F2

• F3

• F4

How can you remove all formatting in a cell?

• Delete the cell

• Use the Clear Formats option

• Press Ctrl + R

• Apply a new format

What does the Filter function do in Excel?

• Applies a filter to the dataset

• Removes all blank rows

• Sorts data

• Deletes duplicate values