Question 1

When you type a password in the Set Database Password dialog box, _____ appear instead of the characters you typed.

Accepted Answer

A)  question marks (?) 
B)  quotation marks (") 
C)  dashes (-) 
D)  asterisks (*) 
A)  question marks (?) 
B)  quotation marks (") 
C)  dashes (-) 
D)  asterisks (*)

Question 2

If you set a database _____, all users must enter that combination of characters before they are allowed to open the database.

Accepted Answer

A)  password 
B)  startup option 
C)  permission 
D)  share list 
A)  password 
B)  startup option 
C)  permission 
D)  share list

Question 3

Which of the following statements accurately describe null field values? Select all the options that apply.

Accepted Answer

A)  You enter a null value by typing two quotation marks (""). 
B)  A null field value indicates unknown data. 
C)  You can use the Is Null criterion to select records with null values. 
D)  You enter a null value by leaving a field blank in a record. 
A)  You enter a null value by typing two quotation marks (""). 
B)  A null field value indicates unknown data. 
C)  You can use the Is Null criterion to select records with null values. 
D)  You enter a null value by leaving a field blank in a record.

When you type a password in the Set Database Password dialog box, _____ appear instead of the characters you typed.

If you set a database _____, all users must enter that combination of characters before they are allowed to open the database.

Which of the following statements accurately describe null field values? Select all the options that apply.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Filters

Exam 12: Developing an Excel Application

When you type a password in the Set Database Password dialog box, _____ appear instead of the characters you typed.

If you set a database _____, all users must enter that combination of characters before they are allowed to open the database.

Which of the following statements accurately describe null field values? Select all the options that apply.

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Filters