T4Tutorials .PK

Introduction to Excel and Its Interface MCQs

1. MS Excel is mainly used for:

(A) Word processing


(B) Creating presentations


(C) Calculations, data analysis, and charting


(D) Drawing graphics



2. By default, a new Excel workbook contains how many worksheets (in latest versions like Excel 2016+)?

(A) 1


(B) 3


(C) 5


(D) Unlimited



3. In Excel, the intersection of a row and a column is called:

(A) Field


(B) Cell


(C) Table


(D) Range



4. Each cell in Excel is identified by a unique address, which consists of:

(A) Row label only


(B) Column label only


(C) Column letter and row number


(D) Worksheet name



5. The file extension of an Excel workbook in modern versions (2007 and later) is:

(A) docx


(B) xlsx


(C) pptx


(D) accdb



6. Which bar in Excel displays the contents of the active cell?

(A) Menu Bar


(B) Status Bar


(C) Title Bar


(D) Formula Bar



7. What is the maximum number of rows in Excel 2016/2019/365?

(A) 1,048,576


(B) 65,536


(C) 104,857


(D) 1,000,000



8. What is the maximum number of columns in Excel 2016/2019/365?

(A) 256 (IV)


(B) 16,384 (XFD)


(C) 1,024 (AMJ)


(D) Unlimited



9. The group of tabs at the top of Excel window is called:

(A) Ribbon


(B) Menu Bar


(C) Toolbar


(D) Status Bar



10. Which of the following is NOT a component of Excel’s interface?

(A) Formula Bar


(B) Ribbon


(C) Worksheet Area


(D) Slide Master



Exit mobile version