Question 1

________ validation requires the specification of upper and/or lower boundary values.

Accepted Answer

A) Logical 
B) Decimal 
C) Conditional 
D) Numeric 
A) Logical 
B) Decimal 
C) Conditional 
D) Numeric

Question 2

________ schemes are rules that combine data values in specific formats and locations to generate new data values.

Accepted Answer

The answer of ________ schemes are rules that combine data...

Question 3

________ are the vertical and horizontal lines on a worksheet that help define a cell's boundaries.

Accepted Answer

The answer of ________ are the vertical and horizontal lines...

Question 4

The 40th room on floor 7 of a building being assigned room number 740 is a potential example of a(n)________ data value.

Accepted Answer

The answer of The 40th room on floor 7 of...

Question 5

All of the following statements are TRUE about gridlines EXCEPT:

Accepted Answer

A) Gridlines are used to demark one worksheet cell from another. 
B) Gridlines should remain visible except in very rare instances. 
C) Gridlines are very helpful during the development of a worksheet. 
D) Gridlines lend visual structure to a worksheet. 
A) Gridlines are used to demark one worksheet cell from another. 
B) Gridlines should remain visible except in very rare instances. 
C) Gridlines are very helpful during the development of a worksheet. 
D) Gridlines lend visual structure to a worksheet.

Question 6

In a well-designed worksheet,row and column headings may not be necessary.

Accepted Answer

A) True 
 B)False

Question 7

________ validation is generally used to limit the number of characters that can be entered into a cell.

Accepted Answer

The answer of ________ validation is generally used to limit...

Question 8

Data ________ is a means of increasing the probability of correct data entry through programmatic tools and/or behavioral modifications.

Accepted Answer

A) authentication 
B) validation 
C) certification 
D) verification 
A) authentication 
B) validation 
C) certification 
D) verification

Question 9

________ validation works very similar to decimal validation except the value entered must be a date that satisfies the specified criteria.

Accepted Answer

The answer of ________ validation works very similar to decimal...

Question 10

A(n)________ is a form of computer program that automates activities such as mouse movements and clicks,menu selections,and data entry.

Accepted Answer

The answer of A(n)________ is a form of computer program...

Question 11

All of the following statements are TRUE about auditing formulas EXCEPT:

Accepted Answer

A) Tracing formulas draws lines from a formula to cells that supply source data and to formulas that use the result of a formula. 
B) Formula-auditing tools show you which cells are used in a formula and how they are used. 
C) When you select to trace dependents, Excel finds and marks with arrows all the cells that supply values to the active cell. 
D) Both tracing a formula and evaluating a formula are useful in understanding how a worksheet is structured, and they are particularly useful if a complex formula is not producing a correct result. 
A) Tracing formulas draws lines from a formula to cells that supply source data and to formulas that use the result of a formula. 
B) Formula-auditing tools show you which cells are used in a formula and how they are used. 
C) When you select to trace dependents, Excel finds and marks with arrows all the cells that supply values to the active cell. 
D) Both tracing a formula and evaluating a formula are useful in understanding how a worksheet is structured, and they are particularly useful if a complex formula is not producing a correct result.

Question 12

All of the following statements are TRUE regarding custom data validation EXCEPT:

Accepted Answer

A) Custom validation allows you to specify more complex criteria than allowed with the other validation types. 
B) Data validation is an excellent tool to use in workbooks where you want to restrict data entry to certain values or ranges of values. 
C) There may be times when data validation rules can hinder data entry rather than enhance it. 
D) Using custom validation, you can apply multiple criteria one at a time. 
A) Custom validation allows you to specify more complex criteria than allowed with the other validation types. 
B) Data validation is an excellent tool to use in workbooks where you want to restrict data entry to certain values or ranges of values. 
C) There may be times when data validation rules can hinder data entry rather than enhance it. 
D) Using custom validation, you can apply multiple criteria one at a time.

Question 13

When you choose to trace dependents and trace precedents,Excel puts arrows on the workbook to show you how the formula in the cell is constructed.

Accepted Answer

A) True 
 B)False

Question 14

If the location where a file is stored is not known to the Excel Trust Center as a trusted location,the Trust Center will block all of the following that could contain malicious code EXCEPT ________.

Accepted Answer

A) formulas 
B) macros 
C) controls 
D) scripts 
A) formulas 
B) macros 
C) controls 
D) scripts

Question 15

The ________ tab is used to hide scroll bars,as well as row and column headings.

Accepted Answer

The answer of The ________ tab is used to hide...

Question 16

________ represents a means of communicating the development status of a workbook,and is not a form of protection.

Accepted Answer

The answer of ________ represents a means of communicating the...

Question 17

________ validation can be used to apply multiple validation criteria to a cell.

Accepted Answer

A) Complex 
B) Detailed 
C) Custom 
D) Compound 
A) Complex 
B) Detailed 
C) Custom 
D) Compound

Question 18

Completely hiding formulas in a worksheet is a(n)________-step process.

Accepted Answer

The answer of Completely hiding formulas in a worksheet is...

Question 19

________ are constraints that limit what users are allowed to enter into a particular cell.

Accepted Answer

The answer of ________ are constraints that limit what users...

Question 20

Data schemes consist of rules that combine data values in specific formats and locations to generate a new data values.

Accepted Answer

A) True 
 B)False

________ validation requires the specification of upper and/or lower boundary values.

________ schemes are rules that combine data values in specific formats and locations to generate new data values.

________ are the vertical and horizontal lines on a worksheet that help define a cell's boundaries.

The 40th room on floor 7 of a building being assigned room number 740 is a potential example of a(n)________ data value.

All of the following statements are TRUE about gridlines EXCEPT:

In a well-designed worksheet,row and column headings may not be necessary.

________ validation is generally used to limit the number of characters that can be entered into a cell.

Data ________ is a means of increasing the probability of correct data entry through programmatic tools and/or behavioral modifications.

________ validation works very similar to decimal validation except the value entered must be a date that satisfies the specified criteria.

A(n)________ is a form of computer program that automates activities such as mouse movements and clicks,menu selections,and data entry.

All of the following statements are TRUE about auditing formulas EXCEPT:

All of the following statements are TRUE regarding custom data validation EXCEPT:

When you choose to trace dependents and trace precedents,Excel puts arrows on the workbook to show you how the formula in the cell is constructed.

If the location where a file is stored is not known to the Excel Trust Center as a trusted location,the Trust Center will block all of the following that could contain malicious code EXCEPT ________.

The ________ tab is used to hide scroll bars,as well as row and column headings.

________ represents a means of communicating the development status of a workbook,and is not a form of protection.

________ validation can be used to apply multiple validation criteria to a cell.

Completely hiding formulas in a worksheet is a(n)________-step process.

________ are constraints that limit what users are allowed to enter into a particular cell.

Data schemes consist of rules that combine data values in specific formats and locations to generate a new data values.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters

Exam 8: Refine an Excel Application

________ validation requires the specification of upper and/or lower boundary values.

________ schemes are rules that combine data values in specific formats and locations to generate new data values.

________ are the vertical and horizontal lines on a worksheet that help define a cell's boundaries.

The 40th room on floor 7 of a building being assigned room number 740 is a potential example of a(n)________ data value.

All of the following statements are TRUE about gridlines EXCEPT:

In a well-designed worksheet,row and column headings may not be necessary.

________ validation is generally used to limit the number of characters that can be entered into a cell.

Data ________ is a means of increasing the probability of correct data entry through programmatic tools and/or behavioral modifications.

________ validation works very similar to decimal validation except the value entered must be a date that satisfies the specified criteria.

A(n)________ is a form of computer program that automates activities such as mouse movements and clicks,menu selections,and data entry.

All of the following statements are TRUE about auditing formulas EXCEPT:

All of the following statements are TRUE regarding custom data validation EXCEPT:

When you choose to trace dependents and trace precedents,Excel puts arrows on the workbook to show you how the formula in the cell is constructed.

If the location where a file is stored is not known to the Excel Trust Center as a trusted location,the Trust Center will block all of the following that could contain malicious code EXCEPT ________.

The ________ tab is used to hide scroll bars,as well as row and column headings.

________ represents a means of communicating the development status of a workbook,and is not a form of protection.

________ validation can be used to apply multiple validation criteria to a cell.

Completely hiding formulas in a worksheet is a(n)________-step process.

________ are constraints that limit what users are allowed to enter into a particular cell.

Data schemes consist of rules that combine data values in specific formats and locations to generate a new data values.

Navigate, manipulate, and Print Worksheets

Formatting, functions, and Formulas

Cell References, named Ranges, and Functions

Effective Charts

Complex Conditional and Retrieval Functions

Analyze Data Using Tables

Multiple Worksheets workbooks and Templates

Organize, import, export, and Cleanse Data Sets

Data Tables, scenario Manager, and Solver

Loan Amortization, investment Analysis, and Asset Depreciation

Business Statistics and Regression Analysis

Excels Data Model, Power-pivot, and Power View

Visual Basic for Applications

Appendix:efficient Interaction With a Touch Screen

The Common Features of Microsoft Office

Filters