Question 1

The largest value in a range can be found using the ________()function.

Accepted Answer

The answer of The largest value in a range can...

Question 2

Which of the following will get the smallest value from a range of cells?

Accepted Answer

A)  SUM 
B)  MIN() 
C)  AVERAGE() 
D)  MAX() 
A)  SUM 
B)  MIN() 
C)  AVERAGE() 
D)  MAX()

Question 3

Which of the following is an example of a constant?

Accepted Answer

A)  =SUM(B2:B3) 
B)  J7 
C)  SUM 
D)  3 
A)  =SUM(B2:B3) 
B)  J7 
C)  SUM 
D)  3

Question 4

Both cells and tables can have ________,which provide pre-built,reusable formatting.

Accepted Answer

A)  banding 
B)  constants 
C)  variables 
D)  styles 
A)  banding 
B)  constants 
C)  variables 
D)  styles

Question 5

Match between columns
                        Premises: argument
constant
parameter
variable
function

Accepted Answer

The Answer of a special value included in a worksheet is...

Question 6

The Format Painter will copy fonts,but not borders,fill colors,or alignment.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following is an example of a formula?

Accepted Answer

A)  =MIN(P2:Q4) 
B)  M11 
C)  57 
D)  COUNT 
A)  =MIN(P2:Q4) 
B)  M11 
C)  57 
D)  COUNT

Question 8

SUM(),COUNT(),AVERAGE(),MIN(),and MAX()are part of a special group of functions known as ________ functions.

Accepted Answer

The answer of SUM(),COUNT(),AVERAGE(),MIN(),and MAX()are part of a special group...

Question 9

Information presented in labeled rows and columns is said to be in ________ format.

Accepted Answer

The answer of Information presented in labeled rows and columns...

Question 10

Cell alignment refers solely to the horizontal alignment of a cell's content.

Accepted Answer

A) True 
 B)False

Question 11

An Excel cell that contains =SUM(A2:A5),SUM is an example of a(n)________.

Accepted Answer

The answer of An Excel cell that contains =SUM(A2:A5),SUM is...

Question 12

Information presented in charts is said to be in ________ format.

Accepted Answer

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

Question 13

The file extension for Adobe's file format that preserves exactly the look and feel of a document is ________.

Accepted Answer

The answer of The file extension for Adobe's file format...

Question 14

Portable Document Format (PDF)is the default file format for Excel spreadsheets.

Accepted Answer

A) True 
 B)False

Question 15

A chart is an example of information presented in ________ format.

Accepted Answer

The answer of A chart is an example of information...

Question 16

All formulas begin with the ________ sign.

Accepted Answer

The answer of All formulas begin with the ________ sign....

Question 17

Order of operations specifies which mathematical operations happen first.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is NOT closely associated with tables?

Accepted Answer

A)  total rows 
B)  charts 
C)  banding 
D)  caps 
A)  total rows 
B)  charts 
C)  banding 
D)  caps

Question 19

In the formula =3+5,the 3 and 5 are both examples of ________.

Accepted Answer

A)  constants 
B)  arguments 
C)  variables 
D)  parameters 
A)  constants 
B)  arguments 
C)  variables 
D)  parameters

Question 20

Which of the following is an example of a mathematical operator?

Accepted Answer

A)  $ 
B)  ^ 
C)  = 
D)  X 
A)  $ 
B)  ^ 
C)  = 
D)  X

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

The largest value in a range can be found using the ________()function.

Which of the following will get the smallest value from a range of cells?

Which of the following is an example of a constant?

Both cells and tables can have ________,which provide pre-built,reusable formatting.

The Format Painter will copy fonts,but not borders,fill colors,or alignment.

Which of the following is an example of a formula?

SUM(),COUNT(),AVERAGE(),MIN(),and MAX()are part of a special group of functions known as ________ functions.

Information presented in labeled rows and columns is said to be in ________ format.

Cell alignment refers solely to the horizontal alignment of a cell's content.

An Excel cell that contains =SUM(A2:A5),SUM is an example of a(n)________.

Information presented in charts is said to be in ________ format.

The file extension for Adobe's file format that preserves exactly the look and feel of a document is ________.

Portable Document Format (PDF)is the default file format for Excel spreadsheets.

A chart is an example of information presented in ________ format.

All formulas begin with the ________ sign.

Order of operations specifies which mathematical operations happen first.

Which of the following is NOT closely associated with tables?

In the formula =3+5,the 3 and 5 are both examples of ________.

Which of the following is an example of a mathematical operator?

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