Solved Exercise:
Unit-III(Session-2)
I. Multiple choice questions. Tick the correct answer.1. Which option lets you access the password creation facility in Excel 2007?
a. home tab b. insert tab c. office menu d. file tab
Answer: Office menu
2. Which of these displays the address of the cell selected in the worksheet?
a. name box b. formula bar c. home tab d. title bar
Answer: Name box
3. Which tab contains the cut, copy and paste commands?
a. view tab b. insert tab c. review tab d. home tab
Answer: Home tab
4. A group of adjacent cells taken together form a :
a. active cell b. cell range c. workbook d. worksheet
Answer: Cell range
5. By default how many workbooks are there in a workbook in MS Excel?
a. Two b. three c. four d. one
Answer: Three
II. Short Answer Questions.
1. What is a spreadsheet? Name some important spreadsheet software available in the market.
Answer: A spreadsheet is an application software that helps to enter number and text in tabular form and provide tools to calculate, manipulate and organize information like sorting a list of names or ordering records and analyzing information using mathematical formulae.
A Spreadsheet software has large number of in built functions.
2. What is a worksheet? How is it different from a workbook?
Answer: A worksheet is a single spreadsheet page and a workbook is a collection of many worksheets. A workbook contains worksheets, in the same way as a book contains pages. For example, a workbook may contain two worksheet with data and a third worksheet containing a chart on those worksheets. By default, an excel workbook has three worksheets.
3. What is a cell? How is a cell different from an active cell?
Answer: The excel spreadsheet consists of horizontal rows and vertical columns. Cells are rectangular boxes formed at the intersection of a row and column where actual data is entered.
In MS Excel every rectangular box is a cell and a selected cell (where cursor present) is called active cell.
4. How many types of data can be entered into a worksheet in MS Excel?
Answer: You can enter three types of data in a worksheet-Text, Numbers and Formulae. Any entry that is not a number or formula is treated as text by Excel. To enter data in a worksheet, either it is typed at the currently active cell, i.e. where the cell pointer is in the worksheet or by typing data in the formula bar.
5. What do you understand by moving data on a worksheet? Write any way to move data.
Answer: Moving means to remove data from one place and paste it at some other place. Way of moving data in Excel.
1. Select the cell/cell range. Use the Ctrl+X keys to cut the data. Use the Ctrl+V keys to paste the data to a desired location.
2. Right click on the selected cell and select the cut option from the shortcut menu.
3. Select the cell/cell range and place the pointer over the border of the selected range so that the pointer changes shape. Drag to move the data to a new location. Hold down the Ctrl key while dragging if you want to copy the data.
Some other links:
No comments:
Post a Comment