Tayari24

CET Graduate — MS Excel MCQs

Practice 20 free ms excel multiple choice questions for CET Graduate exam. Instant answers with explanations in Hindi and English.

Master MS Excel under MS Office for CET Graduate with our curated MCQ set. Every question follows real Rajasthan exam patterns. 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

Which precise visual indicator is universally employed by spreadsheet software to clearly distinguish the 'Active Cell' from the rest of the grid?

Question 2 of 20

A cell requires a lookup mechanism to search vertically for a specific employee ID number in the leftmost column of a massive personnel database table. Which enterprise function is predominantly used for this specific action?

Question 3 of 20

Given below are two statements, one labeled as Assertion (A) and the other as Reason (R): Assertion (A): The standard modern Open XML format (.xlsx) inherently disables and prohibits the automated execution of highly complex VBA macro scripts. Reason (R): Executable Visual Basic for Applications (VBA) scripts bypass system safeguards to automate intense mathematical workloads, making them exceptionally potent vectors for malicious cybersecurity threats if not strictly isolated into specialized formats like .xlsm. Select the accurate logical deduction:

Question 4 of 20

To rapidly cycle sequentially between relative, absolute, and mixed cell referencing states while directly editing a formula, which dedicated keyboard shortcut must a user press?

Question 5 of 20

Which specific geometric formatting feature prevents an exceptionally long alphanumeric string from visually bleeding over the horizontal boundary into adjacent empty columns without modifying font size?

Question 6 of 20

If an administrator wishes to filter a massive dataset visually and efficiently through a dynamic button-based graphical dashboard rather than sifting through column drop-down menus, what tool should they utilize?

Question 7 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 8 of 20

What fundamental error occurs if an MS Excel user completely omits the equal sign (=) when typing a custom formula like `A1+B2`?

Question 9 of 20

When an administrator applies the standard 'AutoFilter' protocol to a database, what specific visual element is systematically placed on every column heading to facilitate user interaction?

Question 10 of 20

Which of the following is an accurate definition of the .csv file format?

Question 11 of 20

Consider the following statements regarding MS Excel keyboard shortcuts: 1. Ctrl + 9 instantly hides the currently selected vertical columns. 2. Ctrl + 0 instantly hides the currently selected horizontal rows. 3. The F4 key rapidly cycles sequentially through relative, absolute, and mixed cell reference states. Which of the statements given above is/are strictly correct?

Question 12 of 20

If an administrative analyst clearly knows the final desired outcome of a mathematical calculation but is entirely unsure of the exact initial input variable required to achieve that specific outcome, which specialized computational tool should be deployed?

Question 13 of 20

What is the primary function of Microsoft Word as a software application?

Question 14 of 20

Match the Advanced Structural Limitations listed in List-I strictly to their definitive numeric caps explicitly programmed into modern calculation architectures provided in List-II. List-I (Architectural Limit) a. Absolute maximum depth of mathematically independent horizontal rows b. Uncompromising maximum nested IF logical functions housed continuously c. Total maximum character volume independently accommodated within a single cell d. Final sequential alphabet identifier denoting the 16,384th vertical column List-II (Numeric Cap / Value) 1. 64 2. XFD 3. 32,767 4. 1,048,576

Question 15 of 20

When utilizing the AVERAGE function, what two underlying arithmetic steps does the Excel engine automatically execute in sequence?

Question 16 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 17 of 20

Under what specific category of mathematical functions does the IF function—such as `=IF(B2>50, "True", "False")`—fundamentally reside?

Question 18 of 20

What is the primary visual distinction of features like 'Sparklines' and 'Data Bars' used for trend analysis in modern spreadsheets?

Question 19 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 20 of 20

Consider the following formula: `=IF(AND(A1>50, B1>50), "Winner", "Loser")`. If cell A1 contains 55 and cell B1 contains 45, what will the final output be?

More MS Office Subtopics

Practice other subtopics under MS Office to strengthen your CET Graduate preparation.