Question 1

A ____________________ provides a visual representation of spreadsheet data.

Accepted Answer

The answer of A ____________________ provides a visual representation of...

Question 2

The intersection of a row and column is known as a ____.

Accepted Answer

A)  cell 
B)  range 
C)  reference 
D)  border 
A)  cell 
B)  range 
C)  reference 
D)  border

Question 3

Excel provides the ability to create new worksheets and new ____ sheets

Accepted Answer

A)  documentation 
B)  chart 
C)  workbook 
D)  reference 
A)  documentation 
B)  chart 
C)  workbook 
D)  reference

Question 4

The Undo and Redo buttons are found on the ____.

Accepted Answer

A)  formula bar 
B)  Quick Access Toolbar 
C)  Clipboard group 
D)  Office Button 
A)  formula bar 
B)  Quick Access Toolbar 
C)  Clipboard group 
D)  Office Button

Question 5

"AD" is an example of a ____.

Accepted Answer

A)  column heading 
B)  row heading 
C)  cell reference 
D)  Name box 
A)  column heading 
B)  row heading 
C)  cell reference 
D)  Name box

Question 6

An Excel formula always begins with a(n)____.

Accepted Answer

A)  parentheses 
B)  equals sign 
C)  plus sign 
D)  colon 
A)  parentheses 
B)  equals sign 
C)  plus sign 
D)  colon

Question 7

A(n)nonadjacent range is comprised of two or more distinct adjacent ranges._________________________

Accepted Answer

A) True 
 B)False

Question 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Displays the cell reference of the active cell

Accepted Answer

A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs 
A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs

Question 9

Charts can be embedded into worksheets.

Accepted Answer

A) True 
 B)False

Question 10

From formula view,press ____ to switch the worksheet back to Normal view.

Accepted Answer

A) Ctrl + > B) Ctrl + < C) Ctrl + ? D) Ctrl + ` A) Ctrl + > B) Ctrl + < C) Ctrl + ? D) Ctrl + `

A ____________________ provides a visual representation of spreadsheet data.

The intersection of a row and column is known as a ____.

Excel provides the ability to create new worksheets and new ____ sheets

The Undo and Redo buttons are found on the ____.

"AD" is an example of a ____.

An Excel formula always begins with a(n)____.

A(n)nonadjacent range is comprised of two or more distinct adjacent ranges._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the cell reference of the active cell

Charts can be embedded into worksheets.

From formula view,press ____ to switch the worksheet back to Normal view.

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 1: Getting Started With Excel

A ____________________ provides a visual representation of spreadsheet data.

The intersection of a row and column is known as a ____.

Excel provides the ability to create new worksheets and new ____ sheets

The Undo and Redo buttons are found on the ____.

"AD" is an example of a ____.

An Excel formula always begins with a(n)____.

A(n)nonadjacent range is comprised of two or more distinct adjacent ranges._________________________

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the cell reference of the active cell

Charts can be embedded into worksheets.

From formula view,press ____ to switch the worksheet back to Normal view.

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters