to move to the cell directly beneath the selected cell, press which key on the keyboard?
What is return/enter
100
true/false - you can delete a single cell
What is true
100
a formula always begins with
What is an equals sign
100
if you want to apply a border to cells A1:D13, what is the first step?
What is select a1:d13
200
a vertical group of cells
What is a column
200
true/false - in order to type in a cell, you need to double click the cell
What is false
200
true/false - to delete an entire column with one click, right click anywhere in the column and press delete
What is false
200
these are preprogrammed shortcuts for calculating complex equations
What are functions?
200
the border button is located under which tab?
What is the home tab?
300
the data entry area directly below the ribbon but above the worksheet. The fx button is directly to the left of this bar
What is a formula bar
300
to get your text to move to the next LINE within a cell instead of continuing to the right, which option would you choose in the home tab?
What is wrap text
300
new columns insert ______, new rows insert ______
What is left, above
300
true/false - formulas can contain cell references
What is true
300
which button looks like a paintbucket?
What is the shading button
400
displays the address of a selected cell. Appears in the top left corner of the excel screen
What is the name box
400
When you want to center text across a selected group of cells, which button would you choose in the home tab?
What is merge and center
400
In which tab is the styles group located?
What is the home tab
400
which button do you click and where is it located to insert a function?
What is fx button, autosum button, formula tab
400
list the 3 steps to properly use format painter in excel
What is select cell with desired format, click format painter, click on cells you want to change
500
appears at the bottom of the worksheet and displays information about the selected data like count, average, and sum.
What is the status bar?
500
when you want to fill a group of cells with the same data or copy a single formula to a group of cells, you would use this little black cross
What is the fill handle?
500
a combination of effects that can be applied at one time. Can include combinations of color, number formatting, fonts, etc... this group is located on the home tab
What are styles?
500
give 3 examples of a function
What is average, sum, pmt, count numbers, etc...
500
which paste option would you use to paste only the content of a cell, not the formatting?