You moved a chart to its own chart sheet. What chart element can you add to provide
a grid that contains a copy of the data source at the bottom of the chart?
Give this one a try later!
data table
,You want to copy the March worksheet to use it to enter data for April. After you
right-click the March sheet tab and select Move or Copy, you click OK in the Move or
Copy dialog box without changing any settings. What happens?
Give this one a try later!
The March sheet is moved to the left of the first sheet tab. The worksheet is
not copied.
What number format places a dollar sign on the left side of the cell, includes commas
to separate thousands, displays two decimal places, and displays zero values as
hyphens?
Give this one a try later!
accounting number format
Which of the following is not a comparison operator?
&
<
>
<>
Give this one a try later!
&
, Which of the following is not an aggregate function that can be applied in a total
row?
MAX
COUNT
VLOOKUP
AVERAGE
Give this one a try later!
VLOOKUP
You just copied a range of data containing formulas. However, you want to preserve
the formula results and the original number and text formatting in the pasted range.
Which paste option would you select?
Give this one a try later!
Values & Source Formatting
The label Souvenir Shop is in cell A1, and April Sales Report is in cell B1. You select the
range A1:E1 and click Merge & Center. What is the result?
Souvenir Shop is centered over the range A1:E1, and April Sales Report is moved to
cell F1.
Souvenir Shop is combined with April Sales Report. The new combined label is then
centered over the range A1:E1.
Excel does not let you merge and center a range of cells where those cells each
contain data.
Souvenir Shop is centered over the range A1:E1, and April Sales Report is deleted.
Give this one a try later!
a grid that contains a copy of the data source at the bottom of the chart?
Give this one a try later!
data table
,You want to copy the March worksheet to use it to enter data for April. After you
right-click the March sheet tab and select Move or Copy, you click OK in the Move or
Copy dialog box without changing any settings. What happens?
Give this one a try later!
The March sheet is moved to the left of the first sheet tab. The worksheet is
not copied.
What number format places a dollar sign on the left side of the cell, includes commas
to separate thousands, displays two decimal places, and displays zero values as
hyphens?
Give this one a try later!
accounting number format
Which of the following is not a comparison operator?
&
<
>
<>
Give this one a try later!
&
, Which of the following is not an aggregate function that can be applied in a total
row?
MAX
COUNT
VLOOKUP
AVERAGE
Give this one a try later!
VLOOKUP
You just copied a range of data containing formulas. However, you want to preserve
the formula results and the original number and text formatting in the pasted range.
Which paste option would you select?
Give this one a try later!
Values & Source Formatting
The label Souvenir Shop is in cell A1, and April Sales Report is in cell B1. You select the
range A1:E1 and click Merge & Center. What is the result?
Souvenir Shop is centered over the range A1:E1, and April Sales Report is moved to
cell F1.
Souvenir Shop is combined with April Sales Report. The new combined label is then
centered over the range A1:E1.
Excel does not let you merge and center a range of cells where those cells each
contain data.
Souvenir Shop is centered over the range A1:E1, and April Sales Report is deleted.
Give this one a try later!
