MS Excel
430 questions available
FILTER BY SUBTOPIC
Q361.What category of built-in Excel spreadsheet functions does the loan calculation function =PMT() belong to?
Correct Answer: C
The PMT (Payment) function is categorized under Financial functions in Excel, used to compute loan payments based on interest and periods.
Q362.Which of the following standard mathematical operators in Microsoft Excel operates strictly on integer operands only?
Correct Answer: D
None of Excel's default operators restrict calculations to integers. Even % (percentage) and / (division) process decimal values.
Q363.What is the standard method to delete an entire column in Microsoft Excel?
Correct Answer: A
To delete an entire column, right-click its heading letter and choose 'Delete' from the contextual menu, or use the shortcut Ctrl + Minus Sign (-).
Q364.How would Microsoft Excel evaluate the mathematical formula entered as: =20 * 10 / 5 * 8?
Correct Answer: C
Excel executes operators of equal precedence from left to right: first 20*10 = 200, then 200/5 = 40, and finally 40*8 = 320.
Q365.In Microsoft Excel terminology, which of the following is NOT treated as a numerical value?
Correct Answer: A
Excel stores date constants and plain numbers as numeric values. Mixed alphanumeric text like 'Obtained marks - 87' is treated as a text label.
Q366.To organize numerical data into rows and columns to perform complex mathematical or statistical calculations, which software is most appropriate?
Correct Answer: A
Microsoft Excel is a spreadsheet application specifically built for tabular data entry, advanced calculations, and data visualization.
Q367.In MS Excel, if you accidentally erase a cell value, which command can be used to instantly restore it?
Correct Answer: A
The Undo command (Ctrl + Z) immediately reverses the last action performed in the spreadsheet, restoring deleted content.
Q368.A Microsoft Excel file (spreadsheet) is also known by which term?
Correct Answer: B
An Excel spreadsheet file is called a workbook. A workbook is a collection of one or more worksheets (grid-based spreadsheet pages) organized in a single file.
Q369.What represents the range when moving from cell C9 to C11 in Microsoft Excel?
Correct Answer: A
A continuous cell range in Microsoft Excel is represented by separating the starting cell address and ending cell address with a colon (:), written as C9:C11.
Q370.Which of the following is NOT a valid chart type available in Microsoft Excel?
Correct Answer: A
Excel provides standard chart types like Line, Pie, Bar, Column, and Scatter. 'Volume' is a measurement of space but is not a built-in chart type.
Q371.In Microsoft Excel, a pre-programmed calculation tool is known as a(n)?
Correct Answer: A
An Excel function is defined as a pre-programmed (or built-in) formula. It automates complex mathematical, statistical, or logical calculations by accepting arguments in parentheses.
Q372.Which function key is used in Microsoft Excel to quickly create a chart from selected cells on a new sheet?
Correct Answer: C
In MS Excel, selecting a data range and pressing the F11 key instantly creates a new, dedicated Chart Sheet displaying a default chart of the selected data.
Q373.What is the comparison symbol for the 'not equal to' operator in Microsoft Excel?
Correct Answer: C
Excel uses the logical comparison operator <> to represent 'not equal to'. This operator is used in formulas and logical tests.
Q374.What should be added before a numerical fraction in Excel to prevent it from automatically converting to a date?
Correct Answer: A
To write a fraction like 1/2 without Excel interpreting it as '02-Jan' or '01-Feb', type '0 1/2' (zero followed by a space and then the fraction). Excel will treat it as a numerical value.
Q375.Microsoft Excel is primarily a ________ program designed for calculations and data management.
Correct Answer: A
Microsoft Excel is a dedicated spreadsheet program that structures data in cells across rows and columns to perform calculations and data analyses.
Q376.Which software is specifically designed to create slide-based presentations for communication purposes?
Correct Answer: C
Microsoft PowerPoint is presentation software designed to create slide shows containing text, shapes, graphics, images, and animations.
Q377.When applying conditional formatting in Excel, you can check conditions against which of the following?
Correct Answer: C
In Excel, conditional formatting can evaluate rules against either a static cell value (e.g., cell > 10) or a dynamic formula.
Q378.Which keyboard key is used in MS Excel to edit and insert text into an already selected cell?
Correct Answer: B
Pressing the F2 key in Microsoft Excel opens the selected cell for editing, placing the cursor inside so you can insert or modify text directly.
Q379.In MS Excel, when you are typing an equation into a cell, what must be entered first?
Correct Answer: D
Excel requires all formulas and equations to begin with an equal sign (=). Without it, Excel interprets the entry as simple text or numbers.
Q380.In Microsoft Excel, which of the following cell entries represents an INCORRECT formula setup because it lacks an initial equal (=) sign?
Correct Answer: D
None of these are correct formula syntaxes. Excel formulas must begin with an equal sign (=). Without it, entries like 'B1*B2' or '10+17' are treated as plain text strings.