Computer Science
Class-VI
Chapter-7 Formatting in MS Excel 2016
A. Tick the correct answer:
1. Which of the following is used for changing font of text?
a. number b. font c. style
Answer: Font
2. Which of the following will make the text bold?
a. bold option b. auto format c. Quick access toolbar
Answer: Bold option
3. Which of the following is used for arranging data in ascending or descending order?
a. merge and center b. sorting c. align text left
Answer: Sorting
4. Which of the following allows to manipulate records as group?
a. alignment group b. filtering c. paragraph
Answer: Filtering
5. Sort and Filter option is in which of the following groups?
a. font b. cells c. editing
Answer: Editing
B. Fill in the blanks with the help of words given in the box:
(Autosum, Changing Alignment, Number Formatting, Autofill, Formatting)
1. ............................ means changing the appearance of the text in a worksheet.
Answer: Formatting
2. Changing the placement of the cell contents with respect to the cell margins is called....................................
Answer: Changing alignment
3. .................... means changing the appearance of numbers without changing their values.
Answer: Number formatting
4. ....................... will automatically fills the remaining characters of the series for you.
Answer: Autofill
5. ...................... is used to find the sum of a series in a row or column quickly.
Answer: Autosum
C. Write true or false:
1. Fonts are the different styles of lettering.
Answer: T
2. Two or more adjacent cells cannot be merged to create a single cell.
Answer: F
3. AutoFormat layouts have coloured backgrounds, borders and attractive text formatting.
Answer: T
4. Number option is not present in the format cells.
Answer: F
5. When a formula contains a cell address, it is called a cell reference.
Answer: T
D. Answer the following questions:
1. What is formatting? How will you change the font of text?
Answer: Formatting means changing the appearance of the text in a worksheet.
To change the font type, follow the given steps:
1. Select the desired cell or range of cells.
2. Click on the home tab.
3. Click on Font option.
4. Select the desired font name from the list.
2. Write the steps involved in AutoFormatting.
Answer: Steps involved in AutoFormatting:
1. Click on the customize quick access toolbar button.
2. Click on the more command option.
3. Click on choose commands.
4. Select autoformat option.
5. Click on add button.
6. Click on OK.
3. What are the steps for creating formula using Point and Click method?
Answer: To create a formula using the point and click method:
1. Select the cell where the answer will appear.
2. Type equal sign'='.
3. Click on the first cell to be included in the formula.
4. Type the operator you need for your formula.
5. Click on the next cell in the formula.
6. Press Enter key.
4. How will you edit a formula in MS Excel?
Answer: To edit a formula in MS Excel follow the steps:
1. Click in the formula bar. Cursor will appear in the formula bar.
2. Now you can delete or add in the formula.
3. Click Enter.
5. Write the steps for filtering numbers and text.
Answer: Steps for filtering numbers and text:
1. Select the range of data.
2. Click on sort and filter option.
3. Click on the filter option.
4. Select the values that have to be filtered.
5. Click OK.
E. Match the following:
Column A Column B
1. AutoFill a. Different style of writing
2. AutoFormat b. Two or more adjacent cells can be merged to create a single cell
3. Fonts c. A predefined list of layouts in Excel
4. Merge and Center d. Automatically fills the remaining characters of the series for you.
Answer:
1. d.
2. c.
3. a.
4. b.
.png)
No comments:
Post a Comment