CGS 2518 EXAM QUESTIONS AND
ANSWERS
You have a workbook that contains sales data where each sales rep's data is stored on
a separate worksheet. Which task is the least likely to be done while the worksheets are
grouped? - Answer-(a)Fill the sales categories across the worksheets.
(b)Format the column and row labels at the same time.
(c)Enter specific values for the first sales rep.
(d)Format the values with an appropriate number style.
A worksheet contains over 400 rows. The first 10 rows contain input data, and functions
containing summary statistics are in the last 10 rows. What is the most efficient method
to see the input area and summary statistics at the same time without having to scroll
back and forth between sections? - Answer-(a)Open multiple windows of the same
workbook and use the Arrange Windows command to tile the windows.
(b)Display a Watch Window for the input section as you view the summary statistics
section.
(c)Select the summary statistics and use the Freeze Panes option.
(d)Use the Split command and adjust one pane to see the input section and another
pane to see the summary statistics.
Which function correctly adds data in cell D25 across multiple worksheets? - Answer-
(a)=SUM(Monday,Friday:D25)
(b)=SUM(Monday:Friday!D25)
(c)=COUNT(Mon:D25,Tues:D25,Wed:D25,Thurs:D25,Fri:D25)
(d)=Monday:D25+Friday:D25
The SalesQtr2 workbook contains links to data in the April, May, and June workbooks.
Which workbook is the destination file? - Answer-(a)June
(b)April
(c)May
(d)SalesQtr2
, 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? - Answer-(A)Use the Go To dialog box.
(b)Type B10 in the Name Box and press Enter.
(c)Use the scroll arrows on the keyboard.
(d)Type B10 in the Formula Bar and press Enter.
- (d)Type B10 in the Formula Bar and press Enter.
Which step is not part of planning a worksheet design? - Answer-(A)Decide what input
values are required.
(b)Enter labels, values, and formulas.
(c)State the purpose of the worksheet.
(d)Decide what outputs are required to achieve the purpose.
- (b)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? - Answer-(a)=A2*(B2-1)
(b)=A2-(A2*B2)
(c)=A2*B2-1
(d)=A2*1-B2
- (B)A2-(A2*B2)
What should you do if you see pound signs (###) instead of values or results of
formulas? - Answer-(a)Increase the column width.
(b)Increase the zoom percentage.
(c)Delete the column.
(d)Adjust the row height.
-A
ANSWERS
You have a workbook that contains sales data where each sales rep's data is stored on
a separate worksheet. Which task is the least likely to be done while the worksheets are
grouped? - Answer-(a)Fill the sales categories across the worksheets.
(b)Format the column and row labels at the same time.
(c)Enter specific values for the first sales rep.
(d)Format the values with an appropriate number style.
A worksheet contains over 400 rows. The first 10 rows contain input data, and functions
containing summary statistics are in the last 10 rows. What is the most efficient method
to see the input area and summary statistics at the same time without having to scroll
back and forth between sections? - Answer-(a)Open multiple windows of the same
workbook and use the Arrange Windows command to tile the windows.
(b)Display a Watch Window for the input section as you view the summary statistics
section.
(c)Select the summary statistics and use the Freeze Panes option.
(d)Use the Split command and adjust one pane to see the input section and another
pane to see the summary statistics.
Which function correctly adds data in cell D25 across multiple worksheets? - Answer-
(a)=SUM(Monday,Friday:D25)
(b)=SUM(Monday:Friday!D25)
(c)=COUNT(Mon:D25,Tues:D25,Wed:D25,Thurs:D25,Fri:D25)
(d)=Monday:D25+Friday:D25
The SalesQtr2 workbook contains links to data in the April, May, and June workbooks.
Which workbook is the destination file? - Answer-(a)June
(b)April
(c)May
(d)SalesQtr2
, 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? - Answer-(A)Use the Go To dialog box.
(b)Type B10 in the Name Box and press Enter.
(c)Use the scroll arrows on the keyboard.
(d)Type B10 in the Formula Bar and press Enter.
- (d)Type B10 in the Formula Bar and press Enter.
Which step is not part of planning a worksheet design? - Answer-(A)Decide what input
values are required.
(b)Enter labels, values, and formulas.
(c)State the purpose of the worksheet.
(d)Decide what outputs are required to achieve the purpose.
- (b)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? - Answer-(a)=A2*(B2-1)
(b)=A2-(A2*B2)
(c)=A2*B2-1
(d)=A2*1-B2
- (B)A2-(A2*B2)
What should you do if you see pound signs (###) instead of values or results of
formulas? - Answer-(a)Increase the column width.
(b)Increase the zoom percentage.
(c)Delete the column.
(d)Adjust the row height.
-A
