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

Question 3

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

Accepted Answer

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

Question 5

"AD" is an example of a ____.

Accepted Answer

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

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

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 + `

Exam 1: Getting Started With Excel