Page 287 - Computer - 9(A&B)

• Arguments are the piece of information like cell range, cell address or constants supplied to the function.
• Some important function in Calc are: SUM, AVERAGE, MAX and MIN.
• The Orientation option is used to rotate the text in variety of ways.
• Text Control provides important options: Wrap text, and Shrink to fi t.
• Wrap Text helps multiple lines of text to be displayed in a single cell.
• If a small amount of data is not visible in a cell, you can reduce the font size of the data so that you don’t have to resize the
column.
• Numbers, currency, percentages, date and time are all treated by Calc as numerical values.
• The AutoFill feature of Calc is used to quickly fi ll a predefi ned series of data such as text or number in a worksheet.
• Charts are the pictorial representation of data values arranged in the form of rows and columns.
• Value axis is the vertical axis of the chart along which the value of each data point is plotted.
• A descriptive text that appears data on the top of the chart is called chart title.
• Calc provides various types of charts like column chart, line chart, pie chart, bar chart, area chart and scatter chart.

Self-Assessmentlf-Assessment
Se

A. Tick () the correct option.

1. The number of rows in a Calc worksheet is:
1048576 65536 42384 256
2. The default name for a new Calc workbook is:
Workbook1 Book1 Worksheet1 Untitled 1
3. An element in the worksheet which displays the name of the active cell:

Formula Bar Name Box Offi ce Button Worksheet tabs
4. A ________________ chart displays data in the form of a circle.

Bar Pie Column None of these
5. The cell having a bold boundary in the worksheet is known as:
Active cell First cell Last cell New cell

6. The default alignment of text values entered in a cell is:
Left Right Center Justifi ed
7. ______________ will be the address of a cell formed by the intersection of 6th row and 8th column.

F8 H6 H8 F6
8. Which of the following is a correct formula?

= A1+B2 = 1A+2A #A1+B2 all of these
9. If you delete a row, the rest of the rows:
shift up shift down

remain in same position all of these
10. Which of the following buttons is used to insert a new worksheet?
Insert Worksheet button Add new sheet
New Worksheet button All of these
11. The default cell reference in a formula is ______________.
relative absolute mixed All of these

149
149