Basic Computer: MS Excel Interface & Cells MCQ — 15 Practice Questions with Answers

Explanation

The Formula Bar is used to view or edit what is inside the active cell, including text, numbers and formulae. Worksheet tabs appear at the bottom and let the user move between sheets in the same workbook. The Status Bar gives quick information such as view mode, zoom and simple calculations for selected cells. So the correct matching is Formula Bar with cell contents, Worksheet Tab with sheet switching, and Status Bar with quick status information.

Explanation

An Excel worksheet is a grid made of rows and columns. A cell is the small rectangular box created where one row and one column intersect. For example, cell B3 lies where column B meets row 3. The question asks for the correct description of a cell, so the key idea is intersection. The other options confuse a cell with a workbook, a row or a column. Hence, the correct statement is that a cell is formed at the intersection of a row and a column.

Explanation

The Name Box is the small box to the left of the Formula Bar in Excel. It shows the address or name of the active cell, so if cell B5 is selected, B5 appears there. The cue in the question is the phrase "address of the currently selected cell". The Formula Bar is close to it, but its main work is to show or edit the cell contents. Therefore, the correct interface part is the Name Box.

Explanation

Excel identifies columns with letters such as A, B and C, while rows are identified with numbers such as 1, 2 and 3. The incorrect statement reverses this arrangement by saying that row headings use letters and column headings use numbers. The other options are standard facts: a cell address combines column and row, the Formula Bar shows active-cell content, and A1:C3 is a range. Since the question asks for the incorrect statement, option C is the answer.

Explanation

A workbook is the Excel file; it may contain one worksheet or many worksheets. A worksheet is the sheet-like grid made of rows and columns. A cell is one small box formed where a row and a column meet, such as C6. A range is a group of cells selected or referred to together, such as A1:B5. The exact matches are therefore Workbook-1, Worksheet-2, Cell-3 and Range-4. Option A gives this complete sequence.