MS Excel MCQs for CET 12th Level
Practice 20 free MS Excel questions under MS Office — Computers.
Strengthen your MS Excel knowledge for CET 12th Level with curated MCQs. 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
Which specific referencing hybrid state utilizes formatting such as 'A$1' or '$A1'?
Question 2 of 20
What is the specific numeric identifier assigned to the absolute final column boundary in a fully expanded modern worksheet, immediately correlating to the alphanumeric label 'XFD'?
Question 3 of 20
Assertion (A): Data Filtering temporarily hides rows of data that do not satisfy a specific condition without permanently deleting them. Reason (R): Data Filtering is explicitly designed to physically rearrange the entire visual dataset into an alphabetical or chronological sequence.
Question 4 of 20
Consider the following statements regarding a specific file format: 1. It is natively utilized for electronic spreadsheet operations. 2. It replaces older, outdated extensions like .doc. 3. It orchestrates a rigid grid of interconnecting rows and columns. Which statements accurately describe the .xlsx format?
Question 5 of 20
Which of the following represents a 'Mixed Referencing' state where the column is strictly locked but the row remains relative?
Question 6 of 20
According to the default typographic and structural rules of spreadsheet engines, how are distinct categories of raw data inherently aligned upon initial entry?
Question 7 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 8 of 20
What explicitly dictates the geometric visual presentation boundary of miniature, high-fidelity data charts known specifically as 'Sparklines'?
Question 9 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 10 of 20
Identify the incorrect statement regarding the Scatter Chart.
Question 11 of 20
Assertion (A): Each worksheet in MS Excel operates as an entirely isolated canvas that cannot interact with other sheets. Reason (R): Excel utilizes advanced 3D referencing formulas to deeply link data across multiple independent worksheets.
Question 12 of 20
Assertion (A): Filtering data physically rearranges entire rows into an ordered A-to-Z hierarchical sequence to uncover patterns. Reason (R): Sorting is defined as an exclusionary mechanism that hides distinct rows failing to meet exact logical criteria.
Question 13 of 20
What is the highest structural level of organization within an MS Excel file that fundamentally acts as a binder?
Question 14 of 20
Assertion (A): Formatting a raw numerical value of 1.50 into a stylized currency display ($1.50) structurally modifies the underlying computational weight of the cell for subsequent arithmetic operations. Reason (R): Data formatting mechanisms alter the visual representation and aesthetic display of data without fundamentally altering its underlying core mathematical value stored in memory.
Question 15 of 20
Given below are two statements: Statement (I): The .xls format strictly prohibits the saving of executable macros to ensure cybersecurity. Statement (II): The .xlsx format introduced comprehensively in Excel 2007 natively supports the expanded 1-million-row limit. Choose the most appropriate answer from the options given below.
Question 16 of 20
Which statement categorically distinguishes the functional nature of 'Sparklines' from legacy formatting modifications?
Question 17 of 20
Which capability of MS Excel enables revenue officers to instantly execute arithmetic operations across thousands of data points without manual calculation?
Question 18 of 20
Statement I: The COUNTIF function is considered a standard basic function that counts all cells regardless of content. Statement II: The COUNTIF function acts as an advanced conditional statistical function that strictly tallies only cells meeting a single user-specified logical criterion. Based on the above statements, choose the most appropriate answer:
Question 19 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 20 of 20