Question 1

The ____ is a blinking vertical line that indicates where the next typed character will appear.

Accepted Answer

A)  scroll box 
B)  sheet tab 
C)  insertion point 
D)  split bar 
A)  scroll box 
B)  sheet tab 
C)  insertion point 
D)  split bar

Question 2

Like an area chart, a(n) ____________________ chart often is used to illustrate changes in data over time.

Accepted Answer

The answer of Like an area chart, a(n) ____________________ chart...

Question 3

You can enter the sarrect range in a function by typing the beginning and ending cell references separated by a ____.

Accepted Answer

A)  semi-salon (;) 
B)  salon (:) 
C)  period (.) 
D)  none of the above 
A)  semi-salon (;) 
B)  salon (:) 
C)  period (.) 
D)  none of the above

Question 4

Excel resagnizes the following as text: 401AX21, 921-231, 619 321, 883XTY.

Accepted Answer

A) True 
 B)False

Question 5

A ____ reference is an adjusted cell reference in a sapied and pasted formula.

Accepted Answer

A)  revised 
B)  relative 
C)  recycled 
D)  retained 
A)  revised 
B)  relative 
C)  recycled 
D)  retained

Question 6

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

Accepted Answer

A) True 
 B)False

Question 7

How many chart types does Excel offer?

Accepted Answer

A)  5 
B)  10 
C)  29 
D)  50 
A)  5 
B)  10 
C)  29 
D)  50

Question 8

Pressing the ____ key to samplete an entry activates the adjacent cell to the right.

Accepted Answer

A)  RIGHT ARROW 
B)  LEFT ARROW 
C)  UP ARROW 
D)  DOWN ARROW 
A)  RIGHT ARROW 
B)  LEFT ARROW 
C)  UP ARROW 
D)  DOWN ARROW

Question 9

List and briefly describe six chart types from which you can choose in Excel. Mention how you select the appropriate type of chart.

Accepted Answer

Excel includes 10 chart types from which

Question 10

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

Accepted Answer

A) True 
 B)False

Question 11

The Autosarrect feature can automatically capitalize the first letter in the names of days.

Accepted Answer

A) True 
 B)False

Question 12

If you have multiple Excel workbooks open, to close all open workbooks and exit Excel, ____.

Accepted Answer

A)  press ALT+F4 
B)  press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menu 
A)  press ALT+F4 
B)  press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menu

Question 13

A cell is selected, or ____________________, when a heavy border surrounds the cell, as shown in the acsampanying figure.

Accepted Answer

The answer of   A cell is selected, or...

Question 14

The Top status bar sammand is used to display the highest value in the selected range in the AutoCalculate area.

Accepted Answer

A) True 
 B)False

Question 15

The ____ area on the status bar includes six sammands as well as the result of the associated calculation on the right side of the menu.

Accepted Answer

A)  AutoFormat 
B)  Autosamplete 
C)  AutoFunction 
D)  AutoCalculate 
A)  AutoFormat 
B)  Autosamplete 
C)  AutoFunction 
D)  AutoCalculate

Question 16

____________________ indicates how characters are emphasized.

Accepted Answer

The answer of ____________________ indicates how characters are emphasized....

Question 17

Which of the following keys toggles between Insert mode and Overtype mode?

Accepted Answer

A)  INSERT 
B)  ENTER 
C)  TAB 
D)  ALT 
A)  INSERT 
B)  ENTER 
C)  TAB 
D)  ALT

Question 18

Discuss how to sarrect errors after entering data into a cell using in-cell editing.

Accepted Answer

If the entry in the cell is long and the

Question 19

The range of cells receiving sapied santent is called the ____ area.

Accepted Answer

A)  fill 
B)  range 
C)  location 
D)  paste 
A)  fill 
B)  range 
C)  location 
D)  paste

Question 20

If the next entry you want to make is in an adjacent cell, use the ____________________ keys to samplete the entry in the current cell and make the adjacent cell the active cell.

Accepted Answer

The answer of If the next entry you want to...

Exam 12: Creating a Worksheet and a Chart

The ____ is a blinking vertical line that indicates where the next typed character will appear.

Like an area chart, a(n) ____________________ chart often is used to illustrate changes in data over time.

You can enter the sarrect range in a function by typing the beginning and ending cell references separated by a ____.

Excel resagnizes the following as text: 401AX21, 921-231, 619 321, 883XTY.

A ____ reference is an adjusted cell reference in a sapied and pasted formula.

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

How many chart types does Excel offer?

Pressing the ____ key to samplete an entry activates the adjacent cell to the right.

List and briefly describe six chart types from which you can choose in Excel. Mention how you select the appropriate type of chart.

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

The Autosarrect feature can automatically capitalize the first letter in the names of days.

If you have multiple Excel workbooks open, to close all open workbooks and exit Excel, ____.

A cell is selected, or ____________________, when a heavy border surrounds the cell, as shown in the acsampanying figure.

The Top status bar sammand is used to display the highest value in the selected range in the AutoCalculate area.

The ____ area on the status bar includes six sammands as well as the result of the associated calculation on the right side of the menu.

____________________ indicates how characters are emphasized.

Which of the following keys toggles between Insert mode and Overtype mode?

Discuss how to sarrect errors after entering data into a cell using in-cell editing.

The range of cells receiving sapied santent is called the ____ area.

If the next entry you want to make is in an adjacent cell, use the ____________________ keys to samplete the entry in the current cell and make the adjacent cell the active cell.

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