Excel Worksheet

Charts, Formulas & Functions in

Excel

Practice Worksheet
Name: ______________________ Class: __________ Roll No.: __________
Date: __________

SECTION A: Fill in the Blanks (15)

1. A group of selected, continuous cells in a worksheet is called a
__________.
2. The address of a range is created by separating the starting and
ending cell addresses with a __________ sign.
3. To select a range with the mouse, click on the first cell, then press
and hold the __________ key and click on the last cell.
4. Once a cell range is named, this name can be used in place of the
__________ in formulas.
5. A __________ is an effective way to display data in pictorial form,
making it easier to draw comparisons.
6. The __________ includes all the objects and elements of a chart.
7. Text in Excel is always aligned on the __________ side of a cell,
while numbers are aligned on the __________ side.
8. A formula in Excel always begins with a(n) __________ sign.
9. According to the BEDMAS rule, Excel calculates __________ and
__________ before Addition and Subtraction.
10. A reference that remains fixed even when a formula is copied is
called a(n) __________ reference, created using the __________
symbol.
11. A reference that locks only the row or only the column is known as
a __________ reference.
12. To refer to a cell in another worksheet, the __________ symbol is
used to separate the worksheet name from the cell address.
13. Functions are __________ formulas in Excel that accept arguments
and return values.
14. The __________ function joins together two or more different text
strings.
15. The __________ function checks whether a given condition is true or
false and returns one of two values accordingly.

SECTION B: Choose the Correct Option

(15)
16. Which symbol separates the starting and ending cell of a range?
a. Semicolon (;) b) Colon (:) c) Hyphen (-) d) Comma (,)
17. Which tab must you click to assign a name to a selected cell
range?
a. Insert b) Data c) Formulas d) View
18. Which chart type always shows only one data series?
a. Bar Chart b) Line Chart c) Pie Chart d) Scatter Chart
19. In a Column Chart, values are represented on which axis?
a. Horizontal axis b) Vertical axis c) Diagonal axis d) None of
these
20. Which of the following is NOT a type of data in Excel?
a. Text b) Values c) Formula d) Hyperlink
21. What happens if you don’t type the equal (=) sign before a
formula?
a. Excel shows an error b) Excel treats the entry as text c) Excel
automatically adds it d) Excel deletes the entry
22. According to BEDMAS, what is calculated first?
a. Addition b) Multiplication c) Expressions within
brackets/parentheses d) Subtraction
23. What is the result of =10 + 10 * 2?
a. 40 b) 30 c) 20 d) 22
24. Which type of reference changes automatically when a formula is
copied to another cell?
a. Absolute b) Relative c) Mixed d) Fixed
25. Which symbol is used to lock a row or column in a cell reference?

a. (hash) b) $ (dollar) c) &

(ampersand) d) % (percent)
26. Which key is pressed repeatedly to switch between reference types
(relative, absolute, mixed)?
a. F2 b) F4 c) F6 d) F9
27. Which function returns the remainder after dividing one number
by another?
a. SQRT() b) INT() c) MOD() d) ABS()
28. Which function removes the decimal part of a number and returns
only the integer part?
a. ROUND() b) INT() c) ABS() d) POWER()
29. What will =LEFT(“Excel”, 3) return?
a. cel b) Exc c) xce d) Excel
30. What category does the IF() function belong to?
a. Mathematical b) Text c) Logical d) Date and Time

SECTION C: Identify the Function (15)

Name the Excel function being described or its correct output.

31. It returns the sum of a range of numbers. → __________

32. It multiplies the values in a range of cells. → __________
33. It returns the square root of a given number. → __________
34. It returns the result of a number raised to a given power. →
__________
35. It returns the count of the number of values in a selected range. →
__________
36. It returns a number after rounding it to a specified number of
digits. → __________
37. It returns the absolute (positive) value of a given number. →
__________
38. It returns the largest value in a given range. → __________
39. It returns the smallest value in a given range. → __________
40. It returns the average (mean) of a given set of numbers. →
__________
41. It returns the specified number of characters from the right side of
a text string. → __________
42. It returns the total number of characters in a text string. →
__________
43. It converts a text string into all uppercase letters. → __________
44. It returns the current system date and time together. → __________
45. It returns only the current year from today’s date. → __________

SECTION D: Identify the Chart (15)

 Name the correct chart type based on the description.

46. Displays data using long rectangular rods placed horizontally on

the chart area. → __________
47. Uses connecting dots to display trends over a period of time,
similar to a graph. → __________
48. A circular chart divided into sectors, where each sector shows the
relative size of a value. → __________
49. Usually used to display data in vertical bars; good for comparison
among different data items. → __________
50. Emphasises the area between the line and the axis using colours or
textures; based on the features of a line chart. → __________
51. Shows the correlation between two sets of values, plotting data
points along the x and y axes. → __________
52. In this chart, categories are represented on the vertical axis and
values on the horizontal axis. → __________
53. In this chart, categories are represented on the horizontal axis and
values on the vertical axis. → __________
54. This chart is best used when you want to put emphasis on one
significant element within the whole. → __________
55. Which chart component describes the main aim and content of the
chart? → __________
56. Which chart component is the rectangular area bounded by the
two axes, containing the actual plotted data? → __________
57. Which chart component is the key that shows the meanings of the
symbols and colours used in the chart? → __________
58. Which chart component can be either horizontal or vertical lines,
making the chart easier to read? → __________
59. What is another name for the X-axis of a chart? → __________
60. What is another name for the Y-axis of a chart? → __________

SECTION E: Cell Referencing (10)

61. If cell A1 contains 10 and cell A2 contains the formula =A1*2,
what type of reference is being used in A2?
62. Write an example of an absolute cell reference for cell D3.
63. Write an example of a mixed reference that locks only the column
A.
64. Write an example of a mixed reference that locks only row 1 of
column A.
65. If the formula =(B3C3)-((B3C3)*($D$3)) is copied from row 3 to
row 4, which part of the formula stays unchanged, and which parts
change?
66. Write the correct formula to refer to cell A2 in Sheet2 from within
Sheet1.
67. What symbol is used to separate a worksheet name from a cell
reference in a formula?
68. Fill in the blank: In relative referencing, you refer to a cell that is
above, below, left, or right by a number of __________ or __________.
69. Why should a discount percentage that applies to every row of a
bill be written as an absolute reference instead of a relative
reference?
70. If you press F4 once on a relative reference like A1, what does it
become?

SECTION F: Types of Data (10)

71. Name the three types of data that can be entered into Excel.
72. Which type of data is always aligned to the left side of a cell?
73. Which type of data is always aligned to the right side of a cell?
74. Give one example of a special character that can be part of
numeric/value data in Excel.
75. Why can’t mathematical calculations be performed on text data in
Excel?
 76. What symbol must precede a formula so that Excel recognises it as
a formula rather than text?
77. State whether the following is TRUE or FALSE: “Phone numbers
are always treated as values in Excel.”
78. Classify the following entry: “Total Profit” — is it text, a value, or a
formula?
79. Classify the following entry: =A2+B2 — is it text, a value, or a
formula?
80. Classify the following entry: 4500 — is it text, a value, or a
formula?

SECTION G: Evaluate the Given Formulas

(15)
Write the final output of each formula.

81. =(8 + 5) - (2 + 3) ^ 2
82. =(9/3) * (4 ^ 2) - 5
83. =MAX(SUM(10,20,30), AVERAGE(10,20,30))
84. =CONCATENATE(UPPER(“orange”), LEN(“ORANGE”))
85. =POWER(ABS(-5), ABS(-2))
86. =SQRT(INT(20.4) + SQRT(25))
87. =((10+6)/SQRT(8))
88. =LEN(“12345”) + LEN(“Excel”)
89. If A1=30, A2=40, A3=50: =(A1 - A2) * A3
90. If A1=30, A2=40, A3=50: =A3 + (A1 * A2)
91. If A1=30, A2=40, A3=50: =A1 * (A2 + A3) - 10
92. =ROUND(35.6662, 2)
93. =MOD(17, 5)
94. If A2=10 and A3=20: =IF(A2 > A3, “A2 is greater than A3”, “A2 is
not greater than A3”)
95. =10 + 10 * 2 − (10 + 10) * 2 (evaluate both parts, then find the
difference)

SECTION H: Write the Output (10)

96. =MIN(9, 6, 1)
97. =LEFT(“Computer”, 4)
98. =AVERAGE(12, 3, 6)
99. =COUNT(4, 8, 12)
100. =SQRT(81)
101. =INT(14.25)
102. =RIGHT(“Touch”, 3)
103. =LOWER(“EXAMINATION”)
104. =PRODUCT(4, 2, 8)
105. =ABS(-25)

SECTION I: HOTS (Higher Order Thinking

Skills) (10)
106. Sohan has created a worksheet in Excel to store the marks of
students in his class. He wants to display the data from the sheet
in pictorial form. Which feature of Excel should he use, and why is
it more effective than just reading the raw numbers?
107. Mayra has written her first name and last name in cells F1 and F2,
respectively. To display the complete name, she enters the formula
=CONCATENATE(F1+F2) in cell F3, but she does not get the
correct output. Identify her mistake and write the correct formula.
108. Simi wants a formula that will always refer to the same discount
cell (say, G2) no matter which row she copies it to, while the price
and quantity cells should change automatically for each row. What
 type of reference should she use for G2, and how would you write
it (e.g., referring to G2)?
109. Romi has a worksheet with 50 rows of sales data and wants to
know both the total sales and the number of transactions greater
than zero. Which two functions would help her find these two
answers, and what is the key difference between what they
calculate?
110. A student enters the formula 25+B2 (without the equal sign) into a
cell. Explain what Excel will do with this entry and why, and
rewrite it correctly.
111. Explain why using parentheses in a formula is recommended even
when they are not mathematically necessary.
112. A teacher wants to find the highest scorer in her class from a
spreadsheet of marks and also wants to check whether each
student has passed (score ≥ 45) or failed. Name the two functions
she should use for these two separate tasks.
113. If you wanted to create a formula in Sheet1 that always shows the
value of cell B5 from Sheet3, write the correct formula, and
explain what the “!” symbol does in it.
114. Explain the difference between a relative reference and an
absolute reference using a real-life example involving a bill with a
fixed tax rate applied to varying item prices.
115. A worksheet contains the values 95, 85, and 90 in cells B2, C2, and
D2 for Maths, English, and Computer Science marks respectively.
Write a single formula using a function (not manual addition) that
calculates the average of these three marks, and explain what the
average would represent as a percentage if the maximum marks
for each subject is 100.

ANSWER KEY

Section A: Fill in the Blanks

1. Range
2. Colon (:)
3. Shift
4. Cell address
5. Chart
6. Chart Area
7. Left (text); Right (numbers)
8. Equal (=)
9. Multiplication; Division
10. Absolute; Dollar ($)
11. Mixed
12. Exclamation point (!)
13. Predefined
14. CONCATENATE
15. IF

Section B: Choose the Correct Option

16. b. Colon (:)
17. c. Formulas
18. c. Pie Chart
19. b. Vertical axis
20. d. Hyperlink
21. b. Excel treats the entry as text
22. c. Expressions within brackets/parentheses
23. b. 30
24. b. Relative
25. b. $ (dollar)
26. b. F4
27. c. MOD()
28. b. INT()
29. b. Exc
30. c. Logical

Section C: Identify the Function

31. SUM()
32. PRODUCT()
33. SQRT()
34. POWER()
35. COUNT()
36. ROUND()
37. ABS()
38. MAX()
39. MIN()
40. AVERAGE()
41. RIGHT()
42. LEN()
43. UPPER()
44. NOW()
45. YEAR(TODAY())

Section D: Identify the Chart

46. Bar Chart
47. Line Chart
48. Pie Chart
49. Column Chart
50. Area Chart
51. Scatter (XY) Chart
52. Bar Chart
53. Column Chart
54. Pie Chart
55. Chart Title
56. Plot Area
57. Legend
58. Gridlines
59. Category axis
60. Value axis

Section E: Cell Referencing

61. Relative reference
62. $D$3
63. $A1
64. A$1
65. $D$3 stays unchanged (absolute); B3/C3 change to B4/C4
(relative)
66. =Sheet2!A2
67. Exclamation point (!)
68. Rows; Columns
69. Because the discount percentage must remain the same for every
row; an absolute reference prevents it from changing when the
formula is copied, whereas a relative reference would shift to a
different (empty/incorrect) cell in each row
70. $A$1 (fully absolute)

Section F: Types of Data

71. Text, Values/Numbers, and Formula
72. Text
73. Values/Numbers
74. Any one of: -, +, [, /, ?, >, <, %
75. Because text is non-numeric information (headings, names, titles)
 and Excel cannot perform mathematical operations on characters
that are not numeric data
76. Equal (=) sign
77. False (phone numbers are treated as text since no calculations are
performed on them)
78. Text
79. Formula
80. Value/Number

Section G: Evaluate the Given Formulas

81. 13 − 25 = −12
82. 3 × 16 − 5 = 43
83. MAX(60, 20) = 60
84. ORANGE6
85. POWER(5,2) = 25
86. SQRT(20 + 5) = SQRT(25) = 5
87. 16/2.828… = ≈5.657
88. 5 + 5 = 10
89. (30−40)×50 = −10×50 = −500
90. 50 + (30×40) = 50+1200 = 1250
91. 30×(40+50) − 10 = 30×90 − 10 = 2700−10 = 2690
92. 35.67
93. 2
94. “A2 is not greater than A3”
95. First part (10+102) = 30; second part (10+10)2 = 40; difference =
30 − 40 = −10

Section H: Write the Output

96. 1
97. Comp
98. 7
99. 3
100. 9
101. 14
102. uch
103. examination
104. 64
105. 25

Section I: HOTS (Sample Answers)

106. He should use a Chart, since charts display data in pictorial form,
making it easier to compare values, spot trends, and analyse
relationships at a glance rather than scanning raw numbers.
107. Her mistake is using the + operator instead of a comma to
separate the two text arguments inside CONCATENATE. The
correct formula is =CONCATENATE(F1,F2) (optionally with a
space: =CONCATENATE(F1,” “,F2)).
108. She should use an absolute reference, written as $G$2, so that the
reference to the discount cell remains fixed no matter which row
the formula is copied to.
109. She should use SUM() to calculate the total sales, and COUNT()
(or COUNTIF for a condition) to count the number of transactions;
SUM() adds up values while COUNT() only counts how many
values/entries exist.
110. Since there is no equal (=) sign at the start, Excel will treat
“25+B2” as plain text and will not perform any calculation. The
correct entry should be =25+B2.
111. Using parentheses removes any doubt about the order in which
Excel will calculate a formula, and makes formulas easier to read
and understand, even in cases where the default BEDMAS order
 would already give the correct result.
112. She should use MAX() to find the highest scorer, and IF() to check
whether each student has passed or failed based on a condition.
113. The formula would be =Sheet3!B5. The “!” (exclamation point)
symbol separates the worksheet name from the cell reference,
telling Excel which sheet the referenced cell belongs to.
114. A relative reference to an item’s price will change automatically as
the formula is copied down different rows of items, correctly
picking up each item’s own price. An absolute reference to a fixed
tax rate cell (e.g., $D$2) will not change when copied, so every row
correctly applies the same tax rate stored in that one cell.
115. The formula =AVERAGE(B2,C2,D2) (or =AVERAGE(B2:D2)) gives
the average marks; since the maximum for each subject is 100,
this average value itself directly represents the percentage scored
across the three subjects.