Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/101

Click to flip

101 Cards in this Set

  • Front
  • Back
You have a list containing all the employees in your organization. You have a criteria range that shows Manager in the Title field in row 18 and New York in the Location field in row 19. Which rows will be
displayed?

(a) All managers in New York
(b) All managers regardless of location and all employees in New York
(c) All managers except those in New York
(d) All managers except those in New York and all New York employees
Chapter 5 Question 10.

(b) All managers regardless of location and all employees in New York
You have a criteria range that you thought would select marketing reps with sales greater than $1,000,000. When you apply the filter, all rows are displayed. What is the most likely reason for this?

(a) You used an OR instead of an AND in your criteria range.
(b) You have a blank row in the criteria range.
(c) You have a blank row in the list.
(d) You mistyped the field names in the criteria range.
Chapter 5 Question 11.

(b) You have a blank row in the criteria range.
To open a dialog box showing all the range names you have defined, use the:
(a) Edit Names command
(b) Name Manager command
(c) View Names command
(d) List Names command
Chapter 5 Question 12.

(b) Name Manager command
You want to show total sales for each location. What should you do before executing the Subtotals
command?
(a) Sort by Sales, in ascending order.
(b) Sort by Sales, in descending order.
(c) Sort by Sales, in either ascending or descending
order, then by Location.
(d) Sort by Location, in either ascending or descending order.
Chapter 5 Q 13.

(d) Sort by Location, in either ascending or descending order.
You use the DAVERAGE function. No rows match your criteria. What is the result of the function?
(a) ###########
(b) The #REF! error message
(c) A circular reference
(d) The #DIV /0 error message
Chapter 5 Q 14

(d) The #DIV /0 error message
Which method will correctly import data from an Access database into Excel?
(a) Use the Query Wizard.
(b) Use the Text Import Wizard.
(c) Use the Get External Data from Access command.
(d) You cannot import data from Access into Excel.
Chapter 5 Q 15.

(c) Use the Get External Data from Access command.
You have a list containing all the employees in your organization. You want to generate two sets of subtotals: the number of employees in each office, and within each office, the number of employees by job title. How can you accomplish this?

(a) You cannot accomplish what the question asks.
(b) Sort the list by office, generate subtotals, resort by title, and then generate subtotals again. Use the COUNT summary function for both subtotals.
(c) Sort the list by office, then by title and generate subtotals on both fields. Use the COUNT summary function for both fields.
(d) Sort the list by office, then by title. Generate subtotals on the office field using the COUNT function. Generate subtotals on the title field using the COUNT field and then clearing the check box to replace the current subtotals.
Chapter 5 Q 16.

(d) Sort the list by office, then by title. Generate subtotals on the office field using the COUNT function. Generate subtotals on the title field using the COUNT field and then clearing the check box to replace the current subtotals.
You have created a PivotTable and make some changes to the cells underlying the PivotTable. How can you update the information in the PivotTable?

(a) Click the cell(s) you changed, and then use the Refresh PivotTable command.
(b) Click the PivotTable, and then use the Refresh All command.
(c) PivotTables are automatically updated once you alter the data.
(d) Once created, PivotTables cannot be updated.
Chapter 5 Q 17.

(b) Click the PivotTable, and then use the Refresh All command.
You have created a PivotChart showing sales by quarter by sales rep. Before presenting it to management, you notice the name of a rep who has since been fired . How do you delete this rep from the chart without deleting the data?
(a) Click the arrow next to the Sales Rep field and remove the employee's name.
(b) Make the employee'S data points and axis titles invisible.
(c) You can't delete the rep from the chart without first deleting the data.
(d) Hide that rep's row(s) in the underlying list, which automatically removes that rep from the chart.
Chapter 5 Q 18.

(a) Click the arrow next to the Sales Rep field and remove the employee's name.
All of the following statements regarding fields are true except.

(a) The field names must be entered in the first row of the list.
(b) The field names will change from record to record.
(c) Each field name must be unique.
(d) The fields will be in the same order in every record.
Chapter 5 Q 1.

(b) The field names will change from record to record.
You have a list of all the members of a club you belong to. The worksheet contains other data as well. How can you be sure Excel recognizes the boundaries of the list?
(a) Insert a comment in the upper-left corner of the
list.
(b) Insert a blank row between the field names and the data.
(c) Insert a blank row and a blank column between the list and other data in the worksheet.
(d) Type a row of dashes (- - -) after the last row of the list.
Chapter 5 Q 2.

(c) Insert a blank row and a blank column between the list and other data in the worksheet.
You have a list of all the employees in your organization. The list contains employee name, office, title, and salary. You want to list all employees in each office branch. The branches should be listed alphabetically, with the employee earning the highest salary listed first in each office. Which is true of your sort order?

(a) Branch office is the primary column and should be in ascending order.
(b) Salary is the primary column and should be in descending order.
(c) Salary is the primary column and should be in ascending order.
(d) Branch office is the primary column and should be in descending order.
Chapter 5 Q 3.

(a) Branch office is the primary column and should be in ascending order.
You have a list of all the employees in your organization. The list contains employee name, location, title, and salary. You want to list all employees in each location. The locations should be listed alphabetically, with the highest-paid employees
listed first for each location. Which is true of your sort order?

(a) Sort by location ascending, then by salary ascending.
(b) Sort by location ascending, then by salary descending.
(c) Sort by salary descending, then by location ascending.
(d) Sort by location descending, then by salary ascending.
Chapter 5 Q 4.

(b) Sort by location ascending, then by salary descending.
The maximum number of columns you can sort by is?

(a) One
(b) Two
(c) Three
(d) Unlimited
Chapter 5 Question 5.

(c) Three

Book says 64
The Text Import Wizard can be used to import data from what type of files?

(a) HTML files
(b) Database files
(c) Text files
(d) Graphic files
Chapter 5 Question 6.

(c) Text files
You have a list of all employees in your organization. You want to use the Sort Ascending button to list them by location, then by title, then by last name alphabetically. How do you do this?

(a) Sort by location first, then by title, then by last name.
(b) Sort by location first, then either by title or by last name.
(c) Sort by last name first, then by title, then by location.
(d) This is impossible; the Sort Ascending button can only sort by one field
Chapter 5 Question 7.

(d) This is impossible; the Sort Ascending button can only sort by one field
You have a list containing all the employees in your organization. You select the AutoFilter command and then select New York from the location field. What is the result?

(a) The list is sorted by city, with New York first.
(b) The rows where the location is New York are written to another worksheet.
(c) The rows where the location is not New York are deleted.
(d) The rows where the location is not New York are hidden.
Chapter 5 Q 8.

(d) The rows where the location is not New York are hidden.
You have a list containing all the employees in the organization. You want to display all rows where employees earn more than $50,000, but less than $75,000. How should you set up your criteria range?

(a) Have one column entry for the salary field, with >50000 in one row and <75000 in another row.
(b) Have two column entries for the salary field, with >50000 in one column and <75000 in another column, on the same line.
(c) Have two column entries for the salary field, with >50000 in one column and <75000 in another column, on different lines.
(d) It is not possible to set up the criteria range to enable this.
Chapter 5 Q 9.

(b) Have two column entries for the salary field, with >50000 in one column and <75000 in another column, on the same line.
A(n) _______ is used to display how a loan is being repaid, and displays the date, amount of principal, and amount of interest for each payment.

(a) Template
(b) Amortization schedule
(c) MATCH function
(d) AND function
Chapter 6 Q 1.

(b) Amortization schedule
The ________ function returns True if all its arguments are true.

(a) MATCH
(b) IF
(c) INDEX
(d) AND
Chapter 6 Q 2.

(d) AND
All of the following are required arguments to the DATE function except:

(a) The cell containing the date
(b) The year portion of the date
(c) The month portion of the date
(d) The day portion of the date
Chapter 6 Q 3.

(a) The cell containing the date
All of the following are required arguments for the MATCH function except:

(a) The value you are looking up
(b) The cell range you are looking in
(c) The number of rows in the cell range you are looking in
(d) The type of match
Chapter 6 Q 4.

(c) The number of rows in the cell range you are looking in
Cell G12 contains the date 12/19/2008. Which of the following will return the date 1/19/2009?

(a) =DATE(YEAR(G12)+1,MONTH(G12)+1,DAY(G12))
(b) =DATE(YEAR(G12),MONTH(G12)+1,DAY(G12))
(c) =G12+MONTH(1)
(d) =MONTH(G12)+1
Chapter 6 Q 5.

(b) =DATE(YEAR(G12),MONTH(G12)+1,DAY(G12))
The INDEX function returns:
(a) The position in a list where a match occurs
(b) The number of cells in the list
(c) The cell in the list that contains the desired value
(d) The value in the cell being looked up
Chapter 6 Q 6.

(d) The value in the cell being looked up
The MATCH function returns:

(a) The cell in the list where a match occurs
(b) The number of cells in the list
(c) The position in a list where a match occurs
(d) The column in the list that contains the desired value
Chapter 6 Q 7.

(c) The position in a list where a match occurs
The function shows the amount of a loan payment that is applied toward principal repayment.

(a) PMT
(b) PPMT
(c) MATCH
(d) IPMT
Chapter 6 Q 8.


(b) PPMT
9. Assume that cell E12 contains the date February 26, 2008. Which of the following will display the date February 25, 2008?

(a) =DATE(E12) - 1
(b) =DATE(YEAR(E12), MONTH(E12), DAY(E12)-1)
(c) =DATE(YEAR(E12), MONTH(E12), DAY(E12-1))
(d) =DATE(YEAR(E12)-l, MONTH(E12)-l, DAY(E12)-1)
Chapter 6 Q 9.

(b) =DATE(YEAR(E12), MONTH(E12), DAY(E12)-1
You created a workbook on December 12, 2007, and entered the Today() function in cell B5. You modified and saved the workbook on December 19, 2007. On January 3, 2008, you opened the workbook again. What is displayed in cell B5?

(a) December 19, 2007
(b) December 12, 2007
(c) January 3, 2008
(d) It depends on how you created the Today() function.
Chapter 6 Q 10.

(c) January 3, 2008
The IPMT function returns the amount of a(n):

(a) Periodic payment
(b) Periodic payment that is applied toward principal
(c) Periodic payment that is applied toward interest
(d) Extra payment
Chapter 6 Q 11.

(c) Periodic payment that is applied toward interest
The primary benefit of using the ROUND function rather than formatting values as currency is:

(a) Ease of working with fractional numbers
(b) Increases precision in numbers
(c) Easier to use than the number format
(d) Gives you less control when copying values
Chapter 6 Question 12

(a) Ease of working with fractional numbers
Which of the following statements is true?

(a) The Delete command can be used to delete a record, but not a field.
(b) The Delete command erases the contents of the selected area, but does not delete it.
(c) The Delete command can be used to delete either a record or a field.
(d) The Delete command can be used to delete a field, but not a record.
Chapter 6 Q 13.

(c) The Delete command can be used to delete either a record or a field.
You have created a named range called MyCDs that is equivalent to the range A1:E19. What is the extent of the range if you subsequently delete row 1 and delete column C?

(a) A1:D18
(b) A1:E19
(c) A1:E18
(d) A1:D19
Chapter 6 Q 14.

(a) A1:D18
Which of the following causes a named range to be adjusted automatically?

(a) Inserting a row within the range
(b) Deleting a row within the range
(c) Either inserting or deleting a row within the range
(d) Neither inserting nor deleting a row within the range
chapter 6 Q 15.

(c) Either inserting or deleting a row within the range
What is the easiest way to change the active worksheet to another worksheet in the same workbook?

(a) Click the workbook tab to change to the desired workbook, and then click the worksheet in the resulting window.
(b) Open the View menu, and then click the desired worksheet from the list at the bottom of the menu.
(c) Select Tile from the Window menu, and then click the desired worksheet.
(d) Click the worksheet tab of the desired worksheet at the bottom of the current workbook.
Chapter 7 Q 1.

(d) Click the worksheet tab of the desired worksheet at the bottom of the current workbook.
Which of the following opens a new window within the same workbook?

(a) The Arrange All command in the Window group
(b) The New Window command in the Window group
(c) The Tiled command in the Arrange Windows dialog box
(d) The New command on the Office menu
Chapter 7 Q 2.

(b) The New Window command in the Window group
You have four windows open, each displaying a different worksheet. To display all open windows in one screen, select the:

(a) Arrange command in the File group, then choose Show All
(b) Arrange All command in the Window group, then choose Tiled
(c) Tile Windows command in the Window group
(d) Arrange All command in the Window group
Chapter 7 Q 3.

(b) Arrange All command in the Window group, then choose Tiled
To change the number of worksheet tabs that can be seen at one time:

(a) Select Cascade from the Window group.
(b) Change the Tabs option in Excel Options.
(c) Drag the tab split bar.
(d) Resize the tabs.
Chapter 7 Q 4.

(c) Drag the tab split bar.
References to another worksheet in the same workbook are called:

(a) Worksheet references
(b) Cell references
(c) 3-D cell references
(d) Linked references
Chapter 7 Q 5.

(a) Worksheet references
In the reference Sales!E5:GI2, the worksheet reference (Sales!) is considered:

(a) Mixed
(b) Absolute
(c) Relative
(d) Impossible to determine
Chapter 7 Q 6.

(b) Absolute
In the formula =January!$B$1 +February!$B$1 + March!$B$1:

(a) The worksheet references are absolute and the cell references are relative.
(b) The worksheet references are relative and the cell references are absolute.
(c) Both the worksheet and the cell references are absolute.
(d) Both the worksheet and the cell references are relative.
Chapter 7 Q 7.

(c) Both the worksheet and the cell references are absolute.
You have grouped the following worksheets in a workbook: Q1Sales, Q2Sales, and Q3Sales. Q2Sales is the active worksheet. You enter the formula =SUM(C12:E14) into cell F17. What is the result of this action?

(a) The formula =SUM(C12:E14) is entered into cell F17 on all three worksheets.
(b) The sum of cells C12:C14 is entered into cell F17 on all three worksheets, but the formula is not copied to any of the cells.
(c) The formula =SUM(Q2Sales!CI2:Q2Sales!E14) is entered into cell F17 on all three worksheets.
(d) The formula =SUM(C12:E14) is entered into cell F17 on the Q2Sales worksheet.
Chapter 7 Q 8.

(a) The formula =SUM(C12:E14) is entered into cell F17 on all three worksheets
You have a workbook with three sheets named January, February, and March, arranged in that order. The formula =SUM(January:March!C10:EI5) refers to the sum of:

(a) Cell C10 on January and E15 on March
(b) All cells between C10 on January and E15 on March
(c) Cell ranges C10:EI5 on January and March
(d) Cell ranges C10:EI5 on January, February, and March
Chapter 7 Q 9.

(d) Cell ranges C10:EI5 on January, February, and March
Which of the following is NOT normally included in a documentation worksheet?

(a) The name of the person who created the workbook
(b) The initial conditions and assumptions on which a worksheet is based
(c) The name and description of each worksheet in the workbook
(d) The date the workbook was last modified
Chapter 7 Q 10.

(b) The initial conditions and assumptions on which a worksheet is based
You have three workbooks named AREAl.XLS, AREA2.XLS, and AREA3.xLS. They contain data that are to be consolidated using file linking in a summary workbook. Which of the following statements is true?

(a) The summary workbook will contain external references to the area workbooks.
(b) The summary workbook must contain a separate worksheet for each district.
(c) The district workbooks should be grouped prior to creating the summary worksheet.
(d) Updates to any of the area workbooks will not be reflected in the summary workbook.
Chapter 7 Q 11.


(a) The summary workbook will contain external references to the area workbooks.
You have three workbooks named Atlanta, Boston, and Chicago. A summary workbook named Summary contains links to all three workbooks. Which of the following statements is true?

(a) Atlanta, Boston, and Chicago are considered dependent workbooks.
(b) Summary is considered the dependent workbook.
(c) Summary is considered the source workbook.
(d) A change in Summary is automatically updated in the appropriate workbook.
Chapter 7 Q 12.

(b) Summary is considered the dependent workbook.
If cell B5 contains the formula =B3+B4, B5 is:

(a) A dependent of cell B3, but not B4
(b) A precedent of cells B3 and B4
(c) A dependent of cells B3 and B4
(d) Both a dependent and a precedent of cells B3 and B4
Chapter 7 Q 13.

(c) A dependent of cells B3 and B4
A dependent cell is one which:

(a) Derives its value from one or more dependent cells
(b) Derives its value from one or more precedent cells
(c) Is independent and not necessary for any relationship
(d) Is required for a precedent cell
Chapter 7 Q 14.

(b) Derives its value from one or more precedent cells
Which tool enables a user to stipulate the values that can be entered into a cell?

(a) The Garbage In/Garbage Out command
(b) The Auditing toolbar
(c) The Data Validation command
(d) The Reviewing toolbar
Chapter 7 Q 15.

(c) The Data Validation command
16. You have a worksheet designed to calculate a salesperson's commission each month. Cell B5 contains sales dollars for the month, whereas cell B6 contains the commission percentage. Cell B8 contains the formula =B5*B6. You want to ensure that commissions are always based on a positive sales amount, so you have decided to use data validation. Which cell should contain the validation?
(a) B6
(b) B8
(c) B5
(d) It is impossible to determine from the information given.
Chapter 7 Q 16.

(c) B5
17. You have entered data validation into a cell, with a maximum value of 10% and a warning alert. What happens if a user enters 12% into that cell?

(a) The user will get a message forcing him or her to enter a new value.
(b) The user will get an error message and Excel will shutdown.
(c) The user will get a message stating that the maximum value of that cell is 10% and giving him or her the option of accepting the entered value or entering a new one.
(d) The user will get a message stating that the maximum value of that cell is 10%, but Excel will accept the value.
Chapter 7 Q 17.

(c) The user will get a message stating that the maximum value of that cell is 10% and giving him or her the option of accepting the entered value or entering a new one.
18. What is the easiest way to edit or delete an existing comment?

(a) Click on the context-sensitive menu and select the appropriate command.
(b) Right-click on the cell, use the context-sensitive menu, and select the appropriate command.
(c) Point to the cell, highlight the comment, and click on Edit Clear.
(d) Point to the cell, highlight the comment, and click on Edit Delete.
Chapter 7 Q 18.

(b) Right-click on the cell, use the context-sensitive menu, and select the appropriate command.
19. A small green triangle in the upper-left corner of a cell indicates that:

(a) The cell contains a comment.
(b) The cell has been changed by a user.
(c) The cell contains a circular reference.
(d) The cell may contain an error.
Chapter 7 Q 19.

(d) The cell may contain an error.
You want to purchase a new car. You have used the PMT function and determined that the amount of the monthly payment will be $450. You can only afford $350 per month. Which of these features will help you determine either the purchase price of the car you can buy or the amount of the down payment you must come up with to reduce the monthly payment to $350?

(a) The Scenario Manager
(b) The VLOOKUP function
(c) The Function Wizard
(d) The Goal Seek
Chapter 8 Q 1.

(d) The Goal Seek
When using the Goal Seek command, how many parameters can you change at a time?
(a) 1
(b) 2
(c) 3
(d) All of them, if necessary
Chapter 8 Q 2

(a) 1
You are creating a financial forecast. What is a good reason for isolating the initial conditions and assumptions from the body of the forecast?

(a) To allow the forecast to be updated automatically if the initial assumptions change
(b) To prevent inaccurate information from being entered into the forecast
(c) To keep invalid formulas from being entered into the forecast
(d) To keep the forecast accurate regardless of formulas entered into the forecast
Chapter 8 Q 3

(a) To allow the forecast to be updated automatically if the initial assumptions change
You are developing a financial forecast. Where would you most likely use absolute references?

(a) When referring to the assumptions about the rate of change in the formulas for the first year
(b) When referring to the values from the first year in the formulas for the second year
(c) When referring to the assumptions about the rate of change in the formulas for the second year
(d) When referring to the initial conditions in the formulas for the first year
Chapter 8 Q 4

(c) When referring to the assumptions about the rate of change in the formulas for the second year
Cell B17 contains the formula =B12*B14 and displays the value of 100,000. When you change cell B12, the value changes to 90,000 and the font in cell B17 changes from red to blue. What is the most likely explanation?

(a) Conditional formatting has been applied to cell B17.
(b) Your computer has the dreaded Red-To-Blue virus.
(c) Conditional formatting has been applied to cell B12.
(d) Conditional formatting has been applied to cell B14.
Chapter 8 Q 5

(a) Conditional formatting has been applied to cell B17.
A(n) ___ is a limitation on the values that a cell can have.

(a) assumption
(b) constraint
(c) objective
(d) result
Chapter 8 Q 6

(b) constraint
The __ cell must always contain a formula.

(a) changing
(b) constraint
(c) precedent
(d) result
Chapter 8 Q 7

(d) result
Solver can be used for __ in which goal seeking or back solving is used.

(a) scenario comparison
(b) equation-solving
(c) linear programming
(d) resource allocation
Chapter 8 Q 8

(b) equation-solving
For the Solver to reach a feasible solution, users need to specify __ .

(a) changing cells
(b) constraints
(c) precedent values
(d) slack values
Chapter 8 Q 9

(b) constraints
Which of the following is the most useful and popular Solver report?

(a) Answer report
(b) Constraint report
(c) Limits report
(d) Sensitivity report
Chapter 8 Q 10

(a) Answer report
Excluding the title, the first section of a Solver Answer Report contains the __ .

(a) adjustable cells
(b) constraints
(c) precedent values
(d) target cell
Chapter 8 Q 11.

(d) target cell
A __ summarizes key input and output cell values of multiple what-if analysis in a single, rectangular cell range.

(a) data table
(b) data criterion
(c) data range
(d) data report
Chapter 8 Q 12.

(a) data table
What is the combination of values assigned to one or more variable cells in a what-if analysis called?

(a) One-variable data table
(b) PivotTable
(c) Scenario
(d) Two-variable data table
Chapter 8 Q 13.

(c) Scenario
Which of the following dialog boxes is accessed to change the name of an existing scenario?

(a) Add Scenario
(b) Edit Scenario
(c) Change Scenario
(d) Rename Scenario
Chapter 8 Q 14.

(b) Edit Scenario
To apply a scenario's values to the designated changing cells, users need to:

(a) Click the scenario in the Scenario Manager dialog box.
(b) Double-click the scenario in the Scenario Manager dialog box.
(c) Right-click the scenario in the Scenario Manager dialog box.
(d) Triple-click the scenario in the Scenario Manager dialog box.
Chapter 8 Q 15.

(b) Double-click the scenario in the Scenario Manager dialog box.
Which of the following tools outlines each scenario by displaying changing cells and result cells in a separate worksheet?

(a) Break-even analysis
(b) Cost-Volume-Profit analysis
(c) Data table
(d) Scenario summary
Chapter 8 Q 16.

(d) Scenario summary
Which of the following statements is true when using the Scenario Manager to produce a scenario summary report?

(a) Users need to select all changing cells in the report manually and the result cells they want to include.
(b) The Scenario Manager automatically includes all changing cells in the report and the result cells users want to include.
(c) The Scenario Manager automatically includes all changing cells in the report, but users must select the result cells they want to include.
(d) The Scenario Manager automatically includes all the result cells in the report, but users must select the changing cells they want to include.
Chapter 8 Q 17.

(c) The Scenario Manager automatically includes all changing cells in the report, but users must select the result cells they want to include.
In your group that is going to share an Excel workbook, you are the only one who has upgraded to Excel 2007. Before you share the workbook you should:

(a) Print a backup copy.
(b) Run the Compatibility Checker.
(c) Have no concerns about whether they can open your document.
(d) Place all the documents on a CD.
Chapter 9 Q 1

(b) Run the Compatibility Checker.
How can you tell if a workbook is not an Excel 2007 workbook?

(a) The title bar is a different color.
(b) The status bar includes the text [Compatibility Mode].
(c) The title bar includes [Compatibility Mode] after the file name.
(d) The file extension is XLSX.
Chapter 9 Q 2

(c) The title bar includes [Compatibility Mode] after the file name.
Which tab contains the Track Changes command?

(a) Review
(b) View
(c) Home
(d) Data
Chapter 9 Q 3

(a) Review
Which of the following Excel features is disabled if Track Changes is turned on?

(a) Save a workbook
(b) Format cells
(c) Create a Web page
(d) Merge cells
Chapter 9 Q 4

(d) Merge cells
Which of the following is not an option when accepting or rejecting changes?

(a) Delete all
(b) Accept
(c) Accept all
(d) Reject
Chapter 9 Q 5


(a) Delete all
Who gets to decide who has the last call on what changes are accepted?

(a) The first person to make a change
(b) Anyone who makes a change
(c) Cannot be determined
(d) The last person to make a change
Chapter 9 Q 6

(d) The last person to make a change
Which of the following is a restriction in Excel Compatibility mode?

(a) 1,048,576 rows are available.
(b) All PivotTable features are removed from the workbook.
(c) Long formulas are omitted.
(d) SUMIF is not supported.
Chapter 9 Q 7

(d) SUMIF is not supported.
Partially completed workbooks used to create other workbooks are known as:

(a) Files
(b) Templates
(c) PDF documents
(d) Workbooks
Chapter 9 Q 8

(b) Templates
What e-mail client must be used to automatically send on Excel document as an attachment?

(a) AOL
(b) Works
(c) Outlook
(d) SMTP
Chapter 9 Q 9

(c) Outlook
Where is the Compatibility Checker located?

(a) Office Button
(b) Home tab
(c) Compatibility tab
(d) Review tab
Chapter 9 Q 10

(a) Office Button
Which of the following is a new feature in Excel 2007?

(a) Document Sharing
(b) Digital Signature
(c) Security Certificates
(d) Document Inspector
Chapter 9 Q 11

(d) Document Inspector
Which of the following applies to a workbook when it is marked final?

(a) It is write-only.
(b) It is read-only.
(c) You can edit it but save it with a different name.
(d) All of the above.
Chapter 9 Q 12

(b) It is read-only.
Which of the following is a category in Excel Options?

(a) Customize
(b) Set-up
(c) Personal
(d) Preview
Chapter 9 Q 13

(a) Customize
Which of the following is not an option in the Document Inspector?

(a) Remove comments
(b) Remove document properties
(c) Remove the signature
(d) Remove range names
Chapter 9 Q 14

(c) Remove the signature
A Certificate Authority is a company that:

(a) Issues digital signatures.
(b) Verifies a certificate's validity.
(c) Manages versions of certified software.
(d) Issues identity theft warnings.
Chapter 9 Q 15

(b) Verifies a certificate's validity.
Restricting access to a spreadsheet enables you to accomplish all of the following except:

(a) Mark a document as final.
(b) Set an access password for a document.
(c) Protect a document.
(d) Create a signature.
Chapter 9 Q 16

(d) Create a signature.
1. You have written a set of instructions that tells Excel which commands to perform. What you have written is known as:

(a) The Visual Basic Editor
(b) A macro
(c) A command
(d) The Code window
Chapter 10 Q 1

(b) A macro
2. Which programming language is used to create Excel macros?

(a) XML
(b) VBA
(c) VB.NET
(d) C#.NET
Chapter 10 Q 2

(b) VBA
3. What happens if you insert an apostrophe (') at the beginning of a line in an Excel macro?

(a) The statement is displayed in red to signify that it has been changed.
(b) At runtime, the macro pauses prior to executing the statement.
(c) At runtime, the line is ignored.
(d) At runtime, the entire macro is executed, one line at a time.
Chapter 10 Q 3

(c) At runtime, the line is ignored.
4. In the Visual Basic Editor, the VBA statements are displayed in the:

(a) Project Explorer
(b) Immediate pane
(c) Macro recorder
(d) Code window
Chapter 10 Q 4

(d) Code window
5. Which of the following statements must be used to define the end of a macro?

(a) Close
(b) End Sub
(c) End Macro
(d) Stop
Chapter 10 Q 5

(b) End Sub
6. What is the purpose of the Step Into command?

(a) It executes one macro statement at a time.
(b) It enables you to pause the macro and select cells in the worksheet to which macro commands apply.
(c) It enables you to pause the macro and edit incorrect formulas in the worksheet.
(d) It enables you to specify input parameters to the macro.
Chapter 10 Q 6

(a) It executes one macro statement at a time.
7. How do you select a macro button to rename, move, or size it?

(a) Point to the button, click the left mouse button, and follow the shortcut menu.
(b) Point to the button, double-click the left mouse button, and follow the shortcut menu.
(c) Point to the button, hold-down the Ctrl key, and click the left mouse button.
(d) Point to the button, click the right mouse button, and select Options from the shortcut menu.
Chapter 10 Q 7

(c) Point to the button, hold-down the Ctrl key, and click the left mouse button.
8. What is the best way to enter the current price of a stock into an Excel worksheet?

(a) Copy the price directly from today's copy of The Wall Street Journal.
(b) Save the worksheet as a Web page.
(c) Create a Web query, and then refresh the query to obtain the current price.
(d) Use Internet Explorer to locate a Web page that contains the current price.
Chapter 10 Q 8

(c) Create a Web query, and then refresh the query to obtain the current price.
9. Excel and Internet Explorer are both open and display the "same" worksheet. You make a change in the Excel file that is not reflected in the Web page. What is the most likely explanation?

(a) The two files are not linked to one another.
(b) The files are stored locally, as opposed to on a Web server.
(c) You did not refresh the Web page in Microsoft Excel.
(d) You did not refresh the Web page in Internet Explorer.
Chapter 10 Q 9

(d) You did not refresh the Web page in Internet Explorer.
10. Which of the following best describes how to protect a worksheet but still enable the user to change the values of various cells within the worksheet?

(a) Protect the entire worksheet, and then unlock the cells that are to change.
(b) Protect the entire worksheet, and then unprotect the cells that are to change.
(c) Lock the cells that are to change, and then protect the entire worksheet.
(d) Unlock the cells that are to change, and then protect the entire worksheet.
Chapter 10 Q 10

(d) Unlock the cells that are to change, and then protect the entire worksheet.
What is the easiest way to change the formatting of five cells that are scattered throughout a worksheet, each of which has the same style?

(a) Select the cells individually, and then click the appropriate buttons on the Formatting toolbar.
(b) Select the cells at the same time, and then click the appropriate buttons on the Formatting toolbar.
(c) Change the format of the existing style.
(d) Reenter the data in each cell according to the new specifications.
Chapter 10 Q 11

(c) Change the format of the existing style.
When you create a new workbook based on a template called Expense Account but see Expense Account1 displayed on the title bar, what is the most likely explanation?

(a) You are the first person to use this template.
(b) Some type of error must have occurred.
(c) All is in order. Excel has appended the number to differentiate the workbook from the template on which it is based.
(d) The situation is impossible.
Chapter 10 Q 12

(c) All is in order. Excel has appended the number to differentiate the workbook from the template on which it is based.
Which of the following best describes how a macro is to be recorded and executed?

(a) A macro is recorded once and executed once.
(b) A macro is recorded once and executed many times.
(c) A macro is recorded many times and executed once.
(d) A macro is recorded many times and executed many times.
Chapter 10 Q 13

(b) A macro is recorded once and executed many times.
Which statement must contain the name of the macro?

(a) The Sub statement at the beginning of the macro
(b) The first comment statement
(c) Both (a) and (b)
(d) Neither (a) nor (b)
Chapter 10 Q 14

(a) The Sub statement at the beginning of the macro
Which of the following is not true regarding a customized button that has been inserted as an object onto a worksheet and assigned to an Excel macro?

(a) Point to the customized button and then click the left mouse button to execute the associated macro.
(b) Point to the customized button and then click the right mouse button to select the macro button and simultaneously display a shortcut menu.
(c) Point to the customized button, and then press and hold Ctrl as you click the left mouse button to select the button.
(d) Point to the customized button, press and hold Ctrl, and click the right mouse button to execute the associated macro.
Chapter 10 Q 15

(d) Point to the customized button, press and hold Ctrl, and click the right mouse button to execute the associated macro.
You want to create a macro to enter your name in the active cell (which will vary whenever the macro is used) and enter the name of the course you are taking in the cell immediately below. The best way to do this is to:

(a) Select the cell for your name, turn on the Macro Recorder with absolute references, type your name, press the down arrow, and type the course.
(b) Turn on the Macro Recorder with absolute references, select the cell for your name, type your name, press the down arrow, and type the course.
(c) Select the cell for your name, turn on the Macro Recorder with relative references, type your name, press the down arrow, and type the course.
(d) Turn on the Macro Recorder with relative references, select the cell for your name, type your name, press the down arrow, and type the course.
Chapter 10 Q 16

(c) Select the cell for your name, turn on the Macro Recorder with relative references, type your name, press the down arrow, and type the course.