MS Excel
430 questions available
FILTER BY SUBTOPIC
Q241.In MS Excel 2016, which function returns the number (code point) corresponding to the first character of the text?
Correct Answer: A
The UNICODE() function returns the numeric Unicode value (code point) of the first character of a given text string.
Q242.In MS Excel 2016, which function returns the number of days between two dates based on a 360-day year?
Correct Answer: C
The DAYS360 function computes the interval between two dates assuming a 30-day month / 360-day year standard, widely used in financial accounting.
Q243.In MS Excel 2016, which option is used to quickly calculate rows of related data by inserting subtotals and totals?
Correct Answer: A
The Subtotal feature automatically groups rows of related data and adds subtotals and grand totals to summarize tables.
Q244.In MS Excel 2016, which feature easily spots trends and patterns in your data using bars, colors, and icons to visually highlight important values?
Correct Answer: C
Conditional Formatting dynamically applies styles (like data bars, colors, or icons) to cells based on their values, emphasizing critical trends.
Q245.Which MS-Excel 2016 feature can you use if you want to work with one database record at a time?
Correct Answer: C
The Data Form feature provides a simple dialog box interface to view, enter, edit, or delete single records in a table one at a time.
Q246.Which function returns the average of all the cells in a range that meet a given criteria in MS Excel 2016?
Correct Answer: A
The AVERAGEIF function calculates the arithmetic mean of cells in a specified range that satisfy a given conditional criteria.
Q247.Which of the following formulas in MS-Excel 2016 will not be able to calculate?
Correct Answer: A
MS Excel can perform calculations using formulas like SUM, subtraction, multiplication, and division. However, `=SUM(Sales)-A3` will result in a `#NAME?` error if 'Sales' has not been defined as a named range or table.
Q248.To return the remainder after a number is divided by a divisor in Excel, we use which function?
Correct Answer: C
The MOD function in Excel returns the remainder after division of one number by another. Syntax: =MOD(Number, Divisor).
Q249.Which of the following is the correct syntax for the IF function in MS Excel?
Correct Answer: A
The standard structure of the IF logical function is: =IF(logical_test, value_if_true, value_if_false).
Q250.Which of the following Excel expressions will give a resulting value of 6?
Correct Answer: A
Following standard operator precedence (PEMDAS), `=6*6/6` evaluates to `36/6 = 6`.
Q251.What is the function of the F4 key in most Microsoft Office applications (Word, Excel, etc.)?
Correct Answer: C
Pressing F4 in MS Word or Excel repeats your most recent action, such as formatting, typing, or deleting.
Q252.What is the second step involved in creating a macro in MS Excel?
Correct Answer: B
The standard sequence of creating a macro is: 1) Access Tools/Developer, 2) Record the Macro actions, 3) Test/Run the macro, and 4) Save it.
Q253.An Excel workbook is a collection of __________?
Correct Answer: C
An Excel workbook is primarily a collection of worksheets. A workbook must contain at least one worksheet.
Q254.An MS Excel worksheet consists of __________?
Correct Answer: B
Excel worksheets consist of a grid of horizontal rows (numbered) and vertical columns (alphabetical) that intersect to form cells.
Q255.A Pivot Table is an advanced summarization feature of which of the following software?
Correct Answer: A
The PivotTable is a core data analysis feature in Microsoft Excel used to summarize, analyze, and explore large datasets.
Q256.Which function in Excel is used to perform addition on two or more complex numbers?
Correct Answer: B
IMSUM() is the specific Excel engineering function used to calculate the sum of two or more complex numbers in the form 'a+bi' or 'a+bj'.
Q257.What does VLOOKUP in Excel represent?
Correct Answer: B
VLOOKUP stands for Vertical Lookup, searching for a value in the first column of a table to pull data from a specified column in the same row.
Q258.The IF function in Excel is used for _____?
Correct Answer: A
The IF function evaluates a condition (logical test) and returns one result if TRUE, and another if FALSE.
Q259.Which of the following is an example of a spreadsheet application?
Correct Answer: C
Microsoft Excel is a premier spreadsheet program used for organizing, formatting, and analyzing numerical data.
Q260.A single page where data is entered in MS Excel is called ______?
Correct Answer: C
An individual page within an Excel workbook is called a worksheet. A workbook can contain multiple worksheets.