ITE 140 EXAM 2 (CHAPTERS 4-7) |QUESTIONS AND ANSWERS | NORTHERN VIRGINIA COMMUNITY COLLEGE.

ITE 140 EXAM 2 (CHAPTERS 4-7) |QUESTIONS AND ANSWERS |
NORTHERN VIRGINIA COMMUNITY COLLEGE.




You can use a two-input data table to see how your monthly mortgage payment will be affected by
changing the interest rate and the term of the loan? (True or False) - (answer)True



To hide formulas so that users won't see them in the formula bar when they select a cell, select the
Hidden check box in the Format Cells dialog box and then protect the worksheet? (True or False) -
(answer)False



Clicking the Increase Decimal button in the Number group changes the displayed cell value 14.54 to
14.5? (True or False) - (answer)False



Kai wants to prevent users from making structural changes to a workbook. To do so, he can protect the
workbook with a password? (True or False) - (answer)True



Vaughn listed unit prices in the range C3:C25 and wants to highlight cells in that range if they match the
price in cell B1. Which of the following options should he select on the Highlight Cell Rules submenu? -
(answer)Equal to



Which of the following are you creating when you specify a row that contains text to repeat at the top of
each printed page? - (answer)Print titles



Which of the following can you use in formulas instead of a cell or range address? - (answer)Cell name



Carol wants to display a workbook window she had hidden earlier. Which of the following buttons
should she select on the View tab? - (answer)Unhide button



Leah needs to borrow money to buy a car. In a worksheet, she entered the loan amount, monthly
interest rate, and number of months to repay the loan. Which if the following functions should she use
to calculate her monthly payment> - (answer)PMT

, ITE 140 EXAM 2 (CHAPTERS 4-7) |QUESTIONS AND ANSWERS |
NORTHERN VIRGINIA COMMUNITY COLLEGE.




To format a cell range so that values between 100 and 500 appear in red, which of the following can you
use? - (answer)Highlight cell rules



You can create a one-input data table in Excel to insert a range of cells that shows the resulting values
when one input value is varied in a formula? (True or False) - (answer)True



If you protect a worksheet, users can enter data only in the unprotected cells? (True or False)? -
(answer)True



If you cannot edit some cells on a worksheet, you can click the Unprotect Sheet button on the Review
tab to unprotect the worksheet? (True or False) - (answer)True



If you select cells and then remove the check mark from the Locked check box in the Format Cells dialog
box, you can modify the selected cells after protecting the worksheet? (True or False) - (answer)True



Ina wants to protect a worksheet with a password to limit the changes other users can make. Before
protecting the worksheet, she must unlock the cells she will allow the other users to edit? (True or False)
- (answer)True



To preserve the original version of a workbook so you can make changes to a copy of it, which of the
following would you do? - (answer)Open the workbook, make changes, and then save it using a different
name.



To save a workbook for the first time, you can use the Save As dialog box? (True or False) - (answer)True



A worksheet named Income (2) is most likely which of the following? - (answer)A copy of another
worksheet named Income



Stella inserted the number 46.374 in cell G5. She can use the formula = ROUNDDOWN(G5,0) to round
46.734 down to 46? (True or false) - (answer)True