Excel Chapter 1

Question 1

worksheet

Answer 1

a spreadsheet that contains formulas, functions, values, text, and visual aids

Question 2

workbook

Answer 2

a file containing related worksheets

Question 3

input area

Answer 3

a range of cells containing values for variables used in formulas

Question 4

output area

Answer 4

a range of cells containing results based on manipulating the variables

Question 5

name box

Answer 5

identifies the address of the current cell

Question 6

formula bar

Answer 6

displays the content (text, value, date, or formula) in the active cell

Question 7

sheet tab

Answer 7

displays the name of a worksheet within a workbook

Question 8

cell

Answer 8

the intersection of a column and row

Question 9

text

Answer 9

includes letters, numbers, symbols, and spaces

Question 10

value

Answer 10

a number that represents a quality or an amount

Question 11

order of operations

Answer 11

rules that control the sequence in which excel performs arithmetic operations

Question 12

auto fill

Answer 12

enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells

Question 13

fill handle

Answer 13

a small green square at the bottom-right corner of a cell

Question 14

column width

Answer 14

a horizontal measurement or a column

Question 15

row height

Answer 15

the vertical measurement of a row

Question 16

range

Answer 16

a rectangular group of cells

Question 17

alignment

Answer 17

the position of data between the cell margins

Question 18

wrap text

Answer 18

formatting that enables a label to appear on multiples lines within the current cell

Question 19

fill color

Answer 19

the background color appearing behind data in a cell

Question 20

formula

Answer 20

a combination of cell references, operators, values, and/or functions used to perform a calculation