CET 12th Level — MS Excel MCQs
Practice 20 free ms excel multiple choice questions for CET 12th Level exam. Instant answers with explanations in Hindi and English.
Master MS Excel under MS Office for CET 12th Level with our curated MCQ set. Every question follows real Rajasthan exam patterns. Switch between Hindi and English anytime.
CET 12th Level — MS Office — MS Excel
20 Questions • Instant results & explanations • Hindi & English
0 / 20
Question 1 of 20
To instantly insert the AutoSum mathematical formula without manually typing syntax, which exact keyboard shortcut is structurally utilized?
Question 2 of 20
In solving local land disputes, a Patwari utilizes MS Excel primarily to perform which specific analytical function?
Question 3 of 20
If a user wants to evaluate whether a student's marks are strictly greater than or equal to 33 and output "Pass" if true, and "Fail" if false, what is the syntactically correct formula using the IF function?
Question 4 of 20
How does the identification numbering of rows behave structurally within the two-dimensional framework of an MS Excel worksheet?
Question 5 of 20
To aggressively circumvent starting from scratch, which specific file extension acts as a master shell, safely storing pre-built structural layouts, advanced formatting, and standard organizational formulas?
Question 6 of 20
What is the structural consequence of opening a modern .xlsx file containing 500,000 rows of data in the legacy .xls Excel 97-2003 format?
Question 7 of 20
Match List-I with List-II concerning distinct MS Excel shortcuts and features, and select the correct answer using the code given below: List-I (Shortcut / Command) a. F4 Key b. Ctrl + 9 c. Ctrl + 0 d. Merge and Center List-II (Computational Function) 1. Erases internal structural boundaries to combine selected cells into a massive header block. 2. Commands the engine to collapse and hide selected vertical columns. 3. Acts as the master toggle to append or remove the '$' absolute anchoring operator. 4. Commands the engine to instantly hide currently selected horizontal rows.
Question 8 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 9 of 20
Consider a dataset containing the numerical values 10, -5, 0, and 50. If the MIN function is applied to this range, which specific value will it retrieve?
Question 10 of 20
Which of the following scenarios best demonstrates the intended practical deployment of the 'Subtotals' analytical feature?
Question 11 of 20
Which of the following actions constitutes 'Data Filtering' as opposed to 'Data Sorting'?
Question 12 of 20
Which of the following geometric descriptions best categorizes the fundamental structural layout of an MS Excel application?
Question 13 of 20
Which statement structurally defines the absolute boundaries natively hardcoded into a fully extended contemporary spreadsheet array?
Question 14 of 20
Which of the following describes the behavior of the .xltx file extension?
Question 15 of 20
Match List-I with List-II concerning Cell Referencing in MS Excel and select the correct answer using the code given below: List-I (Referencing State) a. Relative Referencing b. Absolute Referencing c. Mixed Referencing (Row Locked) d. Mixed Referencing (Column Locked) List-II (Example Notation) 1. A$1 2. $A1 3. A1 4. $A$1
Question 16 of 20
Which of the following is the strictly correct nomenclature in MS Excel to refer to a cell located at the exact intersection of column A and row 10?
Question 17 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 18 of 20
Match the targeted Grid Masking commands in List-I strictly to their explicitly mandated System Shortcuts in List-II. List-I (Grid Command) a. Hide the currently selected horizontal Rows from view b. Hide the currently selected vertical Columns from view c. Unhide the currently obscured horizontal Rows actively d. Unhide the currently obscured vertical Columns actively List-II (System Shortcut) 1. Ctrl + 0 2. Ctrl + Shift + 9 3. Ctrl + 9 4. Ctrl + Shift + 0
Question 19 of 20
What happens if a user applies a chronological Data Sort to a dataset containing dates?
Question 20 of 20
Which precise procedural action is accomplished when a user simultaneously presses the 'Ctrl + Z' keyboard combination within an active worksheet environment?
More MS Office Subtopics
Practice other subtopics under MS Office to strengthen your CET 12th Level preparation.