Question 1

The ________ tool could be used to take an existing cell's format and apply it to other cells.

Accepted Answer

A)  Format Painter 
B)  Banding 
C)  Workbook Theme 
D)  Table Style 
A)  Format Painter 
B)  Banding 
C)  Workbook Theme 
D)  Table Style

Question 2

The ________ tool allows copying a source format from one cell or range to another cell or range of cells.

Accepted Answer

The answer of The ________ tool allows copying a source...

Question 3

The rule that determines the order that Excel processes calculations in a formula is known as the ________.

Accepted Answer

The answer of The rule that determines the order that...

Question 4

A small program that performs calculations on data is known as a(n)________.

Accepted Answer

The answer of A small program that performs calculations on...

Question 5

Which of the following statements about banding is FALSE?

Accepted Answer

A)  If a row or column is deleted from a table, the banding will be automatically updated. 
B)  Banding can be done manually. 
C)  Banding can be done for rows, but not for columns. 
D)  Banding can be used in tracking information. 
A)  If a row or column is deleted from a table, the banding will be automatically updated. 
B)  Banding can be done manually. 
C)  Banding can be done for rows, but not for columns. 
D)  Banding can be used in tracking information.

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Variables or values inside a function's parentheses are known as ________.

Accepted Answer

The answer of Variables or values inside a function's parentheses...

Question 8

The correct order of operations is:
Exponentiation and Parentheses
Multiplication and Division
Addition and Subtraction

Accepted Answer

A) True 
 B)False

Question 9

Match between columns
                        Premises: theme
Format Painter
default
table style
cell style

Accepted Answer

The Answer of allows formats to be copied from one is...

Question 10

A table is just another name for a worksheet.

Accepted Answer

A) True 
 B)False

Question 11

An Excel cell that contains =SUM(11,12,25),11,12,25 is an example of a(n)________.

Accepted Answer

The answer of An Excel cell that contains =SUM(11,12,25),11,12,25 is...

Question 12

The more than 400 functions that come as part of Excel are known as ________ functions.

Accepted Answer

The answer of The more than 400 functions that come...

Question 13

________ allows the specification of rules that apply formatting to a cell as determined by the rule outcome.

Accepted Answer

Conditiona

Question 14

If a formula contains the relative cell reference J7 and the formula is copied to a cell two rows down and one row to the right,the reference will become K9.

Accepted Answer

A) True 
 B)False

Question 15

Negative numbers can be displayed in different colors and different formats.

Accepted Answer

A) True 
 B)False

Question 16

A value in a cell that is referenced in a formula or function is known as a variable.

Accepted Answer

A) True 
 B)False

Question 17

Cell content can be rotated by changing the cell's orientation.

Accepted Answer

A) True 
 B)False

Question 18

Conditional formatting is when Excel automatically changes a formula within a cell based on parameters assigned to that cell.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following has the highest priority per order of operations?

Accepted Answer

A)  parentheses 
B)  exponentiation 
C)  division 
D)  addition 
A)  parentheses 
B)  exponentiation 
C)  division 
D)  addition

Question 20

Which of the following does the Format Painter NOT copy?

Accepted Answer

A)  alignment 
B)  font colors 
C)  cell contents 
D)  borders 
A)  alignment 
B)  font colors 
C)  cell contents 
D)  borders

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

The ________ tool could be used to take an existing cell's format and apply it to other cells.

The ________ tool allows copying a source format from one cell or range to another cell or range of cells.

The rule that determines the order that Excel processes calculations in a formula is known as the ________.

A small program that performs calculations on data is known as a(n)________.

Which of the following statements about banding is FALSE?

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

Variables or values inside a function's parentheses are known as ________.

The correct order of operations is: Exponentiation and Parentheses Multiplication and Division Addition and Subtraction

A table is just another name for a worksheet.

An Excel cell that contains =SUM(11,12,25),11,12,25 is an example of a(n)________.

The more than 400 functions that come as part of Excel are known as ________ functions.

________ allows the specification of rules that apply formatting to a cell as determined by the rule outcome.

If a formula contains the relative cell reference J7 and the formula is copied to a cell two rows down and one row to the right,the reference will become K9.

Negative numbers can be displayed in different colors and different formats.

A value in a cell that is referenced in a formula or function is known as a variable.

Cell content can be rotated by changing the cell's orientation.

Conditional formatting is when Excel automatically changes a formula within a cell based on parameters assigned to that cell.

Which of the following has the highest priority per order of operations?

Which of the following does the Format Painter NOT copy?

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