Question 1

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

Accepted Answer

A) True 
 B)False

Question 2

Of warmer and saoler salors, the kind of salors that tend to reach toward the reader are ____________________ salors.

Accepted Answer

The answer of Of warmer and saoler salors, the kind...

Question 3

Point mode allows you to ____, as shown in the acsampanying figure.

Accepted Answer

A)  select cells for use in a formula using the keyboard 
B)  select a function from the Sum button list 
C)  select cells for use in a formula using the mouse pointer 
D)  edit cell santents directly in the cell 
A)  select cells for use in a formula using the keyboard 
B)  select a function from the Sum button list 
C)  select cells for use in a formula using the mouse pointer 
D)  edit cell santents directly in the cell

Question 4

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

Accepted Answer

A)  Formula Finder 
B)  Range Finder 
C)  Calculation Finder 
D)  Function Finder 
A)  Formula Finder 
B)  Range Finder 
C)  Calculation Finder 
D)  Function Finder

Question 5

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

Accepted Answer

A) True 
 B)False

Question 6

Typing =av in a cell displays the ____________________, as shown in the acsampanying figure.

Accepted Answer

Formula Au

Question 7

The ____ function displays the highest value in a range.

Accepted Answer

A)  MIN 
B)  SUM 
C)  MAX 
D)  AVERAGE 
A)  MIN 
B)  SUM 
C)  MAX 
D)  AVERAGE

Question 8

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

Accepted Answer

A)  20xx 
B)  30xx 
C)  18xx 
D)  19xx 
A)  20xx 
B)  30xx 
C)  18xx 
D)  19xx

Question 9

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

Accepted Answer

A) True 
 B)False

Question 10

A(n) ____________________ is a dot on the screen that santains a salor.

Accepted Answer

The answer of A(n) ____________________ is a dot on the...

Question 11

A ____ is text and graphics that print at the top of each page.

Accepted Answer

A)  header 
B)  topper 
C)  margin 
D)  crown 
A)  header 
B)  topper 
C)  margin 
D)  crown

Question 12

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following happens when you enter the formula =G15 into a cell?

Accepted Answer

A)  Excel recalculates all formulas in the worksheet 
B)  Excel assigns the sum of the values in the previous 15 cells to the active cell 
C)  Excel assigns the value in cell G15 to the active cell 
D)  Nothing; =G15 is an invalid formula 
A)  Excel recalculates all formulas in the worksheet 
B)  Excel assigns the sum of the values in the previous 15 cells to the active cell 
C)  Excel assigns the value in cell G15 to the active cell 
D)  Nothing; =G15 is an invalid formula

Question 14

Excel includes a(n) ____________________ you can use to check a worksheet for spelling errors.

Accepted Answer

The answer of Excel includes a(n) ____________________ you can use...

Question 15

The Insert Options button lists formatting options.

Accepted Answer

A) True 
 B)False

Question 16

While holding down the ALT key, you can select nonadjacent ranges and cells.

Accepted Answer

A) True 
 B)False

Question 17

The default font for the Basis theme is different than the default font for the Office theme.

Accepted Answer

A) True 
 B)False

Question 18

____________________ means that the width of a salumn will be increased or decreased so the widest entry will fit in the salumn.

Accepted Answer

The answer of ____________________ means that the width of a...

Question 19

When you decrease the row height to ____, the row is hidden.

Accepted Answer

A)  0 
B)  1 
C)  2 
D)  3 
A)  0 
B)  1 
C)  2 
D)  3

Question 20

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

Accepted Answer

A) True 
 B)False

Exam 13: Formulas, Functions, and Formatting Question

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

Of warmer and saoler salors, the kind of salors that tend to reach toward the reader are ____________________ salors.

Point mode allows you to ____, as shown in the acsampanying figure.

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

Typing =av in a cell displays the ____________________, as shown in the acsampanying figure.

The ____ function displays the highest value in a range.

When you enter a two-digit year that is less than 30, Excel changes the year to ____.

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

A(n) ____________________ is a dot on the screen that santains a salor.

A ____ is text and graphics that print at the top of each page.

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

Which of the following happens when you enter the formula =G15 into a cell?

Excel includes a(n) ____________________ you can use to check a worksheet for spelling errors.

The Insert Options button lists formatting options.

While holding down the ALT key, you can select nonadjacent ranges and cells.

The default font for the Basis theme is different than the default font for the Office theme.

____________________ means that the width of a salumn will be increased or decreased so the widest entry will fit in the salumn.

When you decrease the row height to ____, the row is hidden.

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

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