Chapter 9 (IT) –
Electronic Spreadsheet
ANSWERS OF CLASS IX – CHAPTER 9 – ELECTRONIC SPREADSHEET
A 1. Which of the following consists of rows and columns?
(a) Worksheet
(b) Title Bar
(c) None of these
2. A cell is identified by __________
(a) A row number (b) A column letter (c) A column letter followed by a row number
3. Which of the following shows you the location of an active cell?
(a) Formula bar
(b) Status Bar
(c) Name box
B 1. What is a spreadsheet?
A spreadsheet is a collection of data and information organized in the form of rows and columns.
2. What is a range of cells?
A group of adjacent cells is known as a range of cells.
3. Define an active cell.
A cell with a dark boundary is known as active cell.
A 1. Which of the following allows us to create a new copy of an existing file to update changes and keeps the previous one, while saving an existing file?
(a) Save
(b) Copy existing
(c) Save As
2. What do you do to save the changes in an existing file?
(a) Use ‘Save’ button
(b) Press Ctrl+N from keyboard
(c) Use ‘Save As’ option
3. What is the keyboard shortcut to create a new workbook?
(a) Ctrl + T keys
(b) Ctrl + N keys
(c) Ctrl + M keys
B 1. Can you insert a new worksheet in a workbook? If yes, tell the keyboard shortcut to insert it.
Yes a new worksheet can be inserted in a workbook .
The shortcut key to insert it is Shift + F11 key
2. How do you enter the data into an active cell using the formula bar?
We enter data into an active cell using the formula bar by clicking in the formula bar and then typing the data.
3. What do you do if you want to edit an existing entry of cell?
To edit an existing entry of cell select the cell and press F2 key. Then move the cursor to the required position and correct it. Finally press the Enter key.
4. Tell the keyboard shortcut to open a cell in edit mode.
The keyboard shortcut to open a cell in edit mode is F2 key.
5. What happens when you close the Excel application without saving it?
When we close the Excel application without saving it will notify us that the current file is not saved and ask us if we want to save the file with options Yes, No and Cancel
A 1. In Excel, a formula begins with a/an
(a) equal to (=) sign
(b) plus (+) sign
(c) hash (#) sign
2. What is used as a separator for numerical values in thousands, one hundred thousands, etc.?
(a) Comma
(b) Decimal
(c) Hash
B 1. How many types of data can be entered in the cells?
Three types of data can be entered in the cells. They are Numbers or Date, Formula and Text.
2. Define the Text type of data.
Text type of data included a combination of letters, numbers and special characters.
A 1. What will the following expression evaluate to, in Excel? 2+3*4+5
(a) 45
(b) 19
(c) 29
2. What does the following expression evaluate to? (2+3)^2
(a) 24
(b) 11
(c) 25
3. What is the name given to pre-defined formulas in Excel?
(a) Formulae
(b) Functions
(c) Headers
B 1. Give the name of any three functions in excel?
Name of any three functions in excel are SUM(), AVERAGE() and MAX().
2. Give an example of how the AVERAGE function is evaluated?
The AVERAGE function will sum the numbers in the specified range and then divide it by the number of numbers in the range.
A 1. In which tab of the Format cells dialog box can you find the Wrap Text option?
(a) Number
(b) Font
(c) Alignment
2. What category of Number in Format cells dialog box allows changing of one time type to another?
(a) Number
(b) Date
(c) Time
3. What is the first step (after making the active cell) to take to change a number into scientific format?
(a) Right-click on cell
(b) Left-click on cell
(c) Scroll with mouse
B 1. If changed to scientific format, what will be the value of 0.002?
If changed to scientific format the value of 0.002 will be 2.00E-03
2. What are the steps to change a date format using Format Cells dialog box?
The steps to change a data format using Format Cells dialog box are as follows:
Click on Date under Category box
Select the type of date format from the type box
A 1. Which of the following is Autofill handle a part of?
(a) Ms Word
(b) Ms Excel
(c) Ms Powerpoint
2. If you do not use the $ sign anywhere, what type of cell reference will it be?
(a) Relative
(b) Mixed
(c) Absolute
3. Which keyboard shortcut can let you quickly add a chart after the selection of range of cells?
(a) F5
(b) F10
(c) F11
B 1. Describe the following charts:
(a) Pie chart
(b) Line Chart
(c) Column Chart
a) Pie chart shows the parts of the whole items that make up a data series to the sum of the items.
b) Line Chart shows trends in data at equal intervals. It is helpful for depicting the change in value over a period of time.
c) Column Chart shows data changes over a period of time or defines comparisons among individual items.
2. What is the difference between category axis and value axis?
The X-axis or horizontal axis is called Category axis while Y-axis or vertical axis is called Value axis.
3. What is the chart area and the plot area in a chart?
Ans The total region of the chart in which the chart is defined is called Chart Area while the area of the chart in which the data is plotted is called Plot Area.
Exercises
A 1. Which of the following is arranged in groups?
(a) Ribbon
(b) Scrollbars
(c) Formula bar
2. Which of the following lists the location of an active cell?
(a) Quick Access toolbar
(b) Worksheet
(c) Name Box
3. Which of the following is an example of mixed reference?
(a) A12 (b) $W$11
(c) $D12
(b) $W$11
4. Which of the following will take you to the last cell containing data in the worksheet?
(a) Ctrl + Home
(b) Ctrl + End
(c) Ctrl + Down arrow
(b) Ctrl + End
5. Which of the following do you press to open Save As dialog box?
(a) Ctrl + S
(b) Alt + S
(c) Shift + S
6. Which of the following is a keyboard shortcut to open a new workbook?
(a) Ctrl + N
(b) Ctrl + M
(c) Ctrl + W
7. A cell with a dark boundary is known as a/an:
(a) Inactive cell
(b) Active cell
(c) Working cell
Ans b
8. What is the extension of a workbook saved in Excel 2010?
(a) .xls
(b) .xl
(c) .xlsx
9. What type of chart looks circular in nature?
(a) Scatter chart
(b) Pie chart
(c) Radar chart
10. What character does every formula start with?
(a) Equal to (=)
(b) Colon (:)
(c) Semicolon (:)
B 1. What is cell reference?
Cell reference is the address of a cell in a formula.
2. How do you insert a new worksheet?
A new worksheet can be inserted by pressing Shift + F11
3. Explain how the & operator works on text.
The & operator is used to concatenate two texts. Example “APS” & “ Bengdubi” will produce the result as APS Bengdubi.
4. What is the purpose of the Enter and Cancel buttons to the left of the formula bar?
The Enter button to the left of the formula bar is used to accept the data while the Cancel button is used to reject the data.
5. What is the difference between Save and Save As in Excel?
Save is used to save the changes made in the existing file while Save As is used to create a new copy to update the changes and keep the previous file as it is.
6. How are dates interpreted in Excel?
Dates can be represented in Excel as dd-mm-yyyy, dd-mm-yy, dd-m-yy, dd.m.yy, yyyy-mm-dd and dd mmm yyyy.
C 1. What is Excel?
Excel is a spreadsheet program which consists of data and information in the form of row and columns.
2. Give example of the Text data type in Excel and how can they be concatenated using operator of Excel?
An example of text data type in Excel is “Suman Jha” and “Rajesh Rai” .
3. What is Name box?
The Name box is the one which shows the address of the active cell.
4. What are the steps to change a decimal number into the scientific format?
Ans-Steps to change a decimal number into the scientific format are
Right click on the cell
Click on Format Cells option. The Format Cells dialog box appears.
Select the Scientific option under Category
5. What is a function? Give four examples.
A function is a pre-defined formula in Excel.
Four examples of functions are SUM, AVERAGE, MAX and MIN.
