.png)
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