RIBBON TAB ICONS
WHERE ARE YOU/WHAT’S YOUR LOCATION
KNOWING YOUR WAY AROUND
WORKING WITH DATA
INSERTING/ DELETING/FROMATTING/SORTING
100
Copy
What is name of the icon that have a picture of two sheets of paper?
100
Vertically from left to right
What directions to rows go from?
100
Click on the Title of the tab
How do you navigate from one tab on the ribbon to another?
100
Columns
Titles/Headings should be entered underneath what?
100
Click on the column number to highlight it, select the insert option under the cell group located in the home tab
How do you add a column?
200
The Microsoft office button
What is the name of the button you press to open, print or save a workbook called?
200
horizontal up and down
What is direction do column go?
200
Sheet tabs
The tabs located at the bottom left of the sheet is called?
200
Rows
Information/data should be entered next to what?
200
Click on the row number to highlight it, select the delete option under the cell group located in the home tab.
How do you delete a row?
300
Scissors
What icon is used to cut a cell?
300
A row and a column
What two things form a cell?
300
Quick Access Tool Bar
What is the tool bar with the most frequently used icon on it called?
300
Use the centering icon located under the alignment group in the home tab
How do you center data in the cells?
300
Highlight the cells and use the cells style option under the styles group located in the Home tab.
How do you format cells?
400
Font group
On which group can you find the fill color icon?
400
In the Name Box
When in an active cell the cell name appears where?
400
Highlight the columns, place cursor between two of the columns until you get the 4 way arrow w/ the point on the left and right side hold down and drag.
How do you change the width of more than one column at the same time?
400
The Font group located in the home tab.
Where do you go to change the data in a cell to bold?
400
Double click the sheet tab, select the format option under the cells group of the home tab, select tab color and click on color you want.
How do you apply color to the sheet tabs?
500
Orientation
What is name of the icon that allows you to rotate text in a diagonal angle?
500
The Formula Bar
When you have data in a cell it appears where?
500
Highlight the rows, place cursor between two of the columns until you get the 4 way arrow w/ the points at the top and bottom hold down and drag.
How do you change the height of more than one row at the same time?
500
By using the merge and center icon located alignment group in the home tab.
How do you combine cells together and center the text?
500
Highlight the data you want sorted, click on the sort and filter icon located in the editing group under the home tab.
How do you sort the data in a worksheet?