MS Office MCQs for CET 12th Level
Practice MS Office under Computers for CET 12th Level with 20 free MCQs in Hindi and English.
CET 12th Level — MS Office
20 Questions • Instant results & explanations • Hindi & English
0 / 20
Question 1 of 20
When operating spreadsheet software like MS Excel, which of the following built-in functions does NOT perform a mathematical or statistical operation?
Question 2 of 20
Assertion (A): It is impossible to hold more than 30,000 characters in a single grid compartment. Reason (R): A single spreadsheet cell can independently accommodate a strict maximum of exactly 32,767 alphanumeric characters. Select the most appropriate analytical response:
Question 3 of 20
Which referencing variant is fundamentally established as a 'hybrid state' in the underlying mechanics of MS Excel?
Question 4 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 5 of 20
Assertion (A): It is physically and mathematically impossible to successfully enter 32,768 characters strictly confined inside a solitary modern spreadsheet cell architecture. Reason (R): Because a solitary cell is structurally engineered to independently accommodate a definitive absolute maximum limit of strictly 32,767 alphanumeric characters.
Question 6 of 20
Which specific architectural component handles the visual animation between sequential slides and confirms PowerPoint's functional divergence from MS Word?
Question 7 of 20
Which keyboard shortcut is utilized in Microsoft Word to immediately summon the Spelling and Grammar dialog box and initiate a sequential scan of the entire document?
Question 8 of 20
If a user wishes to replicate a highly specific combination of font type, 14-point size, blue color, and justified paragraph alignment to another location without copying the actual text, which tool is architecturally designed for this task?
Question 9 of 20
Match the specific File Extensions (List-I) to their fundamental internal architectures and functional capabilities (List-II): List-I a. .xltx b. .xlsm c. .xlsx d. .xlsb List-II I. Master template saving pre-built layout infrastructure. II. Default Open XML architecture strictly prohibiting executable macros. III. Highly compressed binary-coded architecture designed for massive enterprise speeds. IV. XML-based architecture explicitly permitting secure VBA macro execution. Choose the correct configuration:
Question 10 of 20
In the context of disaster management by state revenue officers, what specific Excel output is utilized?
Question 11 of 20
Which structural format utilizes horizontal bars, inherently acting as a column chart rotated by exactly 90 degrees to bypass the limitations of lengthy qualitative text strings?
Question 12 of 20
Which structural analysis tool automatically calculates intermediate figures and grand totals by physically inserting new summary rows into a list of pre-sorted data?
Question 13 of 20
Consider the following statements regarding the logical architectural sequence of administrative data processing: 1. The deployment of PivotTables, Goal Seek, and Subtotals immediately precedes the execution of Sorting and Filtering. 2. Generating visual charts (Line, Bar, Pie) is executed after applying conditional formatting but before typing formulas. Which of the statements given above is/are structurally correct?
Question 14 of 20
Assertion (A): Mastery of the 'Ctrl + G' shortcut enhances the physical efficiency of a typist operating within a large manuscript. Reason (R): Executing 'Ctrl + G' opens the Go To dialog box, commanding the software engine to rapidly jump the cursor to specific geometric coordinates like page or line numbers.
Question 15 of 20
Introduced as a major architectural enhancement in newer versions, which tool provides a highly visual, button-based graphical interface for filtering data and is particularly deployed alongside PivotTables?
Question 16 of 20
Which of the following functions is explicitly performed by the 'Format Painter' tool in MS Word?
Question 17 of 20
Which interface element is defined as a 'highly customizable, narrow strip' designed to provide instant access to critical functions?
Question 18 of 20
Which specific group within the Insert tab must an administrator access to generate a pre-formatted 'Cover Page' or force a hard 'Page Break'?
Question 19 of 20
The primary function of the Open command (Ctrl+O) is to:
Question 20 of 20