1 / 21

Excel

Excel. When you open Excel. What you see when you open Excel is the ______________ It is composed of rows and columns which are composed of _______. Columns. Rows. Cells. A cell is an individual block in a spreadsheet. An _______ cell is the cell that is currently selected.

jason
Télécharger la présentation

Excel

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Excel

  2. When you open Excel • What you see when you open Excel is the ______________ • It is composed of rows and columns which are composed of _______. Columns Rows

  3. Cells • A cell is an individual block in a spreadsheet. • An _______ cell is the cell that is currently selected. • A cell’s name is its coordinates. Active cell This cell’s name is C4 Cell

  4. Cell Range • A cell range is a group of cells that are being used together. • A cell range has it’s own name. These cells are C10:J10

  5. Worksheet • A worksheet is a single page in Excel. • A _____________ is a group of three worksheets. • Excel automatically opens with ______ worksheets.

  6. Functions • Excel is designed to be able to use the data that you enter: in this case mathematically. • Sum ~ ____________________________________. (The default function) • Average ~Values added together and then divided by the number of values. • Count ~ The number of data values. Default function for data other than numbers. • Max ~ ________ • Min ~ _________

  7. How to perform a Function • ______________________________________

  8. Basic Instructions • Select the cell that you want your total in. • Select the function button • Select SUM and make sure the names of the cells are the ones you want to add after you press OK. • Press OK!

  9. Graphs • There are 6 basic graphs and charts

  10. The Area chart is similar to a bar graph but shows trends over time. • To read this take the base line of a topping and subtract it from the top line to find the actual number of students that liked that topping. Area Chart

  11. XY Scatter • A scatter plot simply ______________________________. • This can help you find trends in your data.

  12. Column Graph A column graph organizes data into __________________

  13. Pie Chart A pie chart show the ____________________________________________________________and not necessarily the actual numerical values.

  14. Bar A bar graph is the same as a column graph but the data is ______________ on the axis.

  15. Line Graph • A line graph shows you __________ in different data. • These are used when looking for changes over time.

  16. How to make a graph • Highlight the data you want to graph. • Select the Insert tab and then choose the type of graph you want.

  17. Editing your graph • Once you have your graph you select it and use the chart tools to change the graph’s format.

  18. How to Edit Cells • To edit specific cells highlight the ones you want and right click. • Scroll down to format cells. • From this window you can change the word angle, color, borders, and more.

  19. Merging and Inserting Cells • Select the cells you want to work with. • Go to the Home Tab • The Insert button allows you to shift your data or simply add whole lines. • The Merge & Center button puts your highlighted cells together.

  20. Cell Style and Other Formatting • The Cell Styles button on the home tab allows you to create a theme and color and select the type of data you plan on using.

  21. Changing the Workbook Tabs • Select the tab you want to change • Right click • You can change the color or the name from that drop down.

More Related