Excel 1 -U1&U2

Question 1

outlined by a bold rectangle; information is entered here

Answer 1

active cell

Question 2

intersection of a row and column

Answer 2

cell

Question 3

starts at the top of the sheet and goes to the bottom of the sheet; identified by a letter

Answer 3

column

Question 4

indicates the current cell that is active; can change the location of active cell by typing here

Answer 4

Name Box

Question 5

starts at the left edge of the sheet and goes to the right edge of the sheet; identified by a number

Answer 5

row

Question 6

spreadsheet file; contains many sheets or pages

Answer 6

workbook

Question 7

one sheet or page in a file; where information is entered

Answer 7

worksheet

Question 8

default view–how worksheet opens up

Answer 8

Normal view

Question 9

automatically divides worksheet into pages

Answer 9

Page Layout view

Question 10

see an overview of worksheet; helps separate worksheet into different pages

Answer 10

Page Break view

Question 11

Click the column heading (Letter name); selects the entire column

Answer 11

Selecting a column

Question 12

Click the row heading (number name); selects the entire row

Answer 12

Selecting a row

Question 13

select multiple cells with mouse

Answer 13

Click and drag method

Question 14

select multiple cells by clicking first cell, hold shift button and click last cell

Answer 14

Shift key method

Question 15

select multiple cells by clicking on first cell, hold control key, click on cells you want to select

Answer 15

Control key method

Question 16

keyboard shortcut for Copy

Answer 16

Ctrl + C

Question 17

keyboard shortcut for Bold

Answer 17

Ctrl + B

Question 18

keyboard shortcut for Italics

Answer 18

Ctrl + I

Question 19

keyboard shortcut for Paste

Answer 19

Ctrl + V

Question 20

keyboard shortcut for Cut

Answer 20

Ctrl + X

Question 21

keyboard shortcut for Undo

Answer 21

Ctrl + Z

Question 22

how text is positioned in cell; left, center, right

Answer 22

alignment

Question 23

forces text too wide for cell to fit inside cell and be readable

Answer 23

wrap text

Question 24

information contained in a cell

Answer 24

cell content

Question 25

pieces of info that describe appearance of cell content; examples--font size, font color

Answer 25

format attributes

Question 26

line between rows or columns; mouse changes to line with 2 arrows

Answer 26

boundary

Question 27

left to right measurement of column

Answer 27

column width

Question 28

top to bottom measurement of row

Answer 28

row height

Question 29

blinking cursor inside cell; changes can be made to cell content

Answer 29

edit mode

Question 30

deletes format from selected cell

Answer 30

Clear Formats

Question 31

deletes cell content

Answer 31

Clear Contents

Question 32

deletes content and format; button looks like an eraser

Answer 32

Clear All

Question 33

insert

Answer 33

add

Question 34

delete

Answer 34

remove

Question 35

cancels the current command

Answer 35

Escape button

Question 36

equation that is entered into a cell

Answer 36

equation

Question 37

first character in a cell that tells Excel there is a calculation, formula or function to perform

Answer 37

equal sign, =

Question 38

values or data used in a formula; numbers

Answer 38

operands

Question 39

symbols used to tell what type of calculation to perform

Answer 39

operators

Question 40

uses the cell name (A2) in the formula; tells Excel to use the value in the cell in the formula/function

Answer 40

cell reference

Question 41

predefined formula

Answer 41

function

Question 42

cell information to be used in function calculation; contained in parentheses

Answer 42

arguments

Question 43

adds all values in a range of cells

Answer 43

SUM function

Question 44

sums cells in a range then dividing by number of cells in the range

Answer 44

AVERAGE function

Question 45

counts the cells with numerical values in a range of cells; blank cells are ignored

Answer 45

COUNT function

Question 46

finds the largest value in a range of cells

Answer 46

MAX function

Question 47

finds the smallest value in a range of cells

Answer 47

MIN function