WorksheetsExcel Topic 3
Total questions: 11
Worksheet time: 22mins
Allows you to turn borders on or off of a particular part of a cell
Drag
Borders Button
Expand the selection
Shading
A method of adjusting column width with use of the mouse and the double headed arrow pointer.
Drag
Autofit
Borders Button
Dialogue Box
Use the “bucket” on the Home tab to change fill color
Pattern
Expand the selection
Shading
Borders Button
Helps rearrange your data so you can use it more efficiently.
Drag
Dialogue Box
Borders Button
Sorting
Use “Format” in the Cell group of the Home tab to apply a combination of colors to fill a cell
Autofit
Expand the selection
Pattern
Shading
A method of adjusting column width where one cell of the column is resized just wide enough to hold the text in the cell you selected.
Autofit
Dialogue Box
Pattern
Border Tab
Excel will keep the data touching your column attached to the cell it is currently touching and sort them together.
Drag
Expand the selection
Dialogue Box
Borders Button
Double-click the right edge of a column’s heading and the column width changes to be as wide as the longest text in any cell in the column.
Sorting
Continue with the current selection
Border Tab
Autofit All
Use “Format” in the Cell group of the Home tab to select the border style and color.
Border Tab
Autofit All
Continue with the current selection
Auto fill
Excel will ONLY sort the column you selected and the columns attached to it will remain as they are.
Autofit All
Shading
Sorting
Continue with the current selection
A pop up window will allow you to type in the exact width you want a column’s cell to be.
Dialogue Box
Pattern
Autofit
Expand the selection
