Question 1

To place a graph on your spreadsheet you would use the ________ tab.

Accepted Answer

A)  View 
B)  Page Layout 
C)  Home 
D)  Insert 
E)  Data

Question 2

A cell is identified by using a

Accepted Answer

A)  column number and a row number. 
B)  column letter and a row number. 
C)  position number. 
D)  column letter and a row letter. 
E)  column number and a row letter.

Question 3

Why are absolute references important in Excel?

Accepted Answer

The answer of Why are absolute references important in Excel?...

Question 4

How does a user rename a worksheet tab?

Accepted Answer

The answer of How does a user rename a worksheet...

Question 5

A relative reference keeps the relative positions of the formula and the cells it references ________.

Accepted Answer

A)  synchronized 
B)  intact 
C)  absolute 
D)  asynchronous 
E)  referred to

Question 6

Formatting options are shown on the Home tab ribbon.

Accepted Answer

A) True 
 B)False

Question 7

You can use the ________ key to cycle through the various types of cell addressing.

Accepted Answer

A)  F8 
B)  F10 
C)  F4 
D)  F2 
E)  F5

Question 8

"G$4" is an example of a(n)

Accepted Answer

A)  absolute column reference. 
B)  relative row reference. 
C)  absolute row reference. 
D)  intact column reference. 
E)  intact row reference.

Question 9

"C8" is an absolute reference.

Accepted Answer

A) True 
 B)False

Question 10

Another way of creating an absolute cell address is to use a(n)______.

Accepted Answer

A)  absolute name 
B)  range name 
C)  cell reference 
D)  range reference 
E)  cell location

Question 11

Text can be used in arithmetic formulas.

Accepted Answer

A) True 
 B)False

Question 12

"/" is the sign used for multiplication.

Accepted Answer

A) True 
 B)False

Question 13

"$G4" is an example of a(n)

Accepted Answer

A)  absolute column reference. 
B)  intact column reference. 
C)  absolute row reference. 
D)  relative column reference. 
E)  intact row reference.

Question 14

Workbooks are made up of multiple pages called ____________.

Accepted Answer

A)  text 
B)  arithmetic symbols 
C)  formulas 
D)  numbers 
E)  worksheets

Question 15

Cells are identified by their column letters and row numbers.

Accepted Answer

A) True 
 B)False

Question 16

Excel provides powerful graphing capabilities.

Accepted Answer

A) True 
 B)False

Question 17

To make a reference absolute you place ________ signs in front of the column letter and row number.

Accepted Answer

A)  + 
B)  $ 
C)  ! 
D)  % 
E)  (?)

Question 18

When you build a formula it must begin with an "=".

Accepted Answer

A) True 
 B)False

Question 19

Formatting cells allows the user to better see the type of data that is in a cell.

Accepted Answer

A) True 
 B)False

Exam 14: Excel Basics: Understanding Spreadsheets, Cells, and Formulas

To place a graph on your spreadsheet you would use the ________ tab.

A cell is identified by using a

Why are absolute references important in Excel?

How does a user rename a worksheet tab?

A relative reference keeps the relative positions of the formula and the cells it references ________.

Formatting options are shown on the Home tab ribbon.

You can use the ________ key to cycle through the various types of cell addressing.

"G$4" is an example of a(n)

"C8" is an absolute reference.

Another way of creating an absolute cell address is to use a(n) ______.

Text can be used in arithmetic formulas.

"/" is the sign used for multiplication.

"$G4" is an example of a(n)

Workbooks are made up of multiple pages called ____________.

Cells are identified by their column letters and row numbers.

Excel provides powerful graphing capabilities.

To make a reference absolute you place ________ signs in front of the column letter and row number.

When you build a formula it must begin with an "=".

Formatting cells allows the user to better see the type of data that is in a cell.