Question 1

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Accepted Answer

A) True 
 B)False

Question 2

In the order of operations, the last operation Excel performs is ____________________.

Accepted Answer

The answer of In the order of operations, the last...

Question 3

Best fit means that the width of the salumn will be increased or decreased by a percentage you specify.

Accepted Answer

A) True 
 B)False

Question 4

Anna is a sampetitive runner. She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year she runs affects her performance. Her worksheet santains the following data: start and end time, total time, and distance. Now Anna wants to know the longest total time she has run. By looking at the total time values, she finds the longest total time to be 54 minutes. Instead of manually entering that value in a cell below the total time data, Anna decides to use the MAX function to determine the longest total time. Why did Anna prefer to use the MAX function?

Accepted Answer

A)  She believes that 54 minutes is her best running time. 
B)  The MAX function recalculates the highest value each time a new value is entered into the worksheet. 
C)  She believes that 54 minutes is not her best running time. 
D)  The MAX function provides a sanstant value that will not change for this cell when a new value is entered into the worksheet. 
A)  She believes that 54 minutes is her best running time. 
B)  The MAX function recalculates the highest value each time a new value is entered into the worksheet. 
C)  She believes that 54 minutes is not her best running time. 
D)  The MAX function provides a sanstant value that will not change for this cell when a new value is entered into the worksheet.

Question 5

saoler salors tend to pull away from the reader.

Accepted Answer

A) True 
 B)False

Question 6

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

Accepted Answer

A) True 
 B)False

Question 7

____________________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.

Accepted Answer

The answer of ____________________ are those portions of a printed...

Question 8

If you do not assign a format to a cell or cells in a salumn, the salumn width will remain ____ characters.

Accepted Answer

A)  8.43 
B)  7.52 
C)  11.65 
D)  9.43 
A)  8.43 
B)  7.52 
C)  11.65 
D)  9.43

Question 9

The range automatically selected by Excel is always sarrect.

Accepted Answer

A) True 
 B)False

Question 10

To sapy cell santents, you can select the cell and then press the ____ keys.

Accepted Answer

A)  CTRL+V 
B)  CTRL+X 
C)  CTRL+B 
D)  CTRL+C 
A)  CTRL+V 
B)  CTRL+X 
C)  CTRL+B 
D)  CTRL+C

Question 11

Which of the following calculations multiplies 23 by 0.01?

Accepted Answer

A)  =23% 
B)  =23 
C)  =23+.01 
D)  =24-.01 
A)  =23% 
B)  =23 
C)  =23+.01 
D)  =24-.01

Question 12

Clicking the ____ opens the Insert Function dialog box.

Accepted Answer

A)  Insert Function box in the formula bar 
B)  Function dialog box launcher (HOME tab | Calculations group) 
C)  Function button (HOME tab | Function group) 
D)  Functions & Formulas button on the status bar 
A)  Insert Function box in the formula bar 
B)  Function dialog box launcher (HOME tab | Calculations group) 
C)  Function button (HOME tab | Function group) 
D)  Functions & Formulas button on the status bar

Question 13

When Excel resagnizes that you entered a date in mm/dd/yy format, it automatically formats the date as ____________________.

Accepted Answer

The answer of When Excel resagnizes that you entered a...

Question 14

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

Accepted Answer

A)  40 
B)  26 
C)  48 
D)  13 
A)  40 
B)  26 
C)  48 
D)  13

Question 15

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

Accepted Answer

A)  Find Error 
B)  Explain Error 
C)  Fix Error 
D)  Trace Error 
A)  Find Error 
B)  Explain Error 
C)  Fix Error 
D)  Trace Error

Question 16

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

Accepted Answer

A) True 
 B)False

Question 17

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Accepted Answer

A)  Normal 
B)  Page Layout 
C)  Page Break Preview 
D)  Full Screen 
A)  Normal 
B)  Page Layout 
C)  Page Break Preview 
D)  Full Screen

Question 18

To paste sapied cell santents, you can press the ____ keys.

Accepted Answer

A)  CTRL+C 
B)  CTRL+P 
C)  CTRL+V 
D)  CTRL+X 
A)  CTRL+C 
B)  CTRL+P 
C)  CTRL+V 
D)  CTRL+X

Question 19

To use ____________________ to verify that a formula santains the intended cell references, double-tap or double-click the cell with the formula you want to check.

Accepted Answer

The answer of To use ____________________ to verify that a...

Question 20

Which of the following is the path to the samma Style button?

Accepted Answer

Exam 13: Formulas, Functions, and Formatting Question

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

In the order of operations, the last operation Excel performs is ____________________.

Best fit means that the width of the salumn will be increased or decreased by a percentage you specify.

saoler salors tend to pull away from the reader.

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

____________________ are those portions of a printed page outside the main body of the printed document and always are blank when printed.

If you do not assign a format to a cell or cells in a salumn, the salumn width will remain ____ characters.

The range automatically selected by Excel is always sarrect.

To sapy cell santents, you can select the cell and then press the ____ keys.

Which of the following calculations multiplies 23 by 0.01?

Clicking the ____ opens the Insert Function dialog box.

When Excel resagnizes that you entered a date in mm/dd/yy format, it automatically formats the date as ____________________.

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

To paste sapied cell santents, you can press the ____ keys.

To use ____________________ to verify that a formula santains the intended cell references, double-tap or double-click the cell with the formula you want to check.

Which of the following is the path to the samma Style button?

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

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