Scroll to the bottom of the spreadsheet and right click on sheet 1, select this to change the name of the sheet.
What is Rename?
200
=$A$4 & doesn't change when moved to a new location
What is Absolute Cell Reference?
200
Used to identify the minimum number in a range
What is the MIN function
200
Used to display trends over time
What is a line chart?
200
Letters at the top a spreadsheet
What are Column headings?
200
To change the style of a range in Excel you go to the Home ribbon in the group "Styles" and select this
What is Format as Table?
300
=$A4
What is an absolute column and relative row?
300
Used to determine the maximum number in a range
What is MAX function?
300
Used to compare values across categories by using vertical bars
What is column chart
300
Select a column heading and right click or go to the home ribbon and select format column to change this.
What is column width?
300
Go to this Ribbon to insert Charts, pictures and maps.
What is the Insert Ribbon
400
=A$4
What is an relative column and absolute row?
400
Used to determine the average of a range of numbers
What is the AVG function?
400
Used to show scientific XY data. Often used to find out if there is a relationship between X & Y.
What is a scatter chart?
400
Select the row number right click or go to the Home ribbon and select format row to change this.
What is row height?
400
On the Page Layout Ribbon in the Page Setup group select this to change the layout of the page from Portrait to Landscape.
What is Orientation?
500
=$A4 & =A$4 are called another type of cell reference.
What is Mixed cell reference?
500
Used to count the numbers in a range?
What is COUNT function?
500
Like line charts except the area below the plot line is solid and like line charts are used to show trends over time or other categories.
What is an Area Chart
500
Located on the Home Ribbon this group will allow you to add or delete columns and rows, change height and width, edit cells, and organize the spreadsheet
What is the cells group?
500
On this Ribbon you can sort, filter, and get external data