Exam 17: Improving Data Accuracy

FIGURE EX 11-1 In Figure EX 11-1 above, click ____ to display the greatest amount of detail.

(Multiple Choice)

4.8/5

(32)

Question 41

Choosing the Information style in the Error Alert tab of the Data Validation dialog box allows data to be entered but simply displays an information box with a message that the data entered is invalid.

(True/False)

4.8/5

(35)

Question 42

To create a drop-down list, it is easier if you first create a(n) ____________________ of cells that has the selections that should appear in the list.

(Short Answer)

4.9/5

(34)

Question 43

Case EX 11-1 Venecia is using a worksheet to track her spending each month. So far the worksheet has the information for January up to August. Venecia wants to quickly view the totals for the worksheet but does not want to store that information permanently in the worksheet. She needs to use the ____ feature.

(Multiple Choice)

4.9/5

(29)

Question 44

A ____ is the total of only specific parts of the data.

(Multiple Choice)

4.7/5

(40)

Question 45

The Circle Invalid Data feature helps you ensure that valid data is entered into a worksheet.

(True/False)

4.7/5

(31)

Question 46

Showing 41 - 46 of 46

Exam 17: Improving Data Accuracy

FIGURE EX 11-1 In Figure EX 11-1 above, click ____ to display the greatest amount of detail.

Choosing the Information style in the Error Alert tab of the Data Validation dialog box allows data to be entered but simply displays an information box with a message that the data entered is invalid.

To create a drop-down list, it is easier if you first create a(n) ____________________ of cells that has the selections that should appear in the list.

A ____ is the total of only specific parts of the data.

The Circle Invalid Data feature helps you ensure that valid data is entered into a worksheet.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters