CGS 2518 Exam 1 FSU Armstrong
questions and answers rated A+
Which step is not part of planning a worksheet design? - correct 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? - correct answer ✔✔Values and source formatting.
Given the formula =B1*B2+B3/B4^2, what operation is calculated first? - correct answer
✔✔B4^2
How can you display formulas within the cells instead of the cell results? - correct answer
✔✔Press Ctrl+'
What is the fast way to apply several formats at one time? - correct answer ✔✔Apply a cell
style.
Which of the following is not an alignment option? - correct answer ✔✔Fill color.
Which of the following characteristics is not applicable to the accounting number format? -
correct 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? - correct
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? - correct answer ✔✔Increase the left and right margins.
What should you do if you see pound signs (###) instead of values or results of formulas? -
correct 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? -
correct answer ✔✔Mixed Reference
What function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5? -
correct answer ✔✔=AVERAGE(B5:F5)
When you start to type =AV, what feature displays a list of functions and defined names? -
correct 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? - correct answer ✔✔=$B5
Which of the following functions should be used to insert the current date and time in a cell? -
correct answer ✔✔=NOW()
Which of the following is not an argument of the IF function? - correct answer ✔✔lookup_value
Which of the following is not true about the VLOOKUP function? - correct answer ✔✔The
lookup table must be in descending order
questions and answers rated A+
Which step is not part of planning a worksheet design? - correct 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? - correct answer ✔✔Values and source formatting.
Given the formula =B1*B2+B3/B4^2, what operation is calculated first? - correct answer
✔✔B4^2
How can you display formulas within the cells instead of the cell results? - correct answer
✔✔Press Ctrl+'
What is the fast way to apply several formats at one time? - correct answer ✔✔Apply a cell
style.
Which of the following is not an alignment option? - correct answer ✔✔Fill color.
Which of the following characteristics is not applicable to the accounting number format? -
correct 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? - correct
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? - correct answer ✔✔Increase the left and right margins.
What should you do if you see pound signs (###) instead of values or results of formulas? -
correct 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? -
correct answer ✔✔Mixed Reference
What function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5? -
correct answer ✔✔=AVERAGE(B5:F5)
When you start to type =AV, what feature displays a list of functions and defined names? -
correct 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? - correct answer ✔✔=$B5
Which of the following functions should be used to insert the current date and time in a cell? -
correct answer ✔✔=NOW()
Which of the following is not an argument of the IF function? - correct answer ✔✔lookup_value
Which of the following is not true about the VLOOKUP function? - correct answer ✔✔The
lookup table must be in descending order
