Chapter 5 Flashcards

Spreadsheets Creating and Editing Workbooks

1
Q

Microsoft Excel

A

Spreadsheet program that allows you to store organize and analyze information

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

workbook

A

A collection of worksheets in a single file

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

worksheet

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

active cell

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

alignment

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Backstage view

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

border

A

An outline applied to the sides of a cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

cell range

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

cell

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

column width

A

The left-to-right measurement of a column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

column

A

Vertical cells that are labeled by letters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

dialog box launcher

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Drag and Drop

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

fill handle

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Flash Fill

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

footer

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

formula bar

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

ribbon group

A

Contains related features and tools organized within a ribbons tab

19
Q

group

A

two or more selected worksheets

20
Q

header

A

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

21
Q

label

A

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

22
Q

margin

A

Space between your content and the edge of the page

23
Q

merge cells

A

Two or more cells combined into a single cell

24
Q

Microsoft Excel

A

Spreadsheet program that allows you to store organize and analyze information

25
Q

name box

A

Displays the name or location of the active cell

26
Q

orientation

A

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

27
Q

Page Break Preview

A

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

28
Q

page break

A

A divider that breaks a worksheet into separate pages for printing

29
Q

page view options

A

Allow you to select page view options

30
Q

print area

A

The specific range of cells to be printed

31
Q

program window controls

A

Allows you to move resize and close the application window

32
Q

Quick Access toolbar

A

Commonly used commands at the top of the application window

33
Q

ribbon

A

Groups of related tools organized within a set of tabs

34
Q

row height

A

The top-to-bottom measurement of a row

35
Q

row

A

Horizontal cells that are labeled by numbers

36
Q

series

A

A list of sequential numbers dates times or text

37
Q

tab

A

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

38
Q

template

A

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

39
Q

value

A

A number a cell address a date or text

40
Q

workbook

A

A collection of worksheets in a single file

41
Q

worksheet tabs

A

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

42
Q

worksheet

A

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

43
Q

wrap

A

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

44
Q

zoom adjustment

A

Adjusts zooming in and out of a worksheet