Question 1

Following the insertion of a row,the Insert Options button lets you select from which of the following options?

Accepted Answer

A)  Format Same As Above 
B)  Undo Formatting 
C)  Format Same As Below 
D)  Clear Formatting 
A)  Format Same As Above 
B)  Undo Formatting 
C)  Format Same As Below 
D)  Clear Formatting

Question 2

When you first enter text,its angle is ____ degrees,and it reads from left to right in a cell.

Accepted Answer

A)  45 
B)  90 
C)  0 
D)  125 
A)  45 
B)  90 
C)  0 
D)  125

Question 3

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

Accepted Answer

SPARKLINE

Question 4

The syntax of the IF function is IF(logical_test),value_if_false,value_if_true).

Accepted Answer

A) True 
 B)False

Question 5

Many ribbon commands,galleries,and shortcut keys function as toggles or switches.

Accepted Answer

A) True 
 B)False

Question 6

Charts can either be embedded in a worksheet or placed in a separate ____.

Accepted Answer

A)  worksheet 
B)  dialog box 
C)  chart sheet 
D)  range 
A)  worksheet 
B)  dialog box 
C)  chart sheet 
D)  range

Question 7

Identify the letter of the choice that best matches the phrase or definition.
-The default option to fill an 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

Panes created using the vertical split bar scroll together horizontally.________________________

Accepted Answer

A) True 
 B)False

Question 9

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

Accepted Answer

A)  ENTER 
B)  ALT 
C)  CTRL 
D)  SHIFT 
A)  ENTER 
B)  ALT 
C)  CTRL 
D)  SHIFT

Question 10

To open the Format Cells dialog box with the Alignment sheet active,tap or click the Alignment Settings ____.

Accepted Answer

A)  button 
B)  check box 
C)  option button 
D)  Dialog Box Launcher 
A)  button 
B)  check box 
C)  option button 
D)  Dialog Box Launcher

Question 11

You can nest IF functions as deep as you want,but after you get beyond a nest of three IF functions,the logic becomes difficult to follow.

Accepted Answer

A) True 
 B)False

Question 12

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

Accepted Answer

A) True 
 B)False

Question 13

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is the path to the Insert Cells arrow?

Accepted Answer

Question 15

The range of entries that identifies the major groups for a clustered column chart are called the category names.

Accepted Answer

A) True 
 B)False

Question 16

Identify the letter of the choice that best matches the phrase or definition.
-Indicates a cell is using a name Excel does not recognize.

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 17

A(n)____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

Accepted Answer

The answer of A(n)____________________ cell reference instructs a paste operation...

Question 18

The NETWORKDAYS function checks a formula for correctness.

Accepted Answer

A) True 
 B)False

Question 19

Briefly discuss how Excel modifies cell references when copying and pasting formulas,including an explanation of absolute,relative,and mixed cell references.

Accepted Answer

Excel modifies cell references when copy

Question 20

The underline format underlines the entire cell,not just the characters in the cell.

Accepted Answer

A) True 
 B)False

Following the insertion of a row,the Insert Options button lets you select from which of the following options?

When you first enter text,its angle is ____ degrees,and it reads from left to right in a cell.

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

The syntax of the IF function is IF(logical_test),value_if_false,value_if_true).

Many ribbon commands,galleries,and shortcut keys function as toggles or switches.

Charts can either be embedded in a worksheet or placed in a separate ____.

Identify the letter of the choice that best matches the phrase or definition. -The default option to fill an area.

Panes created using the vertical split bar scroll together horizontally.________________________

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

To open the Format Cells dialog box with the Alignment sheet active,tap or click the Alignment Settings ____.

You can nest IF functions as deep as you want,but after you get beyond a nest of three IF functions,the logic becomes difficult to follow.

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Which of the following is the path to the Insert Cells arrow?

The range of entries that identifies the major groups for a clustered column chart are called the category names.

Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell is using a name Excel does not recognize.

A(n)____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

The NETWORKDAYS function checks a formula for correctness.

Briefly discuss how Excel modifies cell references when copying and pasting formulas,including an explanation of absolute,relative,and mixed cell references.

The underline format underlines the entire cell,not just the characters in the cell.

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

Following the insertion of a row,the Insert Options button lets you select from which of the following options?

When you first enter text,its angle is ____ degrees,and it reads from left to right in a cell.

You can specify the style and color for the parts of a sparkline chart by selecting a style in the Styles group on the ____________________.

The syntax of the IF function is IF(logical_test),value_if_false,value_if_true).

Many ribbon commands,galleries,and shortcut keys function as toggles or switches.

Charts can either be embedded in a worksheet or placed in a separate ____.

Identify the letter of the choice that best matches the phrase or definition. -The default option to fill an area.

Panes created using the vertical split bar scroll together horizontally.________________________

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

To open the Format Cells dialog box with the Alignment sheet active,tap or click the Alignment Settings ____.

You can nest IF functions as deep as you want,but after you get beyond a nest of three IF functions,the logic becomes difficult to follow.

Excel allows you to rotate text in a cell counterclockwise by entering a number between -1 degrees and -90 degrees.

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Which of the following is the path to the Insert Cells arrow?

The range of entries that identifies the major groups for a clustered column chart are called the category names.

Identify the letter of the choice that best matches the phrase or definition. -Indicates a cell is using a name Excel does not recognize.

A(n)____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

The NETWORKDAYS function checks a formula for correctness.

Briefly discuss how Excel modifies cell references when copying and pasting formulas,including an explanation of absolute,relative,and mixed cell references.

The underline format underlines the entire cell,not just the characters in the cell.

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