Question 1

The following is a function:=B2*B5

Accepted Answer

A) True 
 B)False

Question 2

A cell reference that changes when copied is known as a(n)________ cell reference.

Accepted Answer

The answer of A cell reference that changes when copied...

Question 3

A table with odd rows in one color and even rows in another color are said to have ________ rows.

Accepted Answer

A)  tabular 
B)  banded 
C)  hard-coded 
D)  constant 
A)  tabular 
B)  banded 
C)  hard-coded 
D)  constant

Question 4

Formulas can be copied to the Clipboard and then copied to other locations in a workbook.

Accepted Answer

A) True 
 B)False

Question 5

If all cell content in a worksheet is lined up along the left side of a cell,it has a left cell ________.

Accepted Answer

A)  constant 
B)  alignment 
C)  justification 
D)  argument 
A)  constant 
B)  alignment 
C)  justification 
D)  argument

Question 6

Banding refers to ________.

Accepted Answer

A)  adding a total row to a table 
B)  alternating the background color of rows and/or columns 
C)  adding a chart to a table 
D)  taking a format from one table and copying it to another table 
A)  adding a total row to a table 
B)  alternating the background color of rows and/or columns 
C)  adding a chart to a table 
D)  taking a format from one table and copying it to another table

Question 7

One function can have multiple arguments.

Accepted Answer

A) True 
 B)False

Question 8

The equal sign (=)is an example of a mathematical operator.

Accepted Answer

A) True 
 B)False

Question 9

The theme that is automatically applied unless you specify otherwise is known as the ________ workbook theme.

Accepted Answer

The answer of The theme that is automatically applied unless...

Question 10

A collection of built-in cell styles given a name is known as a workbook ________.

Accepted Answer

The answer of A collection of built-in cell styles given...

Question 11

Pi is one example of a value well-suited to being a parameter.

Accepted Answer

A) True 
 B)False

Question 12

The formula below contains a hard-coded value:
=J3*SUM(A1:A2)

Accepted Answer

A) True 
 B)False

Question 13

The COUNT()function will return the total number of cells in a range,regardless of value.

Accepted Answer

A) True 
 B)False

The following is a function:=B2*B5

A cell reference that changes when copied is known as a(n)________ cell reference.

A table with odd rows in one color and even rows in another color are said to have ________ rows.

Formulas can be copied to the Clipboard and then copied to other locations in a workbook.

If all cell content in a worksheet is lined up along the left side of a cell,it has a left cell ________.

Banding refers to ________.

One function can have multiple arguments.

The equal sign (=)is an example of a mathematical operator.

The theme that is automatically applied unless you specify otherwise is known as the ________ workbook theme.

A collection of built-in cell styles given a name is known as a workbook ________.

Pi is one example of a value well-suited to being a parameter.

The formula below contains a hard-coded value: =J3*SUM(A1:A2)

The COUNT()function will return the total number of cells in a range,regardless of value.

Integrated Projects, workshop 1: Integrating Word and Excel

Integrated Projects, workshop 2: Integrating Word, excel, and Access

Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Integrated Projects, workshop 4: Integrating Word, powerpoint, access, excel, and Outlook

Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

Microsoft Access 2010,workshop 2: Gathering Data Into a Database

Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010

Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

Microsoft Excel 2010,workshop 4: Using Charts

Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks

Microsoft Powerpoint 2010 workshop 1: Communicating With Presentations

Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics

Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia

Microsoft Powerpoint 2010, workshop 4: Customizing, Collaborating, and Presenting

Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document

Microsoft Word 2010,workshop 2: Creating and Editing a Document

Microsoft Word 2010,workshop 3: Including Tables and Objects

Microsoft Word 2010,workshop 4: Formatting Special Documents and Using Mail Merge

Appendix: Microsoft Windows 8: Understanding the Windows 8 Interface

Common Features,workshop 1: Understanding the Common Features of Microsoft Office

Windows 7, workshop 1: Understanding the Windows 7 Desktop and Managing Windows

Filters

Exam 10: Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

The following is a function:=B2*B5

A cell reference that changes when copied is known as a(n)________ cell reference.

A table with odd rows in one color and even rows in another color are said to have ________ rows.

Formulas can be copied to the Clipboard and then copied to other locations in a workbook.

If all cell content in a worksheet is lined up along the left side of a cell,it has a left cell ________.

Banding refers to ________.

One function can have multiple arguments.

The equal sign (=)is an example of a mathematical operator.

The theme that is automatically applied unless you specify otherwise is known as the ________ workbook theme.

A collection of built-in cell styles given a name is known as a workbook ________.

Pi is one example of a value well-suited to being a parameter.

The formula below contains a hard-coded value: =J3*SUM(A1:A2)

The COUNT()function will return the total number of cells in a range,regardless of value.

Integrated Projects, workshop 1: Integrating Word and Excel

Integrated Projects, workshop 2: Integrating Word, excel, and Access

Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Integrated Projects, workshop 4: Integrating Word, powerpoint, access, excel, and Outlook

Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

Microsoft Access 2010,workshop 2: Gathering Data Into a Database

Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010

Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

Microsoft Excel 2010,workshop 4: Using Charts

Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks

Microsoft Powerpoint 2010 workshop 1: Communicating With Presentations

Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics

Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia

Microsoft Powerpoint 2010, workshop 4: Customizing, Collaborating, and Presenting

Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document

Microsoft Word 2010,workshop 2: Creating and Editing a Document

Microsoft Word 2010,workshop 3: Including Tables and Objects

Microsoft Word 2010,workshop 4: Formatting Special Documents and Using Mail Merge

Appendix: Microsoft Windows 8: Understanding the Windows 8 Interface

Common Features,workshop 1: Understanding the Common Features of Microsoft Office

Windows 7, workshop 1: Understanding the Windows 7 Desktop and Managing Windows

Filters