CGS 2518 Exam 1 Multiple Choice with verified
questions and answers 2025/2026
Cell A5 is the active cell. You want to make cell B10 the active cell. Which of the
following is not a method for going to cell B10?
- Use the Go To dialog box.
- Type B10 in the Name Box and press Enter.
- Use the scroll arrows on the keyboard.
- Type B10 in the formula bar and press enter. - correct answer-
Which step is not part of planning a worksheet design?
- Decide what input values are required.
- Enter labels, values, and formulas.
- State the purpose of the worksheet.
- Decide what outputs are required to achieved the purpose. - correct answer-
Enter labels, values, and formulas.
,Cell A2 contains the regular price $100. Cell B2 contains the discount rate 15%.
Cell C3 contains =A2*(1-B2) to calculate the sale price of $85. Which of the
following formulas produces the same result?
(a)=A2*(B2-1)
(b)=A2-(A2*B2)
(c)=A2*B2-1
(d)=A2*1-B2 - correct answer(b)=A2-(A2*B2)
What should you do if you see pound signs (###) instead of values or results of
formulas?
(a)Increase the column width.
(b)Increase the zoom percentage.
(c)Delete the column.
(d)Adjust the row height. - correct answer(a)Increase the column width.
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?
, (a)Formulas
(b)Keep Source Formatting
(c)Values & Source Formatting
(d)Values & Number Formatting - correct answer(c)Values & Source Formatting
The label Souvenir Shop is in cell A1, and April Sales Report is in cell B1. You select
the range A1:E1 and click Merge & Center. What is the result?
(a)Souvenir Shop is centered over the range A1:E1, and April Sales Report is
moved to cell F1.
(b)Excel does not let you merge and center a range of cells where those cells each
contain data.
(c)Souvenir Shop is combined with April Sales Report. The new combined label is
then centered over the range A1:E1.
(d)Souvenir Shop is centered over the range A1:E1, and April Sales Report is
deleted. - correct answer(d)Souvenir Shop is centered over the range A1:E1, and
April Sales Report is deleted.
questions and answers 2025/2026
Cell A5 is the active cell. You want to make cell B10 the active cell. Which of the
following is not a method for going to cell B10?
- Use the Go To dialog box.
- Type B10 in the Name Box and press Enter.
- Use the scroll arrows on the keyboard.
- Type B10 in the formula bar and press enter. - correct answer-
Which step is not part of planning a worksheet design?
- Decide what input values are required.
- Enter labels, values, and formulas.
- State the purpose of the worksheet.
- Decide what outputs are required to achieved the purpose. - correct answer-
Enter labels, values, and formulas.
,Cell A2 contains the regular price $100. Cell B2 contains the discount rate 15%.
Cell C3 contains =A2*(1-B2) to calculate the sale price of $85. Which of the
following formulas produces the same result?
(a)=A2*(B2-1)
(b)=A2-(A2*B2)
(c)=A2*B2-1
(d)=A2*1-B2 - correct answer(b)=A2-(A2*B2)
What should you do if you see pound signs (###) instead of values or results of
formulas?
(a)Increase the column width.
(b)Increase the zoom percentage.
(c)Delete the column.
(d)Adjust the row height. - correct answer(a)Increase the column width.
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?
, (a)Formulas
(b)Keep Source Formatting
(c)Values & Source Formatting
(d)Values & Number Formatting - correct answer(c)Values & Source Formatting
The label Souvenir Shop is in cell A1, and April Sales Report is in cell B1. You select
the range A1:E1 and click Merge & Center. What is the result?
(a)Souvenir Shop is centered over the range A1:E1, and April Sales Report is
moved to cell F1.
(b)Excel does not let you merge and center a range of cells where those cells each
contain data.
(c)Souvenir Shop is combined with April Sales Report. The new combined label is
then centered over the range A1:E1.
(d)Souvenir Shop is centered over the range A1:E1, and April Sales Report is
deleted. - correct answer(d)Souvenir Shop is centered over the range A1:E1, and
April Sales Report is deleted.
