excel – a spreadsheet program that allows you to organize, calculate, make decisions, graph,...
TRANSCRIPT
![Page 1: Excel – a spreadsheet program that allows you to organize, calculate, make decisions, graph, develop reports, and publish information to the Web. Worksheet](https://reader036.vdocuments.us/reader036/viewer/2022082818/56649e8a5503460f94b8fd73/html5/thumbnails/1.jpg)
Excel – a spreadsheet program that allows you to organize, calculate, make decisions, graph, develop reports, and publish information to the Web.
Worksheet – a grid of rows and columns; 1 spreadsheet
Workbook – 2 or more worksheets
![Page 2: Excel – a spreadsheet program that allows you to organize, calculate, make decisions, graph, develop reports, and publish information to the Web. Worksheet](https://reader036.vdocuments.us/reader036/viewer/2022082818/56649e8a5503460f94b8fd73/html5/thumbnails/2.jpg)
• To keep track of facts and figures• Grades• Budget
• Home• Business
• Business Expense Report• Sales or Financial Report• Check Register• Inventory List• Personnel List• Client List
![Page 3: Excel – a spreadsheet program that allows you to organize, calculate, make decisions, graph, develop reports, and publish information to the Web. Worksheet](https://reader036.vdocuments.us/reader036/viewer/2022082818/56649e8a5503460f94b8fd73/html5/thumbnails/3.jpg)
Cell – The basic unit of an Excel worksheet; where a row and column intersect
Cell reference – a unique address that refers to the cell located at a certain location
Column – letters
Row - numbers
![Page 4: Excel – a spreadsheet program that allows you to organize, calculate, make decisions, graph, develop reports, and publish information to the Web. Worksheet](https://reader036.vdocuments.us/reader036/viewer/2022082818/56649e8a5503460f94b8fd73/html5/thumbnails/4.jpg)
Active Cell– cell that you are working in3 ways to identify an active cell:1.Bold, black line around the cell2.Column and row are highlighted3.Name box displays the cell reference (A1, B13, …)
Gridlines – horizontal and vertical lines on the worksheet
![Page 5: Excel – a spreadsheet program that allows you to organize, calculate, make decisions, graph, develop reports, and publish information to the Web. Worksheet](https://reader036.vdocuments.us/reader036/viewer/2022082818/56649e8a5503460f94b8fd73/html5/thumbnails/5.jpg)
Title bar - includes the name of the worksheet or workbook
Range – a series of 2 or more adjacent cells in a column or rectangular group of cells
SUM Function – adds all of the numbers in a range of cells
AVERAGE Function – averages numbers in a range of cells (add and then divide by the number of cells included in range)