MS Excel
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

The status bar does not display the cell address
Cell address will change when it is copied to another cell
An absolute cell address is created
The sheet tab is changed

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
What happens when you press Ctrl + X after selecting some cells in Excel?

The cell content of selected cells disappear from cell and stored in clipboard
The selected cells are deleted and the cells are shifted left
The cells selected are marked for cutting
The selected cells are deleted and cells are shifted up

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
When you copy a formula

Excel erases the original copy of the formula
Excel adjusts absolute cell references
Excel edits cell references in the newly copied formula
Excel doesn’t adjust relative cell references

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
The name box

Appears below the menu bar
Shows the location of the previously active cell
Appears below the status bar
Appears to the left of the formula bar

ANSWER DOWNLOAD EXAMIANS APP