Formatting Worksheet in MS Excel Class 6 MCQ: CBSE Board Class 6 Computer MCQ Questions and Answers with elaborate explanation. Students get here all Important MCQ on Formatting Worksheet in MS Excel Class 6.
Formatting Worksheet in MS Excel Class 6 MCQ with Answers and Explanations:
1.) It is used to display the worksheets attractive and legible manner.
Editing b) Formatting c) Polishing d) None of these
Explanation :- Formatting is the very important feature in Excel which is used to show the worksheets in an attractive and beautiful manner.
(2) It refers to the position in which data is placed within the cell.
Alignment b) Location c) Destination d) All of these
Explanation :- In the selected cell, one can change the position of the data which helps the appearance of the worksheet is to be termed as Alignment. There are three types of alignment such as Left, Center and Right. In Excel, the data in the form of text is been aligned to the Left side of the selected cell whereas the data that is in the form of numbers are aligned to the Right side of the selected cell.
(3) It is the process of converting the selected cells into the one cell.
(a) Combining b) Mixing c) Conversion d) Merging
Explanation :-Merging is the process of bringing the data of the selected cell at the middle across the selected rows and columns. It is useful for bringing the Titles at the center over the data. Merge and Center command holds the title text at center by merging the selected rows or columns. The Merge and Center command is available in Home tab under Alignment group.
(4) The default column width of a cell is
(a) 43 b) 6.00 c) 4.95 d) 11. 00
Explanation :- In Excel there are 16,384 columns which are labelled with alphabets from A,B,C,D ….. XFD in a single worksheet. If you want you can add extra columns into the worksheets. If incase, if there is a need for one to increase the selected column width or cell width then he/she may increase or decrease it manually by inputting values. We can change the values of the selected column from the Home tab —– under Format option from Cells group —–Enter the values inside the column width box —– click on OK button. By the way, the by default column width of a cell is 8.43. You may also see that the extra column will be added/inserted at the left side of the selected column.
(5) The default row height is
(a) 00 b) 20.00 c) 5.00 d) 10.00
Explanation :- In Excel there are 1,48,576 rows which are labelled with numbers ranging from 1,2,3,4 ……. 1,48,576 in a single worksheet. If you want you can add extra rows into the worksheets. If incase, if there is a need for one to increase the selected row height or cell height then he/she may increase or decrease it manually by inputting values. We can change the values of the selected column from the Home tab —– under Format option from Cells group —– Enter the values inside the row height box —– click on OK button. By the way, the by default row height of a cell is 15.00. You may also see that the extra row will be added/inserted at the top/above of the selected row.
(6) To make a switch from worksheets, we have to
(a) Press Alt + Arrow keys
b) Alt + Tab key
(c) Click on the Sheets tab
d) None of the above.
Explanation :- In Excel if you want to move in between the cells, then you may make use of arrow keys i.e is Left, Right, Top, and Bottom etc. But if you want directly jump from first row to the last row in a worksheet then you have to press the Alt + Down arrow key from the keyboard and from last row to the 1st row Alt + Up arrow key. Whereas to jump directly from the First column to the last column in a worksheet, then have to press the Alt + Left arrow key and from last column to the first column press Alt + Right arrow key. But for switching between the sheets of the workbook, one has to click on the Sheet tabs i.e is present at the bottom of every workbook.
(7) A worksheet name can contain upto ………………… characters.
(a) 18 b) 8 c) 10 d) 31
Explanation :-Excel also provides the user to give the suitable name of his/her choice to the worksheets inserted into the workbook. You can rename the worksheet from Home Tab ——- Format option from Cells group ——- Select the Rename sheet from the Organize sheets option. The sheet name gets selected in which you are currently active. The selected sheet name erases it by the backspace key and retype the new name for the sheet. OR you may Right click the sheet name whose name you wants to rename, the worksheet gets selected, The selected sheet name can be erased it by the backspace key and retype the new name for the sheet. OR you may make a double click on the sheet name for renaming the worksheet. While renaming the worksheet, we must keep in mind, that the worksheet name contains 31 characters including the spaces in between the characters.
(8) In Excel, by default the sheets tabs colour is
(a) Black b) white c) yellow d) Red
Explanation :- The by default of thecolour of all the sheets in the worksheet tab is white. But if incase to make it attractive, the user can add the colour of their choice to the sheets in the tab. The colour i.e is applied to the sheets present/available in the sheet tab appears at the background of the sheet name in the sheets tab.To apply the colour to the worksheet name in the sheet tab as a background, we may make use of Home Tab ——- Format option from Cells group ——- Select the Tab color from the Organize sheets option OR Go to the sheet name whose color you want to change ——– Right click the mouse button and click on the small arrow i.e is infront of the Tab color option from the drop down list —– and you’ll also notice that when you move the arrow pointer on the different colours available in the colour box, the preview of the colour will be highlighted behind the selected sheet name in the sheets tab.
(9) There are ………………. number styles format in MS-Excel.
(a) 10 b) 12 c) 15 d) 20
Explanation :- The numerical data that is entered into the cell or in worksheet its appearance can be changed by making use of number formatting. There are 12 number formats in MS-Excel which are as follows along with their descriptions :-
Sr. No | Number Formats styles | Descriptions |
1. | General | The default category (no specific formatting is applied) |
2. | Number | General number display with two default decimal points. |
3. | Currency | Add rupees signs and decimals to display monetary values. |
4. | Accounting | Lines up currency symbols and decimal points in a column |
5. | Date | Used to display date values. |
6. | Time | Used to display time values. |
7. | Percentage | Multiplies cell value by 100 and displays percent sign. |
8. | Fraction | Displays value as a specified fraction. |
9. | Scientific | Uses scientific or exponential notation. |
10 | Text | Treats the value as text. |
11. | Special | Works with the list and database values. |
12. | Custom | Enables you to create your own custom format. |
(10) It allows the user to control the appearance of the decimals within the numeric data
(a) Increase and decrease decimal
b) Enter or Exit decimals
c) More or less decimals
d) None of these.
Explanation :-Some times in Excel worksheet, there is a need/ requirement of decimal points in between the digits/ in numerical data. We can increase or decrease the digits in the numerical data that follows after the decimal point. It is very useful for percentage. For ex – 95.70. Increase decimal and decrease decimal command is available on the Home Tab —– under Number group.
(11) This feature In Excel means formatting to the selected data gets applied only if the values of the cell meets the specified condition.
(a) Argument formatting
b) Exceptional Formatting
c) Conditional formatting
d) All of the above
Explanation :- In the numerical, there arises a situation when there is a need of applying formatting to only a particular data that meets/ fulfills the expectations or specified conditions. In such case, we make use of Conditional Formatting feature that is provided by MS-Excel. In conditional formatting one can apply different formatting options such as background color, borders, font formatting to data that meets the certain condition. As per our wish we can make/frame the rules from the menu, depending on what we want to highlight. If the data values in the selected range of cells meets the requirements of the specified condition, then the selected range of cells gets highlighted.
(12) To remove the conditional formatting from the selected range of cells within the worksheet, you make use of
(a) Remove rules
b) Cut rules
c) Deduct rules
d) clear rules
Explanation :- Once you apply the conditional formatting to the selected range of cells, then you may easily remove it by making a click on the clear rules. You can also clear the rule from the selected cells, Entire sheet, Entire table etc. You can perform clear rules as Go to Home Tab —— Click on conditional formatting under the Styles group —— Click on the small arrow i.e is in front of Clear rules ——– Click on the option from which you want to remove the rules such as Clear rule of selected cell, clear rule of Entire sheet, clear rule from this table.
(13) This feature in MS-Excel is used to apply a combination of formatting settings.
(a) Photo gallery
b) Colors gallery
c) Themes gallery
d) Templates gallery
Explanation :- For presenting the worksheet to the audience, it is must for one to give attractive or legible look to your worksheet, so can apply different formatting settings such as colors, fonts and effects. You may find the theme gallery in Page Layout tab under Themes group.