MS Excel
430 questions available
FILTER BY SUBTOPIC
Q321.Microsoft Excel can ______ text so it appears on multiple lines in a cell.
Correct Answer: C
Text wrapping automatically adjusts cell content to span across multiple vertical lines within the same column width, ensuring text remains visible.
Q322.In MS Excel, _____ function calculates the square root of a number.
Correct Answer: B
The SQRT() function is used in Microsoft Excel to return the positive square root of a specified number.
Q323.Which symbol is used for division in Excel?
Correct Answer: A
The forward slash (/) is the standard mathematical operator used to perform numeric division inside Microsoft Excel formulas.
Q324.MS-Excel uses the _____ function when creating a data table.
Correct Answer: D
Microsoft Excel uses the built-in TABLE() function internally when a user sets up a data table range for what-if scenarios.
Q325.Which Excel function is used to add the current system date?
Correct Answer: C
The =TODAY() function inserts the current dynamic system date into an Excel cell, which will recalculate automatically each day.
Q326.Which one can be used for creating a document?
Correct Answer: B
Microsoft Word is the flagship word processing application within Microsoft Office designed specifically for typing and formatting text documents.
Q327.What would you do to delete a record in MS Excel?
Correct Answer: A
In legacy database-linked Excel structures, deleting a record involves navigating to the record in the Data form dialog box and selecting the Delete command.
Q328.Function key to go to a specific cell in MS Excel is:
Correct Answer: B
Pressing the F5 function key opens the 'Go To' dialog box in MS Excel, allowing users to enter a specific cell reference (like G14) to navigate there directly.
Q329.Which Microsoft Excel feature is used to selectively display only rows that satisfy a specified condition while hiding the rest?
Correct Answer: C
Filtering isolates specific rows based on custom conditions (e.g., showing only values > 100) while temporarily hiding irrelevant rows.
Q330.In Microsoft Excel, which built-in tools are categorized under 'What-If Analysis'?
Correct Answer: D
Excel's What-If Analysis tools include Goal Seek, Scenario Manager, and Data Tables. Solver is a advanced optimization add-in grouped under analysis.
Q331.Which software category is Microsoft Excel universally associated with?
Correct Answer: D
Microsoft Excel is a spreadsheet application used to organize, calculate, analyze, and visualize numerical data in grids of rows and columns.
Q332.Which application in the Microsoft Office productivity suite is designed specifically to handle complex calculations and mathematical formulas?
Correct Answer: A
MS Excel is the dedicated spreadsheet application used for data calculations, mathematical formulas, and statistical analysis.
Q333.In Microsoft Excel, which cell attributes can be selectively pasted using the Paste Special command?
Correct Answer: D
The Paste Special command (Ctrl + Alt + V) allows users to selectively paste only formulas, values, cell formats, validation rules, or comments.
Q334.When is an active Smart Tag automatically removed from a cell in Microsoft Excel?
Correct Answer: B
Excel automatically deletes or clears a smart tag associated with a cell once the original data triggering that tag is modified or erased.
Q335.Which of the following represents a valid absolute cell reference in Microsoft Excel?
Correct Answer: A
An absolute reference uses dollar signs before both the column letter and row number (e.g., $A$1) to lock the cell coordinate.
Q336.What is the primary function of a Macro in Microsoft Excel?
Correct Answer: B
Macros record a sequence of formatting or calculation steps in VBA to allow users to replay them with a single click, automating repetitive tasks.
Q337.Which application is most commonly suggested to accounting departments to calculate monthly salaries, budgets, and balance sheets?
Correct Answer: C
Microsoft Excel provides dedicated spreadsheets, multi-variable formulas, financial functions, and pivot tables ideal for accounting tasks.
Q338.In spreadsheet applications like Excel, how is an individual cell defined?
Correct Answer: A
A cell is the basic storage coordinate in a spreadsheet, formed by the intersection of a horizontal row and a vertical column.
Q339.Which logical function in Microsoft Excel does NOT output the boolean words 'TRUE' or 'FALSE' as its direct evaluation result?
Correct Answer: B
The IF function returns custom values specified by the user for true/false states, unlike AND/OR which output boolean values.
Q340.Which Microsoft Excel function is used to transpose rows of data into columns, and columns into rows?
Correct Answer: B
The TRANSPOSE function rotates the orientation of cell ranges, converting vertical arrays to horizontal arrays and vice versa.