Descriptive Type Questions :
1. What do you understand by MS Excel ?
Ans. MS Excel is a popular spreadsheet software that is designed by Microsoft . It is a powerful tool that helps us to organize , calculate and analyze data arranged in the form of rows and columns . It also allows us to represent the data pictorially in the form of a chart and make complex accounting , mathematical and financial calculations.
2. Differentiate between Workbook and Worksheet.
Ans. Workbook is an Excel file. It is temporarily assigned the name Book1. Worksheet is an area inside a workbook that consists of Rows and columns. These are named as Sheet1 , Sheet2 , Sheet3 etc. A workbook is a collection of worksheets and should have minimum one worksheet.
3. What is a cell ? How many characters can a cell contain ?
Ans. A cell is an intersection of a row and column in a worksheet. Each cell is denoted by a cell address. For eg : A5 denotes the cell that is present at the intersection of Column A and Row 5. A cell can contain upto 32,767 characters.
4. What is a Formula bar ? How is it different from the Name box ?
Ans. The Formula bar is an area below the ribbon that shows the characters and formulas entered in the active cell. But , Name box is an area that displays the location of the cell pointer or active cell address. It is present towards the left of formula bar.
5. How can you rename a worksheet ? Explain.
Ans. To rename a worksheet , double-click on the sheet name in the worksheet tab and type a new name . (or) Right-click on the Sheet name in the worksheet tab and select Rename option. Type and new name and press Enter.
Computer Notes 2019-20 