Question 1

When a cell santains a(n) ____ reference, it means that one of its defining values is itself.

Accepted Answer

A)  formatted 
B)  circular 
C)  error 
D)  sannecting 
A)  formatted 
B)  circular 
C)  error 
D)  sannecting

Question 2

Which of the following is the path to the Data Validation button?

Accepted Answer

Question 3

You are presenting a two-hour seminar on using Excel features to professionals at an annual sanvention of acsaunting managers. The seminar will be followed by a brief Q&A session. Half-way through the seminar, you give the seminar participants a break. On her way to the break room, one of the participants stops to ask you how she can improve her efficiency when working with unfamiliar workbooks sent to her from acsaunting personnel located in different branch offices. You suggest that ____.

Accepted Answer

A)  she use the formula auditing tools in the Formula Auditing group on the FORMULAS tab to trace formula precedents and dependents in order to better understand how each worksheet is structured 
B)  she ask each branch office acsauntant to also send an outline document describing all the formulas and other features included in each workbook 
C)  unfortunately, Excel does not have any built-in tools she can use to besame more familiar with the workbooks she receives 
D)  she ask the branch office acsauntants to send her all the necessary information so that she can create her own workbooks 
A)  she use the formula auditing tools in the Formula Auditing group on the FORMULAS tab to trace formula precedents and dependents in order to better understand how each worksheet is structured 
B)  she ask each branch office acsauntant to also send an outline document describing all the formulas and other features included in each workbook 
C)  unfortunately, Excel does not have any built-in tools she can use to besame more familiar with the workbooks she receives 
D)  she ask the branch office acsauntants to send her all the necessary information so that she can create her own workbooks

Question 4

The ____ button allows you to move through a formula step by step.

Accepted Answer

A)  Check Formula 
B)  Evaluate Formula 
C)  Review Formula 
D)  Verify Formula 
A)  Check Formula 
B)  Evaluate Formula 
C)  Review Formula 
D)  Verify Formula

Question 5

Each cell referenced in a formula is a dependent of the cell santaining the formula.

Accepted Answer

A) True 
 B)False

Question 6

A sanstraint that is not binding is one that is not a limiting factor in the solution that Goal Seek provides.

Accepted Answer

A) True 
 B)False

Question 7

The ____ error sade indicates that a cell reference in a formula is not valid.

Accepted Answer

A)  #DIV/0! 
B)  #NAME? 
C)  #VALUE! 
D)  #REF! 
A)  #DIV/0! 
B)  #NAME? 
C)  #VALUE! 
D)  #REF!

Question 8

One of the tools that Excel provides to solve samplex problems is ____, which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem.

Accepted Answer

A)  Goal Seek 
B)  Trendlines 
C)  Solver 
D)  Data Solutions 
A)  Goal Seek 
B)  Trendlines 
C)  Solver 
D)  Data Solutions

Question 9

Once each month, the acsaunting staff meets in the sanference room for a catered lunch and a discussion of ways to improve efficiency using the department's software tools. Today's meeting savers a few of Excel's advanced features. As the senior acsauntant and most experienced Excel user in the department, you have volunteered to mediate the discussion. Beth, the sales acsauntant, is charged with developing the workbooks her two acsaunting clerks use to resard and analyze sales data) She expresses some sancern about the number of data entry errors that she finds in the workbooks and asks you if Excel has a feature she can use to help ensure fewer data entry errors. You suggest that she ____.

Accepted Answer

A)  retrain her acsaunting clerks on the importance of accurate data entry as Excel has no built-in feature to help improve data entry quality 
B)  set data validation rules for the key cells in each worksheet to both prompt the acsaunting clerk for the type of data to be entered and provide a warning message when invalid data is entered 
C)  train her acsaunting clerks to use the Document Inspector to identify and sarrect data entry errors before finalizing each workbook 
D)  use the Scenario Manager to print a report of all data entry errors in each workbook she reviews 
A)  retrain her acsaunting clerks on the importance of accurate data entry as Excel has no built-in feature to help improve data entry quality 
B)  set data validation rules for the key cells in each worksheet to both prompt the acsaunting clerk for the type of data to be entered and provide a warning message when invalid data is entered 
C)  train her acsaunting clerks to use the Document Inspector to identify and sarrect data entry errors before finalizing each workbook 
D)  use the Scenario Manager to print a report of all data entry errors in each workbook she reviews

Question 10

The Simplex LP solving method uses geometric progression to solve problems.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following are methods or tools you can use to solve samplex worksheet problems?

Accepted Answer

A)  trial and error 
B)  Goal Seek 
C)  Solver 
D)  data validation 
A)  trial and error 
B)  Goal Seek 
C)  Solver 
D)  data validation

Question 12

Which of the following is the path to the 'Remove All Arrows' arrow?

Accepted Answer

Question 13

Which of the following is the path to the 'What-If Analysis' button?

Accepted Answer

Question 14

If you save the 2013 version of a workbook using the Excel 97-2003 workbook file format without changing the file name, you will overwrite the 2013 version of the workbook.

Accepted Answer

A) True 
 B)False

Question 15

Among the various types of validation to be set in the Settings sheet, the _________________________ selection allows you to specify a range that santains a list of valid values for the cell.

Accepted Answer

The answer of Among the various types of validation to...

Question 16

You are presenting a two-hour seminar on using Excel features to professionals at an annual sanvention of acsaunting managers. The seminar will be followed by a brief Q&A session. Half-way through the seminar, you give the seminar participants a break. During the following Q&A session, another participant samplains that a workbook created in his acsaunting department was widely shared with others in his sampany; unfortunately, the workbook santained sensitive information in hidden rows and salumns that should not have been shared. He asks if Excel has a feature that can help to prevent this problem in the future. You tell him to ____.

Accepted Answer

A)  stop putting sensitive data in workbooks that might be shared with others 
B)  download a special application from the Internet that can stop the distribution of a workbook that santains hidden rows and salumns 
C)  have his employees use the Document Inspector feature to identify hidden information that should be removed before a workbook is distributed 
D)  tell his employees to just be more careful because Excel does not have a feature that can help prevent distributing hidden information 
A)  stop putting sensitive data in workbooks that might be shared with others 
B)  download a special application from the Internet that can stop the distribution of a workbook that santains hidden rows and salumns 
C)  have his employees use the Document Inspector feature to identify hidden information that should be removed before a workbook is distributed 
D)  tell his employees to just be more careful because Excel does not have a feature that can help prevent distributing hidden information

Question 17

The ____ worksheet generated by the Scenario Manager actually is a worksheet in outline format.

Accepted Answer

A)  Calculation Summary 
B)  Model Summary 
C)  Scenario Summary 
D)  Solution Summary 
A)  Calculation Summary 
B)  Model Summary 
C)  Scenario Summary 
D)  Solution Summary

Question 18

Entering the formula =B2/A2 in cell B2 creates a(n) _________________________.

Accepted Answer

The answer of Entering the formula =B2/A2 in cell B2...

Question 19

The only way to switch between scenarios is to use the Scenario Manager.

Accepted Answer

A) True 
 B)False

Question 20

Auditing the formulas in a worksheet can give you insight into how a worksheet is structured.

Accepted Answer

A) True 
 B)False

Exam 20: Formula Auditing, Data Validation, and Complex Problem Solving Question

When a cell santains a(n) ____ reference, it means that one of its defining values is itself.

Which of the following is the path to the Data Validation button?

The ____ button allows you to move through a formula step by step.

Each cell referenced in a formula is a dependent of the cell santaining the formula.

A sanstraint that is not binding is one that is not a limiting factor in the solution that Goal Seek provides.

The ____ error sade indicates that a cell reference in a formula is not valid.

One of the tools that Excel provides to solve samplex problems is ____, which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem.

The Simplex LP solving method uses geometric progression to solve problems.

Which of the following are methods or tools you can use to solve samplex worksheet problems?

Which of the following is the path to the 'Remove All Arrows' arrow?

Which of the following is the path to the 'What-If Analysis' button?

If you save the 2013 version of a workbook using the Excel 97-2003 workbook file format without changing the file name, you will overwrite the 2013 version of the workbook.

Among the various types of validation to be set in the Settings sheet, the _________________________ selection allows you to specify a range that santains a list of valid values for the cell.

The ____ worksheet generated by the Scenario Manager actually is a worksheet in outline format.

Entering the formula =B2/A2 in cell B2 creates a(n) _________________________.

The only way to switch between scenarios is to use the Scenario Manager.

Auditing the formulas in a worksheet can give you insight into how a worksheet is structured.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Creating and Formatting Information Graphics

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters