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

Excel PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation


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



When you open 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 _______.





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

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



  • A worksheet is a single page in Excel.

  • A _____________ is a group of three worksheets.

  • Excel automatically opens with ______ worksheets.



  • 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 ~ _________

How to perform a function

How to perform a Function

  • ______________________________________

Basic instructions

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!



  • There are 6 basic graphs and charts

Area chart

  • 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

Xy scatter

XY Scatter

  • A scatter plot simply ______________________________.

  • This can help you find trends in your data.

Column graph

Column Graph

A column graph organizes data into __________________

Pie chart

Pie Chart

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



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

Line graph

Line Graph

  • A line graph shows you __________ in different data.

  • These are used when looking for changes over time.

How to make a graph

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.

Editing your graph

Editing your graph

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

How to e dit c ells

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.

Merging and inserting cells

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.

Cell style and other formatting

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.

Changing the workbook tabs

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.

  • Login