2/17 Class Quiz and New Material

Today's quiz was ten items

Name the three parts of an IF function
1. The logic test
2. Value if true
3. Value if false

Name the steps to freeze a spreadsheet
1. Select the location to freeze
2. View tab
3. Window group
4. Freeze panes icon

What are the three options when freezing a spreadsheet
1. Freeze panes
2. Freeze 1st row
3. Freeze 1st column

Today are covered the third and fourth steps in creating a spreadsheet Formatting and Charts.

*Format Painter was used to copy the formatting of a selected cell to another cell.
*By using the control key we were able to select nonadjacent cells to format groups of cells all at once.
*Using a pie chart, we created a picture of the data in the spreadsheet in four steps

1. Select the cells with the data to be used in the chart
2. Click the Insert tab on the ribbon
3. Go to the Chart group
4. Select the type of chart
   

*The Chart Tools tab became available when the chart was selected allowing us to move the chart, edit the title, legend, and labels of the chart.

Class Notes 2/16 - Freeze, NOW, and & IF

Freezing panes, rows, and columns in spreadsheets allow you to always view selected portions of your spreadsheet.

Freeze
1. Select location - Select the portion of your spreadsheet that is to be frozen. Select the cell immediately below and to the right of the row and column you wish to freeze. In our example yesterday, we froze column A and rows 1,2,&3 so we selected cell B4.
2. View Tab - On the Ribbon, go to the View Tab
3. Window Group - In the View Tab, go to the Window Group
4. Freeze Panes - Click the arrow on the Freeze Panes icon

• Freeze Panes
• Freeze Top Row
• Freeze First Column

5. Unfreeze - Only available in the Freeze Panes arrow if portions of the spreadsheet are already frozen

NOW Function
=NOW()
The now function inputs the current date and time in the selected cell allowing user of the spreadsheet to know when it was created.
You can edit the appearance of the date and time generated by the NOW function by selecting the Number tab in the Format dialog box and then the Date catergory.

IF Function
=IF(logic test, value if true, value if false)
1. Logic test - The logic test is the question that you are asking. The example in class was if sales in January were more than or equal to the goal of $4,750,000.
2. Value if true - This is the value that will appear in the cell if the the logic test is true. If sales were more than or equal to $4,750,000, then the value of the bonus would be $100,000
3. Value if false - This is the value that will appear in the cell if the logic test is false. If sales did not reach $4,750,000, there would be no bonus, $0.
Since both the goal and the bonus were in our What If section of the spreadsheet, it was necessary to use absolute cell reference to refer to the the goal and bonus amounts.
=IF(b4>=$B$24, $B$19, 0)
By changing the values in B24 or B19 we can quickly change the projection report, allowing us to make business decisions based on new figures quickly.

Spreadsheet Critical Thinking

Excel allows you to change values in a worksheet quickly and easily.

*How is this helpful in running a business?

*How can changing values affect business decisions?

Although electronic spreadsheets were introduced less than 50 years ago, people have created spreadsheets by hand for hundreds of years.

*What are the advantages of creating an automated spreadsheet rather than a hand written one?

*How does the capability to recalculate automatically when values change, make an electronic spreadsheet more valuable than a spreadsheet created by hand?

Who isWarren Buffet?

Extra credit posting of who is Warren Buffet, what does he do, how does he relate to our lesson activity, and why is he important is due today before the start of class. Information found to be copied and pasted from websites will not receive credit.

Financial Spreadsheet Vocabulary 2/2 & 2/3

Director of Finance and Accounting
Semiannual
Projected
Gross Margin
Cost of Goods Sold
Expenses
Bonus
Commission
Marketing
Research and Development (R&D)
Support, General, and Administrative
Operating Income