Question 1

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.

Accepted Answer

A) True 
 B)False  True

Question 2

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  True

Question 3

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

Accepted Answer

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

Question 4

The ____ button allows you to erase recent cell entries.

Accepted Answer

A)  Undo 
B)  Cell Style 
C)  Bold 
D)  Increase Decimal 
A)  Undo 
B)  Cell Style 
C)  Bold 
D)  Increase Decimal

Question 5

Live preview is available on a touch screen.

Accepted Answer

A) True 
 B)False

Question 6

What effect does the Comma Style format have on the selected cells?

Accepted Answer

A)  Converts decimals to commas within a cell 
B)  Converts decimals to commas within merged cells 
C)  Displays cell contents with two decimal places and commas as thousands separators 
D)  Allows for substitution of selected characters 
A)  Converts decimals to commas within a cell 
B)  Converts decimals to commas within merged cells 
C)  Displays cell contents with two decimal places and commas as thousands separators 
D)  Allows for substitution of selected characters

Question 7

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 8

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 9

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

Accepted Answer

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

Question 10

Pressing the ____ keyboard shortcut key(s)selects cell A1.

Accepted Answer

A)  CTRL+HOME 
B)  CTRL+END 
C)  HOME 
D)  END 
A)  CTRL+HOME 
B)  CTRL+END 
C)  HOME 
D)  END

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A)  hard copy 
B)  column 
C)  validation 
D)  printout 
A)  hard copy 
B)  column 
C)  validation 
D)  printout

Question 13

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

Accepted Answer

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

Question 14

Case 1-2
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)  AutoComplete 
B)  AutoCalculate 
C)  AutoCorrect 
D)  Auto Fill 
A)  AutoComplete 
B)  AutoCalculate 
C)  AutoCorrect 
D)  Auto Fill

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

Worksheet ____________________ typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet.

Accepted Answer

The answer of Worksheet ____________________ typically contain descriptive information about...

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

Accepted Answer

A)  quotation mark (") 
B)  colon (:) 
C)  plus (+) 
D)  equal sign (=) 
A)  quotation mark (") 
B)  colon (:) 
C)  plus (+) 
D)  equal sign (=)

Question 20

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

Accepted Answer

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

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.

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

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

The ____ button allows you to erase recent cell entries.

Live preview is available on a touch screen.

What effect does the Comma Style format have on the selected cells?

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

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

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

Pressing the ____ keyboard shortcut key(s)selects cell A1.

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

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

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

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

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.

Worksheet ____________________ typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet.

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

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

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

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Filters

Exam 12: Excel: Creating a Worksheet and a Chart

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.

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

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

The ____ button allows you to erase recent cell entries.

Live preview is available on a touch screen.

What effect does the Comma Style format have on the selected cells?

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

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

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

Pressing the ____ keyboard shortcut key(s)selects cell A1.

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

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

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

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

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.

Worksheet ____________________ typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet.

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

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

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

Word: Creating, Formatting, and Editing a Word Document With a Picture

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Office 2013 and Windows 8: Essential Concepts and Skills

Office 365 Essentials

Introduction to Technology

Excel: Formulas, Functions, and Formatting

Excel: Working With Large Worksheets, Charting, and What-If Analysis

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Filters