Top 550+ Solved Microsoft Excel (MS Excel) MCQ Questions Answer
Q. An Excel Workbook is a collection of …….
a. Workbooks
b. Worksheets
c. Charts
d. Worksheets and Charts
Q. What do you mean by a Workspace?
a. Group of Columns
b. Group of Worksheets
c. Group of Rows
d. Group of Workbooks
Q. In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
a. AutoFill
b. Auto correct
c. Auto sum
d. Auto format
Q. To select an entire column in MS-EXCEL, press?
a. CTRL + C
b. CTRL + Arrow key
c. CTRL + S
d. None of the above
Q. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
a. ROUND ( )
b. FACT ( )
c. MOD ( )
d. DIV ( )
Q. Which is not the function of “Edit, Clear” command?
a. Delete contents
b. Delete notes
c. Delete cells
d. Delete formats
Q. Microsoft Excel is a powerful………..
a. Word processing package
b. Spreadsheet package
c. Communication S/W Package
d. DBMS package
Q. How do you rearrange the data in ascending or descending order?
a. Data, Sort
b. Data, Form
c. Data, Table
d. Data Subtotals
Q. How do you display current date and time in MS Excel?
a. date ()
b. Today ()
c. now ()
d. time ()
Q. How do you wrap the text in a cell?
a. Format, cells, font
b. Format, cells, protection
c. format, cells, number
d. Format, cells, alignment
Q. What does COUNTA () function do?
a. counts cells having alphabets
b. counts empty cells
c. counts cells having number
d. counts non-empty cells