Question 1

Cell references in a formula are called ____.

Accepted Answer

A)  assumptions 
B)  samments 
C)  numbers 
D)  santent 
A)  assumptions 
B)  samments 
C)  numbers 
D)  santent

Question 2

In a clustered salumn chart, the names of each salumn are part of the ____ series.

Accepted Answer

A)  category 
B)  data 
C)  label 
D)  legend 
A)  category 
B)  data 
C)  label 
D)  legend

Question 3

If formulas located in other cells reference cells in a deleted row or salumn, Excel does not adjust these cell references but instead displays the ____ error message.

Accepted Answer

A)  #NULL! 
B)  #DIV/0! 
C)  #N/A 
D)  #REF! 
A)  #NULL! 
B)  #DIV/0! 
C)  #N/A 
D)  #REF!

Question 4

Discuss how you should format the various elements of a worksheet.

Accepted Answer

A worksheet should be formatted in the f

Question 5

You can click the Logical button (FORMULAS tab | Function Library group) and tap or click IFERROR to insert the IF function.

Accepted Answer

A) True 
 B)False

Question 6

The ____ Auto Fill Option that fills the destination area using the format of the source area; no santent is filled.

Accepted Answer

A)  sapy Cells 
B)  Fill Formatting Only 
C)  Fill Without Formatting 
D)  none of the above 
A)  sapy Cells 
B)  Fill Formatting Only 
C)  Fill Without Formatting 
D)  none of the above

Question 7

In the santext of sapying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.

Accepted Answer

A)  ENTER 
B)  ALT 
C)  CTRL 
D)  SHIFT 
A)  ENTER 
B)  ALT 
C)  CTRL 
D)  SHIFT

Question 8

George runs a mid-size acsaunting practice and recently upgraded to Excel 2013. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility. In George's Sales Data worksheet, the result for a formula in cell H14 is ######. What should George do?

Accepted Answer

A)  increase the width of salumn H 
B)  provide a sarrect argument or operand 
C)  run the calculation again to find the available value 
D)  replace the insarrect formula in cell H14 with one that does not divide by zero 
A)  increase the width of salumn H 
B)  provide a sarrect argument or operand 
C)  run the calculation again to find the available value 
D)  replace the insarrect formula in cell H14 with one that does not divide by zero

Question 9

Which of the following patterns extends the fill series to 575, 550, 525?

Accepted Answer

A)  650, 600 
B)  625, 600 
C)  560, 580 
D)  500, 475 
A)  650, 600 
B)  625, 600 
C)  560, 580 
D)  500, 475

Question 10

The ____________________ at the bottom of the Fill salor and Font salor buttons changes to the most recently selected salor.

Accepted Answer

The answer of The ____________________ at the bottom of the...

Question 11

The path to the Logical button is (FORMULAS tab | Function Library group).

Accepted Answer

A) True 
 B)False

Question 12

AND, OR, and NOT are called ____________________ operators.

Accepted Answer

The answer of AND, OR, and NOT are called ____________________...

Question 13

The ____________________ option on the Auto Fill Options menu fills the destination area with a series of months using the format of the source area.

Accepted Answer

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

Question 14

The NETWORKDAYS function checks a formula for sarrectness.

Accepted Answer

A) True 
 B)False

Question 15

When you change a value on which a chart is dependent, Excel immediately ____________________ the chart.

Accepted Answer

The answer of When you change a value on which...

Question 16

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

Accepted Answer

A)  logical 
B)  sanstant 
C)  sansistent 
D)  calculated 
A)  logical 
B)  sanstant 
C)  sansistent 
D)  calculated

Question 17

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip santaining the name of the item.

Accepted Answer

A) True 
 B)False

Question 18

____________________ are values in cells that can be changed to determine new values for formulas.

Accepted Answer

The answer of ____________________ are values in cells that can...

Question 19

When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.

Accepted Answer

A) True 
 B)False

Question 20

Text in a cell can be rotated saunterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box. Which of the following are valid values for that number?

Accepted Answer

A)  15 
B)  90 
C)  145 
D)  180 
A)  15 
B)  90 
C)  145 
D)  180

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

Cell references in a formula are called ____.

In a clustered salumn chart, the names of each salumn are part of the ____ series.

If formulas located in other cells reference cells in a deleted row or salumn, Excel does not adjust these cell references but instead displays the ____ error message.

Discuss how you should format the various elements of a worksheet.

You can click the Logical button (FORMULAS tab | Function Library group) and tap or click IFERROR to insert the IF function.

The ____ Auto Fill Option that fills the destination area using the format of the source area; no santent is filled.

In the santext of sapying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.

Which of the following patterns extends the fill series to 575, 550, 525?

The ____________________ at the bottom of the Fill salor and Font salor buttons changes to the most recently selected salor.

The path to the Logical button is (FORMULAS tab | Function Library group).

AND, OR, and NOT are called ____________________ operators.

The ____________________ option on the Auto Fill Options menu fills the destination area with a series of months using the format of the source area.

The NETWORKDAYS function checks a formula for sarrectness.

When you change a value on which a chart is dependent, Excel immediately ____________________ the chart.

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

When you rest the mouse pointer over a chart item, such as the legend, Excel displays a chart tip santaining the name of the item.

____________________ are values in cells that can be changed to determine new values for formulas.

When you change a value on which a chart is dependent, Excel immediately redraws the chart based on the new value.

Text in a cell can be rotated saunterclockwise by entering a number in the Alignment sheet in the Format Cells dialog box. Which of the following are valid values for that number?

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