MS Excel
430 questions available
FILTER BY SUBTOPIC
Q301.MS Excel is based on :
Correct Answer: C
Microsoft Excel is a spreadsheet application specifically developed to run on the Windows operating system.
Q302.How columns are numbered in MS Excel?
Correct Answer: B
Columns in MS Excel are labeled alphabetically (A, B, C... Z, AA, AB...), while rows are numbered numerically (1, 2, 3...).
Q303.Which symbol is used to execute formulas in MS Excel?
Correct Answer: B
Every formula and function in Excel must begin with an equal sign (=) to signify that a calculation is to be performed.
Q304.Which function is used in Excel to count numeric values in a range?
Correct Answer: B
The COUNT function in MS Excel is used to return the number of cells in a specified range that contain numeric values.
Q305.For calculation of data, which software is mainly used?
Correct Answer: B
Microsoft Excel is a spreadsheet application specifically designed for organizing, calculating, and analyzing data.
Q306.The ______ function in Excel returns the highest value in a set of data that you specify.
Correct Answer: C
The MAX function evaluates a specified range of cells and returns the highest (maximum) numeric value in that set.
Q307.What are the number of columns in MS Excel 2007?
Correct Answer: B
Excel 2007 and later versions support up to 16,384 columns (from A to XFD) and 1,048,576 rows per worksheet.
Q308.Which of following is not a valid zoom percentage in Excel?
Correct Answer: D
MS Excel restricts worksheet zoom levels to a minimum of 10% and a maximum of 400%, making 500% an invalid zoom level.
Q309.Which of the following formulas is NOT correctly entered in Excel?
Correct Answer: D
Excel formulas must always begin with an equal sign (=). Without it, Excel treats 'C1+15' as plain literal text.
Q310.How many sheets (worksheets) are there in the Excel workbook by default?
Correct Answer: B
By default, older versions of Microsoft Excel open a new workbook containing exactly 3 blank worksheets (Sheet1, Sheet2, Sheet3).
Q311.In MS Excel, the $ symbol in a formula denotes ______?
Correct Answer: C
Placing a $ sign before column letters or row numbers (e.g., $A$1) creates an absolute reference that stays fixed when formulas are copied.
Q312.Feature in Excel which automatically adds numbers in the selected cells is _____?
Correct Answer: C
Excel's Autosum feature (accessed via the Σ Sigma button or Alt + =) automatically inputs a SUM formula to total adjacent numerical ranges.
Q313.Mujtaba wants to record his monthly expenses on the computer. Which software should he use?
Correct Answer: A
Spreadsheet applications like MS Excel are specifically designed for recording, calculating, and analyzing structured numerical data (such as personal budgets and monthly expenses).
Q314.In MS Excel, through which of the following table options can charts be created?
Correct Answer: C
Excel charts, tables, shapes, and other graphical elements are inserted using tools located inside the Insert tab.
Q315.In MS Excel, inside a workbook are sheets called _____?
Correct Answer: A
An Excel workbook is a file containing multiple individual sheets, which are referred to as worksheets.
Q316.Excel is a program that is used to prepare a ______?
Correct Answer: A
Microsoft Excel is primarily designed as an electronic spreadsheet program used to process, calculate, and analyze numerical data.
Q317.In Excel, if you want to calculate the sum of cells ranging from C1 to C12, then which of the following formula you will use?
Correct Answer: B
The colon (:) operator defines a contiguous cell range in Excel, making =SUM(C1:C12) the correct summation formula.
Q318.Consider a worksheet of MS Excel, If value of F7 cell is 12 and value of H12 cell is 30. Calculate the answer of following formula=F7*H12 _____?
Correct Answer: C
F7 (12) multiplied by H12 (30) equals 360.
Q319.Excel sometimes does not recalculate when a formula is updated because ______?
Correct Answer: C
If Excel's calculation engine is toggled to manual mode, formulas will not recalculate automatically when values change until the user presses F9.
Q320.In Excel, a trendline can be added to a ______?
Correct Answer: A
Trendlines can be added to standard Excel data charts (e.g., scatter, bar, or line graphs) to illustrate general data trends, patterns, or projections.