What is right clicking or in the home tab, clicking delete
100
All formulas begin with this....
what is = sign
100
Explain to me how to widen a column
What is clicking between the columns and dragging to the left or right
100
What would be the appropriate formula shown in cell G4 to arrive at the result for Ramons' test average
What is =Average(B4:F4)
100
How would I rename a sheet tab?
What is by right clicking and choosing rename or double clicking and keying the new name
200
In the home tab, this will allow you to add a title centered in one cell across your table
What is merge and center
200
This function will calculate as follows
(5+5+5+10)/5=6
What is average function
200
When your data cells in Excel show number signs (########), it means this.
What is the column not being wide enough
200
What formula would show in cell B14
What is =min(B3:B11)
200
When the data in your cell is too long, you can turn this on to allow it to go onto a second line; thus making the cell larger.
What is wrap text
300
Under this ribbon, I can align data, left, right and center
What is the alignment tab
300
Formulas will allow for simple calculations within cells (=a5+b5+c5), but THIS type of formula will allow for more advanced coded formulas. Often referred to as a shortcut for a formula
What is a function
300
Where would I go to format a column where it would be defaulted to two decimal places
What is number dropdown, select currency
300
What key/s would I need to press in order to show the formulas in my spreadsheet
What is control/accent tilde key
300
What symbol do you use to define a range of cells
What is a colon
400
Under this ribbon I can change my font style, color and size
What is the font tab
400
Excel performs a series of operations from left to right but gives some operators precedence over others. This acronym is...
What is PEMDAS
400
Show me how to add or subtract two decimal places
What is under the number tab, increase or decrease decimal places
400
What formula would be shown in cell G15
What is =Average(B15:F15)
400
How do I perform a sort in alphabetical order
What is by highlighting the data, clicking sort and filter or by inserting a table
500
Names the types of justification under the alignment ribbon to format text
What is left, right, center, indent
500
To add all the cells in column A, row 1 through row 20 and then multiply the sum by B8. I would write this how?
What is =sum(A1:A20)*B8
500
Show me how to add an accounting border in Excel
What is a double line border
500
There are three ways to arrive at the total of the test scores for Dan. What are they?
What is auto sum, =sum(B8:F8), and =B8+C8+D8+E8+F8
500
In the page setup window, I would select which tab to set the print orientation to portrait or landscape.