Advance Computer Science

Spreadsheet Software (MS Excel)

50,000+ Questions

Previous Year Papers

Detailed Solutions

Hindi & English

EASY

Assertion (A): The POWER(number, power) function is an alternative to the exponent operator (^). Reason (R): The POWER function returns the result of a number raised to a given power.

Both A and R are true and R is the correct explanation of A

Both A and R are true but R is not the correct explanation of A

A is true but R is false

A is false but R is true

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is Both A and R are true and R is the correct explanation of A.
Core Concept: The POWER function is functionally equivalent to the exponent operator in Excel, providing a named function alternative for clarity.

🧠 Solution Blueprint

Step-by-Step Reasoning:
- Assertion Analysis: The POWER function is indeed an alternative to the exponent operator (^), making the assertion true.
- Reason Analysis: The POWER function's primary purpose is to raise a number to a specified power, which explains why it serves as an alternative to the exponent operator, making the reason true and the correct explanation.

MEDIUM

Consider the following statements regarding file management in MS Excel:

The 'Save' command is used to save a workbook under a new name.
MS Excel 2010 worksheets are saved using an XML-based file format with the .xlsx extension.
Which of the above statements is/are correct?

Only 1 is correct

Only 2 is correct

Both 1 and 2 are correct

Neither 1 nor 2 is correct

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is Only 2 is correct.
Core Concept: The 'Save' command updates the current file, while 'Save As' is used for new names.

🧠 Solution Blueprint

Statement 1 Analysis: The 'Save' command is used to save a workbook (update current file). The command used to save a workbook under a new name is 'Save As'. Therefore, this statement is incorrect.
Statement 2 Analysis: MS Excel 2010 worksheets are indeed saved using an XML-based file format with the .xlsx extension. This statement is correct.

MEDIUM

What is the final output of the MS Excel formula =LCM(MOD(27, 8), MOD(19, 4))?

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is 3.
Core Concept: Nested formula evaluation requires solving inner functions first, then using their results as arguments for the outer function.

🧠 Solution Blueprint

Step-by-Step Solution:
- Inner Evaluation 1: MOD(27, 8) calculates the remainder of 27 divided by 8, which is 3.
- Inner Evaluation 2: MOD(19, 4) calculates the remainder of 19 divided by 4, which is 3.
- Outer Evaluation: The formula simplifies to LCM(3, 3). The Least Common Multiple of 3 and 3 is 3.

📊 Fact Spotlight

Attribute	Detail	Significance
MOD Function	Remainder	Returns remainder after division
LCM Function	Least Common Multiple	Returns the smallest common multiple

💡 Exam Strategy & Trivia

Tip

Common Pitfall: Do not confuse MOD with division. MOD returns the remainder, not the quotient.

Memorable Trivia: The LCM of two identical numbers is always the number itself.

UPP Computer Operator 21-12-2018 (Batch-02)

MEDIUM

If you enter the formula "=SUM(A1:A4)" in cell A5, it would:

A	B
1	50
2	100
3	150
4	200
5

Throw an error message because text values cannot be added.

Display the result, but will be of junk value as it adds the ASCII value instead of the numerical value.

Display the average of all numbers from A1 to A4.

Display the correct sum of all numbers from A1 to A4.

Explanation

The SUM(A1:A4) function is used to add the values present in cells A1, A2, A3, and A4. The sum here will be $50 + 100 + 150 + 200 = 500$ .

AHC RO-2016

MEDIUM

In an absolute cell address, row numbers and column labels are preceded by.........symbol.

Explanation

In Excel, the dollar ( $) sign is used for absolute cell references (e.g.,$ A$1).

No credit card required

MEDIUM

Match the following keyboard shortcuts with their functions in Microsoft Excel:

List I:

Ctrl + Shift + #
Ctrl + Shift + @
Ctrl + Arrow Key
Shift + Space

List II:
(a) Format number in time format
(b) Select entire row
(c) Format number in date format
(d) Move cursor to next section of text

1-c, 2-a, 3-d, 4-b

1-a, 2-c, 3-b, 4-d

1-b, 2-d, 3-a, 4-c

1-d, 2-b, 3-c, 4-a

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is 1-c, 2-a, 3-d, 4-b.
Core Concept: Excel provides specific shortcuts for date/time formatting and navigation/selection.

🧠 Solution Blueprint

Mapping:
- Ctrl + Shift + #: Format number in date format (1-c).
- Ctrl + Shift + @: Format number in time format (2-a).
- Ctrl + Arrow Key: Move cursor to next section of text (3-d).
- Shift + Space: Select entire row (4-b).

MEDIUM

Match the following shortcuts with their specific editing or creation functions:

List I:

F2
F11
Shift + F3
Alt + =

List II:
(a) Create a formula to sum cells
(b) Edit the selected cell
(c) Create a chart
(d) Open the Excel formula window

1-b, 2-c, 3-d, 4-a

1-c, 2-b, 3-a, 4-d

1-d, 2-a, 3-b, 4-c

1-b, 2-d, 3-c, 4-a

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is 1-b, 2-c, 3-d, 4-a.
Core Concept: Function keys and Alt combinations are essential for rapid editing, formula creation, and visualization in Excel.

🧠 Solution Blueprint

Mapping:
- F2: Edit selected cell (1-b).
- F11: Create chart (2-c).
- Shift + F3: Open formula window (3-d).
- Alt + =: AutoSum formula (4-a).

📊 Fact Spotlight

Shortcut	Function	Category
F2	Edit Cell	Editing
F11	Chart	Visualization
Alt+=	Sum	Formula

EASY

Consider the following mouse actions in MS Excel:

Double-click: Selects a word.
Triple-click: Selects a paragraph.
Ctrl + Mouse wheel: Zooms in and out.

Which of the above are correct?

1 and 2 only

2 and 3 only

1 and 3 only

1, 2, and 3

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is 1, 2, and 3.
Core Concept: Mouse actions provide intuitive shortcuts for selection and view control.

🧠 Concept Blueprint

The Core Entity: Mouse Actions:
- Double-click: Selects a word.
- Triple-click: Selects a paragraph.
- Ctrl + Mouse wheel: Zooms in and out.
Why It is Correct: All three statements are factually correct based on the provided mouse action documentation.

📊 Fact Spotlight

Action	Result
Double-click	Select Word
Triple-click	Select Paragraph
Ctrl + Wheel	Zoom

💡 Exam Strategy & Trivia

Tip

Common Pitfall / Exam Trap: Remember that triple-click is for the paragraph, not the whole document.

Memorable Trivia: The Ctrl + Mouse wheel zoom is one of the most frequently used shortcuts for accessibility and detailed editing.

EASY

Which command in MS Excel is specifically used to save an existing workbook under a new name?

Save

Save As

Export

Rename

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is Save As.
Core Concept: The Save As command allows users to create a new file copy with a different name or location.

🧠 Solution Blueprint

Step-by-Step Solution:
- The Save command is used to update the current file with changes.
- The Save As command is specifically designed to save a workbook under a new name or in a different format/location.
- Therefore, when a user needs to preserve the original file and create a new version, Save As is the correct choice.

MEDIUM

What is the result of the function =ROUND(5.135, 1)?

5.1

5.2

5.13

5.14

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is 5.1.
Core Concept: The ROUND function rounds a number to a specified number of digits. When rounding 5.135 to 1 decimal place, the second decimal digit (3) is less than 5, so it rounds down.

Full Mock Tests

Take Full-Length Mock Tests

Test your complete preparation with timed mock tests. Get detailed analytics and compare scores with other aspirants.

Explore Test Series

MEDIUM

Consider the following statements: 1. The TODAY() function returns the current date and time. 2. The NOW() function returns the current date. 3. The YEAR() function returns the year corresponding to a given date. Which of the statements are correct?

Only 1 and 2

Only 2 and 3

Only 3

1, 2, and 3

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is Only 3.
Core Concept: TODAY() returns only the date, while NOW() returns both date and time. YEAR() correctly extracts the year.

🧠 Concept Blueprint

Why It is Correct:
- Statement 1 is incorrect because TODAY() returns only the date.
- Statement 2 is incorrect because NOW() returns both the date and the time.
- Statement 3 is correct as the YEAR() function returns the year corresponding to a given date.

MEDIUM

Consider the following statements regarding an MS Excel workbook and identify the correct combination: 1. A workbook is a collection of one or more spreadsheets. 2. By default, opening a workbook shows five worksheets. 3. A maximum of 255 worksheets can be added within a workbook.

Only 1 and 2 are correct

Only 2 and 3 are correct

Only 1 and 3 are correct

All 1, 2, and 3 are correct

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is Only 1 and 3 are correct.
Core Concept: A workbook acts as a container for spreadsheets, with specific default and maximum limits for worksheet capacity.

🧠 Concept Blueprint

The Core Entity: Workbook Structure:
Workbook Definition: It is a collection of one or more spreadsheets.
Default State: Opening a workbook shows three worksheets by default, not five.
Capacity Limit: You can add a maximum of 255 worksheets within a single workbook.
Why It is Correct: Statement 1 is accurate as per the definition. Statement 2 is incorrect because the default is three, not five. Statement 3 is accurate regarding the maximum limit.

📊 Fact Spotlight

Attribute	Detail	Significance
Default Worksheets	3	Initial setup
Max Worksheets	255	Upper limit

💡 Exam Strategy & Trivia

Tip

Common Pitfall: Do not confuse the default number of worksheets (3) with the maximum number of worksheets (255). Always verify the specific limit being asked.
Memorable Trivia: A workbook is essentially the 'file' you save in Excel, containing all your data sheets.

EASY

Which of the following correctly represents the zoom capabilities in MS PowerPoint?

Minimum: 10%, Maximum: 400%, Default: 69%

Minimum: 5%, Maximum: 500%, Default: 100%

Minimum: 10%, Maximum: 200%, Default: 69%

Minimum: 25%, Maximum: 400%, Default: 100%

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is Minimum: 10%, Maximum: 400%, Default: 69%.
Core Concept: PowerPoint zoom limits are fixed parameters ranging from 10% to 400%, with a specific default value of 69%.

🧠 Concept Blueprint

The Core Entity: Zoom Slider:
- The zoom slider allows users to adjust the magnification of the slide view.
- The range is strictly defined between 10% (minimum) and 400% (maximum).
Why It is Correct:
- The provided facts explicitly state that the minimum zoom limit is 10% and the maximum is 400%.
- The default zoom size is specified as 69%.

📊 Fact Spotlight

Attribute	Detail
Minimum Zoom	10%
Maximum Zoom	400%
Default Zoom	69%

💡 Exam Strategy & Trivia

Tip

Common Pitfall: Many users assume the default zoom is 100% because that is standard in Word or Excel. In PowerPoint, the default is uniquely 69%.

Memorable Trivia: The 69% default is a specific design choice in PowerPoint to ensure the slide fits optimally within the standard editing pane.

UPPCL (Ste.) 28-08-2018 (Morning)

MEDIUM

To edit any text or formula in Microsoft Excel you have to select that cell and press ____.

Shift + F3

Explanation

The 'F2' key is used to enter edit mode for a cell.

MEDIUM

Assertion (A): The Notes Pane is a critical tool for presenters during a live slide show.
Reason (R): The Notes Pane displays text that is visible to the audience while the presentation is running.

Both A and R are true and R is the correct explanation of A

Both A and R are true but R is not the correct explanation of A

A is true but R is false

A is false but R is true

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is A is true but R is false.
Core Concept: The Notes Pane is designed for speaker preparation, not for audience viewing during the presentation.

🧠 Solution Blueprint

Step-by-Step Reasoning:
- Assertion Analysis: The Notes Pane is indeed a critical tool for presenters to keep track of their speech points while preparing.
- Reason Analysis: The reason states that notes are visible to the audience during the slide show. This is factually incorrect; the notes are explicitly excluded from the slide show display.

📊 Fact Spotlight

Feature	Audience Visibility
Slide Content	Visible
Notes Pane	Hidden

Ald. Bank (Clerk) 2009

MEDIUM

Which types of software is like an accountant's worksheets

Word processing

Database

Spreadsheets

Graphics

Explanation

Spreadsheet software was originally designed for accounting tasks (like balance sheets, budgets, etc.), so it is like an accountant's worksheet.

EASY

Which keyboard shortcut is used to repeat the last action performed in MS Excel?

F12

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is F4.
Core Concept: Function keys provide rapid access to repetitive tasks, with F4 specifically dedicated to repeating the most recent operation.

🧠 Concept Blueprint

The Core Entity: Action Repetition:
- F4: Repeats the last action performed (Word 2000+).
Why It is Correct: F4 is the standard shortcut key for the 'Repeat' command in Microsoft Office applications.

📊 Fact Spotlight

Shortcut	Function
F4	Repeat Last Action
F5	Go To
F7	Spell and Grammar
F12	Save As

💡 Exam Strategy & Trivia

Tip

Common Pitfall / Exam Trap: Do not confuse F4 with F5 (Go To) or F12 (Save As).

Memorable Trivia: This shortcut is a massive time-saver when applying the same formatting or action to multiple non-contiguous cells or objects.

HARD

Consider the following statements regarding window management in Excel:

Ctrl + F9 is used to maximize the currently selected window.
Ctrl + F10 is used to minimize the current window.
Ctrl + F6 is used to switch between open workbooks or windows.

Which of the above statements are correct?

1 and 2 only

2 and 3 only

3 only

All are correct

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is 3 only.
Core Concept: Window management shortcuts in Excel are specific and often inverted in user memory.

🧠 Concept Blueprint

Correction of Statements:
- Statement 1: Incorrect. Ctrl + F9 is used to minimize the current window.
- Statement 2: Incorrect. Ctrl + F10 is used to maximize the currently selected window.
- Statement 3: Correct. Ctrl + F6 switches between open workbooks.

💡 Exam Strategy & Trivia

Tip

Mnemonic Trick: Think of F9 as '9' (going down/minimizing) and F10 as '10' (reaching the top/maximizing).

MEDIUM

Consider the following statements about the Auto Sum process:

Pressing the Enter button is required to finalize the sum calculation.
The Auto Sum command is located on the standard toolbar.
The shortcut key for Auto Sum is Alt + =.

Which of the above statements are correct?

1 and 2 are correct

2 and 3 are correct

1 and 3 are correct

All are correct

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is All are correct.
Core Concept: The Auto Sum process involves specific steps, locations, and shortcuts as defined in MS Excel.

🧠 Concept Blueprint

The Core Entity: Auto Sum Facts:
- Statement 1 is correct: Pressing the Enter button displays the final sum.
- Statement 2 is correct: The Auto Sum command is located on the standard toolbar.
- Statement 3 is correct: The shortcut key for Auto Sum is Alt + =.
Why It is Correct:
- All three statements accurately reflect the facts provided regarding the Auto Sum feature.

MEDIUM

Assertion (A): The 'What if analysis' command is located under the Data section of the menu bar in MS Excel 2007.
Reason (R): MS Excel is primarily used for accounting purposes.

Select the correct option:

Both (A) and (R) are true, and (R) is the correct explanation of (A).

Both (A) and (R) are true, but (R) is not the correct explanation of (A).

(A) is true, but (R) is false.

(A) is false, but (R) is true.

Explanation

🌟 Quick Verification

Direct Answer: The correct answer is Both (A) and (R) are true, but (R) is not the correct explanation of (A).
Core Concept: Distinguishing between specific feature locations and the general purpose of the software.

🧠 Solution Blueprint

Step-by-Step Solution:
- Assertion (A): The fact pool explicitly states that the 'What if analysis' command is available under the Data section in MS Excel 2007. This is True.
- Reason (R): The fact pool states that MS Excel is mainly used for accounting purposes. This is True.
- Logical Connection: While both statements are factually correct, the primary purpose of Excel (accounting) does not explain why the 'What if analysis' command is located in the Data tab. Therefore, (R) is not the explanation for (A).

💡 Exam Strategy & Trivia

Tip

Common Pitfall / Exam Trap: In Assertion-Reason questions, always check the truth value of both statements first. Then, ask 'Does the reason cause the assertion?' If the answer is no, select the 'not the correct explanation' option.

Free Forever

Track Your Progress

You're Doing Great! 🎯

Sign up free to unlock unlimited questions, save your progress, and access all Spreadsheet Software (MS Excel) questions.

Unlimited PYQs Progress Tracking Mock Tests

✨ Free forever • No credit card • 2 sec signup with Google

Full Mock Tests

Take Full-Length Mock Tests

Test your complete preparation with timed mock tests. Get detailed analytics and compare scores with other aspirants.

Explore Test Series

All Chapters

Advance Computer Science

Fundamentals of Computer

513+ questions

Word Processing (MS Word)

457+ questions

Spreadsheet Software (MS Excel)

147+ questions

Current 4

Presentation Software (MS PowerPoint)

162+ questions

DBMS Software (MS Access)

224+ questions

C and C++ Programming

Artificial Intelligence and Machine Learning

175+ questions

Python Programming

92+ questions

Blockchain Technology

83+ questions

Principles of Programming and OOPs

630+ questions

Data Structures and Algorithms

288+ questions

Computer Organization and Operating System

302+ questions

Communication and Network Concepts

627+ questions

Network Security

97+ questions

Database Management System

223+ questions

System Analysis and Design

226+ questions

Internet of Things and its Application

318+ questions

Major Developments in IT

103+ questions

Pedagogy of Computer Science

119+ questions

Digital Logic Systems

268+ questions