Question 1

When you create a table, Excel automatically applies a default table style.

Accepted Answer

A) True 
 B)False

Question 2

You can delete a table row using the Resize Table button in the Arrange group of the Table Tools Design tab. ____________________​

Accepted Answer

A) True 
 B)False

Question 3

12A, 99B, DX8, QT7 is an example of a(n) ____________________ alphanumeric sort order.

Accepted Answer

The answer of 12A, 99B, DX8, QT7 is an example...

Question 4

Aligning the edges of controls generally makes them easier to read and use.

Accepted Answer

A) True 
 B)False

Question 5

When the pointer changes to a pencil it indicates that you ____.

Accepted Answer

A)  can erase information 
B)  can type text 
C)  are in paint mode 
D)  are in drawing mode 
A)  can erase information 
B)  can type text 
C)  are in paint mode 
D)  are in drawing mode

Question 6

The file extension for a PowerPoint template is _____.​

Accepted Answer

A) .ppsx 
B) .odp 
C) .pptx 
D)  .potx​ 
A) .ppsx 
B) .odp 
C) .pptx 
D)  .potx​

Question 7

Which wildcard symbol is a substitute for one or more characters?

Accepted Answer

A)  (?) 
B)  * 
C)  # 
D)  @ 
A)  (?) 
B)  * 
C)  # 
D)  @

Question 8

You can save a group of font and paragraph settings as a new ____.

Accepted Answer

A)  theme 
B)  style set 
C)  building block 
D)  template 
A)  theme 
B)  style set 
C)  building block 
D)  template

Question 9

The Align button, which aligns the edges of controls, is found on the ____ tab on the Ribbon.

Accepted Answer

A)  Home 
B)  Arrange 
C)  Design 
D)  Layout 
A)  Home 
B)  Arrange 
C)  Design 
D)  Layout

Question 10

The Remove Background button is used for removing the ____.

Accepted Answer

A)  theme 
B)  slide background 
C)  picture background 
D)  backstage view 
A)  theme 
B)  slide background 
C)  picture background 
D)  backstage view

Question 11

Tables are organized into records which are composed of fields.

Accepted Answer

A) True 
 B)False

Question 12

Which two properties control how a form and subform are linked?

Accepted Answer

A)  Link Child Fields and Link Master Fields 
B)  Form and Subform 
C)  Link Form and Link Subform 
D)  Form Layout and Subform Layout 
A)  Link Child Fields and Link Master Fields 
B)  Form and Subform 
C)  Link Form and Link Subform 
D)  Form Layout and Subform Layout

Question 13

Which tab contains the print options for gridlines and headings?

Accepted Answer

A)  Home 
B)  Insert 
C)  Page Layout 
D)  Table Options 
A)  Home 
B)  Insert 
C)  Page Layout 
D)  Table Options

Question 14

You can add a header or a footer by clicking the Page Layout button in the task bar and clicking in the header and footer area.​ ____________________

Accepted Answer

A) True 
 B)False

Question 15

Narration recordings and other sounds do not affect the size of a PowerPoint file.​

Accepted Answer

A) True 
 B)False

Question 16

One or more option buttons can be chosen at the same time within an option group.

Accepted Answer

A) True 
 B)False

Question 17

Explain why a text box rather than a combo box is the best choice for FName and LName data fields in a Customers table.

Accepted Answer

There are endless possibilities for the

Question 18

Case-Based Critical Thinking Question Ramon works for an Internet travel agency. His presentation, about his company's services, needs to be accessible by potential clients on the Internet. Ramon needs to add some functionality that will allow users to move through the slides on their own.
Ramon has limited space to create an important table. He decides to ____ instead.

Accepted Answer

A)  create a chart 
B)  insert a linked table from Microsoft Word 
C)  convert the table to a SmartArt graphic 
D)  draw a custom table 
A)  create a chart 
B)  insert a linked table from Microsoft Word 
C)  convert the table to a SmartArt graphic 
D)  draw a custom table

Question 19

Each shape in the SmartArt graphic is separate and distinct from the other shapes.

Accepted Answer

A) True 
 B)False

Question 20

Action buttons are commonly used in self-running presentations.

Accepted Answer

A) True 
 B)False

When you create a table, Excel automatically applies a default table style.

You can delete a table row using the Resize Table button in the Arrange group of the Table Tools Design tab. ____________________

12A, 99B, DX8, QT7 is an example of a(n) ____________________ alphanumeric sort order.

Aligning the edges of controls generally makes them easier to read and use.

When the pointer changes to a pencil it indicates that you ____.

The file extension for a PowerPoint template is _____.

Which wildcard symbol is a substitute for one or more characters?

You can save a group of font and paragraph settings as a new ____.

The Align button, which aligns the edges of controls, is found on the ____ tab on the Ribbon.

The Remove Background button is used for removing the ____.

Tables are organized into records which are composed of fields.

Which two properties control how a form and subform are linked?

Which tab contains the print options for gridlines and headings?

You can add a header or a footer by clicking the Page Layout button in the task bar and clicking in the header and footer area. ____________________

Narration recordings and other sounds do not affect the size of a PowerPoint file.

One or more option buttons can be chosen at the same time within an option group.

Explain why a text box rather than a combo box is the best choice for FName and LName data fields in a Customers table.

Each shape in the SmartArt graphic is separate and distinct from the other shapes.

Action buttons are commonly used in self-running presentations.

Module 4: Integrating Word and Excel Access

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

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

Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Filters

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

When you create a table, Excel automatically applies a default table style.

You can delete a table row using the Resize Table button in the Arrange group of the Table Tools Design tab. ____________________​

12A, 99B, DX8, QT7 is an example of a(n) ____________________ alphanumeric sort order.

Aligning the edges of controls generally makes them easier to read and use.

When the pointer changes to a pencil it indicates that you ____.

The file extension for a PowerPoint template is _____.​

Which wildcard symbol is a substitute for one or more characters?

You can save a group of font and paragraph settings as a new ____.

The Align button, which aligns the edges of controls, is found on the ____ tab on the Ribbon.

The Remove Background button is used for removing the ____.

Tables are organized into records which are composed of fields.

Which two properties control how a form and subform are linked?

Which tab contains the print options for gridlines and headings?

You can add a header or a footer by clicking the Page Layout button in the task bar and clicking in the header and footer area.​ ____________________

Narration recordings and other sounds do not affect the size of a PowerPoint file.​

One or more option buttons can be chosen at the same time within an option group.

Explain why a text box rather than a combo box is the best choice for FName and LName data fields in a Customers table.

Each shape in the SmartArt graphic is separate and distinct from the other shapes.

Action buttons are commonly used in self-running presentations.

Module 4: Integrating Word and Excel Access

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

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

Merging Word Documents Analyzing Table Dataanalyzing Data With Reportsusing Advanced Features

Filters

You can delete a table row using the Resize Table button in the Arrange group of the Table Tools Design tab. ____________________

The file extension for a PowerPoint template is _____.

You can add a header or a footer by clicking the Page Layout button in the task bar and clicking in the header and footer area. ____________________

Narration recordings and other sounds do not affect the size of a PowerPoint file.