How can you display formulas within the cells instead of the cell results?
Give this one a try later!
Press Ctrl+`.
Assume that the data on a worksheet consume a whole printed page and a couple of
column on a second page. You can do all of the following except to force the data to
print all on one page?
Give this one a try later!
Increase the left and right margins
, What function would most efficiently accomplish the same thing as =
(B5+C5+D5+E5+F5)/5?
Give this one a try later!
=AVERAGE(B5:F5)
What does a negative COVARIANCE indicate?
Give this one a try later!
an inverse relationship between the datasets
Which of the following is not an alignment option?
Give this one a try later!
Fill Color
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 period range.
Which paste option would you select?
Give this one a try later!
Give this one a try later!
Press Ctrl+`.
Assume that the data on a worksheet consume a whole printed page and a couple of
column on a second page. You can do all of the following except to force the data to
print all on one page?
Give this one a try later!
Increase the left and right margins
, What function would most efficiently accomplish the same thing as =
(B5+C5+D5+E5+F5)/5?
Give this one a try later!
=AVERAGE(B5:F5)
What does a negative COVARIANCE indicate?
Give this one a try later!
an inverse relationship between the datasets
Which of the following is not an alignment option?
Give this one a try later!
Fill Color
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 period range.
Which paste option would you select?
Give this one a try later!
