Deck 14: Excel Basics: Understanding Spreadsheets, Cells, and Formulas

Question 1

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

Answer 1

True

Question 2

To place a graph on your spreadsheet you would use the ________ tab.

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

Answer 2

D

Question 3

Before the advent of computers accountants used paper spreadsheets.

Answer 3

True

Question 4

Spreadsheets store information in ________.

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

Question 5

A cell is identified by using a

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 6

Today the term spreadsheet almost always refers to electronic models.

Question 7

Excel provides powerful graphing capabilities.

Question 8

Cells can only store numbers.

Question 9

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

Question 10

"2B" would be a cell reference.

Question 11

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

Question 12

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

Question 13

Formatting options are shown on the Home tab ribbon.

Question 14

Cells are identified by their column letters and row numbers.

Question 15

Workbooks are made up of multiple pages called ____________.

A) text
B) arithmetic symbols
C) formulas
D) numbers
E) worksheets

Question 16

Text can be used in arithmetic formulas.

Question 17

"C8" is an absolute reference.

Question 18

"/" is the sign used for multiplication.

Question 19

When you build a formula it must begin with an "=".

Question 20

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

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

Question 21

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

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

Question 22

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

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

Question 23

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

Question 24

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

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

Question 25

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

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

Question 26

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

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

Question 27

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

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

Question 28

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 29

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

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

Question 30

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

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

Question 31

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

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

Question 32

How does a user rename a worksheet tab?

Question 33

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

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

Question 34

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

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

Question 35

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

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

Question 36

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

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

Question 37

Why are absolute references important in Excel?

Question 38

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

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

Question 39

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

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