Exam 5: Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and Access

Quickly resize a table by dragging the table resize handle to a new location.

(True/False)

4.8/5

(35)

Question 221

The ____________________ function calculates the future value of an investment.

(Short Answer)

4.7/5

(29)

Question 222

Explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

(Essay)

4.7/5

(37)

Question 223

Which Excel function checks for errors and displays a message you specify if there is an error in a formula.

(Multiple Choice)

5.0/5

(32)

Question 224

Names that you assign to cells and cell ranges can be used in formulas.

(True/False)

4.9/5

(38)

Question 225

The Field Size property is not available for Currency fields.

(True/False)

4.8/5

(37)

Question 226

Which Excel function counts the number of cells in a range?

(Multiple Choice)

4.9/5

(37)

Question 227

Which of the following is NOT a possible entry for the Field Size property of a Number field?

(Multiple Choice)

4.9/5

(37)

Question 228

A common place to use an Input Mask property would be for a Phone Number field.

(True/False)

4.7/5

(34)

Question 229

____ properties allow you to supply a drop-down list of values for a field.

(Multiple Choice)

4.7/5

(34)

Question 230

You must type a(n) ____________________in any blank cell before using the SUM function.

(Short Answer)

4.8/5

(40)

Question 231

You can choose which records you want to merge from an Access table to a Word document.

(True/False)

4.7/5

(43)

Question 232

The ____________________ function joins two or more text strings into one.

(Short Answer)

4.7/5

(31)

Question 233

Case-Based Critical Thinking Question John is using PowerPoint to create an extensive marketing presentation and he keeps modifying the same slide layout by adding new placeholders for pictures and adjusting the text indents in the content placeholder. John wants to modify his presentation so he can work more efficiently. Which of the following should John use to solve the text indent problems he is having?

(Multiple Choice)

4.8/5

(34)

Question 234

If a number is divided by zero, the error value #DIV/0! will display in the cell.

(True/False)

4.8/5

(41)

Question 235

Case-Based Critical Thinking Question John is using PowerPoint to create an extensive marketing presentation and he keeps modifying the same slide layout by adding new placeholders for pictures and adjusting the text indents in the content placeholder. John wants to modify his presentation so he can work more efficiently. What does John need to do first in order to create a custom slide layout?

(Multiple Choice)

4.9/5

(31)

Question 236

Before you click the Finish & Merge button, you should click the ____ button to see if any spaces need to be added or deleted.

(Multiple Choice)

4.8/5

(39)

Question 237

You manage the Sales department of a company that has four salespeople. You are creating a table that summarizes the company's sales to send to your manager. The total sales for Quarter 1 and Quarter 2 for each of the four salespeople are in cells D3 through D6. How would you use the SUM function to calculate the grand total of all the sales?

(Essay)

4.9/5

(38)

Question 238

The _____ function calculates the current date and time.

(Multiple Choice)

4.8/5

(36)

Question 239

If the formula, =IF(B3>B1,5,0) is entered in cell C3, the value 0 will be stored in cell C3 if the logical test is true. ____________________

(True/False)

4.8/5

(34)

Question 240

Showing 221 - 240 of 321

Quickly resize a table by dragging the table resize handle to a new location.

The ____________________ function calculates the future value of an investment.

Explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

Which Excel function checks for errors and displays a message you specify if there is an error in a formula.

Names that you assign to cells and cell ranges can be used in formulas.

The Field Size property is not available for Currency fields.

Which Excel function counts the number of cells in a range?

Which of the following is NOT a possible entry for the Field Size property of a Number field?

A common place to use an Input Mask property would be for a Phone Number field.

____ properties allow you to supply a drop-down list of values for a field.

You must type a(n) ____________________in any blank cell before using the SUM function.

You can choose which records you want to merge from an Access table to a Word document.

The ____________________ function joins two or more text strings into one.

If a number is divided by zero, the error value #DIV/0! will display in the cell.

Before you click the Finish & Merge button, you should click the ____ button to see if any spaces need to be added or deleted.

The _____ function calculates the current date and time.

If the formula, =IF(B3>B1,5,0) is entered in cell C3, the value 0 will be stored in cell C3 if the logical test is true. ____________________

Module 4: Integrating Word and Excel Access

Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Filters

Exam 5: Productivity Apps for School and Work Word, Analyzing Data Using Formulasmodifying the Database Structureintegrating Word, Excel, and Access

Quickly resize a table by dragging the table resize handle to a new location.

The ____________________ function calculates the future value of an investment.

Explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

Which Excel function checks for errors and displays a message you specify if there is an error in a formula.

Names that you assign to cells and cell ranges can be used in formulas.

The Field Size property is not available for Currency fields.

Which Excel function counts the number of cells in a range?

Which of the following is NOT a possible entry for the Field Size property of a Number field?

A common place to use an Input Mask property would be for a Phone Number field.

____ properties allow you to supply a drop-down list of values for a field.

You must type a(n) ____________________in any blank cell before using the SUM function.

You can choose which records you want to merge from an Access table to a Word document.

The ____________________ function joins two or more text strings into one.

If a number is divided by zero, the error value #DIV/0! will display in the cell.

Before you click the Finish & Merge button, you should click the ____ button to see if any spaces need to be added or deleted.

The _____ function calculates the current date and time.​

If the formula, =IF(B3>B1,5,0) is entered in cell C3,​ the value 0 will be stored in cell C3 if the logical test is true. ____________________

Module 4: Integrating Word and Excel Access

Illustrating Documents With Graphics Managing Workbook Dataimproving Queriesenhancing Chartsintegrating Word, Excel, Access, and Powerpoint

Working With Themes and Building Blocksusing Tablesenhancing Formsinserting Graphics, Media, and Objects

Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Filters

The _____ function calculates the current date and time.

If the formula, =IF(B3>B1,5,0) is entered in cell C3, the value 0 will be stored in cell C3 if the logical test is true. ____________________