CGS 1060 EXAM QUESTIONS WITH
COMPLETE SOLUTIONS 2025
, Which of the following will you select as X in the given series of clicks to insert a pie
chart: Insert > Charts group > X >? - ANSWERInsert Pie or Doughnut Chart
If you discover an error immediately after you have confirmed a cell entry, what of the
following would you use next? - ANSWERThe Undo button on the Quick Access toolbar
To have Excel enter the lowest price from a range of prices, which of the following
would you use? - ANSWERMIN function
To see a preview of how a pasted value will look, which of the following would you use?
- ANSWERPaste List arrow
To select a single worksheet cell so you can work with it, which of the following would
you do? - ANSWERClick the cell.
On which tab and button are document properties located for editing? - ANSWERFile
tab Info button
To combine multiple cells into one combined cell, which of the following do you use? -
ANSWERMerge and Center button
In the formula =SUM(A6:A9), which of the following best describes A6? -
ANSWERargument
You have selected a cell with a formula. Which of the following can you use to copy that
formula to an adjacent cell? - ANSWERFill handle
Which of the following lets you search for a function or select one from a category? -
ANSWERInsert Function dialog box
When you underline cell content, you are using _____. - ANSWERFont style
How many actions does the Undo button let you reverse? - ANSWER100
To align currency symbols and decimal points in a column of numbers, you can apply
the ____ number format. - ANSWERCurrency
Your worksheet is too wide to fit on one portrait page. What is the best way to fix this
problem? - ANSWERChange the Page Orientation to landscape
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most
efficiently? - ANSWER=SUM(B6:B10)
COMPLETE SOLUTIONS 2025
, Which of the following will you select as X in the given series of clicks to insert a pie
chart: Insert > Charts group > X >? - ANSWERInsert Pie or Doughnut Chart
If you discover an error immediately after you have confirmed a cell entry, what of the
following would you use next? - ANSWERThe Undo button on the Quick Access toolbar
To have Excel enter the lowest price from a range of prices, which of the following
would you use? - ANSWERMIN function
To see a preview of how a pasted value will look, which of the following would you use?
- ANSWERPaste List arrow
To select a single worksheet cell so you can work with it, which of the following would
you do? - ANSWERClick the cell.
On which tab and button are document properties located for editing? - ANSWERFile
tab Info button
To combine multiple cells into one combined cell, which of the following do you use? -
ANSWERMerge and Center button
In the formula =SUM(A6:A9), which of the following best describes A6? -
ANSWERargument
You have selected a cell with a formula. Which of the following can you use to copy that
formula to an adjacent cell? - ANSWERFill handle
Which of the following lets you search for a function or select one from a category? -
ANSWERInsert Function dialog box
When you underline cell content, you are using _____. - ANSWERFont style
How many actions does the Undo button let you reverse? - ANSWER100
To align currency symbols and decimal points in a column of numbers, you can apply
the ____ number format. - ANSWERCurrency
Your worksheet is too wide to fit on one portrait page. What is the best way to fix this
problem? - ANSWERChange the Page Orientation to landscape
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most
efficiently? - ANSWER=SUM(B6:B10)
