Выравнивание
жүктеу/скачать 29,23 Kb.
|
- Бұл бет үшін навигация:
- ТЕКСТ
|
LAB WORK. MS Excel CREATING, FILLING, EDITING AND FORMATTING OF TABLES Exercise 1. Entering text data. The range A1: E3 to create a copy of the table below.
Exercise 2. Enter in a cell A1 in sheet 2 proposal and format as follows (ALT + ENTER): Электронный процессор EXCEL предназначен для обработки данных, представленных в табличной форме. Exercise 3. On sheet 4 a) Write to A1-A12 cell names of all the months of the year, starting in January. In cell A1 write the first month. Then, with the help of auto-stretch marker down. In this months months will continue automatically in order. b) Write to B1-B7 cell names of all the months since July c) Record the cells C1-C7 days of the week. d) Write to cell D1-D10 numbers from 1 to 10, for this you need to enter in cell D1 and D2 figures 1 and 2, then select them, and autocomplete continue down marker. e) Record E1-E9 cell number from -2 to 2 in 0.5 Exercise 4. On sheet 5 to calculate: Exercise 5. On sheet 5 to create the following table. Columns in the tour cost $ and cost of the tour in the district. calculated by the formula: =СУММ(B7:E7), =F7*5. Current date and time to make using the formula: =ТДАТА(). жүктеу/скачать 29,23 Kb. Достарыңызбен бөлісу:
|