Application
Title: Enter the title for the first cell A1 and select from A1 to F1, right click, format cell, Text alignment, Horizontal: focus on multiple columns.
Subtitle: the same options as the title.
Table:
5th line: change the size to cell A5 then choose the "reference to the line automatically" option to cells B5, C5, D5 and E5, to: right click on the cell, cell format, alignment, control text, select to return automatically.
Type the data, then use the border to frame the picture.
To change the shape of figures type: select the data, right click, format cell, Number, Currency: No symbol, number of decimal places 0.
Use the (+) for the D6 cell (= (B6 + C6)), then use the (-) in cell F6 (= E6-D6) and the "Sum" function in cell B12 (Sum (B6 : B11).
Using the handle to apply the copy remaining cells.

0 commentaires:
Enregistrer un commentaire