T4Tutorials .PK

MS OFFICE (MS-EXCEL) MCQs

1. . MS-Excel is also called as:

(A) System Software


(B) Spread Sheet Software


(C) Hardware


(D) Software




2. . In MS-Excel, number of columns:

(A) 32


(B) 256


(C) 512


(D) 65535




3. . In MS-Excel, which key is used to edit data in a cell?

(A) Shift + F2


(B) Arrow keys


(C) F2


(D) Alt + F4




4. . Formula can be started in MS-Excel through:

(A) F2


(B) +


(C) =


(D)




5. . In MS-Excel total number of rows are:

(A) 65535


(B) 65536


(C) 65534


(D) 65535




6. . What is the intersection of a column and a row on a worksheet called?

(A) Column


(B) Value


(C) Address


(D) Cell




7. . Statistical calculations and preparation of tables and graphs can be done using:

(A) Adobe Photoshop


(B) Excel


(C) Notepad


(D) Power Point




8. . Functions in MS-Excel must begin with:

(A) ( ) sign


(B) Equal Sign


(C) Plus Sign


(D) > Sign




9. . The process of arranging the items of a column in some sequence or order is known as:

(A) Arranging


(B) Auto fill


(C) Sorting


(D) Filtering




10. . The feature of MS-Excel that quickly completes a series of data is:

(A) Auto Complete


(B) Auto Fill


(C) Fill Handle


(D) All




11. . It is a chart in MS-Excel:

(A) Line Chart


(B) Column Chart


(C) Area Chart


(D) All




12. . A new line can be entered in an active cell of MS-Excel by using:

(A) Shift + F3


(B) Ctrl + N


(C) Alt + Enter


(D) F5




13. . Auto Sum is represented by:

(A) ≤


(B) ∑


(C) Ω


(D) √




14. . An inactive cell can be made active by using key:

(A) F8


(B) F6


(C) F10


(D) All




15. . Excel files are called:

(A) Work Book


(B) Work Sheets


(C) Spreadsheet


(D) All




Exit mobile version