Solutions of Chapter no. 3

 Solution of the chapter 3: Excel- Creating Worksheet

This chapter has the preliminary discussion of the spreadsheet software program like MS-Excel. Learning MS excel will help you to use the program for various purposes, from simple data recording to computing complicated data. Here below solution of the chapter 3 is given for all of you to check and learn along with some images and videos. Hope it will help you in the long run.

A) Tick the correct answer:

1. The collection rows and columns is called ________.

    a) workbook    b) worksheet c) document

    Ans.: b) worksheet

2. We can also select a cell in a  worksheet is ________.

    a) Ctrl              b) Alt             c) Arrow

    Ans.: c) Arrow.

3. The number of columns in a single worksheet is _______.

    a) 16384           b) 16385        c) 16353

    Ans.: a) 16384

4. We can make a worksheet look more attractive and legible by ______.

    a) Editing        b) Formatting c) Correcting

    Ans.: b) Formatting

5. ______ means the way in which data is settled within the boundary off a cell.

    a) Editing        b) Underlining c) Alignment

6. The _______ formatting is used to format the data according to specified condition.

    a) mixed          b) Conditional c) reference

    Ans.: b) Conditional

B. Write "T" for True and "F" for false statements.

1. Cells nay contain four types of data.        

    Ans.: False

2. We cannot save worksheet data as a PDF and HTML file.         

    Ans.: False

3. We cannot cancel the last changes that we made to the worksheet.    

    Ans.: False

4. We can change the font of numbers in Excel.         

    Ans.: True

5. Excel automatically left-aligns the text in a cell and right-aligns the number. 

    Ans.: True

6. Border separated the data from surrounding cells. 

    Ans.: True

C. Fill in the blanks.

1. There are _____ rows and ______ columns in a single worksheet.

    Ans.: 1048576 and 16384.

2. A _____ identifies each column and a ____ identifies each row.

    Ans.: Letter, Number.

3. By Using ______ feature, one can revert the last changes.

    Ans.: Undo

4. ______ command is used to quickly create a merged cell to hold the title text.

    Ans.: Merge and Center.

5. _____ can be added to the cells for separating the data from surrounding cells.

    Ans.: Border

D. Differentiate between the following:

1. Workbook and Worksheet

Workbook: A spreadsheet file is called a workbook, that contains at least 3 worksheets to work with. Workbook is used to maintain data in a collection of worksheets.

Worksheet: A spreadsheet is called a worksheet which is a collection of rows and column. A worksheet can contains 1048576 rows and 16384 columns.

2. Moving Data and Copying Data

Moving Data: Moving data allows us to re-organize data in or worksheets. When we move data, the data disappears from its original location.

Video showing the process of moving data

Copying Data: Copying data allows us to repeat data in our worksheet without having to retype it, it appears in both the original and the new locations.

Video showing the process of Copying data

E. Answer in 1 or 2 sentences.

1.    What is the use of Microsoft Excel?

    Ans.: Microsoft Excel is a powerful spreadsheet program that allows us to organize and         maintain data, complete calculation and represent data in graphs.

2. What is the default row height and column width in excel?

Ans.: The default column width of a cell in 8.43 characters in Excel while the default row height is 15 points.

   

3. Why do we need to select cells in Excel?

    Ans.: We need to select cells in Excel to perform task like editing, calculating and formatting. We can use the Arrow keys (←, ↑,→.↓).

4. What is the need of formatting in Excel?

    Ans.: Formatting in Excel is required to display worksheets in an attractive and more legible outlook. We can make our worksheets more presentable by applying one or several of excel formatting features.

5. What is the use of border?

    Ans.: In worksheet we can use border in cells that will separate data from surrounding cells.

F. Answers briefly:-

1.  What are features of excel?

Ans.: There are various features in excel:

    a) Editing and formatting of data.

    b) Using Formulas and functions.

    c) Printing worksheets.

    d) Creating charts and objects.

2. What is the use of alignment? Name different alignment buttons.

    Ans.: Alignment is the way with which data can be set within the boundary of a cell.

    Different alignment buttons are, 

    a) Align Left button     b) Align Right button     c) Align Center button

    d) Align Top button     e) Align Middle button.  f) Align Bottom button

Video showing all alignment buttons

3. What is the use of conditional formatting? Write steps to remove conditional formatting.

    Ans.: Conditional formatting is a feature to apply some formatting only if data or value of cells meets certain conditions. Conditional formatting can change color of a cell, format fonts by applying conditions manually on any selected cells.

    Steps to remove conditional formatting are as follows:

    a) Click on home,

    b) Click on Conditional Formatting

    c) Click on Clear rules then Click on Clear rules from selected cells.

Image showing the steps of removing conditional formatting