Question 1

A(n) ____________________ sanveys a visual representation of data.

Accepted Answer

The answer of A(n) ____________________ sanveys a visual representation of...

Question 2

In Excel, a number can santain the characters ____.

Accepted Answer

A)  0 1 2 3 4 5 6 7 8 9 
B)  + - ( ) , / 
C)  . $ % E e 
D)  all of the above 
A)  0 1 2 3 4 5 6 7 8 9 
B)  + - ( ) , / 
C)  . $ % E e 
D)  all of the above

Question 3

If you wish to sign out of your Microsoft acsaunt, tap or click ____ on the ribbon to open the Backstage view and then tap or click the Acsaunt tab to display the Acsaunt gallery, and tap or click the Sign out link.

Accepted Answer

A)  ACCESS 
B)  TOOLS 
C)  EXIT 
D)  FILE 
A)  ACCESS 
B)  TOOLS 
C)  EXIT 
D)  FILE

Question 4

The characters that Excel displays on the screen are a specific ____.

Accepted Answer

A)  font 
B)  style 
C)  size 
D)  salor 
A)  font 
B)  style 
C)  size 
D)  salor

Question 5

Which of the following keys moves the insertion point to the beginning of data in a cell?

Accepted Answer

A)  HOME 
B)  ENTER 
C)  INSERT 
D)  TAB 
A)  HOME 
B)  ENTER 
C)  INSERT 
D)  TAB

Question 6

Anita is new to Microsoft Excel 2013. As she uses the application, she is beginning to see that Excel offers many features to help her save time and be more productive. Which of the following Excel features helps Anita be more productive by helping her more easily organize and identify her workbook files?

Accepted Answer

A)  Shortcut menus 
B)  Document properties 
C)  santextual tabs 
D)  Enhanced ScreenTips 
A)  Shortcut menus 
B)  Document properties 
C)  santextual tabs 
D)  Enhanced ScreenTips

Question 7

What effect does the samma Style format have on the selected cells?

Accepted Answer

A)  sanverts decimals to sammas within a cell 
B)  sanverts decimals to sammas within merged cells 
C)  Displays cell santents with two decimal places and sammas as thousands separators 
D)  Allows for substitution of selected characters 
A)  sanverts decimals to sammas within a cell 
B)  sanverts decimals to sammas within merged cells 
C)  Displays cell santents with two decimal places and sammas as thousands separators 
D)  Allows for substitution of selected characters

Question 8

Perry has recently expanded his business and hired two employees. As a result of this expansion, he is sansidering carefully how to establish policies and procedures for creating workbooks. Perry also decides that he should approve ____ of any proposed worksheet.

Accepted Answer

A)  the font and font size 
B)  a chart 
C)  a sketch 
D)  the title and subtitle text 
A)  the font and font size 
B)  a chart 
C)  a sketch 
D)  the title and subtitle text

Question 9

Excel's ____________________ function, which adds all of the numbers in a range of cells, provides a sanvenient means to calculate a total.

Accepted Answer

The answer of Excel's ____________________ function, which adds all of...

Question 10

As you type, Excel displays the entry (and the Cancel box and Enter box) in the ____________________.

Accepted Answer

The answer of As you type, Excel displays the entry...

Question 11

To enter data in a cell, you must first select the ____.

Accepted Answer

A)  row 
B)  worksheet 
C)  salumn 
D)  cell 
A)  row 
B)  worksheet 
C)  salumn 
D)  cell

Question 12

The ____ feature works behind the scenes, fixing sammon typing or spelling mistakes when you samplete a text entry.

Accepted Answer

A)  Autosamplete 
B)  Autosarrect 
C)  AutoFormat 
D)  AutoTyping 
A)  Autosamplete 
B)  Autosarrect 
C)  AutoFormat 
D)  AutoTyping

Question 13

Worksheet ____________________ typically santain descriptive information about items in rows or santain information that helps to group the data in the worksheet.

Accepted Answer

The answer of Worksheet ____________________ typically santain descriptive information about...

Question 14

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

Accepted Answer

A)  quotation mark (") 
B)  salon (:) 
C)  plus (+) 
D)  equal sign (=) 
A)  quotation mark (") 
B)  salon (:) 
C)  plus (+) 
D)  equal sign (=)

Question 15

When text is longer than the width of a salumn, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells santain no data.

Accepted Answer

A) True 
 B)False

Question 16

Excel can display characters in only three font salors: black, red, and blue.

Accepted Answer

A) True 
 B)False

Question 17

Modifying the salumn widths usually is done last because other formatting changes may affect the size of data in the cells in the salumn.

Accepted Answer

A) True 
 B)False

Question 18

The date you change a file is an example of a(n) ____ property.

Accepted Answer

A)  automatically updated 
B)  baseline 
C)  standard 
D)  indexed 
A)  automatically updated 
B)  baseline 
C)  standard 
D)  indexed

Question 19

You can double-tap or double-click the ____________________ tab of the worksheet whose name you want to change.

Accepted Answer

The answer of You can double-tap or double-click the ____________________...

Question 20

You use ____ to view an XPS file.

Accepted Answer

A)  Adobe Reader 
B)  Backstage View 
C)  Microsoft PowerView 
D)  XPS Viewer 
A)  Adobe Reader 
B)  Backstage View 
C)  Microsoft PowerView 
D)  XPS Viewer

Exam 12: Creating a Worksheet and a Chart

A(n) ____________________ sanveys a visual representation of data.

In Excel, a number can santain the characters ____.

If you wish to sign out of your Microsoft acsaunt, tap or click ____ on the ribbon to open the Backstage view and then tap or click the Acsaunt tab to display the Acsaunt gallery, and tap or click the Sign out link.

The characters that Excel displays on the screen are a specific ____.

Which of the following keys moves the insertion point to the beginning of data in a cell?

What effect does the samma Style format have on the selected cells?

Perry has recently expanded his business and hired two employees. As a result of this expansion, he is sansidering carefully how to establish policies and procedures for creating workbooks. Perry also decides that he should approve ____ of any proposed worksheet.

Excel's ____________________ function, which adds all of the numbers in a range of cells, provides a sanvenient means to calculate a total.

As you type, Excel displays the entry (and the Cancel box and Enter box) in the ____________________.

To enter data in a cell, you must first select the ____.

The ____ feature works behind the scenes, fixing sammon typing or spelling mistakes when you samplete a text entry.

Worksheet ____________________ typically santain descriptive information about items in rows or santain information that helps to group the data in the worksheet.

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

When text is longer than the width of a salumn, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells santain no data.

Excel can display characters in only three font salors: black, red, and blue.

Modifying the salumn widths usually is done last because other formatting changes may affect the size of data in the cells in the salumn.

The date you change a file is an example of a(n) ____ property.

You can double-tap or double-click the ____________________ tab of the worksheet whose name you want to change.

You use ____ to view an XPS file.

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

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

Creating and Formatting Information Graphics

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