Which button do you need to press to access the table button
What is the insert button
100
Click this button to move to the cell to the right.
What is tab or right arrow
100
This is the amount of worksheets automatically appearing when opening up a new Excel workbook.
What is three
100
In order to multiply cells A2 and B2 the formula =A1A2 needs what key to be pressed in order to multiply?
What is *
200
This graph uses columns going up and down
What is a bar graph
200
What does making a table allow you to do?
What is allows you to sort data
200
Click this button to move down a cell
What is enter or down arrow
200
Columns are labeled with this.
What is letters
200
This button will automatically add up the total of all cells above it in the same column or row.
What is "Auto Sum"
300
A graph can be created in Excel by doing this.
What is highlight data, insert graph, and click on type of graph needed.
300
How can you make your table different colors?
What is click the design tab
300
Oops, I made a mistake. I must do this to go back to my previous version before I made a mistake.
What is the undo button or control z
300
This picture is clicked to highlight a cell.
What is paintbrush
300
=sum(C3,D3,E3,F3) can be re-written as this formula
What is =sum(C3:F3)
400
In order to make a graph using data from columns that are not next to each other, one must highlight the columns by pressing which key on the keyboard?
What is the control key
400
What do you click to add a new column to your table?
What is click the home tab and then insert
400
Oh no, the cell is too small for the text. I must do this to fix this problem.
What is wrap text or change size of column/row.
400
This following occurs to add a row in between two rows of data.
What is
1. Click on the row below where you want to add a row.
2. Home
3. Insert Row
400
This forumla is used to divide cells B5 and C5.
What is =B5/C5
500
This will happen if you highlight cells with no information in them.
What is a blank graph
500
How could you add numbers on your table
What is go to the formula tab and then select "autosum"
500
This is the view mode for viewing the header.
What is page view
500
This location is where the title of an Excel worksheet goes.
What is header
500
After highlighting the data, I would click the arrow next to autosum and then this word to calculate the average.