Basics Flashcards
Which key do you hold down when you want to select cells in different areas of the worksheet
Control
How do you write an absolute cell
$A$B dollar signs first
What do you always use with a formula
=
What do you use to copy formatting
Format painting
How do you minimize or expand the ribbon
Double click the tab
How do you add to your quick access tool bar
Go to the desired button on your ribbon tab right click and add to quick access tool bar
Where and what is your status bar
Bottom right, shows the average, count and sum of the selected numeric values
What is the big white cross icon
The select tool
What is the black arrow icon when you are on the edge of a cell?
Drag and drop or move
How do you select a large group of cells
Control a or select first and hold shift then select last
How do you use split screen
Select the cell you want to divide along, then select split screen from the view ribbon
How to copy down
Double click bottom right aarow
How do I autofill with a pattern?
Select the cells that contain the pattern. Such as counting by 8s 8 then 16 and use fill excel automatically finds and continues the pattern.
How to use flash fill
For more complex patterns, such as a list of names and the next column is first.last@email.com using flash fill will continue to concatenate the rest of the names
How do you start a new line inside a cell
Alt enter
