Excel MCQ Questions

Excel MCQ Questions

1-To print a sheet, we need to click on ___ tab.

(A) File

(B) Home

(C) Page layout

(D) Insert

 

2-Following is (are) the example(s) of ribbon tab.

(A) Home

(B) Insert

(C) Page layout

(D) All of the above

 

3-Page layout view displays

(A) the page in normal view

(B) pages exactly as they will appear when printed

(C) preview of where pages will break when printed

(D) none of the above

 

4-Maximum limit of rows

(A) 10, 28, 576

(B) 10, 38, 576

(C) 10, 48, 576

(D) 10, 58, 576

 

5-Maximum limit of columns is

(A) 16, 184

(B) 16, 284

(C) 16, 384

(D) 16, 484

 

6-Following displays the current status of the active cell in the worksheet.

(A) Row bar

(B) Column bar

(C) Status bar

(D) none of the above

 

7-Sheet properties include

(A) sheet size

(B) title

(C) categories

(D) all of the above

 

8-Press ___ to go to next column.

(A) Tab

(B) Enter

(C) Alt + Enter

(D) All of the above

 

9-Press ___ to go to next row.

(A) Tab

(B) Enter

(C) Alt + Enter

(D) All of the above

 

10-Press ___ to enter a new line in the same column.

(A) Tab

(B) Enter

(C) Alt + Enter

(D) All of the above

 

ANSWERS:

1-(A), 2-(D), 3-(B), 4-(C), 5-(C), 6-(C), 7-(D), 8-(A), 9-(B), 10-(C)