Question 1

The formatting function pastes the formatting and the cell value from the Clipboard to a cell.

Accepted Answer

A) True 
 B)False

Question 2

What is the result of the following Excel formula?
=2(2+5)

Accepted Answer

A)  4 
B)  9 
C)  64 
D)  14 
A)  4 
B)  9 
C)  64 
D)  14

Question 3

Which of the following statements about cell alignment is FALSE?

Accepted Answer

A)  Most number, date, and time formats align right. 
B)  Most text formatting aligns right. 
C)  Cells can be aligned on the horizontal axis. 
D)  Cells can be aligned on the vertical axis. 
A)  Most number, date, and time formats align right. 
B)  Most text formatting aligns right. 
C)  Cells can be aligned on the horizontal axis. 
D)  Cells can be aligned on the vertical axis.

Question 4

MAX is an example of a function.

Accepted Answer

A) True 
 B)False

Question 5

C5 is an example of a cell ________.

Accepted Answer

The answer of C5 is an example of a cell...

Question 6

A(n)________ is a value that may potentially change over time and is stored in a cell and referenced in a formula.

Accepted Answer

The answer of A(n)________ is a value that may potentially...

Question 7

The AVERAGE()function returns the average of a range of cells.

Accepted Answer

A) True 
 B)False

Question 8

The A1:A3 in the formula below is a(n)________.
=SUM(A1:A3)

Accepted Answer

A)  parameter 
B)  constant 
C)  variable 
D)  argument 
A)  parameter 
B)  constant 
C)  variable 
D)  argument

Question 9

A series of numbers laid out in a spreadsheet is most consistent with a(n)________ format.

Accepted Answer

A)  tabular 
B)  oral 
C)  graphical 
D)  narrative 
A)  tabular 
B)  oral 
C)  graphical 
D)  narrative

Question 10

The background color of a cell is also known as the ________ color.

Accepted Answer

The answer of The background color of a cell is...

Question 11

Conditional formatting is when Excel changes the way information is displayed based on rules specific to the problem in the worksheet.

Accepted Answer

A) True 
 B)False

Question 12

The inclusion of an explicit value in a formula is known as ________.

Accepted Answer

The answer of The inclusion of an explicit value in...

Question 13

Rather than hard-code a value,it is considered good practice to use a(n)________ instead.

Accepted Answer

A)  function 
B)  parameter 
C)  constant 
D)  argument 
A)  function 
B)  parameter 
C)  constant 
D)  argument

Question 14

A function is a small program that performs operations on data.

Accepted Answer

A) True 
 B)False

Question 15

If cell J6 contains 14 and cell J7 contains 6,the ________()function would return 10 if applied to that range.

Accepted Answer

The answer of If cell J6 contains 14 and cell...

Question 16

An unchanging value such as 3.14 for Pi can also be called a(n)________.

Accepted Answer

The answer of An unchanging value such as 3.14 for...

Question 17

A relative cell reference will not change when copied.

Accepted Answer

A) True 
 B)False

Question 18

In the formula =E5,the value contained in E5 is known as a(n)________.

Accepted Answer

A)  constant 
B)  argument 
C)  parameter 
D)  variable 
A)  constant 
B)  argument 
C)  parameter 
D)  variable

Question 19

If a state's sales tax is stored in cell B2 and referenced in formulas,this value is known as a(n)________.

Accepted Answer

A)  variable 
B)  parameter 
C)  argument 
D)  constant 
A)  variable 
B)  parameter 
C)  argument 
D)  constant

Question 20

In the formula =J3+4,the value stored in cell J3 is known as a variable.

Accepted Answer

A) True 
 B)False

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

The formatting function pastes the formatting and the cell value from the Clipboard to a cell.

What is the result of the following Excel formula? =2(2+5)

Which of the following statements about cell alignment is FALSE?

MAX is an example of a function.

C5 is an example of a cell ________.

A(n)________ is a value that may potentially change over time and is stored in a cell and referenced in a formula.

The AVERAGE()function returns the average of a range of cells.

The A1:A3 in the formula below is a(n)________. =SUM(A1:A3)

A series of numbers laid out in a spreadsheet is most consistent with a(n)________ format.

The background color of a cell is also known as the ________ color.

Conditional formatting is when Excel changes the way information is displayed based on rules specific to the problem in the worksheet.

The inclusion of an explicit value in a formula is known as ________.

Rather than hard-code a value,it is considered good practice to use a(n)________ instead.

A function is a small program that performs operations on data.

If cell J6 contains 14 and cell J7 contains 6,the ________()function would return 10 if applied to that range.

An unchanging value such as 3.14 for Pi can also be called a(n)________.

A relative cell reference will not change when copied.

In the formula =E5,the value contained in E5 is known as a(n)________.

If a state's sales tax is stored in cell B2 and referenced in formulas,this value is known as a(n)________.

In the formula =J3+4,the value stored in cell J3 is known as a variable.

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