Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Transcript of Spreadsheet Software
is a software application for entering, calculating, manipulating and analyzing sets of numbers.
There are different software spreadsheet applications such as:
We will be working with
Microsoft Excel 2013.
Documents in Microsoft Excel are called workbooks. The document you actually work in is called a
contains multiple worksheets.
A worksheet is made up of
are vertical (up & down).
Think columns on a porch.
They are identified with a letter.
are horizontal (across).
Think: rowing across the lake in a rowboat.
Rows are identified with a number.
The intersection of a column and row is called a
It looks like a little box.
Each worksheet contains thousands of individual cells.
Data is entered into the cells.
Individual cells are identified by the column letter followed by the row number.
This name is called the
The cell that is the intersection of column A and row 1 is named A1.
The intersection of column C and Row 5 is cell C5.
If you click on a cell it is active.
is a rectangle that makes an active cell's border look bold.
are used to describe data
in a column or row.
Labels are usually words or dates.
You do not make calculations with labels.
is a numerical entry in a spreadsheet.
It is used to make calculations or is the result of a calculation.
calculates numbers based on values or formulas in other cells. A formula always begins with an
You can enter and edit data and formulas here in the
are predefined or built-in formulas that perform specialized calculations such as SUM, AVERAGE, or COUNT. Functions also begin with
The SUM function adds a range of values to get a total
The AVERAGE function adds a range of values and then divides by the number of values
The COUNT function counts the number of values in a given range
A group of cells is called a
You indicate a range by placing a colon
between the first cell and the last cell
in the group. Here are some examples:
Here is an example of a formula:
The power of a spreadsheet is in calculations created within its worksheets.
let you perform calculations using data from any worksheets.
Here is an example:
=SUM('1st Qtr Sales'!B9, '2nd Qtr Sales'!B9, '3rd Qtr Sales'!B9, '4th Qtr Sales '!B9)
This function adds the total sales for each quarter from four different worksheets to get an annual total.
These powerful calculations make it easy to use a
to test how alternative scenarios affect numeric results. What if sales increase by 5%? What if we raise the price of that product by $1.00? You can plug in different numbers to see how they will change the outcome and get instant results.
Please raise your right hand and repeat this vow:
"I do hereby solemnly promise that I will never use a calculator to add numbers on my spreadsheet. I will enter a formula or function to do it for me."
You are now ready to take the
Spreadsheet Software Quiz.
In a formula or function a range of cells is
That means that if you copy the formula or function
to another part of the worksheet, the range of cells
will change to the cells in the same location on the worksheet
in relationship to the new formula or function.
This makes it very easy to copy formulas or functions to other areas.
To make a formula or function refer to the same cell when copying it, you must use an
. An absolute reference is noted like this:
Another way spreadsheets can have a powerful impact is by creating a visual representation of numbers.
Charts and graphs
are easy to create in Excel and make a bold statement that is quickly grasped by your audience.
When opening a new workbook in Excel, one worksheet is created. It is named Sheet 1. You can add more worksheets by clicking on the + symbol. Each worksheet can be accessed by clicking on the appropriate tab at the bottom of the screen. Double-clicking on the tab allows you to rename the worksheet.