Question 1

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

Accepted Answer

A) True 
 B)False

Question 2

Cooler colors tend to pull away from the reader._________________________

Accepted Answer

A) True 
 B)False

Question 3

An asterisk (*)following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

Accepted Answer

A) True 
 B)False

Question 4

In designing a worksheet,visual aesthetics should come first._________________________

Accepted Answer

F
function

Question 5

A formula in a cell that contains a reference back to itself is called a(n)____________________.

Accepted Answer

The answer of A formula in a cell that contains...

Question 6

You can press the ____________________ key to quit Range Finder.

Accepted Answer

The answer of You can press the ____________________ key to...

Question 7

A ____ is a prewritten formula that is built into Excel.

Accepted Answer

A) function 
B) feature 
C) task 
D) calculation 
A) function 
B) feature 
C) task 
D) calculation

Question 8

You can click the ____ button to undo an automatic correction.

Accepted Answer

A) Auto Fill Options 
B) AutoCorrect Options 
C) Paste Options 
D) Trace Error 
A) Auto Fill Options 
B) AutoCorrect Options 
C) Paste Options 
D) Trace Error

Question 9

Clicking the Create Function box opens the Function Arguments dialog box.

Accepted Answer

A) True 
 B)False

Question 10

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.ALT+ENTER
f.CTRL+1
b.order of operations
g.function
c.circular reference
h.F7
d.MAX
i.CTRL+ACCENT MARK (`)
e.CTRL+C
j.CTRL+V
-Pastes a formula.

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

Question 11

Which of the following actions are provided by the Paste Options button?

Accepted Answer

A) Pastes an exact copy of what you copied including contents and formatting 
B) Pastes synonyms or acronyms 
C) Copy just formulas 
D) Copy just formatting 
A) Pastes an exact copy of what you copied including contents and formatting 
B) Pastes synonyms or acronyms 
C) Copy just formulas 
D) Copy just formatting

Question 12

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

Accepted Answer

A) Find Error 
B) Explain Error 
C) Fix Error 
D) Trace Error 
A) Find Error 
B) Explain Error 
C) Fix Error 
D) Trace Error

Question 13

When designing a worksheet,which steps should be taken to ensure that functional considerations supersede visual aesthetics?

Accepted Answer

A) Understanding the requirements document 
B) Identification of how to format various elements of the worksheet 
C) Avoiding the temptation to use flashy or confusing visual elements within the worksheet 
D) Choosing the proper functions and formulas 
A) Understanding the requirements document 
B) Identification of how to format various elements of the worksheet 
C) Avoiding the temptation to use flashy or confusing visual elements within the worksheet 
D) Choosing the proper functions and formulas

Question 14

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following Option buttons gives options for filling cells following a fill operation?

Accepted Answer

A) Auto Fill Options 
B) AutoCorrect Options 
C) Insert Options 
D) Paste Options 
A) Auto Fill Options 
B) AutoCorrect Options 
C) Insert Options 
D) Paste Options

Question 16

To select a number format,you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places,whether or not a dollar sign should be displayed,and how negative numbers should appear.

Accepted Answer

A) True 
 B)False

Question 17

If you do not assign a format to a cell or cells in a column,the column width will remain ____ characters.

Accepted Answer

A) 8.43 
B) 7.52 
C) 11.65 
D) 9.43 
A) 8.43 
B) 7.52 
C) 11.65 
D) 9.43

Question 18

The range automatically selected by Excel is always correct.

Accepted Answer

A) True 
 B)False

Question 19

You can choose from 12 categories of formats in the Format Cells dialog box._________________________

Accepted Answer

A) True 
 B)False

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.ALT+ENTER
f.CTRL+1
b.order of operations
g.function
c.circular reference
h.F7
d.MAX
i.CTRL+ACCENT MARK (`)
e.CTRL+C
j.CTRL+V
-Wraps text in a cell.

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

Cooler colors tend to pull away from the reader._________________________

An asterisk (*)following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

In designing a worksheet,visual aesthetics should come first._________________________

A formula in a cell that contains a reference back to itself is called a(n)____________________.

You can press the ____________________ key to quit Range Finder.

A ____ is a prewritten formula that is built into Excel.

You can click the ____ button to undo an automatic correction.

Clicking the Create Function box opens the Function Arguments dialog box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -Pastes a formula.

Which of the following actions are provided by the Paste Options button?

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

When designing a worksheet,which steps should be taken to ensure that functional considerations supersede visual aesthetics?

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Which of the following Option buttons gives options for filling cells following a fill operation?

To select a number format,you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places,whether or not a dollar sign should be displayed,and how negative numbers should appear.

If you do not assign a format to a cell or cells in a column,the column width will remain ____ characters.

The range automatically selected by Excel is always correct.

You can choose from 12 categories of formats in the Format Cells dialog box._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -Wraps text in a cell.

Introduction to Technology

Office 365 Essentials

Office 2013 and Windows 8 Essential Concepts and Skills

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Excel: Creating a Worksheet and a Chart

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

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

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

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

Filters

Exam 8: Excel: Formulas, Functions, and Formatting

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

Cooler colors tend to pull away from the reader._________________________

An asterisk (*)following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

In designing a worksheet,visual aesthetics should come first._________________________

A formula in a cell that contains a reference back to itself is called a(n)____________________.

You can press the ____________________ key to quit Range Finder.

A ____ is a prewritten formula that is built into Excel.

You can click the ____ button to undo an automatic correction.

Clicking the Create Function box opens the Function Arguments dialog box.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -Pastes a formula.

Which of the following actions are provided by the Paste Options button?

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

When designing a worksheet,which steps should be taken to ensure that functional considerations supersede visual aesthetics?

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

Which of the following Option buttons gives options for filling cells following a fill operation?

To select a number format,you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places,whether or not a dollar sign should be displayed,and how negative numbers should appear.

If you do not assign a format to a cell or cells in a column,the column width will remain ____ characters.

The range automatically selected by Excel is always correct.

You can choose from 12 categories of formats in the Format Cells dialog box._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -Wraps text in a cell.

Introduction to Technology

Office 365 Essentials

Office 2013 and Windows 8 Essential Concepts and Skills

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Excel: Creating a Worksheet and a Chart

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

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

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

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

Filters