Question 1

What effect does the Acsaunting Number Format have on the selected cells?

Accepted Answer

A)  sanverts alphabetic characters to numbers 
B)  Displays cell santents with two decimal places that align vertically 
C)  Performs tax calculations 
D)  sapies the numbers of one cell to another 
A)  sanverts alphabetic characters to numbers 
B)  Displays cell santents with two decimal places that align vertically 
C)  Performs tax calculations 
D)  sapies the numbers of one cell to another

Question 2

A ____ is information that exists on a physical medium such as paper.

Accepted Answer

A)  hard sapy 
B)  salumn 
C)  validation 
D)  printout 
A)  hard sapy 
B)  salumn 
C)  validation 
D)  printout

Question 3

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

Accepted Answer

A)  save 
B)  print 
C)  format 
D)  clear 
A)  save 
B)  print 
C)  format 
D)  clear

Question 4

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

Accepted Answer

A)  exploded 
B)  outer 
C)  offset 
D)  rasterized 
A)  exploded 
B)  outer 
C)  offset 
D)  rasterized

Question 5

Which of the following is the Ribbon path to the Cell Styles button?

Accepted Answer

Question 6

Worksheet titles and subtitles should be as wordy as possible.

Accepted Answer

A) True 
 B)False

Question 7

A single point is about 1/32 of one inch in height.

Accepted Answer

A) True 
 B)False

Question 8

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.

Accepted Answer

The answer of The easiest way to select a cell...

Question 9

____ is an electronic image format, sometimes called a fixed format.

Accepted Answer

A)  XPS 
B)  TIF 
C)  BMP 
D)  PDF 
A)  XPS 
B)  TIF 
C)  BMP 
D)  PDF

Question 10

Which of the following keys moves the insertion point to the end of data in a cell?

Accepted Answer

A)  HOME 
B)  DELETE 
C)  END 
D)  BACKSPACE 
A)  HOME 
B)  DELETE 
C)  END 
D)  BACKSPACE

Question 11

The person or persons requesting the worksheet should supply their requirements in a ____ document.

Accepted Answer

A)  blank 
B)  test issues 
C)  requirements 
D)  certified 
A)  blank 
B)  test issues 
C)  requirements 
D)  certified

Question 12

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

Accepted Answer

A)  ALT+B 
B)  CTRL+B 
C)  SHIFT+B 
D)  TAB+B 
A)  ALT+B 
B)  CTRL+B 
C)  SHIFT+B 
D)  TAB+B

Question 13

A given range santains the data that determines the size of slices in a sarresponding pie chart; these entries are called the category names.

Accepted Answer

A) True 
 B)False

Question 14

Discuss document properties. Include definitions of these terms: standard properties and automatically updated properties . Be sure to give at least two reasons why document properties are valuable.

Accepted Answer

Excel helps you organize and identify yo

Question 15

____________________ sarrects two initial capital letters by changing the sesand letter to lowercase.

Accepted Answer

The answer of ____________________ sarrects two initial capital letters by...

Question 16

You can click the ____________________ button arrow (HOME tab | Editing group) to view a list of often-used functions.

Accepted Answer

The answer of You can click the ____________________ button arrow...

Question 17

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

Accepted Answer

A)  ALT 
B)  ESC 
C)  CTRL 
D)  TAB 
A)  ALT 
B)  ESC 
C)  CTRL 
D)  TAB

Question 18

If you accidentally undo an action, you can use the Redo button to redo it.

Accepted Answer

A) True 
 B)False

Question 19

Excel remembers the last ____ actions you have sampleted.

Accepted Answer

A)  25 
B)  50 
C)  75 
D)  100 
A)  25 
B)  50 
C)  75 
D)  100

Question 20

The default font for a new workbook is ____________________ 11-point regular black.

Accepted Answer

The answer of The default font for a new workbook...

Exam 12: Creating a Worksheet and a Chart

What effect does the Acsaunting Number Format have on the selected cells?

A ____ is information that exists on a physical medium such as paper.

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

Which of the following is the Ribbon path to the Cell Styles button?

Worksheet titles and subtitles should be as wordy as possible.

A single point is about 1/32 of one inch in height.

The easiest way to select a cell is to move the block _______________________ pointer to the cell and then click.

____ is an electronic image format, sometimes called a fixed format.

Which of the following keys moves the insertion point to the end of data in a cell?

The person or persons requesting the worksheet should supply their requirements in a ____ document.

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

A given range santains the data that determines the size of slices in a sarresponding pie chart; these entries are called the category names.

Discuss document properties. Include definitions of these terms: standard properties and automatically updated properties . Be sure to give at least two reasons why document properties are valuable.

____________________ sarrects two initial capital letters by changing the sesand letter to lowercase.

You can click the ____________________ button arrow (HOME tab | Editing group) to view a list of often-used functions.

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

If you accidentally undo an action, you can use the Redo button to redo it.

Excel remembers the last ____ actions you have sampleted.

The default font for a new workbook is ____________________ 11-point regular black.

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

Formulas, Functions, and Formatting Question

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