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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about ' Excel' - jason

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

### Excel

• What you see when you open Excel is the ______________

• It is composed of rows and columns which are composed of _______.

Columns

Rows

• 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

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

• ______________________________________

• 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

XY Scatter over time.

• A scatter plot simply ______________________________.

Column Graph over time.

A column graph organizes data into __________________

Pie Chart over time.

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

Bar over time.

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

Line Graph over time.

• A line graph shows you __________ in different data.

• These are used when looking for changes over time.

How to make a graph over time.

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

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

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

• Select the tab you want to change

• Right click

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