Работа в MS Office 2007. Табличный процессор Excel 2007: Методические указания и задания для выполнения лабораторных работ

  • Published on
    08-Dec-2016

  • View
    226

  • Download
    11

Embed Size (px)

Transcript

<ul><li><p>. . </p><p> MS Office 2007. Excel 2007 </p><p>08080165 ( ) </p><p> 2010 </p></li><li><p>2 </p><p> 004.383.1 (076) 32.973.26-018.27 89 </p><p> . . </p><p> - </p><p> , . . </p><p> MS Office 2007. Excel 2007 : 08080165 ( ) / . . . : , 2010. 52 . </p><p> 08080165. </p><p> , Excel , , Office 2007. Excel MS Office 2007, . </p><p> . </p><p> 004.383.1 (076) 32.973.26-018.27 </p><p> . ., 2010 . , 2010</p><p> 89 </p></li><li><p>3 </p><p> 1. MICROSOFT EXCEL 2007 .......................................................... 5 ............................................................................................................................. 5 Microsoft Excel 2007 .......................................................... 6 Office .............................................................................................................................. 7 ........................................................................................................ 7 ................................................................................................................. 7 ................................................................................................................... 11 </p><p> ................................................................................................ 12 2. MS EXCEL 2007 ............................................................. 12 ................................................................................................................. 12 ........................................................................................................................ 13 ............................................................................................................................ 13 ................................................................................ 14 ................................................................................................ 14 </p><p> 3. EXCEL 2007 ....................................... 15 ................................................................................................... 15 , ......................................................... 16 ................................................................................................................................. 16 ................................................................................................... 17 ............................................................................................................. 17 .................................................................................................................................... 18 </p><p> ................................................................................................ 18 4. EXCEL 2007 ................................................... 18 ................................................................................................................ 18 ......................................................................... 18 .................................................................................................................. 20 .................................................................................... 20 .............................................................. 21 ..................................................................................................... 21 </p><p> ............................................................................................ 22 ................................................................................................ 23 </p><p> 5. EXCEL 2007 .................. 23 ........................................................................................ 23 ................................................................................................................................. 23 ................................................................................................. 23 ............................................................................................................................. 24 ........................................................................................................................... 24 ..................................................................................................................... 24 , .............................................................. 25 ..................................................................................................... 26 </p><p> ............................................................................................................... 26 ........................................................................................................ 26 Excel ..................................................................................................... 27 ................................................................................ 28 ............................................................................. 28 ............................................................................................... 29 </p><p> ................................................................................................ 29 6. </p><p> EXCEL 2007 ................................................................................................................................. 30 ............................................................................................................. 30 ...................................................................... 30 </p></li><li><p>4 </p><p> ..................................................................................................... 30 ............................................................. 30 .................................................................................................. 30 ............................................................................................... 30 </p><p> ....................................................................................................................... 32 .......................................................................................................................... 32 .......................................................................................................... 32 </p><p> WordArt ......................................................................................................................... 33 SmartArt ........................................................................................................................ 33 ...................................................................................................................... 34 ................................................................................................................. 34 ............................................................................................................... 34 ............................................................................................................. 35 , , ............................................................... 36 </p><p> ...................................................................................................................... 37 ................................................................................................ 39 </p><p> 7. ....................................................................... 40 ................................................................................................................. 40 ..................................................................................................... 41 .............................................................................................................................. 42 ........................................................................... 43 .............................................................................................................. 44 .......................................................................... 44 ........................................................... 45 ......................................................................................................... 46 </p><p> ................................................................................................ 47 ........................................................................... 48 1. Excel 2007. ...................................................... 48 2. MS Word 2007. .................................................................................. 50 </p><p> ....................................................................................... 52 </p></li><li><p>5 </p><p> 1. MICROSOFT EXCEL 2007 </p><p>Microsoft Office Excel 2007 , , . </p><p> , . , , , , . , , . . . </p><p> , . </p><p> Excel 2007 (. [1, . 40]): - , ( , ); - ; - ( ); - ( ); - ( SmartArt); - ( ). </p><p> Excel 2007 (. [1, . 61-70]): - , ; - ( 1 048 576 65 536 Excel 2003; 16384 256 Excel 2003); - ( 64), ( 64), ( 255), ( 32 000), ( 10 000); - ( xml); - ( ); - ( ), ; </p></li><li><p>6 </p><p>- ; - ; - ( , ); - ( ); - SmartArt ( ); - ( ) ; - ( 5 ); - ; - ; - ( ); - Excel. </p><p> Microsoft Excel 2007 </p><p> Microsoft Excel 2007, MS Office 2007, </p><p> (. 1.1). </p><p>. 1.1. MS Excel 2007 </p></li><li><p>7 </p><p>. 1.2. Office </p><p>. 1.3. </p><p> , Office, , . , , . , . Office </p><p> Office (. 1.2) : , , , , - , , , , , . - ( ), Excel ( Excel), ( Excel). </p><p> (. 1.3) - . : , , . , . , , , </p><p>, , . </p><p> : , , , , , , . , . , . </p></li><li><p>8 </p><p> . , . (. 1.4), . , . </p><p>. 1.4. . (. 1.5) , </p><p> , : - ( , , , , ); - ( , ); - ( , , -/ ); - ( , ); - ( , ); - ( , , , , , , ); - ( , , , , ). </p></li><li><p>9 </p><p> (. 1.5) , </p><p> : - ( , ); - ( , , , SmartArt); - ( ), - ( ); - ( , WordArt, , ). </p><p> (. 1.5) , : - ( , , , , ); - ( , , , , ); - ( , ); </p><p>. 1.5. </p><p>. 1.5. </p></li><li><p>10 </p><p>- ( ); - ( , ). </p><p> (. 1.5) </p><p> : - ( ); - ( ); - ( ); - ( ). </p><p> (. 1.5) </p><p> : - ( ); - ( ); - ( ); - (, , , ); - ( ). </p><p>. 1.5. </p><p>. 1.5. </p><p>. 1.5. </p></li><li><p>11 </p><p> (. 1.5) : - ( , , , ); - (, ); - ( ). </p><p> (. 1.5) , </p><p> : - ( ); - ( ); - ( ); - ( , , ); - ( ). </p><p> (. 1.6). </p><p> , . , . , . </p><p>. 1.5. </p><p>. 1.5. </p></li><li><p>12 </p><p>1. ? 2. Office? 3. ? 4. ? 5. ? 6. ? </p><p> 2. MS EXCEL 2007 </p><p> Excel , .XLSX ( ) .XLSM ( ), .XLTX (-) .XLTM (- ). . Office. (. 2.1). , . , ( </p><p>. 1.6. </p></li><li><p>13 </p><p>) ( , ) . </p><p> . </p><p>. , Office . </p><p> Excel 2007 .xlsx. </p><p> . , Excel, Excel 97-2003 ( Office ). . </p><p> , Excel , </p><p> . Excel 2007, Office. </p><p>Excel , - . (. 2.2) : ; - - ; ; </p><p>. 2.1. </p><p>. 2.2. </p></li><li><p>14 </p><p> . , </p><p> : ; ; ; , . </p><p> , , </p><p> Excel 2007 . : </p><p>- ; - ; - . </p><p> Office , Office . </p><p> - . </p><p> , . </p><p> (Office ), . </p><p> , . Office . </p><p> . . </p><p> 1. , ? 2. , ? </p></li><li><p>15 </p><p>3. ? 4. ? 5. ? 6. ? 7. ? </p><p> 3. EXCEL 2007 </p><p> Excel . </p><p>, . 1 048 576 16 384 . </p><p>, (. 3.1). , , , , -</p><p>, , . (. 3.2). </p><p>. 3.1. </p></li><li><p>16 </p><p>. Shift , Ctrl . </p><p> . </p><p> . </p><p> , . </p><p> , </p><p> - (, , . .) , , . </p><p> , . , , Shift, . . , Ctrl. </p><p> /, /. /, / , Shift, / . /, / Ctrl. </p><p> , Ctrl+A, (. 3.1). </p><p> ( F2 ) . </p><p>. Excel 2007 , . . </p><p>. 3.2. </p></li><li><p>17 </p><p> , , . </p><p> //, , , . Ctrl+Insert Ctrl+C ( ) Shift+Insert Ctrl+V ( ), Ctrl , . </p><p> //, , , . Shift+Delete Ctrl+X ( ) Shift+Insert Ctrl+V ( ), , . . , -, . . - (. 2.3). , . . -. </p><p> , , . </p><p> /, /, /, , . </p><p> /, , , , </p><p>. 3.3. </p></li><li><p>18 </p><p> . , . </p><p> .. . </p><p> . , , (, , , ). </p><p> , /. / , (). / . </p><p> , , , (). </p><p> 1. ? 2. ? 3. ? 4. ? 5. ? 6. ? </p><p> 4. EXCEL 2007 , , </p><p> . </p><p> , , , , , . 4.1. - </p></li><li><p>19 </p><p> ( , ) - (. 4.1), . </p><p> (. 4.2), . </p><p> (, , , , ) -, , . </p><p> , , , , / , -, . </p><p> , -, , . </p><p> , , -. </p><p>. , . , . . , . . , , . </p><p>. 4.2. </p></li><li><p>20 </p><p> , </p><p> . . : - , ; - ( , ); - , ( , ; , ). </p><p> , . , , , . </p><p> , (. 4.3). . </p><p>. 4.3. </p></li><li><p>21 </p><p>. 4.4. - </p><p> , . . </p><p> , , . </p><p> , , . . </p><p> Excel 2007 (. [1, . 128-133]). . , , . </p><p> , - (. 4.4) . - . - , (/ , - /). </p><p> , -- . </p><p> - . - , , . </p></li><li><p>22 </p><p>. 4.5. </p><p> . (. 4.5) . , . </p><p> : - ( -) - , ; - ( -</p><p> ) , . (, , , . ); - (...</p></li></ul>

Recommended

View more >