J J INTERNATIONAL SCHOOL (CBSE) ANAND

STD : 9 CHAPTER: 4 Electronic Spreadsheet(Part B) SUBJECT: Computer

A. Tick the Correct option.

1. The number of rows in Calc worksheet is.
a. 1048576
b. 65636
c. 42384
d. 256
2. The default name for a workbook is:
a. Workbook 1
b. Book1
c. Worksheet1
d. Sheet 1
3. An element in the worksheet which displays the name of the active cell:
a. Formula Bar
b. Name Box
c. Office Button
d. Worksheet tabs
4. For directly editing in a cell for minor changes use the function key:
a. F3
b. F4
c. F2
d. F1
5. The Fonts group is present in this tab.
a. Home
b. Insert
c. Page layout
d. Formulas.
6. ___________key is used to insert a chart quickly.
a. F8
b. F10
c. F11
d. F6
7. A _________ chart displays data In the form of a circle.
a. Bar
b. Pie
c. Column
 d. None of these
8. The cell having a bold boundry in the worksheet is known as:
a. Active cell
b. First cell
c. Last cell
d. New cell
9. The default alignment of text values entered in a cell is:
a. Left
b. Right
c. Center
d. Justified
10. ________ will be the address of a cell formed by the intersection of 6 th row
and 8th column.
a. F8
b. H6
c. H8
d. F6
11. Which of the following is a correct formula?
a. =A1 + B2
b. =1A + 2A
c. #A1 + B2
d. All of these
12. If you delete a row, the rest of the rows:
a. Shift Up
b. Shift Down
c. Remain in same position
d. All of these
13. Which of the following do you click to insert a new worksheet?
a. Insert Worksheet button
b. Add Worksheet button
c. New Worksheet button
d. All of these
14. Which option is used to change the border style and color of chart?
a. Formatting plot Area
b. Formatting data series
c. Both of these
d. None of these
15. The default cell reference in a formula is _________.
a. Relative
 b. Absolute
c. Mixed
d. All of these
16. An absolute reference has a ________ sign along with the column letter
and row number in the cell.
a. *
b. $
c. ?
d. ^
17. Arjun has values entered in a cell B1 down to cell B15. He gives cell range
B3:B10 in a formula. How many values are left out of the range?
a. 7
b. 5
c. 15
d. 22
18. Neha mentions a cell range as A1 : C5. How many cells are in the range?
a. 5
b. 3
c. 15
d. 25
19. Which of the following are often mentioned only as text type in a spread
sheet?
a. Data
b. Labels
c. Functions
d. Formula.
20. When values are changed in the cells, the result of calculations update
according to the changes. This is an advantage related to which of the
following?
a. Functions
b. Formula
c. Charts
d. None of these
21. NAMITA has prepared a list of 2000 employees. Now she needs to give
therm serial number from 1to 2000. Which is the quickest way to do this?
a. Formula
b. Fill handle
c. Copy – paste
d. =Count ()
 22. Arjun is calculating the percentage of 100 students out of five subject with
maximum marks 500.The value 500 is in a cell B2. Which of the following
is the best suited referencing to use to access the value 500 in the formula
for all the student s?
a. Relative
b. Absolute
c. Mixed
d. Any of these
23. Jawahar has stored the formula = B5 + B6 in cell A1. He copied the
formula in cell B1. The changed formula will look like which of the
following?
a. =B6 + B7
b. =C5 + C6
c. =C6 + C7
d. =B5 + B6
24. In absolute cell referencing which of the following remains fixed?
a. Row
b. Column
c. Both of these
d. None of these
B. Very short answer type questions.
1. What is the use of LibreOffice Calc?
Ans. Calc is the spreadsheet component of LibreOffice. You can enter data
(usually numerical) in a spreadsheet and then manipulate this data to
produce certain results.
2. What is active cell?
Ans. An active cell refers to a cell in Excel spreadsheet that is currently
selected by clicking mouse pointer or keyboard keys. Remember only one
cell can be an active cell at a time.
3. How do you select the complete row?
Ans. The correct answer is Shift + Space. Short-cut key to Select entire
row in M.S. Excel Worksheet is Shift + Space.
4. What are the different types of values used in Calc worksheet?
Ans. In Excel, the worksheet consists of a grid of columns and rows that
form cells. You enter three types of data in cells: labels, values, and
formulas.
5. Can you insert a new worksheet in a workbook? If yes, tell the keyboard
shortcut to insert it.
Ans. The “SHIFT + F11” key is the shortcut key to insert a new worksheet.
 6. How do you enter the data into an active cell using the formula bar?
Ans. The formula bar is an empty text box at the top of the workbook. You
can enter data into the active cell on a worksheet by typing the data into the
formula bar and pressing ENTER. The cell reference indicator, a gray box
to the left of the formula bar, shows the address of the active cell.
7. What is AutoSum?
Ans. Autosum is a feature in spreadsheet software, such as Microsoft
Excel, that automatically calculates the sum of a range of cells.
8. What is the keyboard shortcut to move to next worksheet from current
one?
Ans. Ctrl+Page down is the shortcut key to move to the next sheet in a
workbook.
9. What is the use of Autofill handle tool?
Ans. The AutoFill tool in Excel allows for quickly filling many cells to
show a series of numbers, such as processing dates.
10. What is the default style of alignment of numbers and text in calc?
Ans. Default alignment of text or label entry is left alignment and for
numbers and formula it is right alignment.
11. Name the three types of cell references.
Ans. There are three types of cell references in Excel: relative, absolute
and mixed.
12. What are data series?
Ans. A data series is a row or column of numbers that are entered in a
worksheet and plotted in your chart, such as a list of quarterly business
profits.
13. Which chart component helps to recognise different data series?
Ans. The chart legend shows the identification and associated color of each
series. For example, in a bar chart, the yellow bars might represent the
sales of shoes and the green bars might represent the sales of boots.
14. What is the use of chart style commands?
Ans. Chart Styles" is an often requested feature to easily assign charts a
certain set of styles (colours/pattern of data representation, line width,
background colour, charting background, type of legend a.o) to a chart.
15. What is legend?
Ans. A 'legend' is a story from ancient times about people and events.
C. Short answer type questions.
1. What do you do if you want to edit an existing entry of cell?
Ans. Click the cell that contains the data that you want to edit, and then
click anywhere in the formula bar. This starts Edit mode and positions the
 cursor in the formula bar at the location that you clicked. Click the cell that
contains the data that you want to edit, and then press F2.
2. What are the steps to open an existing worksheet in Excel?
Ans. Click the File tab.
Click Open. Press Ctrl + O to quickly display the Open tab of the
Backstage view.
Select the location where the file is saved. You can choose from: Recent:
Recent files you've worked on. ...
Select the file you want to open.
Click Open.
3. why do you apply Wrap Text formatting on cells?

Ans. Wrapping text” means displaying the cell contents on multiple lines,
rather than one long line. This will allow you to avoid the “truncated
column” effect, make the text easier to read and better fit for printing.
4. What do you do to set your content in the center of selected cells?

Ans. Select the Cell Range to Center the Text Across. Press “Ctrl + 1” to
Open the Format Cells Box. Open the “Horizontal:” Drop-Down Menu in
the “Alignment” Tab. Click the “Center Across Selection” Option and
Press the “Enter” Key.
5. How do you insert a currency symbol in a worksheet?
Ans. In the Format Cells dialog box, in the Category list, click Currency or
Accounting. In the Symbol box, click the currency symbol that you want.
6. What is the use of a formula in calc?

Ans. Formulas are equations using numbers and variables to get a result. In
a spreadsheet, the variables are cell locations that hold the data needed for
the equation to be completed. A function is a predefined calculation
entered in a cell to help you analyze or manipulate data in a spreadsheet.
7. What do you mean by formula? Give an example.

Ans A formula is an expression telling the computer what mathematical

operation to perform upon a specific value. ... In the picture below is an
example of a Microsoft Excel formula =SUM(A$1:A$3), which adds the
total of cells A1, A2, and A3. In this formula, SUM is the function of the
formula..
8. What do you mean by function?
 Ans. A function is defined as a relation between a set of inputs having one
output each. In simple words, a function is a relationship between inputs
where each input is related to exactly one output.
9. What is the difference between relative and absolute reference?

Ans. There are two types of cell references: relative and absolute. Relative
and absolute references behave differently when copied and filled to other
cells. Relative references change when a formula is copied to another cell.
Absolute references, on the other hand, remain constant no matter where
they are copied.
10. Explain the types of cell references in brief.

Ans. There are two types of cell references: relative and absolute. Relative
and absolute references behave differently when copied and filled to other
cells. Relative references change when a formula is copied to another cell.
Absolute references, on the other hand, remain constant no matter where
they are copied.
D. Long answer type questions.
1. Explain the components of Calc which help you to perform the basic
functions of the electronic Spreadsheet
Ans. Spreadsheet – a table in which you can enter and manipulate data.
Cell – a table entry. ...
Row – cells aligned horizontally. .
Column – cells aligned vertically.
Range – the specification for a series of cells. ...
Function – an operation applied to a range of cells, always beginning with
an “=” sign.
2. How do you change font size and color of cell's content in Excel?

Ans. Select the cell or range of cells that has the data you want to format.
You can also select just a portion of the text within a cell.
On the Home tab, choose the arrow next to Font Color .
Under Theme Colors or Standard Colors, choose a color.
3. What do you understand by charts? Explain the benefits of using charts.
 Ans. Charts enable you to visually compare multiple sets of data. Charts
can help people better understand and remember information. Many people
understand a picture more quickly than blocks of text. A compelling chart
can help you make your point more convincingly and lend credibility to
your presentation.
4. What is a spreadsheet ?Briefly discuss any 4 major features of a
spreadsheet program.

Ans. A spreadsheet is a tool that is used to store, manipulate and analyze

data. Data in a spreadsheet is organized in a series of rows and columns
and can be searched, sorted, calculated and used in a variety of charts and
graphs.Grids, Rows & Columns. A spreadsheet consists of a grid of
columns and rows. ... Functions. Functions are used in the Spreadsheet
software to evaluate values and perform different kinds of operations.
5. Why do we have absolute and mixed referencing when relative referencing
works well and is so useful?

Ans. A formula's relative references are altered when it is copied to another

cell. Contrarily, regardless of where they are duplicated, absolute
references hold true. By using absolute cell referencing, the cell references
don't change when the formula is copied to a new spot and stay constant.