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.