MS Excel — Set 1
Computers · MS Excel · Questions 1–10 of 80
What is the intersection of a row and a column in MS Excel called?
Correct Answer: A. Cell
A cell is the basic unit where data is entered in a spreadsheet. It is identified by the column letter and row number combined. Every worksheet contains millions of these individual units.
Which symbol must every formula in MS Excel begin with?
Correct Answer: D. =
The equal sign informs Excel that the succeeding characters constitute a mathematical expression. Without this symbol, the program treats the entry as plain text or a label. This is a fundamental rule for all versions of Excel.
What is the default file extension for a workbook created in MS Excel 2007 and later?
Correct Answer: D. .xlsx
The .xlsx format is based on the XML standard and is more efficient than older formats. It was introduced with the 2007 version to improve data recovery and file size. Older versions used the .xls extension as the standard.
Which bar displays the contents of the active cell in MS Excel?
Correct Answer: A. Formula Bar
The Formula Bar allows users to view and edit data or formulas present in a cell. It is located just above the column headers in the workspace. It displays the actual formula even if the cell shows only the result.
What is the maximum number of rows available in a single worksheet of MS Excel 2010?
Correct Answer: D. 1,048,576
Modern Excel worksheets contain exactly 1,048,576 rows to handle large datasets. This capacity was significantly increased from the 65,536 rows available in older versions. The row limit remains consistent across most recent versions.
Which feature is used to combine multiple cells into a single, larger cell?
Correct Answer: A. Merge & Center
Merge & Center is commonly used for creating titles that span across several columns. It creates one large cell from selected adjacent cells while centering the text. Only the data from the upper-left cell is kept after merging.
What is the shortcut key to open the 'Go To' dialog box in Excel?
Correct Answer: D. F5
The F5 key opens the 'Go To' menu to quickly navigate to a specific cell or named range. Alternatively, the Ctrl+G shortcut performs the same function. This helps in managing navigation within very large workbooks.
Which function in Excel is used to count the number of cells that contain numbers?
Correct Answer: A. COUNT
The COUNT function ignores text and logical values, focusing only on numeric entries. If you need to count all non-empty cells regardless of type, COUNTA is used. This helps in basic statistical analysis of data columns.
How are columns traditionally identified in an MS Excel worksheet?
Correct Answer: D. Letters (A, B, C...)
In Microsoft Excel, columns are traditionally identified using Letters (A, B, C...). The columns start from A and go up to Z, then continue as AA, AB... all the way to XFD, giving a total of 16,384 columns. Rows, on the other hand, are identified by numbers (1, 2, 3...) on the left side of the worksheet.
Which feature automatically adjusts a group of cells based on specific rules or criteria?
Correct Answer: A. Conditional Formatting
Conditional Formatting changes cell appearance, like color or font, based on its value. It helps in visually identifying trends or anomalies in a large set of data. Rules can be based on text, numbers, or dates.