jeudi 9 mai 2013










Application
* Enter the number 1 in A1 then use the handle to copy to assign the number 1 in cell A1 to A10.
* To use the handle to copy select the first cell, then move the mouse to the small square at the bottom right of the cell when the mouse takes the form of a (+) by clicking and hold the small square that moves to the cell you want.
* Type the number 1 and number 2 B1 to B2 and use the handle to copy on selecting the first two columns, for assigning numbers (1-10) to cells in column B.
* Enter the number 2 and number 4 C1 to C2 and then use the handle to copy on selecting the first two columns to affect the cells in column C the even number from 2 to 20.
* Press the letter A to D1 and then use the handle to copy it to affect selecting the letter A to the cells in column D.
* Enter the number 3 and number 6 E1 to E2 and then use the handle to copy on selecting the first two columns, for assigning numbers (E-1 x 3) cells from column E.
* Enter the number 10 and number 15 F1 to F2 and then use the handle to copy on selecting the first two columns, for assigning numbers (1-x F 5) cells from column F.
* Enter the number 10 and number 20 G1 to G2 and then use the handle to copy on selecting the first two columns, for assigning numbers (G-1 x 10) cells from column G.
* Enter the number 100 to number 200 H1 and H2 to then use the handle to copy on selecting the first two columns, for assigning numbers (H-1 x 100) cells from column H.
* Use the border to draw the table.
* Give each column a color and pattern style. To select the right column click    filling cell format.
* Change the border style columns B and D.

0 commentaires:

Enregistrer un commentaire