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

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


  • 93 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


EXCEL2007

EXCEL2007

EXCEL2007

EXCEL2007

EXCEL2007


Excel 2007

100 16,000


Excel 2007

Excel 2007 Excel Services


Excel 2007

Excel 2007

1Microsoft Office Microsoft Office ExcelEXCEL1-1

3

4

2

1


2.xls.xlsxEXCEL1-2

Excel 2007

1EXCEL EXCEL

2EXCEL

EXCEL

3 >ExcelEXCEL1-3


1

2


4Alt+F4EXCEL

EXCEL 2007

EXCEL 2007EXCEL20071-4


EXCEL 2007

1-5

Office


1Office EXCEL 2007EXCELOffice1-6


2

1-7


EXCEL 1-8

1

2()

3

4

5



3

4

1-9


EXCEL 20071-10


:

Excel Excel

Excel

Excel

Book.xlt

Sheet.xlt


1

1-12


Excel 20071-1

.xlsx

.xlsm

.xltx

.xltm

XML .xlsb

.xlam


2

Excel1-13

1

3


1

2

3 ABCD

4 1234

A2B3A2B3C1F4


6 3Sheet1Sheet2 Sheet3

7

8

9


EXCEL 2007

:


1

1

1)1-14Shift+F11


2)

,1-15


2

1) Shift

2) Shift,


(1)1-16


(2)

(1)1-17


(2) 1-18


(1)

(2) Shift

(3) F8 F8


Ctrl

(1)

(2) Ctrl+Shift+


(1)

(2)Shift

Ctrl


(1) Ctrl+

(2)

Ctrl+Home

Ctrl+End

Ctrl+Shift+End

Ctrl+Shift+Home


Shift

(1) 1-19

(2) Ctrl+A


1

2

1-20


3

1

Ctrl


2

1-21


1 //

2


1

2


11-26

2

3


1

2

3 1-27


1


2 1-28


EXCEL,

0255,8.43 ;

0409,12.75

1

2


1

2


1

2 1-42


1

2


*

Sum( )

1

+ )

(

A1

=

=


1

2008-10-91000

2

1

+ *

/ % ^Shift+6

2

> <

>= <= <>

3

&


4

: ,

3Excel

= Excel 1-11

=6+2*10 26

=(6+2)*10 80


1

SUMA1B2 A1B2

1

=

2

Shift+F3


2

1

2 fx

3

4

5 Enter


3

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

1

2 B A B


{ }

Ctrl+Shift+Enter

1

Excel { }

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


2

1

2 TRUEFALSE #N/A

3

{ }

,

102030 40 {10,20,30,40}

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



  • Login