《計算機應(yīng)用基礎(chǔ)傳媒大3課件》由會員分享，可在線閱讀，更多相關(guān)《計算機應(yīng)用基礎(chǔ)傳媒大3課件（39頁珍藏版）》請在裝配圖網(wǎng)上搜索。

1、單擊此處編輯母版標題樣式,單擊此處編輯母版文本樣式,第二級,第三級,第四級,第五級,*,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,計算機應(yīng)用基礎(chǔ),周江,2019,年,4,月,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Excel 2007,概述,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMi

2、n,Vocational School,Excel,的中文意思就是超越,從,1983,年起，先后推出了,Excel.0,/,Excel 5.0,/,Excel 6.0,/,Excel 7.0,/,Excel 97,，,Excel 2000,，,Excel 2002,，,Excel 2003,，直到現(xiàn)在的,Excel 2007,和,2010,、,2016,管理公司和個人財務(wù)/統(tǒng)計數(shù)據(jù)/繪制各種專業(yè)化表格,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,1.1 Excel 2007,的啟動與退出,啟動,“開始”,“,程序”,“

3、Microsoft Office”Microsoft Office Excel 2007,在“運行”對話框中輸入“,excel”,（機房里,2003,與,2007,兩個版本同時裝的情況）,退出,Excel,是多文檔的操作界面，關(guān)閉某工作薄與退出,Excel,是有區(qū)別的,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,1.2 Excel 2007,窗口的基本組成,工作簿,單元格,工作表標簽,活動單元格地址/名稱框,行號,列號,活動,單元格,填充柄,編輯欄,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,

4、JinMin,Vocational School,2 Excel 2007,的基本操作,2.1,單元格的選擇與活動單元格,行/列的選擇,單元格的選擇,單元格區(qū)域的選擇,活動單元格的移動,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,1.,選擇行和列,單擊行號,選擇整行,單擊列號,選擇整列,單擊行號或列號，然后拖動鼠標到相鄰的行號或列號；或者按,Shift,鍵,選擇相鄰的行或列,單擊第一個行號或列標，按住,Ctrl,，再單擊其他的行號或列號,選擇不相鄰的行或列,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技

5、術(shù)學校,JinMin,Vocational School,2.,選定單元格,定位一個單元格,直接鼠標單擊某個單元格,選定多個相鄰的單元格,用鼠標拖動或者,Shift,鍵,選定多個不相鄰的單元格,先選中一個單元格，然后按住,Ctrl,鍵的同時，點擊別的需要選中的單元格,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,3.,選定單元格區(qū)域,單擊選取區(qū)域,左上角的單元格,，按住,Shift,鍵，將鼠標指針指向要選取區(qū)域的,右下角單元格,或者用鼠標從左上角單元格滑動到右下角單元格,選定一個單元格區(qū)域,選擇不相鄰的單元格區(qū)域,先選中

6、一個單元格區(qū)域，然后按住,Ctrl,鍵，再選取其他區(qū)域,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,2 Excel 2007,的基本操作,2.2,數(shù)據(jù)的錄入,1.,數(shù)據(jù)類型,2.,不同類型數(shù)據(jù)的錄入,3.,序列填充,4.,給單元格添加批注,5.,為單元格設(shè)置數(shù)據(jù)有效性,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan

7、 EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan

8、 EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan

9、 EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan

10、 EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,Sichuan EDU,我學習,我快樂！,宜賓敘州區(qū)金岷職業(yè)技術(shù)學校,JinMin,Vocational School,