Workbook 8 — Chapter 3 (Spreadsheet Software) — Answer Key
Q No 1: Objective Type Questions (Answers)
a) ii. Wrap Text
b) iv. all of these
c) ii. 54,612.000
d) ii. Pie chart
e) ii. Data label
f) iv. Both a. and b. (DESIGN and FORMAT)
g) iv. All of these (Chart Elements, Chart Styles, Chart Filters)
h) iv. FIX (not an Excel function)
i) i. Use the SUM function
j) i. Go to the 'Insert' tab and click 'Chart'
Q No 2: Additional (Answers)
1. d. all of them
2. a. Font Formatting
3. a. Bottom Right
4. b. Absolute referencing
5. b. The column is not wide enough to display the value
6. d. Total
7. a. Counts the number of numeric values in a cell range
8. a. Functions
9. a. Comparing trends in data at equal intervals
10. d. All of them
Q No 3: Fill in the blanks (Answers)
1. Pie chart
2. Horizontal axis and Vertical axis
3. Exponent (power)
4. 29
5. #DIV/0!
6. String
7. Hello World
8. Sparkline
9. Alignment
10. Orientation
11. Formula
12. Cell reference
Q No 4: Descriptive Type Questions (Answers)
Ans a. Typing vs Pointing (cell reference):
Typing: You write the cell names yourself, like =A1+B1. This way is
good when you already know the cell addresses.
Pointing: You click the cells with the mouse, and Excel adds their
names automatically. This way is easier and helps avoid mistakes.
Ans b. To see the formula instead of the answer, press (Ctrl + ` )on the
keyboard or go to Formulas → Show Formulas.
You can also click the cell and see the formula in the formula bar.
Ans c.
Addition (+), Subtraction (-), Multiplication (*), Division (/),
Exponentiation (^), Percent (%)
Ans d.
Wrap Text: Keeps all the text in one cell and shows it on more
than one line so it fits properly.
Merge & Center: Joins two or more cells into one big cell and puts
the text in the center.
Ans e.
General, Number, Currency, Accounting, Short Date, Long Date, Time,
Percentage, Fraction, Scientific, Text, Custom
Ans f.
Makes data easy to read and neat.
Shows different types of data clearly (like dates or money).
Helps find mistakes easily.
Makes work look nice and professional.
Easy to print and share.
Ans g.
Common components: Chart area, Plot area, Legend, Axis titles, X-
axis, Y-axis, Data labels, Gridlines, Data table, Chart title, Plot
markers.
- Legend: Explains the different data series shown in the chart.
- Axis titles: Describe what the X and Y axes represent (units,
categories).
- Data labels: Show exact numeric values on the data points for
quick reading.
Extra Questions (Q No 5) — Short Answers
1. Alignment:
Placement of cell contents within the cell boundary (left, center, right,
top, middle, bottom).
2. Orientation:
Rotation or direction of text within a cell (e.g., rotated 45°, vertical).
3. Combo chart:
A combination chart that displays two or more chart types together
(e.g., column + line) to compare different data series.
4. Sparkline:
A tiny, cell-sized chart that gives a visual trend of a series (often used for
quick trend checks).
5. Definitions:
a. Absolute Reference: A reference that does not change when copied,
written with $ signs (e.g., $A$1).
b. Relative Reference: A reference that changes relative to the copied
position (e.g., A1).
c. Mixed Reference: One part fixed and one relative (e.g., $A1 or A$1).
d. Circular Reference: A formula that refers to its own cell either directly
or indirectly, causing iterative calculations or errors unless enabled.
Q No 9: Error Reasons (Filled Table)
###### — Column is too narrow to display the value
#DIV/0! — Division by zero (a formula attempts to divide by zero or an
empty cell).
#N/A — Value not available
#NUM! — Invalid numeric value
#REF! — Invalid cell reference (a referenced cell was deleted or is
invalid).
#VALUE — Wrong type of argument or operand (e.g., text used where
number expected).