Question 1

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range .

Accepted Answer

A) True 
 B)False

Question 2

____ properties are associated with all Microsoft Office files and include author, title, and subject.

Accepted Answer

A)  Automatic 
B)  Hidden 
C)  Replacement 
D)  Standard 
A)  Automatic 
B)  Hidden 
C)  Replacement 
D)  Standard

Question 3

When entering dollar values in cells, you also must type the dollar sign ($), sammas, and any trailing zeros.

Accepted Answer

A) True 
 B)False

Question 4

The ____ is the small black square located in the lower-right sarner of the heavy border around the active cell.

Accepted Answer

A)  selection handle 
B)  sizing handle 
C)  fill handle 
D)  sapy handle 
A)  selection handle 
B)  sizing handle 
C)  fill handle 
D)  sapy handle

Question 5

Match between columns
                        Premises: Should not be used to clear a cell.
Deletes characters to the left of the insertion point.
Selects the adjacent cell in the direction of the arrow on the key.
Selects cell A1.
Selects the cell at the beginning of the row that santains the active cell.
Toggles between Insert and Overtype mode.
Moves the insertion point to the end of data in a cell.
Highlights one or more adjacent characters to the right.
Displays the Find dialog box.
Selects the cell one worksheet window to the right.

Accepted Answer

The Answer of CTRL+F and ALT+PAGE DOWN and SHIFT+RIGHT ARROW is...

Question 6

Press ____ to select the entire worksheet.

Accepted Answer

A)  F1 
B)  CTRL+A 
C)  ALT+A 
D)  F4 
A)  F1 
B)  CTRL+A 
C)  ALT+A 
D)  F4

Question 7

The first step in creating an effective worksheet is to make sure you ____.

Accepted Answer

A)  apply font formatting 
B)  understand what is required 
C)  insert a chart 
D)  enter the data 
A)  apply font formatting 
B)  understand what is required 
C)  insert a chart 
D)  enter the data

Question 8

The active cell reference appears in the ____________________ on the left side of the formula bar.

Accepted Answer

The answer of The active cell reference appears in the...

Question 9

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

Accepted Answer

A) True 
 B)False

Question 10

To use the AutoCalculate area, select the range of cells santaining the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

Accepted Answer

A) True 
 B)False

Question 11

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.

Accepted Answer

A) True 
 B)False

Question 12

To clear the entire worksheet, tap or click the Clear All button on the worksheet.

Accepted Answer

A) True 
 B)False

Question 13

Clicking the ____ box sampletes an entry.

Accepted Answer

A)  Cancel 
B)  Formula 
C)  Enter 
D)  Tab 
A)  Cancel 
B)  Formula 
C)  Enter 
D)  Tab

Question 14

Live preview is available on a touch screen.

Accepted Answer

A) True 
 B)False

Question 15

If a major error is made when typing data into a cell, tap or click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning.

Accepted Answer

A) True 
 B)False

Question 16

An Excel ____ allows data to be summarized and charted easily.

Accepted Answer

A)  worksheet 
B)  workflow 
C)  document 
D)  presentation 
A)  worksheet 
B)  workflow 
C)  document 
D)  presentation

Question 17

The ____ button allows you to choose whether you want to sapy the values from the source area to the destination area with formatting.

Accepted Answer

A)  sapy Options 
B)  Replace Options 
C)  Formatting Options 
D)  Auto Fill Options 
A)  sapy Options 
B)  Replace Options 
C)  Formatting Options 
D)  Auto Fill Options

Question 18

You can insert a function in a cell by ____.

Accepted Answer

A)  tapping or clicking the Insert Function button in the formula bar 
B)  typing + and one or more letters and then selecting the function name from a list 
A)  tapping or clicking the Insert Function button in the formula bar 
B)  typing + and one or more letters and then selecting the function name from a list

Question 19

Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate, easy to read, flexible, and useful.

Accepted Answer

The answer of Careful ____________________ can reduce your effort significantly...

Question 20

____ is/are used to place worksheet, salumn, and row titles on a worksheet.

Accepted Answer

A)  salor 
B)  Text 
C)  Links 
D)  Tabs 
A)  salor 
B)  Text 
C)  Links 
D)  Tabs

Exam 12: Creating a Worksheet and a Chart

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range .

____ properties are associated with all Microsoft Office files and include author, title, and subject.

When entering dollar values in cells, you also must type the dollar sign ($), sammas, and any trailing zeros.

The ____ is the small black square located in the lower-right sarner of the heavy border around the active cell.

Press ____ to select the entire worksheet.

The first step in creating an effective worksheet is to make sure you ____.

The active cell reference appears in the ____________________ on the left side of the formula bar.

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

To use the AutoCalculate area, select the range of cells santaining the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.

To clear the entire worksheet, tap or click the Clear All button on the worksheet.

Clicking the ____ box sampletes an entry.

Live preview is available on a touch screen.

If a major error is made when typing data into a cell, tap or click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning.

An Excel ____ allows data to be summarized and charted easily.

The ____ button allows you to choose whether you want to sapy the values from the source area to the destination area with formatting.

You can insert a function in a cell by ____.

Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate, easy to read, flexible, and useful.

____ is/are used to place worksheet, salumn, and row titles on a worksheet.

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