8-12 Flashcards

1
Q

changing default settings to improve the appearance of the cell contents

A

Format

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

positioning data horizontally and vertically within a cell

A

Alignment

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

rotating text at an angle within a cell to

A

Text Rotation

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

why do we use text rotation

A

Take up less space
Make it stand out

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

copies or “paints” formats from one cell to range to another

A

Paint Formats

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

determines how to display data that exceeds the size of the cell

A

Text Wrapping

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

types of text wrapping

A

over flow- wrap- clip

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

centers text across columns, and combines two or more selected adjacent cells into one.

A

Merge & Center

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

what id the default in number formats

A

automatic

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

what is similar with accounting and currency

A

Both give you a dollar sign and 2 decimal places; however,

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

what is a way to adjust column width

A

Drag the right border of the column

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

what is a way to adjust column width

A

Double- click the right border of the column

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

what is a way to adjust column width

A

Select the column, right click, resize column

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

Methods of Inserting & Deleting Rows & Columns

A

Insert
Row above, row below, column left, column right

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

Methods of Inserting & Deleting Rows & Columns

A

right - click, insert

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

Methods of Inserting & Deleting Rows & Columns

A

Edit,
Delete

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

what does clear for matting do

A

restores default formatting

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

what are borders and shading used for

A

Used to enhance appearance; draw readers attention

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

what is conditional formatting

A

Applying different formats to cell contents that meet specified conditions; allow readers to evaluate data at a glance

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

how many sheets by default are in a workbook

A

1

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

what is the maximum number of sheets in a workbook

A

200

22
Q

what is workbook

A

a spreadsheet file

23
Q

how to duplicate a worksheet

A

right click on the sheet tab

24
Q

why is duplicating helpful

A

becaus eit keeps it organized especially with a similar set up

25
Q

what will change when duplicating sheets

A

data

26
Q

how may you identify a sheet tab

A

sheet name, or tab color

27
Q

how can you move and rearrange or organize sheet tabs

A

Click and drag to move tabs in a specific order

28
Q

what do all sheets button do

A

Displays a list of all sheets in the work book

29
Q

how many work sheets are added at a time by default

A

1

30
Q

how do you add a sheet

A

To add more, click the - Add Sheet button

31
Q

what is a chart

A
  • a graphical representation of numeric data
32
Q

Where have we seen them?

A

-text books, news articles, websites

33
Q

Why are we using charts?

A

Make information easier to understand
Provide a visual picture of information for quick reference

34
Q

what chart
Compares data
A chart that displays data values as vertical columns
Column height represents values
Depicts data similar to a bar chart

A

column

35
Q

what chart
Compares data
A column chart turned on its side
Length of bar represents value
Depicts data similar to a column chart

A

bar

36
Q

what chart
Shows trends over time
A chart or visualization that displays data as separate lines across categories

A

line

37
Q

what chart
Shows parts of a whole
A chart is the shape of a circle divided into slices, like a pie
Shows data values as percentages of the whole

A

pie

38
Q

what chart
Combination of line chart and pie chart
A chart that shows how individual volume changes over time in relations to total volume

A

area charts

39
Q

what charts
Shows a relationship or correlation between two sets of data
A chart that shows plotted points on the X and Y axis representing two sets of data.

A

scatter charts

40
Q

what is chart area

A

the entire chart and all chart elements

41
Q

the area inside the horizontal and vertical axes that contains the graphical representation of the data series.

A

plot area

42
Q

lines that establish a relationship between data in a chart

A

axis

43
Q

category axis; contains names of data categories.

A

x- axis

44
Q

value axis; contains numeric values

A

y- axis

45
Q

lines that carry the eye from the axis to the chart data.

A

gridlines

46
Q

labels that appear on each data marker; they can be values, category labels, or percentages

A

Data labels

47
Q

descriptive labels that identify the contents of the chart and axes

A

titles

48
Q

a list or ‘’keys’’ that identifies patterns, symbols, or colors used in a chart

A

legend

49
Q

how many options do you when when deciding a location in a work sheet

A

2

50
Q

inserting as an object into the current worksheet (default)

A

embedded chart

51
Q
A