MS Office MCQs for CET Graduate
Practice MS Office under Computers for CET Graduate with 20 free MCQs in Hindi and English.
CET Graduate — MS Office
20 Questions • Instant results & explanations • Hindi & English
0 / 20
Question 1 of 20
What is the primary conceptual distinction between a Hyperlink and an Action Button within a presentation framework?
Question 2 of 20
Assertion (A): The Quick Access Toolbar (QAT) bypasses the necessity to navigate the Ribbon interface. Reason (R): It is designed to provide instant, single-click access to the Save, Undo, and Redo commands regardless of which Ribbon tab is active. Select the correct answer:
Question 3 of 20
Which of the following accurately describes the precise limitation associated with 'Maximum Characters per Cell' across succeeding spreadsheet software generations?
Question 4 of 20
Consider the following statements regarding typographical sizing controls in word processing: 1. The command 'Ctrl + ]' increments the font size by exactly one point per keystroke. 2. 'Ctrl + Shift + >' enlarges the font size strictly according to the predefined standard increments in the size menu. 3. 'Ctrl + Shift + <' decreases the font size by exactly two points regardless of the current size. Which of the statements given above is/are correct?
Question 5 of 20
What is the absolute unyielding structural condition mandated to securely retain automated programming languages (VBA scripts) inside a contemporary workbook framework over extended timeframes?
Question 6 of 20
Consider the supplementary logical operators AND and OR in MS Excel. Which of the following statements is fundamentally correct regarding their operational requirements?
Question 7 of 20
Which keyboard shortcut is used to align text flush against the left margin?
Question 8 of 20
What is the primary operational purpose of the 'Slide Sorter View' in Microsoft PowerPoint?
Question 9 of 20
What is the specific typographical symbol that is heavily utilized to construct a totally locked, absolute cell reference (e.g., locking geographic shifting during formula drags)?
Question 10 of 20
During the final execution phase (Step 6) of a Mail Merge, a user opts to disseminate the output electronically rather than generating a printable file. Which integrated Microsoft application is strictly utilized by the software to send these mass messages directly?
Question 11 of 20
Assertion (A): The alphabetical nomenclature for columns in MS Excel eventually transitions into a triple sequence (e.g., AAA, AAB). Reason (R): The standard single letters (A-Z) and paired letters (AA-ZZ) represent finite sets that must be exhausted to accommodate massive, extensive data grids.
Question 12 of 20
Which statement categorically distinguishes the functional nature of 'Sparklines' from legacy formatting modifications?
Question 13 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 14 of 20
If you wish to open an existing document file from your computer's storage drive using a shortcut, which combination is correct?
Question 15 of 20
Which of the following describes the behavior of the .xltx file extension?
Question 16 of 20
The operation of the 'Rehearse Timings' tool is definitively described as 'silent' primarily because it deliberately omits the recording of:
Question 17 of 20
If an administrator needs to reorder an entire visual dataset alphabetically from A to Z, which precise MS Excel feature must they utilize?
Question 18 of 20
Match List-I with List-II regarding Microsoft Word tools and concepts: List-I a. F7 b. Shift + F7 c. Data Source d. Boilerplate Text List-II 1. External database containing variable info 2. Scans entire document sequentially for errors 3. Static text identical across outputs 4. Provides instant access to synonyms and antonyms Choose the correct code:
Question 19 of 20
How does the Reading View functionally differ from the Slide Show View while previewing a presentation?
Question 20 of 20