Computer Science
Class-VI
Chapter-6 More About MS Excel 2016
A. Tick the correct answer:
1. What is the file of MS Excel called?
a. sheet b. worksheet c. workbook
Answer: Workbook
2. Which of the following is located on the left side of formula bar?
a. active cell b. name box c. sheet tab
Answer: Name Box
3. Which of the following is used to type a new name of the worksheet?
a. undo b. cut c. rename sheet
Answer: Rename sheet
4. Which of the following is used to paste data in cell?
a. redo command b. undo command c. paste command
Answer: Paste command
5. Which of the following is used to insert cells and columns?
a. formula b. insert cells option c. numbers
Answer: Insert cells option
B. Fill in the blanks:
1. MS Excel is a _________________ program.
Answer: Spreadsheet
2. _____________ is the top border of a worksheet.
Answer: Column Heading
3. ____________ data consists of 0-9 and symbols like +,-,*,/,(,),= etc.
Answer: Numbers
4. ____________ is a combination of numbers, operators and cell addresses.
Answer: Formula
5. ____________ command is used to repeat the last step you performed in the worksheet.
Answer: Redo
C. Write true or false:
1. Active cell is also known as current cell.
Answer: T
2. Scroll bar indicates the current worksheet.
Answer: F
3. Text contains letters, numbers and special characters.
Answer: T
4. Ctrl key is used to select non-adjacent cells.
Answer: T
5. Cut command is used to move contents from one cell to another cell in the same worksheet or in another worksheet.
Answer: T
D. Match the following:
Column A Column B
1. MS Excel file a. Giving a new name to a worksheet
2. Rename sheet b. Workbook
3. Cut and Paste command c. Displays the address of active cell
4. Name box d. Moving text
Answer:
1. b.
2. a.
3. d.
4. c.
E. Answer the following questions:
1. What is the use of MS Excel?
Answer: MS Excel is a spreadsheet application developed by Microsoft. It organizes data in the form of rows and column. It is used for calculations, create charts and graphs.
2. What is the differene between formula bar and status bar?
Answer: Formula bar is used to enter or edit a function, enter formula or any data in cell.
Status bar appears at the bottom of the microsoft excel window.
3. How will you insert cells, rows and columns in a worksheet?
Answer:
1. Select the cells.
2. Click on the home tab.
3. Click on the insert option. Insert cells, insert sheet row, insert sheet column, insert sheet options will appear.
4. Select either of these opotions according to your requirement.
4. Differentiate between undo and redo commands.
Answer: Undo and Redo commands are present in the Quick access toolbar. Undo command is used when you want to cancel the last steps you performed in the worksheet. Redo command is used to see the last change you made in the worksheet.
5. How will you resize a column in MS Excel?
Answer:
1. Select any cell in the column whose width is to be changed.
2. Click on the home tab.
3. Click on the format option.
4. Select the column width in the cell.
5. Type the required column width in the box.
6. Click on OK.
.png)
No comments:
Post a Comment