Question 1

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 2

To place a graph on your spreadsheet you would use the________tab.

Accepted Answer

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

Question 3

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

Accepted Answer

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

Question 4

The______capability of Excel allows the users to create more formulas with less work

Accepted Answer

The answer of The______capability of Excel allows the users to...

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

A formula usually begins with a(n)_______sign.

Accepted Answer

The answer of A formula usually begins with a(n)_______sign....

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

Cells are identified by their column letters and row numbers.

Accepted Answer

A) True 
 B)False

Question 11

The term spreadsheet refers to_______ models, today.

Accepted Answer

The answer of The term spreadsheet refers to_______ models, today....

Question 12

A(n)_______is used for multiplication in formulas.

Accepted Answer

The answer of A(n)_______is used for multiplication in formulas....

Question 13

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 14

"C8" is a absolute reference.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

"/" is the sign used for multiplication.

Accepted Answer

A) True 
 B)False

Question 18

"B2" would be a cell _______ .

Accepted Answer

The answer of "B2" would be a cell _______ ....

Question 19

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

Accepted Answer

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

Question 20

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) intact reference. 
B) synchronous reference 
C) absolute reference. 
D) asynchronous reference. 
E) relative reference. 
A) intact reference. 
B) synchronous reference 
C) absolute reference. 
D) asynchronous reference. 
E) relative reference.

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

To place a graph on your spreadsheet you would use the________tab.

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

The______capability of Excel allows the users to create more formulas with less work

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

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

A formula usually begins with a(n)_______sign.

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

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

Cells are identified by their column letters and row numbers.

The term spreadsheet refers to_______ models, today.

A(n)_______is used for multiplication in formulas.

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

"C8" is a absolute reference.

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

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

"/" is the sign used for multiplication.

"B2" would be a cell _______ .

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

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

Is in the Life of Business Professionals

Business Processes, Information, and Information Systems

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

Extensions A: Introduction to Microsoft Excel

Extensions B: Introduction to Microsoft Excel

Data Communications

Business Process Management

E-Commerce and Web 2.0

Business Intelligence and Information Systems for Decision Making

Information Systems Development

Extensions A: How the Internet Works

Information Systems Management

Information Security Management

Filters

Exam 2: Extensions S: Using Collaboration Information Systems

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

To place a graph on your spreadsheet you would use the________tab.

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

The______capability of Excel allows the users to create more formulas with less work

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

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

A formula usually begins with a(n)_______sign.

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

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

Cells are identified by their column letters and row numbers.

The term spreadsheet refers to_______ models, today.

A(n)_______is used for multiplication in formulas.

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

"C8" is a absolute reference.

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

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

"/" is the sign used for multiplication.

"B2" would be a cell _______ .

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

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

Is in the Life of Business Professionals

Business Processes, Information, and Information Systems

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

Extensions A: Introduction to Microsoft Excel

Extensions B: Introduction to Microsoft Excel

Data Communications

Business Process Management

E-Commerce and Web 2.0

Business Intelligence and Information Systems for Decision Making

Information Systems Development

Extensions A: How the Internet Works

Information Systems Management

Information Security Management

Filters