Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Explain what circular references,direct circular references,and indirect circular references are.

Accepted Answer

A formula in a cell that creates a refer

Question 4

Which of the following is the path to the Spelling button?

Accepted Answer

Question 5

Identify the letter of the choice that best matches the phrase or definition.
-A formula in a cell that contains a reference back to itself.

Accepted Answer

A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V 
A) ALT+ENTER 
B) order of operations 
C) circular reference 
D) MAX 
E) CTRL+C
F)CTRL+1
G)function
H)F7
I)CTRL+ACCENT MARK (`)
J)CTRL+V

Question 6

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

Accepted Answer

A) True 
 B)False

Question 7

When you decrease the row height to ____,the row is hidden.

Accepted Answer

A)  0 
B)  1 
C)  2 
D)  3 
A)  0 
B)  1 
C)  2 
D)  3

Question 8

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 9

Briefly discuss the order of operations.

Accepted Answer

When more than one arithmetic operator i

Question 10

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 11

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

Accepted Answer

A) True 
 B)False

Question 12

While holding down the ALT key,you can select nonadjacent ranges and cells._________________________

Accepted Answer

A) True 
 B)False

Question 13

____________________ colors jump out of a dark background and are easiest to see.

Accepted Answer

The answer of ____________________ colors jump out of a dark...

Question 14

Which of the following is the path to the Sum arrow?

Accepted Answer

Question 15

When Excel recognizes that you entered a date in mm/dd/yy format,it automatically formats the date as ____________________.

Accepted Answer

The answer of When Excel recognizes that you entered a...

Question 16

Moving from left to right,the first calculation in the order of operations is negation (-).

Accepted Answer

A) True 
 B)False

Question 17

To use ____________________ to verify that a formula contains the intended cell references,double-tap or double-click the cell with the formula you want to check.

Accepted Answer

The answer of To use ____________________ to verify that a...

Question 18

One of the reasons Excel is such a valuable tool is that you can assign a(n)____________________ to a cell,and Excel will calculate the result.

Accepted Answer

The answer of One of the reasons Excel is such...

Question 19

____________________ view shows the worksheet divided into pages.

Accepted Answer

The answer of ____________________ view shows the worksheet divided into...

Question 20

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Accepted Answer

A)  Normal 
B)  Page Layout 
C)  Page Break Preview 
D)  Full Screen 
A)  Normal 
B)  Page Layout 
C)  Page Break Preview 
D)  Full Screen

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

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

Explain what circular references,direct circular references,and indirect circular references are.

Which of the following is the path to the Spelling button?

Identify the letter of the choice that best matches the phrase or definition. -A formula in a cell that contains a reference back to itself.

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

When you decrease the row height to ____,the row is hidden.

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.

Briefly discuss the order of operations.

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

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

While holding down the ALT key,you can select nonadjacent ranges and cells._________________________

____________________ colors jump out of a dark background and are easiest to see.

Which of the following is the path to the Sum arrow?

When Excel recognizes that you entered a date in mm/dd/yy format,it automatically formats the date as ____________________.

Moving from left to right,the first calculation in the order of operations is negation (-).

To use ____________________ to verify that a formula contains the intended cell references,double-tap or double-click the cell with the formula you want to check.

One of the reasons Excel is such a valuable tool is that you can assign a(n)____________________ to a cell,and Excel will calculate the result.

____________________ view shows the worksheet divided into pages.

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

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: 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 13: Excel: Formulas, Functions, and Formatting

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

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

Explain what circular references,direct circular references,and indirect circular references are.

Which of the following is the path to the Spelling button?

Identify the letter of the choice that best matches the phrase or definition. -A formula in a cell that contains a reference back to itself.

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

When you decrease the row height to ____,the row is hidden.

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.

Briefly discuss the order of operations.

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

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

While holding down the ALT key,you can select nonadjacent ranges and cells._________________________

____________________ colors jump out of a dark background and are easiest to see.

Which of the following is the path to the Sum arrow?

When Excel recognizes that you entered a date in mm/dd/yy format,it automatically formats the date as ____________________.

Moving from left to right,the first calculation in the order of operations is negation (-).

To use ____________________ to verify that a formula contains the intended cell references,double-tap or double-click the cell with the formula you want to check.

One of the reasons Excel is such a valuable tool is that you can assign a(n)____________________ to a cell,and Excel will calculate the result.

____________________ view shows the worksheet divided into pages.

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

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: 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