Chapter 3: Introduction to Excel:
Creating and Formatting a Worksheet
Questions & Answers
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? - ANSWERSType B10 in the Formula
Bar and press Enter.
Which step is not part of planning a worksheet design? - ANSWERSEnter 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? - ANSWERS=A2-(A2*B2)
What should you do if you see pound signs (###) instead of values or results of
formulas? - ANSWERSIncrease 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? - ANSWERSValues & 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? - ANSWERSSouvenir
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? - ANSWERSAccounting 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? - ANSWERSThe March sheet
is moved to the left of the first sheet tab. The worksheet is not copied.
Creating and Formatting a Worksheet
Questions & Answers
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? - ANSWERSType B10 in the Formula
Bar and press Enter.
Which step is not part of planning a worksheet design? - ANSWERSEnter 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? - ANSWERS=A2-(A2*B2)
What should you do if you see pound signs (###) instead of values or results of
formulas? - ANSWERSIncrease 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? - ANSWERSValues & 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? - ANSWERSSouvenir
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? - ANSWERSAccounting 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? - ANSWERSThe March sheet
is moved to the left of the first sheet tab. The worksheet is not copied.
