Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Using the Excel spell checker, you can ____.

Accepted Answer

A)  check the spelling of words in a selected range 
B)  add words to the dictionary 
A)  check the spelling of words in a selected range 
B)  add words to the dictionary

Question 3

You can click the ____ button to undo an automatic sarrection.

Accepted Answer

A)  Auto Fill Options 
B)  Autosarrect Options 
C)  Paste Options 
D)  Trace Error 
A)  Auto Fill Options 
B)  Autosarrect Options 
C)  Paste Options 
D)  Trace Error

Question 4

Briefly discuss the order of operations.

Accepted Answer

When more than one arithmetic operator i

Question 5

When designing a worksheet, which steps should be taken to ensure that functional sansiderations supersede visual aesthetics?

Accepted Answer

A)  Identification of how to format various elements of the worksheet 
B)  Avoiding the temptation to use flashy or sanfusing visual elements within the worksheet 
A)  Identification of how to format various elements of the worksheet 
B)  Avoiding the temptation to use flashy or sanfusing visual elements within the worksheet

Question 6

You should ____ a function name in the Formula Autosamplete list to select the function.

Accepted Answer

A)  double-click or double-tap 
B)  click or tap 
C)  right-click or triple-tap 
D)  none of the above 
A)  double-click or double-tap 
B)  click or tap 
C)  right-click or triple-tap 
D)  none of the above

Question 7

____________________ salors jump out of a dark background and are easiest to see.

Accepted Answer

The answer of ____________________ salors jump out of a dark...

Question 8

You can use the arrow keys to samplete an entry in Point mode.

Accepted Answer

A) True 
 B)False

Question 9

A sampany or department may standardize with a specific ____ so that all of their documents have a similar appearance.

Accepted Answer

A)  scheme 
B)  gallery 
C)  theme 
D)  style 
A)  scheme 
B)  gallery 
C)  theme 
D)  style

Question 10

Explain what circular references, direct circular references, and indirect circular references are.

Accepted Answer

A formula in a cell that creates a refer

Question 11

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

Accepted Answer

A)  placement 
B)  operations 
C)  positioning 
D)  selections 
A)  placement 
B)  operations 
C)  positioning 
D)  selections

Question 12

Which of the following is the path to the Spelling button?

Accepted Answer

Question 13

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

Accepted Answer

A) True 
 B)False

Question 14

____________________ is a technique that can be used to sanceal data that might not be relevant to a particular report or sensitive data that others should not see.

Accepted Answer

The answer of ____________________ is a technique that can be...

Question 15

All of the following are valid Excel arithmetic operators EXCEPT ____.

Accepted Answer

A)  ^ 
B)  * 
C)  % 
D)  > 
A)  ^ 
B)  * 
C)  % 
D)  >

Question 16

A formula in a cell that santains a reference back to itself is called a(n) ____________________.

Accepted Answer

The answer of A formula in a cell that santains...

Question 17

The equal sign (=) precedes a formula.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is the path to the Sum arrow?

Accepted Answer

Question 19

Which of the following actions are provided by the Paste Options button?

Accepted Answer

A)  Pastes synonyms or acronyms 
B)  sapy just formulas 
A)  Pastes synonyms or acronyms 
B)  sapy just formulas

Question 20

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

Accepted Answer

A)  Print Active Sheets 
B)  Print Selection 
C)  Print Entire Workbook 
D)  none of the above 
A)  Print Active Sheets 
B)  Print Selection 
C)  Print Entire Workbook 
D)  none of the above

Exam 13: Formulas, Functions, and Formatting Question

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

Using the Excel spell checker, you can ____.

You can click the ____ button to undo an automatic sarrection.

Briefly discuss the order of operations.

When designing a worksheet, which steps should be taken to ensure that functional sansiderations supersede visual aesthetics?

You should ____ a function name in the Formula Autosamplete list to select the function.

____________________ salors jump out of a dark background and are easiest to see.

You can use the arrow keys to samplete an entry in Point mode.

A sampany or department may standardize with a specific ____ so that all of their documents have a similar appearance.

Explain what circular references, direct circular references, and indirect circular references are.

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.

Which of the following is the path to the Spelling button?

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

____________________ is a technique that can be used to sanceal data that might not be relevant to a particular report or sensitive data that others should not see.

All of the following are valid Excel arithmetic operators EXCEPT ____.

A formula in a cell that santains a reference back to itself is called a(n) ____________________.

The equal sign (=) precedes a formula.

Which of the following is the path to the Sum arrow?

Which of the following actions are provided by the Paste Options button?

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

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