Microsoft Excel questions and answers
Cells, formulas, functions, charts, worksheets and data analysis.
These are practice variations, many generated from templates and numeric inputs, not an official question bank. They remain outside search indexing until at least 100 independently reviewed questions across five chapters are available.
Questions and clear answers
01Formulas · foundation · Editorial previewWhat is an Excel formula?+
A formula starts with = and calculates a result, such as =SUM(A1:A5), instead of storing a fixed result.
02References · foundation · Editorial previewWhat does $A$1 mean in a formula?+
Both the column and row are absolute references that remain fixed when you copy the formula.
03Functions · foundation · Editorial previewWhat is the difference between COUNT and COUNTIF?+
COUNT counts numeric cells; COUNTIF counts cells matching a condition such as a word or a number range.
04Display · foundation · Editorial previewWhy might a cell show ####?+
The column may be too narrow for its number or date; widening it is a useful first troubleshooting step.
05SUM function · advanced · Editorial previewIn ms excel — SUM function: A practice worksheet lists 4304 objects and then 33 more. How many objects are there in total?+
Add the two quantities: 4304 + 33 = 4337 objects in total.
06AVERAGE function · foundation · Editorial previewIn ms excel — AVERAGE function: Four measurements are 4915, 6, 4922 and 13. What is their arithmetic mean?+
Sum = 9856; divide by 4 to get 2464.
07IF function · foundation · Editorial previewIn ms excel — IF function: Excel cell A12 contains 2734. Write an IF formula that returns Pass when A12 is at least 11, otherwise Review.+
=IF(A12>=11,"Pass","Review"). It returns Pass for the stated value.
08COUNTIF function · intermediate · Editorial previewIn ms excel — COUNTIF function: An Excel range B2:B3534 contains status values. Write a formula counting cells exactly equal to Paid.+
=COUNTIF(B2:B3534,"Paid"). COUNTIF counts matching entries; the actual count depends on the cell contents.
09SUMIF function · foundation · Editorial previewIn ms excel — SUMIF function: In Excel, A2:A4333 contains categories and B2:B4333 contains amounts. What formula adds amounts where the category equals Food?+
=SUMIF(A2:A4333,"Food",B2:B4333). The numerical result depends on the worksheet data.
10Cell references · advanced · Editorial previewIn ms excel — Cell references: A formula multiplies B10 by a fixed tax rate in cell C15. What reference keeps C15 fixed when copying the formula?+
Use $C$15 for an absolute reference, for example =B10*$C$15.
11Percentage formulas · intermediate · Editorial previewIn ms excel — Percentage formulas: A sample has 3019 units, of which 2971 meet the stated condition. What percentage meet it, rounded to two decimals?+
98.41% because 2971 ÷ 3019 × 100 = 98.41%.
12MAX and MIN · foundation · Editorial previewIn ms excel — MAX and MIN: Three Excel cells contain 1730, 7 and 24. What results should MAX and MIN produce?+
MAX selects the largest value, 1730; MIN selects the smallest, 7.
13Chart data · foundation · Editorial previewIn ms excel — Chart data: A chart has two counts 2529 and 39. What is the absolute difference?+
Absolute difference = 2529 − 39 = 2490 counts.
14Filtering · intermediate · Editorial previewIn ms excel — Filtering: An Excel table has 3328 entries. You need to temporarily show only rows with Status = Open. Should you delete the other rows?+
No. Apply a filter to the Status column for Open; filtering hides nonmatching rows without deleting them.
15Tax calculation · advanced · Editorial previewIn ms excel — Tax calculation: A worksheet amount is ₹412700 and a modeled tax rate is 22%. What tax amount should the formula calculate?+
Tax = amount × rate = 412700 × 22/100 = ₹90794. This is an arithmetic example, not tax advice.
16Data validation · foundation · Editorial previewIn ms excel — Data validation: An Excel cell should allow only whole numbers from 1 to 4926. Which feature constrains entry?+
Set Data Validation to whole numbers with minimum 1 and maximum 4926. Other methods can still paste invalid data, so audit inputs.
17SUM function · intermediate · Editorial previewIn ms excel — SUM function: A practice worksheet lists 1638 objects and then 4 more. How many objects are there in total?+
Add the two quantities: 1638 + 4 = 1642 objects in total.
18AVERAGE function · foundation · Editorial previewIn ms excel — AVERAGE function: Four measurements are 2249, 36, 2254 and 41. What is their arithmetic mean?+
Sum = 4580; divide by 4 to get 1145.
This is an educational practice preview. Answers and board-specific alignment are undergoing editorial review; these are not official exam questions.