CGS 2518 EXAM 1 FSU ARMSTRONG | QUESTIONS AND
ANSWERS | 100% CORRECT.
Which step is not part of planning a worksheet design? Answer - Enter labels,
values and formulas.
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? Answer - Values and
source formatting.
Given the formula =B1*B2+B3/B4^2, what operation is calculated first?
Answer - B4^2
How can you display formulas within the cells instead of the cell results?
Answer - Press Ctrl+'
What is the fast way to apply several formats at one time? Answer - Apply a
cell style.
Which of the following is not an alignment option? Answer - Fill color.
Which of the following characteristics is not applicable to the accounting
number format? Answer - Dollar sign immediately on the left side of the value.
, You selected and copied worksheet data containing formulas. however you
want the pasted copy to contain the current formula results rather than
formulas, what do you do? Answer - Click The paste arrow in the clipboard
group and select values and source formatting
Assume that the data on a worksheet consume a whole printed page and a
couple of columns on a second page you can do all of the following except
what to force the data to print all on one page? Answer - Increase the left and
right margins.
What should you do if you see pound signs (###) instead of values or results of
formulas? Answer - Increase the column width.
If Cell E15 contains the formula =$c$5*J$15, what type of reference is the J$15
in the formula? Answer - Mixed Reference
What function would most efficiently accomplish the same thing as
=(B5+C5+D5+E5+F5)/5? Answer - =AVERAGE(B5:F5)
When you start to type =AV, what feature displays a list of functions and
defined names? Answer - Formula AutoComplete
A formula containing the entry =$B3 is copied to a cell one column to the right
and two rows down. How will the entry appear in its new location? Answer -
=$B5
Which of the following functions should be used to insert the current date and
time in a cell? Answer - =NOW()
ANSWERS | 100% CORRECT.
Which step is not part of planning a worksheet design? Answer - Enter labels,
values and formulas.
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? Answer - Values and
source formatting.
Given the formula =B1*B2+B3/B4^2, what operation is calculated first?
Answer - B4^2
How can you display formulas within the cells instead of the cell results?
Answer - Press Ctrl+'
What is the fast way to apply several formats at one time? Answer - Apply a
cell style.
Which of the following is not an alignment option? Answer - Fill color.
Which of the following characteristics is not applicable to the accounting
number format? Answer - Dollar sign immediately on the left side of the value.
, You selected and copied worksheet data containing formulas. however you
want the pasted copy to contain the current formula results rather than
formulas, what do you do? Answer - Click The paste arrow in the clipboard
group and select values and source formatting
Assume that the data on a worksheet consume a whole printed page and a
couple of columns on a second page you can do all of the following except
what to force the data to print all on one page? Answer - Increase the left and
right margins.
What should you do if you see pound signs (###) instead of values or results of
formulas? Answer - Increase the column width.
If Cell E15 contains the formula =$c$5*J$15, what type of reference is the J$15
in the formula? Answer - Mixed Reference
What function would most efficiently accomplish the same thing as
=(B5+C5+D5+E5+F5)/5? Answer - =AVERAGE(B5:F5)
When you start to type =AV, what feature displays a list of functions and
defined names? Answer - Formula AutoComplete
A formula containing the entry =$B3 is copied to a cell one column to the right
and two rows down. How will the entry appear in its new location? Answer -
=$B5
Which of the following functions should be used to insert the current date and
time in a cell? Answer - =NOW()
