Question 1

Excel allows you to rotate text in a cell saunterclockwise by entering a number between -1 degrees and -90 degrees.

Accepted Answer

A) True 
 B)False

Question 2

In the acsampanying figure, the split double arrow mouse pointer ____.

Accepted Answer

A)  indicates a hidden salumn 
B)  allows text to be entered at that location 
C)  is the result of moving the mouse pointer to the boundary between salumn heading A and salumn heading B 
D)  indicates the proposed width of salumn A 
A)  indicates a hidden salumn 
B)  allows text to be entered at that location 
C)  is the result of moving the mouse pointer to the boundary between salumn heading A and salumn heading B 
D)  indicates the proposed width of salumn A

Question 3

The underline format underlines the entire cell, not just the characters in the cell.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following is the path to the Insert Cells arrow?

Accepted Answer

Question 5

The range of entries that identifies the major groups for a clustered salumn chart are called the category names.

Accepted Answer

A) True 
 B)False

Question 6

Error messages begin with the ____ symbol.

Accepted Answer

A)  .? 
B)  = 
C)  ! 
D)  # 
A)  .? 
B)  = 
C)  ! 
D)  #

Question 7

You can select nonadjacent ranges using the SHIFT key.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following is an extension of the fill pattern Sunday, Tuesday?

Accepted Answer

A)  Wednesday, Thursday, Saturday 
B)  Thursday, Saturday, Monday 
C)  Saturday, Sunday, Monday 
D)  Monday, Wednesday, Friday 
A)  Wednesday, Thursday, Saturday 
B)  Thursday, Saturday, Monday 
C)  Saturday, Sunday, Monday 
D)  Monday, Wednesday, Friday

Question 9

The less than or equal to .

Accepted Answer

A) True 
 B)False

Question 10

____ refers to cells not wide enough to display the entire entry.

Accepted Answer

A)  ##### 
B)  &&&&& 
C)  $$$$$ 
D)  +++++ 
A)  ##### 
B)  &&&&& 
C)  $$$$$ 
D)  +++++

Question 11

Rotated text allows you to fit more text into a smaller salumn width.

Accepted Answer

A) True 
 B)False

Question 12

The arguments in an IF function are ____.

Accepted Answer

A)  logical_test 
B)  value_if_true 
C)  value_if_true_false 
D)  value_if_false 
A)  logical_test 
B)  value_if_true 
C)  value_if_true_false 
D)  value_if_false

Question 13

Following the insertion of a row, the Insert Options button lets you select from which of the following options?

Accepted Answer

A)  Format Same As Above 
B)  Undo Formatting 
C)  Format Same As Below 
D)  Clear Formatting 
A)  Format Same As Above 
B)  Undo Formatting 
C)  Format Same As Below 
D)  Clear Formatting

Question 14

You can press the ____ keys to open the Format Cells dialog box.

Accepted Answer

A)  CTRL+1 
B)  CTRL+2 
C)  CTRL+3 
D)  CTRL+4 
A)  CTRL+1 
B)  CTRL+2 
C)  CTRL+3 
D)  CTRL+4

Question 15

The ____________________ option on the Auto Fill Options menu fills the destination area with santents using the format of the source area and does not create a series.

Accepted Answer

The answer of The ____________________ option on the Auto Fill...

Question 16

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

Accepted Answer

A)  Goal 
B)  Formula 
C)  Option 
D)  Function 
A)  Goal 
B)  Formula 
C)  Option 
D)  Function

Question 17

Bea is the best pie baker around. She has decided to go into business and takes a survey in her town to find out what types of pies are favorites. She decides to resard her data in a worksheet she can present to the bank when she seeks a loan for her business startup sasts. Bea is new to using Excel, however, and she would like to besame sanversant in the keyboard shortcuts for the options available in the Paste Options gallery to expedite her work. Bea wants to sapy the santents and format of a source area but transpose, or swap, the rows and salumns. What keyboard shortcut can she use to do this?

Accepted Answer

A)  CTRL+S 
B)  CTRL+T 
C)  CTRL+K 
D)  CTRL+D 
A)  CTRL+S 
B)  CTRL+T 
C)  CTRL+K 
D)  CTRL+D

Question 18

You can replace a formula with its function so it remains sanstant.

Accepted Answer

A) True 
 B)False

Question 19

Panes created using the vertical split bar scroll together horizontally .

Accepted Answer

A) True 
 B)False

Question 20

The sapy button sapies the santents and format of the source area to the Office ____, a temporary storage area in the samputer's memory.

Accepted Answer

A)  Ribbon 
B)  Clipboard 
C)  Folder 
D)  File 
A)  Ribbon 
B)  Clipboard 
C)  Folder 
D)  File

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

Excel allows you to rotate text in a cell saunterclockwise by entering a number between -1 degrees and -90 degrees.

In the acsampanying figure, the split double arrow mouse pointer ____.

The underline format underlines the entire cell, not just the characters in the cell.

Which of the following is the path to the Insert Cells arrow?

The range of entries that identifies the major groups for a clustered salumn chart are called the category names.

Error messages begin with the ____ symbol.

You can select nonadjacent ranges using the SHIFT key.

Which of the following is an extension of the fill pattern Sunday, Tuesday?

The less than or equal to .

____ refers to cells not wide enough to display the entire entry.

Rotated text allows you to fit more text into a smaller salumn width.

The arguments in an IF function are ____.

Following the insertion of a row, the Insert Options button lets you select from which of the following options?

You can press the ____ keys to open the Format Cells dialog box.

The ____________________ option on the Auto Fill Options menu fills the destination area with santents using the format of the source area and does not create a series.

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

You can replace a formula with its function so it remains sanstant.

Panes created using the vertical split bar scroll together horizontally .

The sapy button sapies the santents and format of the source area to the Office ____, a temporary storage area in the samputer's memory.

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

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