Practice 20 free MS Excel questions under MS Office — Computers.
Strengthen your MS Excel knowledge for CET Graduate with curated MCQs. Switch between Hindi and English anytime.
CET Graduate — MS Office — MS Excel
20 Questions • Instant results & explanations • Hindi & English
0 / 20
Question 1 of 20
According to the administrative utility of PivotTables, which of the following operations can be accomplished without writing complex, manual formulas?
Question 2 of 20
What architectural action occurs dynamically when a user initially opens the MS Excel application to begin a new project?
Question 3 of 20
Upon transitioning to the Windows operating system in 1987, which specific early software competitor did MS Excel successfully establish absolute market dominance over?
Question 4 of 20
What is the primary purpose of applying 'conditional logic-based functions' in an administrative spreadsheet?
Question 5 of 20
What primary graphical and interactive enhancement significantly differentiates 'Slicers' from the standard, legacy 'AutoFilter' methodology?
Question 6 of 20
When configuring a highly layered algorithmic model, an analyst inserts 65 distinct 'IF' logical functions inside a single uninterrupted formula. What is the guaranteed architectural result of this precise action?
Question 7 of 20
A user inputs the following string into cell A1: `A1+B2*C3` without typing anything before the 'A'. What action will MS Excel execute?
Question 8 of 20
When utilizing the AVERAGE function, what two underlying arithmetic steps does the Excel engine automatically execute in sequence?
Question 9 of 20
What happens if a user applies a chronological Data Sort to a dataset containing dates?
Question 10 of 20
Consider the following statements regarding the structural grid of an MS Excel worksheet:
1. Columns are horizontal spaces identified chronologically by numerical digits.
2. Rows are vertical spaces strictly identified by alphabetical characters.
Which of the statements given above is/are correct?
Question 11 of 20
Which characteristic best describes MS Excel's foundational grid architecture?
Question 12 of 20
Which precise procedural action is accomplished when a user simultaneously presses the 'Ctrl + Z' keyboard combination within an active worksheet environment?
Question 13 of 20
Which procedural step is traditionally positioned at the very end of the logical architectural flowchart of administrative data management, following the generation of Line, Bar, and Pie Charts?
Question 14 of 20
Assertion (A): MS Excel is formally classified as a computational engine rather than a word processor.
Reason (R): It is engineered specifically for statistical analysis, mathematical modeling, and structured data storage rather than drafting continuous text.
Question 15 of 20
Regarding exact coordinate address mapping protocols, why would an administrative system definitively reject an address formatted exactly as '5C'?
Question 16 of 20
What is the exact functional placement of the 'Name Box' component within the graphical user interface of a spreadsheet application?
Question 17 of 20
Which of the following functions strictly evaluates a Boolean premise—such as whether a cell value exceeds a specified limit—to dictate mutually exclusive logical outputs?
Question 18 of 20
Assertion (A): Copying formula '=A1' downward by one row automatically updates it to '=A2' under default Excel mechanics.
Reason (R): The default operational mode in Excel is Relative Referencing, which shifts row and column addresses dynamically relative to their new spatial location.
Question 19 of 20
Which specific referencing notation guarantees that a cell formula remains perfectly static and permanently unchanged, irrespective of where the user pastes it geographically on the grid?
Question 20 of 20
What traditional physical tool does Microsoft Excel fundamentally act as a digital simulation of?
