2.
Name the term or option used for the following:
a. A group of selected cells that are adjacent to each other-Cell range
b. An option that displays the content in a cell in multiple lines by increasing
the height of the row-Wrap text
c. It determines how the content, such as text or numbers, is displayed
horizontally and vertically within a cell.-Alignment Text
d. A number format that multiples the cell value by 100 and displays the result
with a percent symbol.-Number Format Percent
e. A function that is used to find the lowest value in a range of cells or a set of
numerical values.-min()
f. It is used to fill a series of values, such as Monday, Tuesday, in a selected
range of cells-Auto fill generating series.
3. Answer the following:
a. What is spreadsheet application used for?
A spreadsheet application is used to store numerical data in a tabular
form, perform calculations and analyses the data by generating charts.
b. Differentiate between a workbook and worksheet.
Workbook Worksheet
Workbook is a file containing A worksheet has a single
many worksheet spreadsheet containing data.
Workbook cannot be added Worksheets can be added in a
within the worksheet workbook.
c. Look at spreadsheet created in Openoffice Calc and answer the following
questions.
i. Write the formula to find the total marks of all the subjects for each
student. =sum(b2:d2)
ii. Write the formula to find the highest marks in Math.=max(c2:c6)
