Deck 5: Application Extension-Introduction to Microsoft Excel 2013

Question 1

Formatting options are shown on the Home tab ribbon.

Answer 1

True

Question 2

The FORMULAS tab in Excel is used to format your page.

Answer 2

False

Question 3

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.

Answer 3

B

Question 4

Text can be used in arithmetic formulas.

Question 5

Cells can only store numbers.

Question 6

The tabs in Excel control the contents of the ribbon.

Question 7

Today the term "spreadsheet" almost always refers to electronic models.

Question 8

Cells are identified by their column letters and row numbers.

Question 9

Spreadsheets store information in

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

Question 10

"C8" is an absolute reference.

Question 11

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

Question 12

The real power of Excel lies in its amazing computational capability.

Question 13

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

Question 14

Before the advent of computers, accountants used paper spreadsheets.

Question 15

If you key in January and February in cells C1 and C2 and then select both cells and drag down, Excel will fill in with March, April, May and so on.

Question 16

"2B" would be a cell reference.

Question 17

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

Question 18

"/" is the sign used for multiplication.

Question 19

The Save As option allows you to rename the current file.

Question 20

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

Question 21

________ spreadsheets were used prior to the advent of computers.

Question 22

To display a preview in Excel, click the FILE button and then the ________ button.

A) Share
B) Info
C) Print
D) Export
E) Open

Question 23

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 24

To insert new rows, click on the row ________ which you want the new rows.

A) below
B) above
C) next to
D) to the left of
E) inside

Question 25

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 26

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 27

"B2" would be a cell ________.

Question 28

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

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

Question 29

A formula always begins with a(n) ________ sign.

Question 30

The term "spreadsheet" usually refers to ________ models, today.

Question 31

Workbooks are made up of multiple pages called

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

Question 32

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 33

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

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

Question 34

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

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

Question 35

The most frequently used tools and selections can be found in the ________ tab.

A) INSERT
B) DATA
C) CELLS
D) HOME
E) VIEW

Question 36

To increase the size of text in a cell, go to the ________ Section of the Home Tab.

A) Alignment
B) Styles
C) Number
D) Font
E) Editing

Question 37

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

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

Question 38

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

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

Question 39

Cells are identified by their ________ letters and row numbers.

Question 40

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 41

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

Question 42

A(n) ________ is used for division in formulas.

Question 43

The formatting options are show on the ________ ribbon.

Question 44

The ________ capability of Excel allows the users to create more formulas with less work.