CGS 2518 EXAM 1 FSU ARMSTRONG
EXAM QUESTIONS AND ANSWERS 100%
PASS 2026/2027
Which step is not part of planning a worksheet design? - ANS 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? - ANS Values and source formatting.
Given the formula =B1*B2+B3/B4^2, what operation is calculated first? - ANS B4^2
How can you display formulas within the cells instead of the cell results? - ANS Press Ctrl+'
What is the fast way to apply several formats at one time? - ANS Apply a cell style.
Which of the following is not an alignment option? - ANS Fill color.
Which of the following characteristics is not applicable to the accounting number format? -
ANS Dollar sign immediately on the left side of the value.
@2026 ALLRIGHTS RESERVED 1
, 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? - ANS 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? - ANS Increase the left and right margins.
What should you do if you see pound signs (###) instead of values or results of formulas? -
ANS 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? -
ANS Mixed Reference
What function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5? -
ANS =AVERAGE(B5:F5)
When you start to type =AV, what feature displays a list of functions and defined names? -
ANS 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? - ANS =$B5
Which of the following functions should be used to insert the current date and time in a cell? -
ANS =NOW()
Which of the following is not an argument of the IF function? - ANS lookup_value
@2026 ALLRIGHTS RESERVED 2
EXAM QUESTIONS AND ANSWERS 100%
PASS 2026/2027
Which step is not part of planning a worksheet design? - ANS 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? - ANS Values and source formatting.
Given the formula =B1*B2+B3/B4^2, what operation is calculated first? - ANS B4^2
How can you display formulas within the cells instead of the cell results? - ANS Press Ctrl+'
What is the fast way to apply several formats at one time? - ANS Apply a cell style.
Which of the following is not an alignment option? - ANS Fill color.
Which of the following characteristics is not applicable to the accounting number format? -
ANS Dollar sign immediately on the left side of the value.
@2026 ALLRIGHTS RESERVED 1
, 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? - ANS 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? - ANS Increase the left and right margins.
What should you do if you see pound signs (###) instead of values or results of formulas? -
ANS 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? -
ANS Mixed Reference
What function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5? -
ANS =AVERAGE(B5:F5)
When you start to type =AV, what feature displays a list of functions and defined names? -
ANS 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? - ANS =$B5
Which of the following functions should be used to insert the current date and time in a cell? -
ANS =NOW()
Which of the following is not an argument of the IF function? - ANS lookup_value
@2026 ALLRIGHTS RESERVED 2
