Question 1

You can create your own ____________________ fill sequences for use with the fill handle.

Accepted Answer

The answer of You can create your own ____________________ fill...

Question 2

-In the accompanying figure,the split double arrow mouse pointer ____.

Accepted Answer

A)  indicates a hidden column 
B)  allows text to be entered at that location 
C)  is the result of moving the mouse pointer to the boundary between column heading A and column heading B 
D)  indicates the proposed width of column A 
A)  indicates a hidden column 
B)  allows text to be entered at that location 
C)  is the result of moving the mouse pointer to the boundary between column heading A and column heading B 
D)  indicates the proposed width of column A

Question 3

When the Paste Options button is visible,you can use ____________________ to access the paste commands available in the Paste Options gallery.

Accepted Answer

The answer of When the Paste Options button is visible,you...

Question 4

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it,for example.

Accepted Answer

A)  Alignment 
B)  Left and Right 
C)  Center 
D)  Position 
A)  Alignment 
B)  Left and Right 
C)  Center 
D)  Position

Question 5

You can press the ____ keys to open the Format Cells dialog box.

Accepted Answer

A)  CTRL+1 
B)  CTRL+2 
C)  CTRL+3 
D)  CTRL+4 
A)  CTRL+1 
B)  CTRL+2 
C)  CTRL+3 
D)  CTRL+4

Question 6

Using the mouse to move or copy cells is called ____.

Accepted Answer

A)  drop and drag 
B)  drag and drop 
C)  drag and copy 
D)  drag and paste 
A)  drop and drag 
B)  drag and drop 
C)  drag and copy 
D)  drag and paste

Question 7

Identify the letter of the choice that best matches the phrase or definition.
-Pastes the contents,format,and styles of the source area.

Accepted Answer

A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing 
A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Question 8

Identify the letter of the choice that best matches the phrase or definition.
-Keeps a cell reference constant when copying a formula or function.

Accepted Answer

A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing 
A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Question 9

Identify the letter of the choice that best matches the phrase or definition.
-Assigns a value to a cell based on a logical test.

Accepted Answer

A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing 
A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Question 10

Identify the letter of the choice that best matches the phrase or definition.
-Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.

Accepted Answer

A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing 
A) NOW function 
B) Fill Formatting Only 
C) goal seeking 
D) what-if analysis 
E) NUM!
F)#NAME?
G)Keep Source Formatting
H)Fill Series
I)IF function
J)absolute cell referencing

Question 11

When working with a large worksheet,you can split the window into ____ panes.

Accepted Answer

A)  three or four 
B)  four or five 
C)  two or six 
D)  two or four 
A)  three or four 
B)  four or five 
C)  two or six 
D)  two or four

Question 12

The path to the Logical button is (FORMULAS tab | Function Library group).

Accepted Answer

A) True 
 B)False

Question 13

Cell references in a formula are called ____.

Accepted Answer

A)  assumptions 
B)  comments 
C)  numbers 
D)  content 
A)  assumptions 
B)  comments 
C)  numbers 
D)  content

Question 14

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

Accepted Answer

A)  Goal 
B)  Formula 
C)  Option 
D)  Function 
A)  Goal 
B)  Formula 
C)  Option 
D)  Function

Question 15

The <= comparison operator means less than or equal to.

Accepted Answer

A) True 
 B)False

Question 16

The Copy button copies the contents and format of the source area to the Office ____,a temporary storage area in the computer's memory.

Accepted Answer

A)  Ribbon 
B)  Clipboard 
C)  Folder 
D)  File 
A)  Ribbon 
B)  Clipboard 
C)  Folder 
D)  File

Question 17

Which of the following is an extension of the fill pattern Sunday,Tuesday?

Accepted Answer

A)  Wednesday,Thursday,Saturday 
B)  Thursday,Saturday,Monday 
C)  Saturday,Sunday,Monday 
D)  Monday,Wednesday,Friday 
A)  Wednesday,Thursday,Saturday 
B)  Thursday,Saturday,Monday 
C)  Saturday,Sunday,Monday 
D)  Monday,Wednesday,Friday

Question 18

When you change a value on which a chart is dependent,Excel immediately ____________________ the chart.

Accepted Answer

The answer of When you change a value on which...

Question 19

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

Accepted Answer

The answer of ____________________ is the default option that Excel...

Question 20

Rotated text allows you to fit more text into a smaller column width.

Accepted Answer

A) True 
 B)False

You can create your own ____________________ fill sequences for use with the fill handle.

-In the accompanying figure,the split double arrow mouse pointer ____.

When the Paste Options button is visible,you can use ____________________ to access the paste commands available in the Paste Options gallery.

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it,for example.

You can press the ____ keys to open the Format Cells dialog box.

Using the mouse to move or copy cells is called ____.

Identify the letter of the choice that best matches the phrase or definition. -Pastes the contents,format,and styles of the source area.

Identify the letter of the choice that best matches the phrase or definition. -Keeps a cell reference constant when copying a formula or function.

Identify the letter of the choice that best matches the phrase or definition. -Assigns a value to a cell based on a logical test.

Identify the letter of the choice that best matches the phrase or definition. -Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.

When working with a large worksheet,you can split the window into ____ panes.

The path to the Logical button is (FORMULAS tab | Function Library group).

Cell references in a formula are called ____.

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

The <= comparison operator means less than or equal to.

The Copy button copies the contents and format of the source area to the Office ____,a temporary storage area in the computer's memory.

Which of the following is an extension of the fill pattern Sunday,Tuesday?

When you change a value on which a chart is dependent,Excel immediately ____________________ the chart.

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

Rotated text allows you to fit more text into a smaller column width.

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: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Filters

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

You can create your own ____________________ fill sequences for use with the fill handle.

-In the accompanying figure,the split double arrow mouse pointer ____.

When the Paste Options button is visible,you can use ____________________ to access the paste commands available in the Paste Options gallery.

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it,for example.

You can press the ____ keys to open the Format Cells dialog box.

Using the mouse to move or copy cells is called ____.

Identify the letter of the choice that best matches the phrase or definition. -Pastes the contents,format,and styles of the source area.

Identify the letter of the choice that best matches the phrase or definition. -Keeps a cell reference constant when copying a formula or function.

Identify the letter of the choice that best matches the phrase or definition. -Assigns a value to a cell based on a logical test.

Identify the letter of the choice that best matches the phrase or definition. -Scrutinizes the impact of changing values in cells that are referenced by a formula in another cell.

When working with a large worksheet,you can split the window into ____ panes.

The path to the Logical button is (FORMULAS tab | Function Library group).

Cell references in a formula are called ____.

____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

The <= comparison operator means less than or equal to.

The Copy button copies the contents and format of the source area to the Office ____,a temporary storage area in the computer's memory.

Which of the following is an extension of the fill pattern Sunday,Tuesday?

When you change a value on which a chart is dependent,Excel immediately ____________________ the chart.

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

Rotated text allows you to fit more text into a smaller column width.

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: Creating a Worksheet and a Chart

Excel: Formulas, Functions, and Formatting

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Filters