CSG2518 EXAM #1 MC KEN
ARMSTRONG QUESTIONS AND
ANSWERS
The SalesQtr2 workbook contains links to data in the April, May, and June workbooks.
Which workbook is the destination file? - Answer-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-Type B10 in the Formula Bar
and press Enter
Which step is not part of planning a worksheet design? - 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? - Answer-=A2-(A2*B2)
What should you do if you see pound signs (###) instead of values or results of
formulas? - Answer-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? - Answer-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? - Answer-Souvenir Shop
is centered over the range A1:E1, and April Sales Report is deleted.
What number format places a dollar sign on the left side of the cell, includes commas to
separate thousands, displays two decimal places, and displays zero values as
hyphens? - Answer-Accounting Number Format
You want to copy the March worksheet to use it to enter data for April. After you right-
click the March sheet tab and select Move or Copy, you click OK in the Move or Copy
dialog box without changing any settings. What happens? - Answer-The March sheet is
moved to the left of the first sheet tab. The worksheet is not copied.
The Header & Footer Tools tab contains commands that insert codes into a header or
footer. These codes enable the header or footer text to change automatically. You can
insert a code for all of the following except: - Answer-Your Name.
ARMSTRONG QUESTIONS AND
ANSWERS
The SalesQtr2 workbook contains links to data in the April, May, and June workbooks.
Which workbook is the destination file? - Answer-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-Type B10 in the Formula Bar
and press Enter
Which step is not part of planning a worksheet design? - 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? - Answer-=A2-(A2*B2)
What should you do if you see pound signs (###) instead of values or results of
formulas? - Answer-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? - Answer-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? - Answer-Souvenir Shop
is centered over the range A1:E1, and April Sales Report is deleted.
What number format places a dollar sign on the left side of the cell, includes commas to
separate thousands, displays two decimal places, and displays zero values as
hyphens? - Answer-Accounting Number Format
You want to copy the March worksheet to use it to enter data for April. After you right-
click the March sheet tab and select Move or Copy, you click OK in the Move or Copy
dialog box without changing any settings. What happens? - Answer-The March sheet is
moved to the left of the first sheet tab. The worksheet is not copied.
The Header & Footer Tools tab contains commands that insert codes into a header or
footer. These codes enable the header or footer text to change automatically. You can
insert a code for all of the following except: - Answer-Your Name.
