MS Excel — Set 1

Correct Answer: A. Cell

• **Cell** = the smallest addressable unit in a spreadsheet, formed where one row and one column cross; every piece of data — a number, text, or formula — lives inside a cell and is identified by its column letter + row number (e.g., B3). • **Key fact** — a modern Excel worksheet contains 17,179,869,184 individual cells (16,384 columns × 1,048,576 rows), yet only one cell is "active" at a time, shown by a green border. • Cells can hold raw values or formulas; when a formula is entered, the cell displays the computed result while the formula bar shows the actual expression. • 💡 Option B (Block) is wrong because "block" is not an Excel term — it is informal slang with no defined meaning in Excel; Option C (Grid) is wrong because the grid refers to the entire network of lines forming the worksheet, not any single intersection point; Option D (Range) is wrong because a range is a group of two or more cells selected together, such as A1:C5.

Correct Answer: D. =

• **Equal sign (=)** = the mandatory prefix that signals to Excel that the cell entry is a formula, not plain text; without it, typing SUM(A1:A5) is stored literally as the word "SUM(A1:A5)" and never calculated. • **Key fact** — the = sign was chosen because it mirrors standard mathematical notation; Excel evaluates everything to the right of it as an expression and displays only the final result in the cell. • Some older Lotus 1-2-3 habits led users to start with +, and Excel still accepts + as an alternative, but = is the official standard recognized across all spreadsheet software. • 💡 Option A (+) is wrong because while Excel may accept + as a legacy alternative, it is not the designated standard starting symbol and can cause confusion with text entries; Option B (@) is wrong because @ was used in Lotus 1-2-3, not in Excel, and typing it in Excel starts a function suggestion only in newer versions but is not a formula prefix; Option C (#) is wrong because # appears in Excel only as part of error codes like #REF! or #DIV/0!, not as a formula initiator.

Correct Answer: D. .xlsx

• **.xlsx** = the default Open XML workbook format introduced with Excel 2007; it stores data as compressed XML files inside a ZIP container, making files smaller and more recoverable than the old binary .xls format. • **Key fact** — .xlsx deliberately does NOT support macros; if a workbook contains VBA macros and is saved as .xlsx, Excel strips the macros and warns the user, because macro-enabled workbooks must use .xlsm instead. • The shift from .xls to .xlsx was part of Microsoft's move to the Office Open XML standard, which is now an ISO-certified international standard (ISO/IEC 29500). • 💡 Option A (.xls) is wrong because .xls is the legacy binary format used by Excel 97–2003, not the default for Excel 2007 and later; Option B (.xltx) is wrong because .xltx is the extension for Excel template files, not regular workbooks; Option C (.xlsm) is wrong because .xlsm is reserved for macro-enabled workbooks that contain VBA code, not ordinary workbooks.

Correct Answer: A. Formula Bar

• **Formula Bar** = the long input box located just above the column headers; it always shows the raw content of the active cell — the actual formula text if a formula is present, or the exact value if plain data is entered. • **Key fact** — when a cell displays a formatted number like "₹1,000.00", the Formula Bar reveals the true underlying value (e.g., 1000), making it essential for verifying data without formatting interference. • The Formula Bar also contains the Name Box on its left, which shows the address (e.g., A1) of the active cell and allows direct navigation by typing a cell address. • 💡 Option B (Status Bar) is wrong because the Status Bar runs along the bottom of the Excel window and shows aggregate information like sum/average of selected cells, not the cell's own content; Option C (Menu Bar) is wrong because the Menu Bar (or Ribbon in modern Excel) holds command groups like Home and Insert, not cell content; Option D (Tool Bar) is wrong because toolbars contain button shortcuts for commands and do not display cell data.

Correct Answer: D. 1,048,576

• **1,048,576 rows** = the exact row limit per worksheet in Excel 2007 and all later versions including 2010; this number equals 2²⁰ and was a deliberate power-of-two design choice to align with binary memory addressing. • **Key fact** — this was a 16× increase over the previous 65,536-row limit of Excel 2003 (.xls), introduced specifically to handle large enterprise datasets that had outgrown older worksheets. • Combined with 16,384 columns (XFD), a single Excel 2010 worksheet can hold over 17 billion cells, though performance degrades well before that limit is reached in practice. • 💡 Option A (65,536) is wrong because 65,536 was the row limit of Excel 2003 and earlier versions, not Excel 2010; Option B (16,384) is wrong because 16,384 is the column limit, not the row limit, in modern Excel; Option C (256) is wrong because 256 was the column limit in Excel 2003 and earlier, not a row count in any Excel version.

Correct Answer: A. Merge & Center

• **Merge & Center** = a formatting command that physically joins two or more adjacent cells into one single cell and simultaneously aligns the content to the center; it is accessed via Home tab → Alignment group. • **Key fact** — merging is destructive: only the data in the upper-left cell of the selection is retained after merging; all other cells in the selection are cleared without warning, so users must move data first. • Excel provides three merge variants — Merge & Center, Merge Across (merges row by row), and Merge Cells (merges without centering) — to suit different layout needs. • 💡 Option B (Conditional Formatting) is wrong because Conditional Formatting changes a cell's visual appearance (color, font, icon) based on its value — it does not join cells together; Option C (Wrap Text) is wrong because Wrap Text makes long text visible by increasing row height, not by combining cells; Option D (Format Painter) is wrong because Format Painter copies the formatting style of one cell and applies it to another — it has no merging capability.

Correct Answer: D. F5

• **F5** = the keyboard shortcut that instantly opens the Go To dialog box in Excel, allowing the user to jump to any cell address or named range by typing it directly, which is far faster than scrolling through large worksheets. • **Key fact** — the Go To dialog also powers the Go To Special command (Ctrl+G → Special), which selects specific types of cells such as blanks, formulas, or cells with errors — a critical tool for data auditing. • Ctrl+G is an alternative shortcut that opens the same Go To dialog, giving users two ways to invoke this navigation feature. • 💡 Option A (F2) is wrong because F2 places the cursor inside the active cell for editing — it does not open any navigation dialog; Option B (F11) is wrong because F11 creates a new chart sheet from the selected data — it has nothing to do with navigation; Option C (F7) is wrong because F7 opens the Spelling & Grammar checker, not the Go To dialog.

Correct Answer: A. COUNT

• **COUNT** = a statistical function that scans a range and returns the total number of cells containing numeric values only; it deliberately skips text, logical values (TRUE/FALSE), and empty cells, making it ideal for counting data entries in numerical columns. • **Key fact** — COUNT is often confused with COUNTA; the difference is that COUNTA counts every non-empty cell regardless of data type, while COUNT counts only cells with numbers — a critical distinction when mixed data exists. • The syntax is =COUNT(value1, [value2], ...) and it can span multiple non-contiguous ranges in a single formula, e.g., =COUNT(A1:A10, C1:C10). • 💡 Option B (COUNTBLANK) is wrong because COUNTBLANK counts the number of empty cells in a range — the opposite of what COUNT does; Option C (COUNTA) is wrong because COUNTA counts all non-empty cells including text, dates, and errors, not just numeric cells; Option D (SUM) is wrong because SUM adds up the numeric values in a range and returns their total — it does not count how many cells have numbers.

Correct Answer: D. Letters (A, B, C...)

• **Letters (A, B, C...)** = the column identification system used in every Excel worksheet; columns proceed alphabetically from A to Z (26 columns), then AA to AZ (26 more), continuing through BA, BB... all the way to XFD, totaling 16,384 columns. • **Key fact** — the column letter and row number together form a cell address (e.g., C7 means column C, row 7); this two-coordinate system is called A1 reference style and is the foundation of all formula writing in Excel. • Excel also supports the R1C1 reference style where both rows and columns are numbered (R3C2 = row 3, column 2), which is useful for macro writing but not the default user-facing display. • 💡 Option A (Numbers 1, 2, 3...) is wrong because numbers are used to identify rows (running down the left side), not columns; Option B (Symbols) is wrong because Excel uses no symbols like *, %, or # to label columns — this option describes nothing in the Excel interface; Option C (Roman Numerals) is wrong because Roman numerals (I, II, III...) are not used anywhere in standard Excel column or row labeling.

Correct Answer: A. Conditional Formatting

• **Conditional Formatting** = a feature that automatically changes a cell's visual appearance — fill color, font color, borders, or icon sets — whenever its value meets a user-defined rule, such as "highlight cells greater than 100 in red". • **Key fact** — Conditional Formatting is purely cosmetic; it changes how data looks without altering the actual cell value, so formulas and calculations are unaffected even when formatting rules are active. • Excel provides built-in rule presets (Data Bars, Color Scales, Icon Sets) as well as custom formula-based rules, allowing sophisticated visual dashboards without any programming. • 💡 Option B (AutoSum) is wrong because AutoSum automatically inserts a SUM formula to add adjacent numbers — it performs a calculation, not visual formatting based on rules; Option C (Data Validation) is wrong because Data Validation restricts what data a user can enter into a cell — it controls input, not appearance; Option D (Pivot Table) is wrong because a Pivot Table reorganizes and summarizes data into a new table — it is an analysis tool, not a formatting feature.