Question 1

Cells can contain _______.

Accepted Answer

A)  numbers
B)  arithmetic symbols
C)  formulas
D)  text
E)  all of the above E

Question 2

Before the advent of computers accountants used paper spreadsheets.

Accepted Answer

A) True 
 B)False  True

Question 3

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

Question 4

When you build a formula it can begin with a "=".

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

Formating options are shown on the Home tab ribbon.

Accepted Answer

A) True 
 B)False

Question 7

Why are absolute references important in Excel?

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

Cells are identified by their________letters and row numbers.

Accepted Answer

The answer of Cells are identified by their________letters and row...

Question 12

"2B" would be a cell reference.

Accepted Answer

A) True 
 B)False

Question 13

The formating options are show on the_______ribbon.

Accepted Answer

The answer of The formating options are show on the_______ribbon....

Question 14

Text can be used in arithmetic formulas.

Accepted Answer

A) True 
 B)False

Question 15

_______spreadsheets where used used prior to the advent of computers.

Accepted Answer

The answer of _______spreadsheets where used used prior to the...

Question 16

Today the term spreadsheet refers to electronic models.

Accepted Answer

A) True 
 B)False

Question 17

Spreadsheets store information in ________ .

Accepted Answer

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

Question 18

"$F$5" is a(n)______reference

Accepted Answer

The answer of "$F$5" is a(n)______reference...

Question 19

The  _______key allows you to edit a cell's content.

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 2: Extensions S: Using Collaboration Information Systems

Cells can contain _______.

Before the advent of computers accountants used paper spreadsheets.

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

When you build a formula it can begin with a "=".

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

Formating options are shown on the Home tab ribbon.

Why are absolute references important in Excel?

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

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

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

Cells are identified by their________letters and row numbers.

"2B" would be a cell reference.

The formating options are show on the_______ribbon.

Text can be used in arithmetic formulas.

_______spreadsheets where used used prior to the advent of computers.

Today the term spreadsheet refers to electronic models.

Spreadsheets store information in ________ .

"$F$5" is a(n)______reference

The _______key allows you to edit a cell's content.

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