Computer Science
Class-VII
Chapter-2 MS Excel
Section-1
A. Answer these questions:
1. What are spreadsheets?
Answer: Spreadsheet is a page in Excel displaying data in the form of rows and columns.
2. What is a formula bar?
Answer: Formula bar containing the various formulas which can be used for calculations in a worksheet.
3. What is a cell?
Answer: Intersection of rows and columns is called a cell.
B. Tick the correct option:
1. MS-Excel is part of :
a. MS- Office b. operating system c. Package d. all of these
Answer: MS Office
2. Cell is the intersection of:
a. vertical and horizontal line b. horizontal and vertical planes
c. rows and columns d. none of these
Answer: Rows and columns
3. By default values are displayed as:
a. currency b. dollar c. rupee d. general number
Answer: General number
4. How many decimal places can there be in a cell?
a. 1 to 10 b. 1 to 15 c. 1 to 13 d. 1 to 20
Answer: 1 to 15
Section-2
A. Fill in the blanks:
1. A cell is formed by the intersection of _______ and a _________.
Answer: Rows and columns
2. _________ is known as workbook.
Answer: Multiple worksheet
3. You can either arrange data in ________ and _____ order.
Answer: Increasing and decreasing
4. Spreadsheets are also known as __________.
Answer: Worksheets
5. Formula bar is mainly used for _____________.
Answer: Calculations
B. Match the following:
Column A Column B
1.Title bar a. Combination of rows and columns
2.Cell b. text entries
3.Workbook c. where programs name appear
4.Formula bar d. multiple worksheets
5.Labels e. contains formula
Answer:
1. c
2. a
3. d
4. e
5. b
C. Answer the following questions:
1. What are the uses of MS -Excel? Write some features of MS Excel.
Answer: MS Excel is used in areas that involve complex calculation and analysis.
MS Excel features are:
Excel is the best package to do calculation and update data.
Excel provides facilities to make charts, graphs and pictures.
You can arrange the data either in increasing or decreasing order.
2. Why is it necessary to change the column width? Explain the steps to change column width.
Answer: Sometimes entry in a column is too long to fit in a cell. In this situation we need to increase the width of a column to make entry readable.
Steps to change the column width.
Step 1: Type the text in any cell.
Step 2: Move mouse pointer to the dividing line between column headers.
Step 3: Hold down the left mouse button and drag it to right or left depending upon you.
Step 4: Release the mouse button. Column width will be adjusted according to the entry.
3. How do you merge and center the text? Explain the steps.
Answer: If you want to place the text or header at the center of worksheet then follow the steps:
Step 1: Type the text in cell A1.
Step 2: Select the cell A1 to E1.
Step 3: Click on Merge and Center button present on formatting toolbar.
4. What is alignment? How will you align cells in MS Excel?
Answer: Alignment refers to the positioning of character within the cell. By default you can change the alignment according the need either to the left, right, entered or justified.
Follow the steps to formatting the cell:
Step 1: Select the cell to be formatted.
Step 2: Click on format menu and format cells option.
Step 3: Select the alignment.
Step 4: Click on the horizontal list box. Choose center for centering the data.
Step 5: You can also change the degree of text.
Step 6: Click on Ok button.
5. Explain the steps to change the decimal points in a cell.
Answer: Steps to change decimal points in a cell:
Step 1: Select the cells.
Step 2: Click on the increase decimal button present on toolbar.
Step 3: If you click on increase decimal button, then only one additional decimal place will be displayed. It increases one by one by clicking.
6. How do you delete cells, rows and columns from the worksheet?
Answer: Follow the given steps for deleting cells:
Step 1: Select the cell.
Step 2: Select the delete option from the edit menu.
Follow the given steps for deleting row and column:
Step 1: Select row or column that you need to delete.
Step 2: Select the delete option from the edit menu. Delete dialog box will appear.
Step 3: Select entire row or entire column to delete and click on OK button.
Some other links:
No comments:
Post a Comment