Home | | Computer Technology 11th std | Formatting Worksheet - Spreadsheet

Spreadsheet (OpenOffice Calc) - Formatting Worksheet - Spreadsheet | 11th Computer Science : Chapter 7 : Spreadsheet-Basics (OpenOffice Calc)

Chapter: 11th Computer Science : Chapter 7 : Spreadsheet-Basics (OpenOffice Calc)

Formatting Worksheet - Spreadsheet

Formatting Data in a cell gives additional effect to the text.

Formatting Worksheet

 

Formatting Data in a cell gives additional effect to the text. Additional effect includes changing the font style, font size, automatic wrapping, bold, underline, italic etc. The data in Calc can be formatted in several ways. Using formatting icons can be used.

 

1. Text Formatting

Making the cell contents as bold, italics, underlined, changing font style, size, colour etc., comes under text formatting. All text formatting options are available as icons in Formatting toolbar learnt in OpenOffice Writer. Figure 7.39(a) Text Formatting Toolbar


 

2. Number formatting

Number formatting options are used to visually change the format of a numeric content. These formatting changes are only for visual as, it does not change its original value. For example, To display a number as currency form use Number format: Currency.

 

Number format: Currency will be used as shown Figure 7.39(b).







 

Tags : Spreadsheet (OpenOffice Calc) , 11th Computer Science : Chapter 7 : Spreadsheet-Basics (OpenOffice Calc)
Study Material, Lecturing Notes, Assignment, Reference, Wiki description explanation, brief detail
11th Computer Science : Chapter 7 : Spreadsheet-Basics (OpenOffice Calc) : Formatting Worksheet - Spreadsheet | Spreadsheet (OpenOffice Calc)


Privacy Policy, Terms and Conditions, DMCA Policy and Compliant

Copyright © 2018-2023 BrainKart.com; All Rights Reserved. Developed by Therithal info, Chennai.