EXCEL INTERMEDIATE QUESTIONS
AND ANSWERS
To change the color of a worksheet tab - Correct Answers -Right click on the tab and
choose tab color, OR Click on the worksheet tab, click Home, click Format, choose Tab
Color
To move the contents of cell B4 to F10 - Correct Answers -Select B4, right click and
select Cut, click on F10, right click Paste , OR Select B4, roll over the edge of the cell
and drag the cell to F10
When using fill down, which is NOT an option - Correct Answers -Copy without
formatting
Frank would like to move the contents of column F in between the A and B columns he
should - Correct Answers -Select column F, choose cut, click on the column header for
B and choose insert cut cells
The correct syntax to make the contents of cell f23 always match the contents of cell d5
is to - Correct Answers -Add the function "=d5" in cell f23
What is the sequence to use to change the format of data in a cell - Correct Answers -
Select cell, choose home tab, cells grouping, format
When a cell that contains a function is selected the formula bar will display - Correct
Answers -The formula
What text qualifier tells Excel that the cell contains a formula - Correct Answers -=
How does a user define a cell name (A1) as an absolute reference - Correct Answers -
$A$1
Juan is creating a worksheet that has each week in the month of January in cells B2-B5.
How can he put the Label "January" above the cells and center it - Correct Answers -
Select the cells above the weeks choose merge and center
Julia would like to rearrange her data so that it is in order by the first column - Correct
Answers -Select the data, choose sort, select first column
AND ANSWERS
To change the color of a worksheet tab - Correct Answers -Right click on the tab and
choose tab color, OR Click on the worksheet tab, click Home, click Format, choose Tab
Color
To move the contents of cell B4 to F10 - Correct Answers -Select B4, right click and
select Cut, click on F10, right click Paste , OR Select B4, roll over the edge of the cell
and drag the cell to F10
When using fill down, which is NOT an option - Correct Answers -Copy without
formatting
Frank would like to move the contents of column F in between the A and B columns he
should - Correct Answers -Select column F, choose cut, click on the column header for
B and choose insert cut cells
The correct syntax to make the contents of cell f23 always match the contents of cell d5
is to - Correct Answers -Add the function "=d5" in cell f23
What is the sequence to use to change the format of data in a cell - Correct Answers -
Select cell, choose home tab, cells grouping, format
When a cell that contains a function is selected the formula bar will display - Correct
Answers -The formula
What text qualifier tells Excel that the cell contains a formula - Correct Answers -=
How does a user define a cell name (A1) as an absolute reference - Correct Answers -
$A$1
Juan is creating a worksheet that has each week in the month of January in cells B2-B5.
How can he put the Label "January" above the cells and center it - Correct Answers -
Select the cells above the weeks choose merge and center
Julia would like to rearrange her data so that it is in order by the first column - Correct
Answers -Select the data, choose sort, select first column
