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 
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. 
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

An absolute reference gives the user the

Question 4

How does a user rename a worksheet tab?

Accepted Answer

If the user double clicks the

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 
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 
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. 
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 
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. 
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 
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)  (?) 
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

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.

Information Systems and You

Business Process Management and Decision Making

Productivity, innovation and Strategy

Hardware and Software

Database and Content Management

Networks and Collaboration

Competitive Advantage and Business Proces

Decision Making and Business Intelligence

E-Commerce, social Networking and Web 2.0

Acquiring Information Systems Through Projects

Structure, governance and Ethics

Managing Information Security and Privacy

Business Process Modeling: Techniques, Rules, and Applications

Database Design and Entity Relationships

Creating and Utilizing Forms, Queries, and Reports in MS Access

Understanding MS Project: Features and Functions

Filters

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.

Information Systems and You

Business Process Management and Decision Making

Productivity, innovation and Strategy

Hardware and Software

Database and Content Management

Networks and Collaboration

Competitive Advantage and Business Proces

Decision Making and Business Intelligence

E-Commerce, social Networking and Web 2.0

Acquiring Information Systems Through Projects

Structure, governance and Ethics

Managing Information Security and Privacy

Business Process Modeling: Techniques, Rules, and Applications

Database Design and Entity Relationships

Creating and Utilizing Forms, Queries, and Reports in MS Access

Understanding MS Project: Features and Functions

Filters