Question 1

To increase a cells value by 10%,it is best to reference the cell with a value of 10% in the formula.

Accepted Answer

A) True 
 B)False  True

Question 2

You can format your worksheet using icons on the ________ tab.

Accepted Answer

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

Question 3

"2B" would be a cell reference.

Accepted Answer

A) True 
 B)False  False

Question 4

Today the term spreadsheet almost always refers to electronic models.

Accepted Answer

A) True 
 B)False

Question 5

$B$4 is an example of a(n)

Accepted Answer

A)  synchronous reference. 
B)  fixed reference. 
C)  asynchronous reference 
D)  relative reference. 
E)  absolute reference. 
A)  synchronous reference. 
B)  fixed reference. 
C)  asynchronous reference 
D)  relative reference. 
E)  absolute reference.

Question 6

During the "fill" function when you move the mouse over top of the handle on the cell the mouse icon changes to a(n)

Accepted Answer

A)  + sign. 
B)  * sign. 
C)  (?) sign. 
D)  ! sign. 
E)  - sign. 
A)  + sign. 
B)  * sign. 
C)  (?) sign. 
D)  ! sign. 
E)  - sign.

Question 7

Describe how you would enter a new formula that adds the value of two cells into and Excel spreadsheet.

Accepted Answer

You would first click on the cell that t

Question 8

When there are two formulas to choose from to type into a cell,choose the formula that is ________.

Accepted Answer

A)  easier to enter 
B)  more correct 
C)  longer 
D)  flexible 
E)  shorter 
A)  easier to enter 
B)  more correct 
C)  longer 
D)  flexible 
E)  shorter

Question 9

The ________ key allows you to edit a cell's content.

Accepted Answer

A)  F4 
B)  F2 
C)  F5 
D)  F1 
E)  F3 
A)  F4 
B)  F2 
C)  F5 
D)  F1 
E)  F3

Question 10

If you need to sort and filter data you would use tools on the ________ tab.

Accepted Answer

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

Question 11

The first thing a user should do once they start to work within an Excel file is to

Accepted Answer

A)  save the workbook. 
B)  create a new worksheet. 
C)  add text. 
D)  create the model. 
E)  add formulas. 
A)  save the workbook. 
B)  create a new worksheet. 
C)  add text. 
D)  create the model. 
E)  add formulas.

Question 12

The flexibility of cells is an important factor in making a spreadsheet a powerful tool.

Accepted Answer

A) True 
 B)False

Question 13

The "Fill" capability in Excel can create more formulas with less work.

Accepted Answer

A) True 
 B)False

Question 14

Before the advent of computers accountants used paper spreadsheets.

Accepted Answer

A) True 
 B)False

Question 15

If you want to apply the same "growth rate" to a number of formulas in different cells you would use a(n)

Accepted Answer

A)  asynchronous reference. 
B)  absolute reference. 
C)  intact reference. 
D)  relative reference. 
E)  synchronous reference 
A)  asynchronous reference. 
B)  absolute reference. 
C)  intact reference. 
D)  relative reference. 
E)  synchronous reference

Question 16

Cells can only store numbers.

Accepted Answer

A) True 
 B)False

Question 17

To create complex formulas you would use tools on the ________ tab.

Accepted Answer

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

Question 18

Spreadsheets were a ________ factor in the early adoption of personal computers.

Accepted Answer

A)  small 
B)  non- 
C)  minimal 
D)  major 
E)  minor 
A)  small 
B)  non- 
C)  minimal 
D)  major 
E)  minor

Question 19

It is ________ best to use references to cell rather than number in your spreadsheet formulas.

Accepted Answer

A)  rarely 
B)  never 
C)  sometimes 
D)  always 
E)  usually 
A)  rarely 
B)  never 
C)  sometimes 
D)  always 
E)  usually

Question 20

Spreadsheets store information in ________.

Accepted Answer

A)  rows 
B)  locations 
C)  cells 
D)  columns 
E)  boxes 
A)  rows 
B)  locations 
C)  cells 
D)  columns 
E)  boxes

To increase a cells value by 10%,it is best to reference the cell with a value of 10% in the formula.

You can format your worksheet using icons on the ________ tab.

"2B" would be a cell reference.

Today the term spreadsheet almost always refers to electronic models.

$B$4 is an example of a(n)

During the "fill" function when you move the mouse over top of the handle on the cell the mouse icon changes to a(n)

Describe how you would enter a new formula that adds the value of two cells into and Excel spreadsheet.

When there are two formulas to choose from to type into a cell,choose the formula that is ________.

The ________ key allows you to edit a cell's content.

If you need to sort and filter data you would use tools on the ________ tab.

The first thing a user should do once they start to work within an Excel file is to

The flexibility of cells is an important factor in making a spreadsheet a powerful tool.

The "Fill" capability in Excel can create more formulas with less work.

Before the advent of computers accountants used paper spreadsheets.

If you want to apply the same "growth rate" to a number of formulas in different cells you would use a(n)

Cells can only store numbers.

To create complex formulas you would use tools on the ________ tab.

Spreadsheets were a ________ factor in the early adoption of personal computers.

It is ________ best to use references to cell rather than number in your spreadsheet formulas.

Spreadsheets store information in ________.

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 increase a cells value by 10%,it is best to reference the cell with a value of 10% in the formula.

You can format your worksheet using icons on the ________ tab.

"2B" would be a cell reference.

Today the term spreadsheet almost always refers to electronic models.

$B$4 is an example of a(n)

During the "fill" function when you move the mouse over top of the handle on the cell the mouse icon changes to a(n)

Describe how you would enter a new formula that adds the value of two cells into and Excel spreadsheet.

When there are two formulas to choose from to type into a cell,choose the formula that is ________.

The ________ key allows you to edit a cell's content.

If you need to sort and filter data you would use tools on the ________ tab.

The first thing a user should do once they start to work within an Excel file is to

The flexibility of cells is an important factor in making a spreadsheet a powerful tool.

The "Fill" capability in Excel can create more formulas with less work.

Before the advent of computers accountants used paper spreadsheets.

If you want to apply the same "growth rate" to a number of formulas in different cells you would use a(n)

Cells can only store numbers.

To create complex formulas you would use tools on the ________ tab.

Spreadsheets were a ________ factor in the early adoption of personal computers.

It is ________ best to use references to cell rather than number in your spreadsheet formulas.

Spreadsheets store information in ________.

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