Excel 1

Question 0

The spreadsheet is called a _______

Answer 0

Work sheet

Question 1

What does an electronic spreadsheet program allow you to do

Answer 1

Perform numeric calculations

Question 2

Individual work sheets are stored in a ________

Answer 2

Work book

Question 3

What are 5 advantages of using Excel

Answer 3

1. Enter data quickly and accurately
2. Recalculate data quickly
3. Perform what-if analysis
4. Create charts
5. Share information

Question 4

What does the name box do

Answer 4

Displays the active cell address

Question 5

What allows you to enter or edit data in the worksheet

Answer 5

The formula bar

Question 6

The intersection of a row and a column is called a ______

Answer 6

Cell

Question 7

What is the cell address

Answer 7

Cells own unique location

Question 8

The cell in which you are working on is

Answer 8

The active cell

Question 9

What allows you to switch from sheet to sheet in a workbook

Answer 9

Sheet tabs

Question 10

What does the status bar do

Answer 10

Provides a brief description of the active command

Question 11

What does the mode indicator do

Answer 11

Provides additional information about certain tasks

Question 12

What are equations in a worksheet called

Answer 12

Formulas

Question 13

What are 3 things you must do when creating calculations in Excel

Answer 13

1. Create formulas with care
2. Use cell references rather than values
3. Determine what calculations will be needed

Question 14

What do labels contain

Answer 14

Text and numerical info not used in calculations

Question 15

What is the name for the info that can be used in calculations

Answer 15

Values

Question 16

What is the name for a built in formula

Answer 16

Function

Question 17

What is the name for the necessary info in a function

Answer 17

Arguments

Question 18

What are the 3 ways to edit a cell

Answer 18

1. Double click the cell
2. Formula bar
3. Just start typing

Question 19

What goes at the start of a formula ?

Answer 19

Equal sign (=) also called the formula prefix

Question 20

What do arithmetic operations do

Answer 20

Perform mathematical calculations

Question 21

What do comparison operators do

Answer 21

Compare values for the purpose of true/false

Question 22

What are these symbols examples of?
>
<
>=
<>

Answer 22

Comparison operators

Question 23

What do text concatenation operators do

Answer 23

Join strings of text in different cells

&

Question 24

What operators enable you to use specific ranges in calculations

Answer 24

Reference operators

Question 25

What 2 methods can you do to change the view of the worksheet window

Answer 25

1. View tab on the Ribbon

2. View buttons on the status bar

Question 26

What view shows the worksheet without including headers and footers or rulers

Answer 26

Normal view

Question 27

What view provides a more accurate view of how a worksheet will look printed

Answer 27

Page layout view

Question 28

What view displays a reduced view of each page of the worksheet, along with page indicators

Answer 28

Page break preview

Question 29

What 2 options allow you to see how a worksheet will look when printed

Answer 29

1. Page layout tab

2. Print preview

Question 30

What does the dotted line in the print layout tab signify

Answer 30

The print area for the sheet

Question 31

What does backstage view do

Answer 31

Let’s you choose the number of copies, printer, etc