Question 1

Approximately ________ of men of European descent are color-blind.

Accepted Answer

A)  3% - 6% 
B)  10% - 12% 
C)  8% - 12% 
D)  10% - 15% 
A)  3% - 6% 
B)  10% - 12% 
C)  8% - 12% 
D)  10% - 15% C

Question 2

To modify the border of a cell or cells,click the Borders button in the ________ group of the Home tab.

Accepted Answer

A)  Font 
B)  Paragraph 
C)  Styles 
D)  Editing 
A)  Font 
B)  Paragraph 
C)  Styles 
D)  Editing A

Question 3

Excel presents information graphically via charts and graphs based on the tabular information in worksheets.

Accepted Answer

A) True 
 B)False  True

Question 4

Documentation is an important part of building a good worksheet.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is NOT true about working with formulas?

Accepted Answer

A)  In Excel, formulas always begin with an equal sign. 
B)  When a formula that contains cell references is copied to another cell, the cell reference will change to reflect the destination cell relative to the original cell. 
C)  To copy a formula and not change relative references, select the formula in the formula bar, click Shift + Esc, select the destination cell, and then click Insert. 
D)  Cells that contain formulas can be treated like any other worksheet cell. 
A)  In Excel, formulas always begin with an equal sign. 
B)  When a formula that contains cell references is copied to another cell, the cell reference will change to reflect the destination cell relative to the original cell. 
C)  To copy a formula and not change relative references, select the formula in the formula bar, click Shift + Esc, select the destination cell, and then click Insert. 
D)  Cells that contain formulas can be treated like any other worksheet cell.

Question 6

Match between columns
                        Premises: Fill color
Graphical format
Cell alignment
Default
Tabular format

Accepted Answer

The Answer of A setting that is automatically in place is...

Question 7

A(n)________ is a collection of fonts,styles,colors,and effects applied to a worksheet.

Accepted Answer

The answer of A(n)________ is a collection of fonts,styles,colors,and effects...

Question 8

There are more than ________ functions built into Excel.

Accepted Answer

The answer of There are more than ________ functions built...

Question 9

A(n)________ performs a mathematical calculation using information in the active worksheet and other worksheets to calculate new values.

Accepted Answer

The answer of A(n)________ performs a mathematical calculation using information...

Question 10

There are ________ types of cell alignment in Excel.

Accepted Answer

A)  six 
B)  seven 
C)  four 
D)  nine 
A)  six 
B)  seven 
C)  four 
D)  nine

Question 11

The ________ function is used to find the mean value for a range of cells.

Accepted Answer

The answer of The ________ function is used to find...

Question 12

Which of the following is NOT true about formatting worksheets?

Accepted Answer

A)  Background colors should be bright colors. 
B)  Use color only to assist in readability, categorization, or identification purposes. 
C)  Format for a reason, not just for appearances. 
D)  Special characters such as the dollar sign should be applied only as necessary. 
A)  Background colors should be bright colors. 
B)  Use color only to assist in readability, categorization, or identification purposes. 
C)  Format for a reason, not just for appearances. 
D)  Special characters such as the dollar sign should be applied only as necessary.

Question 13

Approximately 6% to 10% of men of Asian descent are color-blind.

Accepted Answer

A) True 
 B)False

Question 14

To paint a format to more than one nonadjacent cell,you can double-click Format Painter and then select nonadjacent cells.

Accepted Answer

A) True 
 B)False

Question 15

The Accounting Number Format is formatted so the currency symbol is placed directly left of the value.

Accepted Answer

A) True 
 B)False

Question 16

________ can set the font,font size and color,number format,background color,borders,and alignment.

Accepted Answer

A)  A built-in function 
B)  Banding 
C)  A built-in cell style 
D)  The fill color 
A)  A built-in function 
B)  Banding 
C)  A built-in cell style 
D)  The fill color

Question 17

Cell banding allows cell content to be arranged horizontally as well as vertically.

Accepted Answer

A) True 
 B)False

Question 18

If you want to see which employee had the highest sale,you could use the ________ function.

Accepted Answer

A)  COUNT 
B)  SUM 
C)  MIN 
D)  MAX 
A)  COUNT 
B)  SUM 
C)  MIN 
D)  MAX

Question 19

Match between columns
                        Premises: Number
Accounting
Comma
Currency
General

Accepted Answer

The Answer of ($1,234.00) and (1,234.00) and -1234 and $ is...

Question 20

When you filter table data,the ________ values will automatically be recalculated.

Accepted Answer

The answer of When you filter table data,the ________ values...

Approximately ________ of men of European descent are color-blind.

To modify the border of a cell or cells,click the Borders button in the ________ group of the Home tab.

Excel presents information graphically via charts and graphs based on the tabular information in worksheets.

Documentation is an important part of building a good worksheet.

Which of the following is NOT true about working with formulas?

A(n)________ is a collection of fonts,styles,colors,and effects applied to a worksheet.

There are more than ________ functions built into Excel.

A(n)________ performs a mathematical calculation using information in the active worksheet and other worksheets to calculate new values.

There are ________ types of cell alignment in Excel.

The ________ function is used to find the mean value for a range of cells.

Which of the following is NOT true about formatting worksheets?

Approximately 6% to 10% of men of Asian descent are color-blind.

To paint a format to more than one nonadjacent cell,you can double-click Format Painter and then select nonadjacent cells.

The Accounting Number Format is formatted so the currency symbol is placed directly left of the value.

________ can set the font,font size and color,number format,background color,borders,and alignment.

Cell banding allows cell content to be arranged horizontally as well as vertically.

If you want to see which employee had the highest sale,you could use the ________ function.

When you filter table data,the ________ values will automatically be recalculated.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Cell References, Named Ranges, and Functions

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters

Exam 8: Formats, Functions, and Formulas

Approximately ________ of men of European descent are color-blind.

To modify the border of a cell or cells,click the Borders button in the ________ group of the Home tab.

Excel presents information graphically via charts and graphs based on the tabular information in worksheets.

Documentation is an important part of building a good worksheet.

Which of the following is NOT true about working with formulas?

A(n)________ is a collection of fonts,styles,colors,and effects applied to a worksheet.

There are more than ________ functions built into Excel.

A(n)________ performs a mathematical calculation using information in the active worksheet and other worksheets to calculate new values.

There are ________ types of cell alignment in Excel.

The ________ function is used to find the mean value for a range of cells.

Which of the following is NOT true about formatting worksheets?

Approximately 6% to 10% of men of Asian descent are color-blind.

To paint a format to more than one nonadjacent cell,you can double-click Format Painter and then select nonadjacent cells.

The Accounting Number Format is formatted so the currency symbol is placed directly left of the value.

________ can set the font,font size and color,number format,background color,borders,and alignment.

Cell banding allows cell content to be arranged horizontally as well as vertically.

If you want to see which employee had the highest sale,you could use the ________ function.

When you filter table data,the ________ values will automatically be recalculated.

Understanding the Common Features of Microsoft Office

Explore Windows and File Management

Review and Modify a Document

Create and Edit a Document

Include Tables and Objects

Special Document Formatting and Mail Merge

Create, Navigate, Work With, and Print Worksheets

Cell References, Named Ranges, and Functions

Effective Charts

The Four Main Database Objects

Tables,Keys,and Relationships

Queries and Data Access

Using Forms and Reports in Access

Presentation Fundamentals

Text and Graphics

Multimedia and Motion

Customization and Collaboration

Filters