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

Excel PowerPoint PPT Presentation

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.

Excel

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

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.

• A cell’s name is its coordinates.

Active cell

This cell’s name is C4

Cell

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

Worksheet

• A worksheet is a single page in Excel.

• A _____________ is a group of three worksheets.

• Excel automatically opens with ______ worksheets.

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

How to perform a Function

• ______________________________________

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!

Graphs

• There are 6 basic graphs and charts

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

XY Scatter

• A scatter plot simply ______________________________.

Column Graph

A column graph organizes data into __________________

Pie Chart

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

Bar

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

Line Graph

• A line graph shows you __________ in different data.

• These are used when looking for changes over time.

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.

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

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

• 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

• 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

• Select the tab you want to change

• Right click

• You can change the color or the name from that drop down.