MS Excel MCQ Questions And Answers (Updated)

Part 2: MCQ on MS Excel Worksheets (Level: Moderate)

This section covers multiple choice questions on MS excel worksheet, cells, rows, columns, and related concepts. These questions are suitable for moderate users.

The intersection of a column and a row in MS Excel worksheet is known as _______

A. Row

B. Cell

C. Column

D. Tab

In Microsoft Excel spreadsheets, rows are labelled as _______

A. 1,2,3,…..

B. A,B,C,….

C. A1,B1,C1….

D. I,II,III,…..

In Microsoft Excel spreadsheets, COLUMNS are labelled as _______

A. 1,2,3,…..

B. A,B,C,….

C. A1,B1,C1….

D. I,II,III,…..

In Microsoft Excel spreadsheets, CELLS are labelled as _______

A. 1,2,3,…..

B. A,B,C,….

C. A1,B1,C1….

D. I,II,III,…..

___________ is a collection of cells organized in rows and columns where you keep and manipulate the data.

A. Workbook

B. Worksheet

C. Spreadsheet

D. ARRAY

Select correct statement

A. Each Excel workbook can contain multiple worksheets.

B. Each Excel worksheet can contain multiple workbooks.

C. Each Excel workbook can contain multiple spreadsheets.

D. Each Excel worksheet can contain multiple spreadsheets.