UNIT 9 Notes

PART B – UNIT 9 Electronic Spreadsheet
EXERCISES
Multiple Choice Questions
1. C) Function Wizard
2. A) 1048576
3. C) Formula
4. A) The page Style
5. C) Active cell
6. A) It will show up as 0
7. C) An equal to (=) sign
8. A) ^
Short answer questions (I)
1. What is cell reference?

The cell address of a cell in a formula is called cell reference.
2. Explain how the & operator works on text.

& is used for string concatenation.For example , =A1 &B will combine the strings within A1 and
B2 and place it as the formula cell.
3. How are dates interpreted in Excel?

Dates are interpreted as Numbers if it is entered in American time format, such as mm-dd-yy
and cannot be interpreted if entered in Indian format (dd-mm-yy).
4. What information does the name box and formula input line display?
The Name box give the cell reference using a combination of a letter and a number
eg.A1
Input line allows a formula to be entered. Also the ‘Input line’ displays the contents of
the selected cell (data, formula, or function) and allows you to edit the cell contents.
5. Name four tasks which spreadsheets allow us to do.

i. To arrange data in a tabular form
ii. To Maintain and analyze data
iii. To perform financial calculations
iv. To manage Inventory
6. How can you rename a sheet in Calc.?

To change the default name for a sheet (Sheet1, Sheet2, and so on):
1. Right-click on the sheet tab and select Rename Sheet from the context menu. A dialog
opens allowing you to type in a new name for the sheet.
2. Click on OK when finished to close the dialog box.
Short answer questions (II).
1. How are numbers represented in Calc?

Numbers in calc are represented as Date, Time , Currency, decimal data and also as text
data.
2. What are the mathematical operators in Calc? Assign them precedence.
Operator Precedence
() - Brackets First
^ - Exponentiation Second
/, * - division and Multiplication Third
+ , - Addition and Subtraction Fourth
3. How can you automatically wrap multiple lines of text in a cell?

1. Select the cell or a range of cells.
2. Right-click on the selection and select Format Cells from the context menu, or go box to
Format >Cells on the menu bar, or press Ctrl+1 to open the Format Cells dialog.
3. Click on the Alignment tab
4. Under Properties, select Wrap text automatically and click on OK.
4. How can you format cell backgrounds in Calc?

To format the background color for a cell or a group of cells:
1. Select a cell or a range of cells.
2. Right-click on the selection and select Format Cells from the context menu, or go to
Format > cells on the menu bar, or press Ctrl+1 to open the Format Cells dialog box.
3. Click on the Background tab.
4. Select a color from the color palette.
5. Click on OK to save your changes and close the dialog.
5. How do you format cells to display times?

i. Make the cell containing the time active.
ii. Right click on the cell
iii. Click on the format cells from the context menu that appears.
iv. Click on time from the category part
Long answer questions.
1.Assume that you have a rectangular array of data on the Calc sheet. How will
you calculate to the right of each row of the table? For example:
A B C D E
1 Average
2 2 12 5 6
3 4 12 8 7
4 12 6 3 15
1. Open calc and enter the data as shown above in the respective cells
2. Click on the cell E2, and enter the formula =average (A2:D2)
3. Press Enter.
4. Hold the fill handle on the corner of the active cell and drag it till the last row.
5. Release the fill handle and now we can see that the average is calculated for all rows.
2. Explain any five elements of the Calc interface.
Title Bar
The Title bar, located at the top, shows the name of the current spreadsheet. When the
spreadsheet is newly created, its name is Untitled X, where X is a number. When you
save a spreadsheet for the first time, you are prompted to enter a name of your choice.
Menu Bar
Under the title bar is the menu bar.When you choose one of the menus, a submenu
appears with other options.Some of the options in the menu bar are file, Edit, view,
Insert , format styles , sheet, tool, data , window and help.
Active Cell
This is the cell in the spreadsheet with a dark boundary. You can type in into only this
cell. In order type in data in a cell, you must make that cell active by clicking on it and
typing in the data.
Active Cell Reference (Name Box)
This box, known also as Name Box, shows the address of the active cell. As the active
cell changes, the contents in this box also change accordingly.
Status Bar
The Calc status bar provides information about the spreadsheet and convenient ways to
quickly change some of its features like page style, zoom percentage etc.
3. How will you increase the decimal places shown by a number in worksheet
from 2 to 5?
Formatting a Range of Cells with Decimal Places
We may format the cell(s) of worksheet in order to change the decimal places occupied by the
numbers.
Follow these steps to change the decimal places used to express the numbers.
1. Select the cell(s) to make it active.
2. Right-click on the cell or range and from the context menu, choose Format Cells.
3. From the Format Cells dialog box, choose Number as Category and Decimal places, for
example to 5.
4. Press on OK button and check the changes in the worksheet data.
4. How can you format a cell range to represent numbers in scientific format?
Formatting of a Cell Range as Scientific
There are various Scientific ways in which a number, usually a large or very small one can be
expressed. To get a good idea, we may use the Format Cells dialog box and choose the
scientific option of it. For example, consider that you have entered a very small positive number
like, 0.000000023.
To represent the above number in Calc would be to:

1. Right-click on the cell.
2. Click on Format Cells option. The Format Cells dialog box appears.
3 Choose the option Scientific from Category.
On changing the decimal places spinner box to what you want (or even without changing), and
click the OK button, the scientific format is applied.
For example, after pressing OK on the dialog box, the entered number changes to: 2.30E-0E

UNIT 9 Notes

Uploaded by

Copyright:

Available Formats

UNIT 9 Notes

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

UNIT 9 Notes

Uploaded by

Copyright:

Available Formats

PART B – UNIT 9 Electronic Spreadsheet

Short answer questions (I)

1. What is cell reference?

2. Explain how the & operator works on text.

3. How are dates interpreted in Excel?

5. Name four tasks which spreadsheets allow us to do.

6. How can you rename a sheet in Calc.?

Short answer questions (II).

1. How are numbers represented in Calc?

3. How can you automatically wrap multiple lines of text in a cell?

4. How can you format cell backgrounds in Calc?

5. How do you format cells to display times?

Long answer questions.

Formatting a Range of Cells with Decimal Places

Formatting of a Cell Range as Scientific

To represent the above number in Calc would be to:

You might also like