Deck 2: Extensions S: Using Collaboration Information Systems

Question 1

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

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

Answer 1

C

Question 2

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

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

Answer 2

($)

Question 3

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

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

Answer 3

F4

Question 4

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

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

Question 5

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

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

Question 6

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

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

Question 7

A cell is identified by using a

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

Question 8

Cells can contain _______.

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

Question 9

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

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

Question 10

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

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

Question 11

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

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

Question 12

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

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

Question 13

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

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

Question 14

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

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

Question 15

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

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

Question 16

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

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

Question 17

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

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

Question 18

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

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

Question 19

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

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

Question 20

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

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

Question 21

A(n)_______is used for multiplication in formulas.

Question 22

Spreadsheets store information in ________ .

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

Question 23

In Excel users can build_______, line, pie, bar, and area graphs.

Question 24

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

Question 25

Excel provides powerful graphing capabilities.

Question 26

A formula usually begins with a(n)_______sign.

Question 27

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

Question 28

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

Question 29

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

Question 30

Before the advent of computers accountants used paper spreadsheets.

Question 31

Cells are identified by their________letters and row numbers.

Question 32

Cells are identified by their column letters and row numbers.

Question 33

The term spreadsheet refers to_______ models, today.

Question 34

"2B" would be a cell reference.

Question 35

The formating options are show on the_______ribbon.

Question 36

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

Question 37

_______spreadsheets where used used prior to the advent of computers.

Question 38

"B2" would be a cell _______ .

Question 39

"C8" is a absolute reference.

Question 40

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

Question 41

Today the term spreadsheet refers to electronic models.

Question 42

Cells can only store numbers.

Question 43

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

Question 44

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

Question 45

Formating options are shown on the Home tab ribbon.

Question 46

Text can be used in arithmetic formulas.

Question 47

"/" is the sign used for multiplication.

Question 48

Why are absolute references important in Excel?

Question 49

How does an user rename a worksheet tab?