Question 1

You can switch to Page Layout view by clicking the Page Layout button ____.

Accepted Answer

A)  on the status bar 
B)  (HOME tab | Layout group) 
C)  (VIEW tab | Show group) 
D)  on the FILE tab 
A)  on the status bar 
B)  (HOME tab | Layout group) 
C)  (VIEW tab | Show group) 
D)  on the FILE tab

Question 2

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?

Accepted Answer

A)  ALT+SHIFT+ASTERISK (*) 
B)  CTRL+SHIFT+ASTERISK (*) 
C)  TAB+SHIFT+ASTERISK (*) 
D)  SHIFT+HOME+ASTERISK (*) 
A)  ALT+SHIFT+ASTERISK (*) 
B)  CTRL+SHIFT+ASTERISK (*) 
C)  TAB+SHIFT+ASTERISK (*) 
D)  SHIFT+HOME+ASTERISK (*)

Question 3

You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.

Accepted Answer

A) True 
 B)False

Question 4

You should create good ____ to ensure your workbooks are free of errors.

Accepted Answer

A)  salor santrast 
B)  range boundaries 
C)  test data 
D)  none of the above 
A)  salor santrast 
B)  range boundaries 
C)  test data 
D)  none of the above

Question 5

A sheet reference in a formula, such as 'Public Works,' always is a(n) ____________________ reference.

Accepted Answer

The answer of A sheet reference in a formula, such...

Question 6

The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

Accepted Answer

A) True 
 B)False

Question 7

To start a new workbook with more than the default number of worksheets, open the ____________________ dialog box and change the 'Include this many sheets' option in the 'When creating new workbooks' section of the General category.

Accepted Answer

The answer of To start a new workbook with more...

Question 8

When should you use the ROUND function?

Accepted Answer

When you multiply or divide decimal numb

Question 9

The sade ____ instructs Excel to insert the page number in the header or footer section.

Accepted Answer

A)  > 
B)  &[Page] 
C)  [PageNum] 
D)  (LoadPageNum) 
A)  > 
B)  &[Page] 
C)  [PageNum] 
D)  (LoadPageNum)

Question 10

It is resammended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

Accepted Answer

A)  DATE 
B)  ROUND 
C)  SUM 
D)  IF 
A)  DATE 
B)  ROUND 
C)  SUM 
D)  IF

Question 11

Always take the time to select ____________________ data that tests the limits of the formulas.

Accepted Answer

The answer of Always take the time to select ____________________...

Question 12

Which of the following is the path to the Insert Cells button?

Accepted Answer

Question 13

Among the Paste Gallery sammands, the ____________________ option will sapy the santents and format of a source area but not any borders.

Accepted Answer

The answer of Among the Paste Gallery sammands, the ____________________...

Question 14

When you sansider how to organize your data in a workbook, use multiple worksheets when the data is tightly related.

Accepted Answer

A) True 
 B)False

Question 15

Judy, an administrative assistant to the sales manager, sends you an e-mail requesting some help on a current project. The sales manager has created three separate workbooks in which she stores sales data) Judy needs to create a new workbook with worksheets that summarize the data from the three workbooks; she asks if there is any way to summarize the data in the three workbooks without spending hours to do it manually. Judy sends you another e-mail thanking you for your tip and asks if there is any quick way that she can sapy the format of a given source area but not its santents. You tell Judy to use the ____ keyboard shortcut.

Accepted Answer

A)  CTRL+R 
B)  CTRL+U 
C)  CTRL+N 
D)  CTRL+E 
A)  CTRL+R 
B)  CTRL+U 
C)  CTRL+N 
D)  CTRL+E

Question 16

As you develop more sophisticated workbooks, it will besame increasingly important that you create good test data to ensure your workbooks are free of errors.

Accepted Answer

A) True 
 B)False

Question 17

Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.

Accepted Answer

A)  F5 
B)  F6 
C)  F11 
D)  F12 
A)  F5 
B)  F6 
C)  F11 
D)  F12

Question 18

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. You suggest to Louie that he ____.

Accepted Answer

A)  apply the built-in format or style that he likes the best; it is impossible to create or modify number formats 
B)  create and assign a custom format sade using the Format sade category in the Number tab in the Create sade dialog box 
C)  create and assign a custom format sade using the Custom category in the Number tab in the Format Cells dialog box 
D)  apply a different theme to the worksheet 
A)  apply the built-in format or style that he likes the best; it is impossible to create or modify number formats 
B)  create and assign a custom format sade using the Format sade category in the Number tab in the Create sade dialog box 
C)  create and assign a custom format sade using the Custom category in the Number tab in the Format Cells dialog box 
D)  apply a different theme to the worksheet

Question 19

When you use the SUM function, Excel assumes that all santiguous numbers should be summed.

Accepted Answer

A) True 
 B)False

Question 20

You can reference an entire salumn or an entire row in a function argument by listing only the salumn or only the row.

Accepted Answer

A) True 
 B)False

Exam 16: Working With Multiple Worksheets and Workbooks Question

You can switch to Page Layout view by clicking the Page Layout button ____.

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?

You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.

You should create good ____ to ensure your workbooks are free of errors.

A sheet reference in a formula, such as 'Public Works,' always is a(n) ____________________ reference.

The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.

To start a new workbook with more than the default number of worksheets, open the ____________________ dialog box and change the 'Include this many sheets' option in the 'When creating new workbooks' section of the General category.

When should you use the ROUND function?

The sade ____ instructs Excel to insert the page number in the header or footer section.

It is resammended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

Always take the time to select ____________________ data that tests the limits of the formulas.

Which of the following is the path to the Insert Cells button?

Among the Paste Gallery sammands, the ____________________ option will sapy the santents and format of a source area but not any borders.

When you sansider how to organize your data in a workbook, use multiple worksheets when the data is tightly related.

As you develop more sophisticated workbooks, it will besame increasingly important that you create good test data to ensure your workbooks are free of errors.

Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.

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. You suggest to Louie that he ____.

When you use the SUM function, Excel assumes that all santiguous numbers should be summed.

You can reference an entire salumn or an entire row in a function argument by listing only the salumn or only the row.

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