This presentation is the property of its rightful owner.
Sponsored Links
1 / 55

欢迎进入 EXCEL 2007 软件的学习 PowerPoint PPT Presentation


  • 89 Views
  • Uploaded on
  • Presentation posted in: General

欢迎进入 EXCEL 2007 软件的学习. 第一章 EXCEL2007 软件基础. 第一节 EXCEL2007 软件简介. 一 EXCEL2007 软件的特点. 二 EXCEL2007 软件的启动 和退出. 三 EXCEL2007 软件的 外观. 一、 Excel 2007 软件的特点. (一)采用的是面向结果的新界面,与以前的版本相比功能更多 (二)在扩展的电子表格中可以导入、组织和浏览大量数据集。 它能够处理大量数据,支持的电子表格多达 100 万行和 16,000 列。.

Download Presentation

欢迎进入 EXCEL 2007 软件的学习

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Excel 2007

EXCEL 2007


Excel2007

EXCEL2007

EXCEL2007

EXCEL2007

EXCEL2007

EXCEL2007


Excel 2007

Excel 2007

100 16,000


Excel 2007

Excel 2007

Excel 2007 Excel Services


Excel 20071

Excel 2007

Excel 2007

1Microsoft Office Microsoft Office ExcelEXCEL1-1

3

4

2

1


Excel 2007

2.xls.xlsxEXCEL1-2

Excel 2007

1EXCEL EXCEL

2EXCEL

EXCEL

3 >ExcelEXCEL1-3


Excel 2007

1

2


4 alt f4 excel

4Alt+F4EXCEL

EXCEL 2007

EXCEL 2007EXCEL20071-4


Excel 20072

EXCEL 2007

1-5

Office


1 office excel 2007 excel office 1 6

1Office EXCEL 2007EXCELOffice1-6


Excel 2007

2

1-7


Excel 2007

EXCEL 1-8

1

2()

3

4

5


Excel 2007


Excel 2007

3

4

1-9


Excel 2007

EXCEL 20071-10


Excel 2007

:

Excel Excel

Excel

Excel

Book.xlt

Sheet.xlt


Excel 2007

1

1-12


Excel 2007

Excel 20071-1

.xlsx

.xlsm

.xltx

.xltm

XML .xlsb

.xlam


Excel 2007

2

Excel1-13

1

3


Excel 2007

1

2

3 ABCD

4 1234

A2B3A2B3C1F4


Excel 2007

6 3Sheet1Sheet2 Sheet3

7

8

9


Excel 20073

EXCEL 2007

:


Excel 2007

1

1

1)1-14Shift+F11


Excel 2007

2)

,1-15


Excel 2007

2

1) Shift

2) Shift,


Excel 2007

(1)1-16


Excel 2007

(2)

(1)1-17


Excel 2007

(2) 1-18


Excel 2007

(1)

(2) Shift

(3) F8 F8


Excel 2007

Ctrl

(1)

(2) Ctrl+Shift+


Excel 2007

(1)

(2)Shift

Ctrl


Excel 2007

(1) Ctrl+

(2)

Ctrl+Home

Ctrl+End

Ctrl+Shift+End

Ctrl+Shift+Home


Excel 2007

Shift

(1) 1-19

(2) Ctrl+A


Excel 2007

1

2

1-20


Excel 2007

3

1

Ctrl


Excel 2007

2

1-21


Excel 2007

1 //

2


Excel 2007

1

2


Excel 2007

11-26

2

3


Excel 2007

1

2

3 1-27


Excel 2007

1


Excel 2007

2 1-28


Excel 2007

EXCEL,

0255,8.43 ;

0409,12.75

1

2


Excel 2007

1

2


Excel 2007

1

2 1-42


Excel 2007

1

2


Excel 2007

*

Sum( )

1

+ )

(

A1

=

=


Excel 2007

1

2008-10-91000

2

1

+ *

/ % ^Shift+6

2

> <

>= <= <>

3

&


Excel 2007

4

: ,

3Excel

= Excel 1-11

=6+2*10 26

=(6+2)*10 80


Excel 2007

1

SUMA1B2 A1B2

1

=

2

Shift+F3


Excel 2007

2

1

2 fx

3

4

5 Enter


Excel 2007

3

=IF(AVERAGE(C1:D2)<100,SUM(F4:G5),5)

1

2 B A B


Excel 2007

{ }

Ctrl+Shift+Enter

1

Excel { }

A ={ =SUM(B2:C2*B3:C3)}


Excel 2007

2

1

2 TRUEFALSE #N/A

3

{ }

,

102030 40 {10,20,30,40}

10203040 50607080 2 4 {10,20,30,4050,60,70,80}


Excel 2007


  • Login