Chapter 5

Question 1

Microsoft Excel

Answer 1

Spreadsheet program that allows you to store organize and analyze information

Question 2

workbook

Answer 2

A collection of worksheets in a single file

Question 3

worksheet

Answer 3

A page in a workbook that consists of a grid of rows and columns in which you can enter text values and formulas and perform calculations

Question 4

active cell

Answer 4

A cell that is highlighted or outlined by a bold black rectangle

Question 5

alignment

Answer 5

Arrangement of cell contents in relation to left and right sides of a cell and the top and bottom of a cell

Question 6

Backstage view

Answer 6

A view that shows you behind-the-scenes options for managing files such as opening saving printing and documenting files

Question 7

border

Answer 7

An outline applied to the sides of a cell

Question 8

cell range

Answer 8

A group of adjacent cells you select to perform operations on all of the selected cells

Question 9

cell

Answer 9

The intersection of a row and column which is identified by a letter and number

Question 10

column width

Answer 10

The left-to-right measurement of a column

Question 11

column

Answer 11

Vertical cells that are labeled by letters

Question 12

dialog box launcher

Answer 12

Opens a small window with information and options about a particular tool or group

Question 13

Drag and Drop

Answer 13

The action of using a mouse to drag a selection from its original location and drop it in a new location

Question 14

fill handle

Answer 14

A small square in the lower right corner of a selected cell or range of cells

Question 15

Flash Fill

Answer 15

Excel recognizes a pattern based on other information in your workbook it uses the pattern to enter data into several cells at once

Question 16

footer

Answer 16

Display content at the bottom of the page prints on every page of the workbook

Question 17

formula bar

Answer 17

Where data and formulas are entered and edited which then appears in the active cell

Question 18

ribbon group

Answer 18

Contains related features and tools organized within a ribbons tab

Question 19

group

Answer 19

two or more selected worksheets

Question 20

header

Answer 20

isplay content at the top of a worksheet prints on every page of the workbook

Question 21

label

Answer 21

Text entered in a worksheet that identifies a numeric data and is the most common type of text entered in a worksheet

Question 22

margin

Answer 22

Space between your content and the edge of the page

Question 23

merge cells

Answer 23

Two or more cells combined into a single cell

Question 24

Microsoft Excel

Answer 24

Spreadsheet program that allows you to store organize and analyze information

Question 25

name box

Answer 25

Displays the name or location of the active cell

Question 26

orientation

Answer 26

The position of the content in a worksheet so that it prints either vertically or horizontally on a page

Question 27

Page Break Preview

Answer 27

An Excel view in which you can quickly adjust automatic page breaks to achieve a more desirable printed document

Question 28

page break

Answer 28

A divider that breaks a worksheet into separate pages for printing

Question 29

page view options

Answer 29

Allow you to select page view options

Question 30

print area

Answer 30

The specific range of cells to be printed

Question 31

program window controls

Answer 31

Allows you to move resize and close the application window

Question 32

Quick Access toolbar

Answer 32

Commonly used commands at the top of the application window

Question 33

ribbon

Answer 33

Groups of related tools organized within a set of tabs

Question 34

row height

Answer 34

The top-to-bottom measurement of a row

Question 35

row

Answer 35

Horizontal cells that are labeled by numbers

Question 36

series

Answer 36

A list of sequential numbers dates times or text

Question 37

tab

Answer 37

Contains related groups of different tools and commands to perform the most common tasks

Question 38

template

Answer 38

A predesigned spreadsheet you can use to create a new workbook quickly

Question 39

value

Answer 39

A number a cell address a date or text

Question 40

workbook

Answer 40

A collection of worksheets in a single file

Question 41

worksheet tabs

Answer 41

Labels that appear at the bottom of the workbook window and display the names of the worksheets can be used to add deleted rename and reorder worksheets

Question 42

worksheet

Answer 42

A page in a workbook that consists of a grid of rows and columns in which you can enter text values and formulas and perform calculations

Question 43

wrap

Answer 43

To automatically display data on the next line when its too long to display within the cells width

Question 44

zoom adjustment

Answer 44

Adjusts zooming in and out of a worksheet