MS Excel MCQs for LDC
Practice 20 free MS Excel questions under MS Office — Computers.
Strengthen your MS Excel knowledge for LDC with curated MCQs. Switch between Hindi and English anytime.
LDC — MS Office — MS Excel
20 Questions • Instant results & explanations • Hindi & English
0 / 20
Question 1 of 20
Which of the following actions constitutes 'Data Filtering' as opposed to 'Data Sorting'?
Question 2 of 20
Which specific defensive architectural protocol ensures that older legacy spreadsheet applications do not experience immediate catastrophic failure and data corruption when attempting to process the vast dimensions of a modern XML grid?
Question 3 of 20
What architectural action occurs dynamically when a user initially opens the MS Excel application to begin a new project?
Question 4 of 20
Within the architectural syntax of the IF function `=IF(logical_test, value_if_true, value_if_false)`, what immediate action does the software take if the evaluated logical test results in a FALSE boolean?
Question 5 of 20
Match List-I with List-II: List-I (Action) a. Open an existing workbook b. Create a new workbook c. Save active workbook d. Open 'Save As' box List-II (Shortcut) I. F12 II. Ctrl+O III. Ctrl+N IV. Ctrl+S
Question 6 of 20
Match the explicit Typographical Format Commands in List-I categorically directly to their precise mapped Operational Shortcuts established universally in List-II. List-I (Formatting Commands) a. Instantly summon the massive "Format Cells" dialog matrix b. Strip away or decisively apply slanting Italic aesthetic formatting c. Modify text actively inside the cell bounds entirely ignoring top-bars d. Add intense structural Bold formatting character weights List-II (Operational Shortcuts) 1. Ctrl + B 2. Ctrl + I 3. F2 4. Ctrl + 1
Question 7 of 20
Which of the following is NOT a formal administrative responsibility of a Patwari that necessitates the extensive daily use of MS Excel?
Question 8 of 20
When dragging a formula downwards across rows using the Fill Handle, what does Excel do with Relative Cell References contained within that formula?
Question 9 of 20
Which of the following is an accurate definition of the .csv file format?
Question 10 of 20
If a data analyst explicitly needs to count only those cells within a specific grid range that contain valid numerical digits, which exact function must be executed?
Question 11 of 20
Which of the following procedural descriptions incorrectly identifies the outcome of a core system command?
Question 12 of 20
Read the following statements: I. Sorting data alphabetically rearranges it from A to Z or Z to A. II. Nested custom sorting allows a user to categorize by 'District' first, and subsequently sort by 'Population' numerically within that specific district. Which of the statement(s) is/are correct?
Question 13 of 20
What is the exact mathematical starting point of the chronological sequence used strictly to identify rows in MS Excel?
Question 14 of 20
Assertion (A): The COUNT function is a universal tallying tool that counts every single non-empty cell in a specified range. Reason (R): The COUNT function is strictly programmed to ignore entirely blank cells, textual strings, and error values, counting only cells that contain numerical data.
Question 15 of 20
Identify the file format that utilizes an Extensible Markup Language (Open XML) architecture and natively prohibits the saving of executable macros to safeguard computer systems.
Question 16 of 20
Consider the following statements regarding the architectural limits and frameworks of spreadsheet grids: 1. The Extensible Markup Language (XML) format expanded the row limit to over 1 million rows. 2. Opening a modern .xlsx file in the Excel 2003 version expands the older software's RAM capacity to 2 GB. 3. The legacy .xls format was constrained by an aging binary architecture. Which of the statements given above is/are correct?
Question 17 of 20
Assertion (A): Mathematical equations utilizing operators like addition (+) and subtraction (-) are categorized as predefined Functions in MS Excel. Reason (R): Functions inherently contain an equal sign, a specific function name, and arguments wrapped in parentheses.
Question 18 of 20
In MS Excel formulas, which specific arithmetic operator is rigidly assigned to execute the mathematical operation of division?
Question 19 of 20
Match the specific mathematical or structural characteristics (List-I) with their corresponding Chart Types (List-II): List-I a. A highly complex, 3-dimensional topological map. b. Individual, disconnected points plotted on intersecting X and Y axes. List-II I. Line Chart II. Surface Chart III. Scatter Chart IV. Area Chart Choose the correct alignment:
Question 20 of 20