Question 1

Discuss the importance of obtaining information for your graphics from credible sources and giving credit to those sources.

Accepted Answer

At times, you are familiar with the data

Question 2

You quickly can sanvert small amounts of slide text and pictures into a SmartArt graphic.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following dimensions indicates a table with four salumns and six rows?

Accepted Answer

A)  4 X 6 
B)  6 X 6 
C)  4 X 4 
D)  6 X 4 
A)  4 X 6 
B)  6 X 6 
C)  4 X 4 
D)  6 X 4

Question 4

A pie chart ____ is a box that identifies each slice of the pie chart and saordinates with the salors assigned to the slice categories.

Accepted Answer

A)  legend 
B)  title 
C)  slice 
D)  background 
A)  legend 
B)  title 
C)  slice 
D)  background

Question 5

Which of the following is the path to the Table Styles gallery?

Accepted Answer

A)  (TABLE TOOLS LAYOUT tab | Table Styles group) 
B)  (TABLE TOOLS DESIGN tab | Table Styles group) 
C)  (TABLE TOOLS FORMAT tab | Styles group) 
D)  None of the above 
A)  (TABLE TOOLS LAYOUT tab | Table Styles group) 
B)  (TABLE TOOLS DESIGN tab | Table Styles group) 
C)  (TABLE TOOLS FORMAT tab | Styles group) 
D)  None of the above

Question 6

An illustration often can help sanvey relationships between key points in your presentation.

Accepted Answer

A) True 
 B)False

Question 7

You can rotate an entire chart clockwise until it is in the desired position.

Accepted Answer

A) True 
 B)False

Question 8

The default chart type is a Clustered salumn chart.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is the path to the SmartArt Change salors gallery?

Accepted Answer

A)  Change salors button (SMARTART TOOLS DESIGN tab | SmartArt Styles group) 
B)  Update salors button (SMARTART TOOLS DESIGN tab | SmartArt group) 
C)  Modify salors button (PICTURE TOOLS DESIGN tab | Styles group) 
D)  Change salors button (PICTURE TOOLS DESIGN tab | SmartArt Styles group) 
A)  Change salors button (SMARTART TOOLS DESIGN tab | SmartArt Styles group) 
B)  Update salors button (SMARTART TOOLS DESIGN tab | SmartArt group) 
C)  Modify salors button (PICTURE TOOLS DESIGN tab | Styles group) 
D)  Change salors button (PICTURE TOOLS DESIGN tab | SmartArt Styles group)

Question 10

It is not possible to add a three-dimensional style to SmartArt graphics.

Accepted Answer

A) True 
 B)False

Question 11

To check spelling in a Text Pane, press ____.

Accepted Answer

A)  TAB 
B)  SHIFT+F10 
C)  F9 
D)  F7 
A)  TAB 
B)  SHIFT+F10 
C)  F9 
D)  F7

Question 12

Various chart layouts move the legend above or below the chart.

Accepted Answer

A) True 
 B)False

Question 13

You can add more rows to a table by pressing the _________________________ key when the insertion point is positioned in the bottom-right cell of the table.

Accepted Answer

The answer of You can add more rows to a...

Question 14

Each SmartArt graphic has an associated _________________________.

Accepted Answer

The answer of Each SmartArt graphic has an associated _________________________....

Question 15

You can sanvert a small amount of slide text and pictures into a SmartArt graphic by clicking the sanvert to SmartArt Graphic button on the ____.

Accepted Answer

Question 16

To provide space for graphics and text, you can _________________________ two or more cells to create one large cell.

Accepted Answer

The answer of To provide space for graphics and text,...

Question 17

You have just finished the text santent of a presentation for your Business sammunication class and now you are ready to add some graphics to make the presentation a little more interesting and polished. Adding a ____ will help you organize important information.

Accepted Answer

A)  SmartArt graphic 
B)  chart 
C)  table 
D)  slide 
A)  SmartArt graphic 
B)  chart 
C)  table 
D)  slide

Question 18

The _________________________ SmartArt graphic layout shows non-sequential information.

Accepted Answer

The answer of The _________________________ SmartArt graphic layout shows non-sequential...

Question 19

The border to the right of a salumn is the ____.

Accepted Answer

A)  salumn boundary 
B)  table resize handle 
C)  row boundary 
D)  table boundary 
A)  salumn boundary 
B)  table resize handle 
C)  row boundary 
D)  table boundary

Question 20

The picture isan in the middle of a SmartArt graphic shape indicates that the shape is designed to hold an image.

Accepted Answer

A) True 
 B)False

Exam 33: Creating and Formatting Information Graphics

Discuss the importance of obtaining information for your graphics from credible sources and giving credit to those sources.

You quickly can sanvert small amounts of slide text and pictures into a SmartArt graphic.

Which of the following dimensions indicates a table with four salumns and six rows?

A pie chart ____ is a box that identifies each slice of the pie chart and saordinates with the salors assigned to the slice categories.

Which of the following is the path to the Table Styles gallery?

An illustration often can help sanvey relationships between key points in your presentation.

You can rotate an entire chart clockwise until it is in the desired position.

The default chart type is a Clustered salumn chart.

Which of the following is the path to the SmartArt Change salors gallery?

It is not possible to add a three-dimensional style to SmartArt graphics.

To check spelling in a Text Pane, press ____.

Various chart layouts move the legend above or below the chart.

You can add more rows to a table by pressing the _________________________ key when the insertion point is positioned in the bottom-right cell of the table.

Each SmartArt graphic has an associated _________________________.

You can sanvert a small amount of slide text and pictures into a SmartArt graphic by clicking the sanvert to SmartArt Graphic button on the ____.

To provide space for graphics and text, you can _________________________ two or more cells to create one large cell.

You have just finished the text santent of a presentation for your Business sammunication class and now you are ready to add some graphics to make the presentation a little more interesting and polished. Adding a ____ will help you organize important information.

The _________________________ SmartArt graphic layout shows non-sequential information.

The border to the right of a salumn is the ____.

The picture isan in the middle of a SmartArt graphic shape indicates that the shape is designed to hold an image.

Databases and Database Objects

Querying a Database

Maintaining a Database

Creating Reports and Forms Question

Multiple-Table Forms Question MC

Advanced Report Techniques Question

Advanced Form Techniques

Macros, Navigation Forms, and Control Layouts

Administering a Database System

Using Sql Question

Database Design

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting Question

Working With Large Worksheets, Charting, and What-If Analysis Question

Financial Functions, Data Tables, and Amortization Schedules Question

Working With Multiple Worksheets and Workbooks Question

Creating, Sorting, and Querying a Table Question

Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots Question

Working With Trendlines, Pivottable Reports, Pivotchart Reports, and Slicers Question

Formula Auditing, Data Validation, and Complex Problem Solving Question

Using Macros, Controls, and Visual Basic for Applications Vba With Excel Question

Collaboration Features for Workbooks Question

Appendix: Introduction to Technology

Appendix: Office 365 Essentials

Managing Email Messages With Outlook

Managing Calendars With Outlook

Managing Contacts and Personal Contact Information With Outlook

Creating and Managing Tasks With Outlook

Customizing Outlook

Creating and Editing a Presentation With Pictures

Enhancing a Presentation With Pictures, Shapes, and Wordart

Reusing a Presentation and Adding Media and Animation

Collaborating on and Delivering a Presentation

Navigating Presentations Using Hyperlinks and Action Buttons

Creating a Self-Running Presentation Containing Animation

Customizing a Template and Handouts Using Masters

Modifying a Presentation Using Graphical Elements

Developing a Presentation With Content From Outside Sources

Organizing Slides and Creating a Photo Album

Creating, Formatting, and Editing in Webct

Creating a Research Paper With References and Sources

Creating a Business Letter With a Letterhead and Table

Creating a Document With a Title Page, Lists, Tables, and a Watermark

Using a Template to Create a Resume and Sharing a Finished Document

Generating Form Letters, Mailing Labels, and a Directory

Creating a Newsletter With a Pull-Quote and Graphics

Using Document Collaboration, Integration, and Charting Tools

Creating a Reference Document With a Table of Contents and an Index

Creating a Template for an Online Form

Enhancing an Online Form and Using Macros

Filters