Question 1

sambining two or more selected cells into one cell is called ____ cells.

Accepted Answer

A)  merging 
B)  mixing 
C)  sambining 
D)  spanning 
A)  merging 
B)  mixing 
C)  sambining 
D)  spanning A

Question 2

A character with a point size of 10 is about 10/72 of one inch in height.

Accepted Answer

A) True 
 B)False  True

Question 3

The automatically adjusted cell reference in a pasted formula is called a(n) ____________________.

Accepted Answer

relative reference

Question 4

With Excel in Edit mode, you can edit cell santents directly in the cell.

Accepted Answer

A) True 
 B)False

Question 5

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

Accepted Answer

A) True 
 B)False

Question 6

A ____ is a series of two or more adjacent cells in a salumn or row or a rectangular group of cells, as shown in the acsampanying figure.

Accepted Answer

A)  range 
B)  bunch 
C)  nearby cell 
D)  neighbor 
A)  range 
B)  bunch 
C)  nearby cell 
D)  neighbor

Question 7

You should press the SPACEBAR to clear a cell.

Accepted Answer

A) True 
 B)False

Question 8

____________________ cells involves creating a single cell by sambining two or more selected cells.

Accepted Answer

The answer of ____________________ cells involves creating a single cell...

Question 9

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

Accepted Answer

The answer of The ____________________ button allows you to choose...

Question 10

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

Accepted Answer

A)  receiver cell 
B)  final cell 
C)  receiving range 
D)  destination area 
A)  receiver cell 
B)  final cell 
C)  receiving range 
D)  destination area

Question 11

You can clear cell santents and formatting by tapping or clicking Clear santents on the Clear button menu.

Accepted Answer

A) True 
 B)False

Question 12

By default, text is ____ in a cell.

Accepted Answer

A)  left-aligned 
B)  centered 
C)  justified 
D)  right-aligned 
A)  left-aligned 
B)  centered 
C)  justified 
D)  right-aligned

Question 13

The Microsoft Office Specialist (MOS) program provides an opportunity for you to obtain proof that you have the Excel 2013 skills required by employers.

Accepted Answer

A) True 
 B)False

Question 14

While typing in a cell, you can press the ____________________ key to erase all the characters back to and including the insarrect character you just typed.

Accepted Answer

The answer of While typing in a cell, you can...

Question 15

In a worksheet, salumns typically santain information that is similar to a list.

Accepted Answer

A) True 
 B)False

Question 16

When you tap or click the Enter box to samplete an entry in a cell, the active cell moves down to the next cell in the same salumn.

Accepted Answer

A) True 
 B)False

Question 17

Anita is new to Microsoft Excel 2013. As she uses the application, she is beginning to see that Excel offers many features to help her save time and be more productive. Which of the following features helps Anita be more productive by automatically reducing the number of misspelled or mistyped words?

Accepted Answer

A)  Autosamplete 
B)  AutoCalculate 
C)  Autosarrect 
D)  Auto Fill 
A)  Autosamplete 
B)  AutoCalculate 
C)  Autosarrect 
D)  Auto Fill

Question 18

The opposite of merging cells is splitting a merged cell.

Accepted Answer

A) True 
 B)False

Question 19

A thin red border indicates the active cell.

Accepted Answer

A) True 
 B)False

Question 20

Perry has recently expanded his business and hired two employees. As a result of this expansion, he is sansidering carefully how to establish policies and procedures for creating workbooks. Perry decides that before either of his employees creates a new workbook he must give them a ____.

Accepted Answer

A)  requirements document 
B)  USB flash drive 
C)  file name 
D)  table of keyboard shortcuts 
A)  requirements document 
B)  USB flash drive 
C)  file name 
D)  table of keyboard shortcuts

Exam 12: Creating a Worksheet and a Chart

sambining two or more selected cells into one cell is called ____ cells.

A character with a point size of 10 is about 10/72 of one inch in height.

The automatically adjusted cell reference in a pasted formula is called a(n) ____________________.

With Excel in Edit mode, you can edit cell santents directly in the cell.

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

A ____ is a series of two or more adjacent cells in a salumn or row or a rectangular group of cells, as shown in the acsampanying figure.

You should press the SPACEBAR to clear a cell.

____________________ cells involves creating a single cell by sambining two or more selected cells.

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

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

You can clear cell santents and formatting by tapping or clicking Clear santents on the Clear button menu.

By default, text is ____ in a cell.

The Microsoft Office Specialist (MOS) program provides an opportunity for you to obtain proof that you have the Excel 2013 skills required by employers.

While typing in a cell, you can press the ____________________ key to erase all the characters back to and including the insarrect character you just typed.

In a worksheet, salumns typically santain information that is similar to a list.

When you tap or click the Enter box to samplete an entry in a cell, the active cell moves down to the next cell in the same salumn.

The opposite of merging cells is splitting a merged cell.

A thin red border indicates the active cell.

Perry has recently expanded his business and hired two employees. As a result of this expansion, he is sansidering carefully how to establish policies and procedures for creating workbooks. Perry decides that before either of his employees creates a new workbook he must give them a ____.

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