Class 5th Ch-5 Introduction to MS Excel

 Class-5th Introduction to Ms Excel 

A. Multiple Choice Questions

1. *d. H3* 

2.

   *b. Formula Bar*  

   

3. *Which of the following keys is used to edit a cell?*  

   *a. F2* 

4. *

   *c. Cell*  

5. 

   *c. Both a) and b)*  

   

---

*B. Fill in the blanks*

1. *Calc* is a spreadsheet program while *Google Sheets* is online spreadsheet.

2. Organising data in an order is called *Sorting*.

3. Cell C5 has the rectangular cursor on it. C5 is a/an *Active* cell.

4. Non-adjacent cells can be selected using *Ctrl* key.

5. Using *Tab* key is a better way of entering data in Excel.

*C. True or False*

1. True

2. False

3. False 

4. True

5. True

C. Answer the following questions in short..

1. *What is extension of Excel?*  

   *Ans.* The default extension of Excel is `.xlsx`.

2. *What is Excel?*  

   *Ans.* Excel is a spreadsheet program used to store, calculate, and analyze data in rows and columns.

3. *Who developed Excel and when?*  

   *Ans.* Microsoft developed Excel and it was first released in 1985.

4. *What is cell?*  

   *Ans.* A cell is the intersection of a row and a column where data is entered in Excel.

*D. Answer the following questions*

1. *What is an electronic spreadsheet? Write the names of any 2 spreadsheet programs.*  

   An electronic spreadsheet is a computer application used to store, organize, calculate and analyze data in rows and columns.  

   Examples: *MS Excel, Google Sheets* _or_ *LibreOffice Calc*

2. *List any 4 features of MS Excel.*  

   - *Formulas and Functions* - for calculations like SUM, AVERAGE

   - *Charts and Graphs* - to visualize data

   - *Sorting and Filtering* - to organize data

   - *Formatting options* - to make data look attractive with colors, borders, etc.

*Q.3 Use of Cell Name box and Formula Bar - Short Answer*

*Cell Name Box:*  

It shows the address of the currently active cell. We can also type a cell address here to go directly to that cell.

*Formula Bar:*  

It shows the content or formula of the active cell. We can view and edit the data of a cell using the Formula Bar.

*Q.4 How will you do the following? - Short Answer*

*a. Edit a cell:*  

Double-click on the cell *OR* Select the cell and press `F2` key *OR* Edit in the Formula Bar and press Enter.

*b. Rename a worksheet:*  

Right-click on the sheet tab → Click *Rename* → Type new name and press Enter.

*c. Wrap text:*  

Select the cell → Go to *Home tab* → Click *Wrap Text* option

.