Page 240 - IT_Play_V1.0 Class9
P. 240

UNIT-4 ELECTRONIC SPREADSHEET





                3          FORMAT DATA IN THE

                           SPREADSHEET









              Formatting  data  in  a  spreadsheet  improves its readability  and  presentation,  helping  users highlight  key
              information, organise data effectively, and create clear, professional-looking sheets for better data analysis
              and communication

                FORMATTING THE SHEET

              Cells  in a spreadsheet can hold various types of data and can be formatted
              using the Formatting toolbar or the Format Cells dialog box. Formatting includes
              changing the appearance of cell contents, such as font styles, text alignment,
              borders, and patterns.

              Use of Dialog Boxes to Format Values

              The Format Cells dialog box can be used to find more about formatting a cell or
              range of cell. You can open this Format Cells dialog box by pressing the shortcut
              key Ctrl+1 or by selecting Cells option from the Format menu.
              Changing Font

              Changing the font in LibreOffice Calc involves selecting different Font, Size, and Style to alter the appearance
              of text in the spreadsheet cells. To change the font in a spreadsheet, follow these steps:

              Step 1:  Select a cell or a range of cells.
              Step 2:  Click on the Format menu from the Menu bar.

              Step 3:  Select the Cells option from the drop-down menu. The Format Cells dialog box appears on the
                      screen.

              Step 4:  Click on the Font tab.

              Step 5:  Select the desired font, font style and font size in the Font, Style and Size drop-down lists, respectively.

                           2
                                                                   4



                                                                                                         5
                                                                   3
                            1













                238     Information Technology Play (Ver 1.0)-IX
   235   236   237   238   239   240   241   242   243   244   245