Absolute-ly
Moving and Copying Cells
Column and Rows CI
Columns and Rows 101
100
This changes after being copied and pasted when (=$L$54*0.1) is written.
What is neither the row nor column.
100
When moving cells A17:B18 to the E15:D16 range, the former cell A17 will now be in this cell.
What is E15.
100
When adding a row via right-click, this is the tab you should click on.
What is Insert.
100
Double-clicking a column does this to the column.
What is Auto-fit's it to the largest data/cell in the column.
200
The ____ changes and ____ remains fixed (doesn't change) when (=Q$13*0.05) is written.
What is the column and row, respectively.
200
This is one way to change a cell's position.
What is making it active, moving the cursor to a border until a white arroy is displayed and clicking/draging the cell to a new place.
200
To insert a row via righ-click, this is the tabyou should click on.
What is Insert.
300
The _____ changes while the ____ remains fixed (doesn't change) when (=$D6*1.5) is written.
What is row and column, respectively.
300
Doing this allows you to select multiple cells and copy them, if theyaren't adjacent.
What is holding CTRL adn clicking the wanted cells. then pushing CTRL+C or right clicking and clicking Copy.
300
Besides via the right-clicking method, you can also do this to insert a row.
What is click on the row number,click on the aroow under Insert in the Cells tab in the Home Ribbon and clicking on Insert Sheet Rows.
400
The _____ and _____ changes when (=V6*1.02) is written.
What is column and row, interchangeably.
400
When moving merged cless, this happens.
What is the merged cells unmerge.
400
Besides via the right-clicking method, you can also do this to insert a column.
What is click on the row number,click on the aroow under Insert in the Cells tab in the Home Ribbon and clicking on Insert Sheet Columns.
500
This is the keyboard shortcut to make a cell address absolute.
What is Function Key 4 or F4
500
When a cell is copied and pasted somewhere else, this happens to the copied cell.
What is nothing.
500
You are unable to do this if you highlight both rows and columns.
What is insert a row/column.
M
e
n
u