MS Excel
39 questions available
FILTER BY SUBTOPIC
Q1.Getting data from a cell located in a different Excel Sheet is called?
Correct Answer: B
Referencing means referring to or retrieving data from another cell or worksheet. In Excel, a reference to another sheet can be written as =Sheet2!A1. This allows data from one worksheet to be used in another worksheet. It is especially useful for linking related data across multiple sheets. There are Three types of Cell reference in Excel: Relative, Absolute, and Mixed.
Q2.When using "Fill Handle" option in MS-Excel, adding "Jan" in a cell and dragging the cursor towards adjacent cells creates what cell contents?
Correct Answer: A
Excel's Fill Handle recognizes common series such as months. When Jan is entered and the Fill Handle is dragged, Excel automatically continues the series. The resulting cells will contain Jan, Feb, Mar, Apr, ... This feature saves time when creating sequential data.
Q3.What is the standard application behavior in MS-Excel when numbers are entered in cells for calculations?
Correct Answer: B
In MS Excel, numbers are right-aligned automatically by default. Text is generally left-aligned automatically. Right alignment makes numerical values easier to compare and calculate. Users can change the alignment using the Alignment options.
Q4.Which sign is used to create an absolute cell reference in MS Excel?
Correct Answer: C
The dollar sign ($) is prepended to column letters and row numbers (e.g., $A$1) to create absolute cell references in MS Excel formulas.
Q5.The thin black cross-shaped pointer in MS Excel is used to _____?
Correct Answer: C
The small black cross cursor (the Fill Handle pointer) at the bottom-right corner of a cell is used to copy formulas or extend data patterns automatically.
Q6.In MS Excel, comments put in the cell are called?
Correct Answer: D
Cell Tips are comments or notes placed in an Excel cell to provide additional information, helping users understand or explain the data entered.
Q7.B2:B6 in MS Excel represents the ______?
Correct Answer: A
B2:B6 represents a cell range from cell B2 to B6. A colon (:) is the range operator in Excel.
Q8.Define a name for a cell or a range in Excel provides a ______ reference to that cell or reference.
Correct Answer: A
Defining a name for a cell or range acts as an absolute reference to those cells.
Q9.In MS Excel, if B3 ids the address of a cell then B is it's _____?
Correct Answer: B
Letters (like B) represent columns, while numbers (like 3) represent rows. So B is the column identifier.
Q10.Which Excel feature allows creating dynamic drop-down lists based on cell values?
Correct Answer: A
Data Validation can restrict entries in a cell and is commonly used to create drop-down lists from a range of cell values.
Q11.Combining two or more cells into a single cell in Excel or Word is called _____?
Correct Answer: B
Merging cells is the function used to combine multiple adjacent cells into one large cell.
Q12.The first cell in EXCEL worksheet is labeled as ____?
Correct Answer: C
The first cell in an Excel grid lies at the intersection of column A and row 1, and is labeled A1.
Q13.What is a cell in MS Excel?
Correct Answer: B
An Excel cell represents the rectangular intersection of a single vertical column and a single horizontal row on a worksheet.
Q14.Which tab helps rearrange data in MS Excel?
Correct Answer: A
The Data tab in MS Excel contains the Sort and Filter tools used to rearrange and organize data.
Q15.When is an active Smart Tag automatically removed from a cell in Microsoft Excel?
Correct Answer: B
Excel automatically deletes or clears a smart tag associated with a cell once the original data triggering that tag is modified or erased.
Q16.Which of the following represents a valid absolute cell reference in Microsoft Excel?
Correct Answer: A
An absolute reference uses dollar signs before both the column letter and row number (e.g., $A$1) to lock the cell coordinate.
Q17.In spreadsheet applications like Excel, how is an individual cell defined?
Correct Answer: A
A cell is the basic storage coordinate in a spreadsheet, formed by the intersection of a horizontal row and a vertical column.
Q18.Move to the next cell in the row in MS Excel _____?
Correct Answer: A
Pressing the Tab key moves the cursor horizontally to the next cell in the active row.
Q19.In an MS Excel sheet, how is the active cell visually indicated?
Correct Answer: B
The active, currently selected cell in an Excel worksheet is bounded by a thick, dark green/black border.
Q20.To fix a cell reference in Microsoft Excel so that it remains constant when copied, we use which type of reference?
Correct Answer: C
An Absolute Cell Reference uses dollar signs ($A$1) to freeze row and column coordinates, preventing them from shifting when copied.