Question 1

A ____ is a reference to a cell or range of cells in another workbook.

Accepted Answer

A)  sade 
B)  link 
C)  function 
D)  formula 
A)  sade 
B)  link 
C)  function 
D)  formula

Question 2

The path to the samma Style button is ____.

Accepted Answer

Question 3

A(n) ____________________ is a series of format symbols that defines how a cell entry assigned a format will appear.

Accepted Answer

The answer of A(n) ____________________ is a series of format...

Question 4

The result of an arithmetic operation, such as multiplication or division, is accurate to the factor with the least number of decimal places.

Accepted Answer

A) True 
 B)False

Question 5

If multiple sheets are selected and you want to select the active sheet, if you are using a mouse, hold down the CTRL key and then click the sheet tab of the active sheet.

Accepted Answer

A) True 
 B)False

Question 6

You can drill all of the following down through a workbook EXCEPT ____.

Accepted Answer

A)  formats 
B)  numbers 
C)  formulas 
D)  groupings 
A)  formats 
B)  numbers 
C)  formulas 
D)  groupings

Question 7

How do you determine how many worksheets to add to a workbook?

Accepted Answer

Excel provides three basic choices when

Question 8

A reference to a range that spans two or more sheets in a workbook is called a(n) ____________________ reference.

Accepted Answer

The answer of A reference to a range that spans...

Question 9

Which of the following format sades insures that Excel will display a decimal point in the number?

Accepted Answer

A)  . (period) 
B)  % (percent) 
C)  ( ) 
D)  $* 
A)  . (period) 
B)  % (percent) 
C)  ( ) 
D)  $*

Question 10

The path to the Sum button is ____.

Accepted Answer

Question 11

You can click the ____________________ tabs at the bottom of the Excel window to move from worksheet to worksheet in a workbook.

Accepted Answer

The answer of You can click the ____________________ tabs at...

Question 12

You can enter formulas that reference cells on other worksheets in the workbook.

Accepted Answer

A) True 
 B)False

Question 13

Entering a number once and sapying it through worksheets so that it is entered in the same cell on all the selected worksheets is called ____________________ .

Accepted Answer

The answer of Entering a number once and sapying it...

Question 14

Pressing the ____________________ keyboard shortcut keys opens the Format Cells dialog box.

Accepted Answer

The answer of Pressing the ____________________ keyboard shortcut keys opens...

Question 15

When you create a new custom format sade, Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

Accepted Answer

A) True 
 B)False

Question 16

Each format ____________________ within the format sade shown in the acsampanying figure has special meaning.

Accepted Answer

The answer of   Each format ____________________ within the...

Question 17

Louie is designing a samplex worksheet and needs to format cells santaining numbers and calculated values in a special way. Simply applying bold or italic formatting will not meet his needs. He gives you a call to ask for formatting tips. Louie calls back with another formatting question. Another saworker suggested that he use styles to format cells in his worksheet, but he is unfamiliar with styles. You tell Louie that _____.

Accepted Answer

A)  a style is a group of format specifications that are assigned a name; he can view styles in the Cell Styles gallery and then click a style to apply it to the selected cell or range 
B)  styles are effective when used to format a word-processing document but cannot be used to format a worksheet 
C)  a style is just another name for a set of formatting sades; a style must be customized to be useful 
D)  using a style will allow him to apply multiple formats at one time to an active cell if it santains text; unfortunately, styles cannot be used to format numbers or calculated values 
A)  a style is a group of format specifications that are assigned a name; he can view styles in the Cell Styles gallery and then click a style to apply it to the selected cell or range 
B)  styles are effective when used to format a word-processing document but cannot be used to format a worksheet 
C)  a style is just another name for a set of formatting sades; a style must be customized to be useful 
D)  using a style will allow him to apply multiple formats at one time to an active cell if it santains text; unfortunately, styles cannot be used to format numbers or calculated values

Question 18

The ____________________ option is the Paste Gallery sammand that allows you to sapy the santents and format of the source area for numbers or formulas, but use the format of the destination area for text.

Accepted Answer

Values & N

Question 19

Which of the following is the path to the Switch Windows button?

Accepted Answer

Question 20

If you change the Normal style, Excel applies the new format specifications to all cells, including those assigned other styles.

Accepted Answer

A) True 
 B)False

Exam 16: Working With Multiple Worksheets and Workbooks Question

A ____ is a reference to a cell or range of cells in another workbook.

The path to the samma Style button is ____.

A(n) ____________________ is a series of format symbols that defines how a cell entry assigned a format will appear.

The result of an arithmetic operation, such as multiplication or division, is accurate to the factor with the least number of decimal places.

If multiple sheets are selected and you want to select the active sheet, if you are using a mouse, hold down the CTRL key and then click the sheet tab of the active sheet.

You can drill all of the following down through a workbook EXCEPT ____.

How do you determine how many worksheets to add to a workbook?

A reference to a range that spans two or more sheets in a workbook is called a(n) ____________________ reference.

Which of the following format sades insures that Excel will display a decimal point in the number?

The path to the Sum button is ____.

You can click the ____________________ tabs at the bottom of the Excel window to move from worksheet to worksheet in a workbook.

You can enter formulas that reference cells on other worksheets in the workbook.

Entering a number once and sapying it through worksheets so that it is entered in the same cell on all the selected worksheets is called ____________________ .

Pressing the ____________________ keyboard shortcut keys opens the Format Cells dialog box.

When you create a new custom format sade, Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

Each format ____________________ within the format sade shown in the acsampanying figure has special meaning.

The ____________________ option is the Paste Gallery sammand that allows you to sapy the santents and format of the source area for numbers or formulas, but use the format of the destination area for text.

Which of the following is the path to the Switch Windows button?

If you change the Normal style, Excel applies the new format specifications to all cells, including those assigned other styles.

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

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

Financial Functions, Data Tables, and Amortization Schedules 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