2023/12/12IT職業(yè)英語0ContentsSpreadsheet1Organizationofspreadsheet23Celladdress4Rangeofcells5SpreadsheetEntries6Spreadsheetformulas6Spreadsheetcharts2023/12/12IT職業(yè)英語1Vocabulary1.spreadsheet n.電子制表軟件2.designate vt.標(biāo)明，指明3.cell n.單元格4.celladdress n.單元格地址5.range n.范圍6.label n.文本，標(biāo)簽7.numeric adj.數(shù)字的8.formula n.公式9.arithmeticoperators n.算術(shù)運(yùn)算符10.function n.函數(shù)11.argument n.范圍12.parentheses n.圓括號(hào)13.chart n.圖表2023/12/12IT職業(yè)英語2SpreadsheetA

spreadsheet,whichissimplyagridforenteringrowsandcolumnsofdata,hasbeenacommonbusinesstoolforcenturies.2023/12/12IT職業(yè)英語3OrganizationofspreadsheetSpreadsheetsareorganizedinatabularstructurewithrowsandcolumns.Theintersectionofaparticularrowandcolumndesignatesacell.rowscolumnscells2023/12/12IT職業(yè)英語4CelladdressDuringoperations,dataarereferredtobytheircelladdress,whichidentifiesthelocationofacellinthespreadsheetbyitscolumnandrow,withthecolumndesignatorfirst.Forexample：C4istheaddressofthecolumnheadingforproductCrown,andD5istheaddressofthetotalamountofMonarchsalesforR.Rose.2023/12/12IT職業(yè)英語5Aparticularrangeisindicatedbytheaddressesoftheendpointcellsseparatedbyacolon,suchastherowrangC14:E14.

Rangeofcells2023/12/12IT職業(yè)英語6EntriesThemajortypesofentries：labelentry：awordoraphrasenumeric

entryformulaentry2023/12/12IT職業(yè)英語7Spreadsheetformulasarithmeticoperators:+(add),_(subtract),*(multiply),/(divide),^(raisetoapower,orexponentiation).Itofferusersavarietyofpredefinedoperationscalled

functions.The

argument,whichisplacedinparentheses,identifiedthedatatobeoperatedon.

=sum(B5:E2)2023/12/12IT職業(yè)英語8chartsSpreadsheetpackagesletyougenerateavarietyof

chartsfromspreadsheetdata.2023/12/12IT職業(yè)英語9Exercise1Trueorfalse1.()Keyelementsinacomputersystemincludememory,inputdevices,andoutputdevices.2.()Keyboards,mice,inputpens,andprintersareinputdevices.3.()Theinput/outputdevicesarealsocalledperipheraldevices.4.()CPUcanbecalledthekeyelementofac