MS Excel
430 questions available
FILTER BY SUBTOPIC
Q261.In MS Excel, which function automatically total a column or row of values?
Correct Answer: A
The SUM function is used to add all numbers in a selected column or row range, and can be quickly triggered using the AutoSum feature.
Q262.Which software is used for typing letters?
Correct Answer: B
Word processing applications like Microsoft Word are the standard software used for typing letters, formatting reports, and managing text documents.
Q263.Which chart type in Excel is best suited for showing the proportion of parts to a whole?
Correct Answer: A
A Pie Chart is the standard spreadsheet tool for visualizing data proportions making up parts of a single cohesive whole.
Q264.In MS Excel, Conditional Formatting is in ______ tab?
Correct Answer: A
In MS Excel, the Conditional Formatting option is available under the Styles group in the Home tab.
Q265.Which button is clicked in Excel to instantly sum a series of numbers?
Correct Answer: A
The AutoSum button (Greek Sigma symbol) automatically inserts the SUM formula for adjacent cell ranges.
Q266.What is the primary purpose of Conditional Formatting in Excel?
Correct Answer: A
Conditional formatting automatically changes cell formatting (e.g., color, fill) based on predefined rules.
Q267.Which function in Excel is used to combine text from multiple cells into one?
Correct Answer: A
The CONCATENATE function (or CONCAT in newer versions) joins two or more text strings together.
Q268.Combining two or more cells into a single cell in Excel or Word is called _____?
Correct Answer: B
Merging cells is the function used to combine multiple adjacent cells into one large cell.
Q269.Word, Excel, Access, and PowerPoint belong to which standard suite?
Correct Answer: A
These are core productivity applications contained within the Microsoft Office suite.
Q270.The .docx extension is the default file format for which program?
Correct Answer: B
The .docx file format represents XML-based documents created in Microsoft Word (2007 and later).
Q271.Which chart type is inserted by default in MS Excel when no specific type is chosen?
Correct Answer: C
By default, Microsoft Excel inserts a vertical Column Chart to represent a selected data series.
Q272.Which formula is used to calculate the arithmetic mean of cells B1 through B10 in Excel?
Correct Answer: B
The =AVERAGE(range) function computes the arithmetic mean of the specified cells in Excel.
Q273.Which of the following is NOT a valid data type in MS Excel?
Correct Answer: B
Excel uses three main data categories: labels (text), values (numbers and dates), and formulas. 'Character' is not a native discrete type.
Q274.What is the primary function of the VLOOKUP tool in Excel?
Correct Answer: B
VLOOKUP (Vertical Lookup) searches for a specified search term in the leftmost column of a table to retrieve data in the same row.
Q275.Which of the following is classified as a word processing application?
Correct Answer: B
Microsoft Word is a word processing software used to write, design, and compile text documents.
Q276.Which standard Windows program is NOT a part of the Microsoft Office suite?
Correct Answer: A
Windows Media Player is an integrated multimedia utility in Windows, not a productivity application of MS Office.
Q277.Parts of an Excel window include _____?
Correct Answer: D
The Title bar, Scroll bars, and window control icons (like Restore) are all standard components of the Excel interface window.
Q278.The first cell in EXCEL worksheet is labeled as ____?
Correct Answer: C
The first cell in an Excel grid lies at the intersection of column A and row 1, and is labeled A1.
Q279.Which feature in MS Excel allows you to visually represent data through graphical elements?
Correct Answer: C
Excel Charts allow users to visually represent numeric data series through graphical bars, lines, pies, or scatter plots.
Q280.What is the purpose of a formula in MS Excel?
Correct Answer: B
In Excel, formulas are custom calculations written by users to automatically compute values based on cell coordinates.