MCQ
Basic Computer: MS Excel Interface & Cells MCQ - Practice Questions with Answers
Solve 15 Basic Computer: MS Excel Interface & Cells questions for RAS/RPSC preparation.
Practice questions
Q1Match the MS Excel interface part with its main use. List I: I. Formula Bar II. Worksheet Tab III. Status Bar List II: a. Shows or edits the active cell's contents b. Switches between sheets in a workbook c. Shows quick information such as zoom and average
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.
Q2Which statement correctly describes a cell in an MS Excel worksheet?
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.
Q3In MS Excel, which part of the interface shows the address of the currently selected cell, such as B5?
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.
Q4Which one of the following statements about Excel cells is incorrect?
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.
Q5Match List I with List II. List I: I. Workbook II. Worksheet III. Cell IV. Range List II: 1. A file that can contain one or more worksheets 2. A grid made of rows and columns 3. The intersection of a row and a column 4. A group of selected cells
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.
You've seen 5 of 15 sample questions
Unlimited practice on Basic Computer: MS Excel Interface & Cells comes with the RAS Test Series + Practice pack or Gate Pass.
More questions
6Assertion (A): In Excel, a formula such as =A1+B1 uses the values stored in cells A1 and B1. Reason (R): A cell reference identifies a cell by combining its column letter and row number. Choose the correct answer.
7Which of the following is the correct example of an absolute cell reference in MS Excel?
8Statement I: In the reference A1, A identifies the column and 1 identifies the row. Statement II: In the reference $A$1, both the column and the row are fixed when the formula is copied. Which of the following is correct?
9Match the Excel interface item in List I with its usual function in List II. List I: I. Formula Bar II. Ribbon III. Sheet Tab List II: 1. Shows and edits the contents of the active cell 2. Switches between worksheets in a workbook 3. Displays grouped commands such as Home and Insert
10Consider the following statements about cells in MS Excel. Statement 1: The active cell is the cell in which typed data will be entered. Statement 2: The small square at the lower-right corner of the active cell is called the fill handle. Which of the above statements is/are correct?
11In MS Excel, which part of the interface shows the address of the active cell, such as B3 or D12?
12Assertion (A): The fill handle can be used to copy a formula from one Excel cell to adjacent cells. Reason (R): When a copied formula contains relative references, Excel adjusts those references according to the new position. Choose the correct answer.
13In MS Excel, which part of the worksheet interface displays the address of the currently selected cell, such as A1 or C7?
14Read the following assertion and reason about MS Excel cell addresses. Assertion (A): Cell B7 is located at the intersection of column B and row 7. Reason (R): In Excel, a normal cell address is written with the column letter first, followed by the row number. Choose the correct answer.
15Statement 1: In Excel, A1 is a relative cell reference. Statement 2: $A$1 is an absolute cell reference because both the column and the row are fixed. Which of the following is correct?