Cell formats:
The data entered in the cell can be formatted either in word processing format or in numeric format. In the word processing format, the font, font size, and text alignment can be specified. In the numeric format, subscripts can be assigned to values to express values in terms of money, percentage, fraction, decimal, and date. For example, the value 23451.90 can be formatted as $23,451.90 or £23,451.90 and so on.
Format Cells dialog box
Users have many options to format cells in a worksheet. To format cells, they have to first select the particular cell or cells that are required to be formatted. They then have to click on the menu bar and select the option Format. A drop-down menu appears from which the option called Cells needs to be selected. A Format Cells dialog box appears which has various tabs like Number tab, Alignment tab, Font tab, Border tab, Pattern tab, and Protection tab. [Refer Exhibit 1 (in Appendix) for a screenshot of the Format Cells Dialog Box]. Each of these tabs is explained here:
Number tab: The number tab allows the user to select data types. The various data types that Excel provides are general, number, currency, accounting, date, time, percentage, fraction, scientific, text, special, and custom. If the user wants all the values to be expressed in Dollars ($), then the data type ‘Currency' has to be selected. This would in turn list out a set of options like the currency to be inserted and the way it should be depicted.
Alignment tab: The alignment tab enables the user to modify the position and the alignment of data within the cells. Excel allows the user to change the indent; change the direction of the text; align the text horizontally or vertically; and shrink the text, wrap the text, or merge the cells.
Font tab: The font tab enables the user to change the font size, style, and effects of the text.
Border tab: The border tab allows the user to add borders with different styles and colors.
Pattern tab: The pattern tab allows the user to add color to the selected cells and change the background style.
Protection tab: The protection tab enables the user to lock cells and hide formulas. This option will work only if the worksheet is protected.
Email based Information technology and system assignment help - homework help at Expertsmind
Are you searching Computer science expert for help with Cell formats questions? Cell formats topic is not easier to learn without external help? We at www.expertsmind.com offer finest service of Information technolgy and system assignment help and Information technology homework help. Live tutors are available for 24x7 hours helping students in their Cell formats related problems. We provide step by step Cell formats question's answers with 100% plagiarism free content. We prepare quality content and notes for Cell formats topic under Information technology theory and study material. These are avail for subscribed users and they can get advantages anytime.
Why Expertsmind for assignment help
- Higher degree holder and experienced experts network
- Punctuality and responsibility of work
- Quality solution with 100% plagiarism free answers
- Time on Delivery
- Privacy of information and details
- Excellence in solving Information Technolgoy and system queries in excels and word format.
- Best tutoring assistance 24x7 hours