Solved Exercise:
Class-6th
Chapter-5 MS Excel
A. Multiple choice questions:
1. Excel is a spreadsheet program in the Microsoft_____ system.
a. software b. office c. basic d. regular
Answer: office
2. In Excel we can use various ________ and a variety of professional looking chart.
a. programming b. task c. calculations d. chart
Answer: calculations
3. You may use format numbers, data or time from the ______ section.
a. category b. function c. page layout d. view
Answer: category
4. You may also click on the enter button on the _____.
a. title bar b. function bar c. cell bar d. formula bar
Answer: formula bar
5. You can add borders to individual cells to emphasize or define sections of a ___________ or table.
a. worksheet b. border c. cells d. columns
Answer: worksheet
6. Click, no border option in the borders button's drop-down menu to _ borders.
a. add b. remove c. shrink d. merge
Answer: remove
7. You can also use the grow font and shrink font commands to change the ______.
a. size b. button c. grid d. font
Answer: size
B. Write 'T' for true and 'F' for false:
1. You can use Excel to create and format workbooks in order to analyze data.
Answer: T
2. ##### is a valid formula.
Answer: F
3. It is not important to type'=' before a formula or a function.
Answer: F
4. Min() calculates the sum of all values.
Answer: F
5. A formula is an equation that performs a calculation.
Answer: T
6. You can also change the cells, text, fonts, patterns and cells borders directly from the buttons given in the Menu bar.
Answer: T
7. #N/A is used for invalid data.
Answer: F
C. Fill in the blanks:
1. Numbers entered in an ______ could be a value, data or time.
Answer: MS Excel
2. ________ features appear on the dialog box.
Answer: Formatting
3. The data entered in a worksheet can be ________ in MS Excel worksheets.
Answer: Modified
4. You can remove the display of _____________ by clearing the view check box.
Answer: Grid lines
5. You can also use the _______ and shrink font commands to change the size.
Answer: Grow font
6. Excel uses__________ operators for equations.
Answer: Standard
7. Count() function counts the _________ values.
Answer: Cells
D. Answer the following questions in short:
1. What is the purpose of sum function?
Answer: It is use to add up all the values in a range of cells.
2. What is the purpose of average function?
Answer: It calculates the average of the cell values.
3. What is the purpose of count function?
Answer: It counts the cells values.
4. What do you mean by no border button?
Answer: No border. option is used to remove the border.
E. Answer the following questions in detail:
1. What is MS Excel? Explain.
Answer: MS Excel is a spreadsheet program in the Microsoft office system. You can use excel to create and format workbooks in order to analyze data and make more informed business decisions.
2. What is formatting number?
Answer: Numbers entered in an MS excel could be a value, data or time.
1. Select the range of the cells that you wish to format.
2. Click on Home tab.
3. Click on format cells or you can use Ctrl+Shift+F.
4. You may use to format numbers, data or time from the category section of the dialog box.
5. Click on OK.
3. What is Border Formatting?
Answer: You can add border to individual cells to emphasize or define sections of a worksheet or table.
Use the borders button in the font group on the home tab to add borders of varying styles. and colors.
4. Write steps to change font size.
Answer:
1. Select the cells you want to modify.
2. Click on font size command.
3. Move your mouse over the various font sizes.
4. Select the font size you want to use.
5. What happen, if the formula or a function is typed incorrectly? Give some common errors displayed in MS Excel and their possible reasons.
Answer: If the formula or a function is type incorrect, error message will display. Some common errors are:
1. #####- The column is not wide enough to display result or the value.
2. #DIV/O!- Division by zero error
3. #N/A- Data unavailable
4. #VALUE- Invalid data
F. Rearrange steps to formatting numbers:
1. Click on format cells or you can use Ctrl+shift+F.
2. Select the range of the cells that you wish to format.
3. Click on OK.
4. Click on Home button.
5. You may use choose to format numbers, data or time from the category section of the dialog box.
Answer:
1. Select the range of the cells that you wish to format.
2. Click on Home tab.
3. Click on format cells or you can use Ctrl+Shift+F.
4. You may use to format numbers, data or time from the category section of the dialog box.
5. Click on OK.
Some other links:
No comments:
Post a Comment