Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

COMPUTER > EXCEL > Flashcards

EXCEL Flashcards

1
Q

an electronic grid consisting of rows and columns in which you can perform numeric calculations

A

Worksheet

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

– the intersection of a row and column

A

Cell address

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

an excel file that can contain one or more worksheets

A

Workbook

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

a worksheet or a workbook

A

Spreadsheet

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

– the cell with the dark border in the worksheet

A

Active cell

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

the dark border surrounding the cell

A

Cell pointer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q
  • a specific location of a cell in a worksheet where a column row intersect. A column letter followed by a row number such as B2 A33
A

Cell address

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

shows the address of the selected cell

A

Name box

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

– located just above the column headings, shows the contents of the selected cell

A

Formula bar

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

You can move to and select a cell by

A

Arrow keys, Tab move to the right, Shift [tab] move to the left, enter move one cell down, clicking it

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

a group of selected cells that share boundaries

A

Cell range

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

use the cell address of the first cell in the range followed by a colon and the cell address of the last cell in the range

A

To reference a cell range

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

click the cell or use arrow keys

A

To select a cell

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

click the row heading or select a cell in the row, then press [shift][Spacebar]

A

To select a row

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

click the column heading or select a cell in the column then press [ctrl][spacebar]

A

To select a column

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

drag across the cells or press [shift], then press the arrow keys

A

To select a cell range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q
  • click the select All button to the left of column heading A, or press [ctrt][[A]
A

To select a worksheet

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

text that describes data in a worksheet

A

Label

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

numeric data that can be used in calculations

A

Values

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

double clicking the cell

A

Edit mode

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

– on the formula bar keeps cell active

A

Enter button

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

– a rectangle above the worksheet column that contains a capital letter

A

Column heading

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

the boxes containing numbers that run along the left edge of the worksheet

A

Row headings

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

– double clicking a column boundary widens or narrow it to fit the longest entry in the column

A

Autofit

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

select row, click format button in the home TAB, in the cells group, click row height

A

Change row height

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

excel guesses that you want to type the same word

A

Autocomplete –

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

an equation that performs a calculation it starts with the equal sign (=)

A

Formula

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

a cell address that identifies the location of a value used in a calculation

A

Cell reference

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

parentheses, exponent, multiplication, division, addition, subtraction

A

Order of precedence

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

– when you copy a formula to a new cell, excel automatically replaces the original cell references with cell references that are in the same relative position as those in the original formula

A

Relative cell referencing

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

the small dark square that you drag to copy info to cells

A

Fill handle

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

prewritten formulas designed for particular types of calculations.

A

Functions

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

most frequently used, totals all numbers and cell references included as function arguments.

A

Sum –

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

information a function needs to make a calculation

A

Argument

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

– this appears around the cells indicating that these are the cells that excel assumes you want to add together or use a formula on

A

Moving dotted border

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

when you enter data in a cell, excel automatically left aligns text, and right-aligns values.

A

Cell alignment

37
Q

are predefined formatting options to ensure that similar elements in your worksheet are formatted consistently
Lets you apply the same collection of formatting options to multiple cells within the workbook.

A

Cell styles-

38
Q

where the page is taller than it is wide

A

Portrait orientation

39
Q

where the page is wider than it is tall

A

Landscape

40
Q

an excel file that stores a spreadsheet

A

Workbook

41
Q

a worksheet in an excel workbook that contains a chart (a visual representation of spreadsheet data)

A

Chart sheet

42
Q

– contain more than one operator

A

Complex formulas

43
Q

rule to determine which calculation to perform first, calculate items in parentheses, calculate exponents, multiply or divide (from left to right), add or subtract (from left to right)

A

Order of precedence

44
Q

a cell reference that always stays the same, even when you copy a formula that contains it to a new location. Contains a $ symbol before the column letter and row number ($A$1)

A

Absolute cell references

45
Q
  • press it once to change a relative cell reference to an absolute cell reference.
A

[F4] key

46
Q
  • counts the number of cells in a range containing numbers
A

Count function

47
Q
  1. An equal sign 2. The function name 3. A set of parentheses 4. Arguments separated by commas and enclosed in parentheses.
A

Four parts to every function

48
Q

any time you type an equal sign followed by a letter a list of valid functions and names beginning with that letter appears.

A

Formula autocomplete

49
Q

a number in a sequential series of numbers. Date series values represent the number of days since January 1, 1900.

A

Serial value

50
Q

appears whenever you select a range of two or more cells and gives you easy access to frequently used tools for formatting cells or analyzing data.

A

Quick analysis button

51
Q

formatting that is applied to cells in a spreadsheet or fields in a form or report when !specified criteria! are met.

A

Conditional formatting

52
Q

shading patterns that use two or three colors to show the relative values of a range of cells.

A

Color scales

53
Q

rows and columns of data with a similar structure. you can analyze, sort, and filter !separately! from other cells in a worksheet.

A

Table

54
Q

an organized collection of data related to a particular topic or purpose and stored electronically in a file

A

Database

55
Q

excel table columns (such as Last Name field)

A

Fields

56
Q

– rows of data in excel (such as a record for each customer)

A

Records

57
Q

display only the data you need. Shows only rows that meet specific requirements. This does not change the order.

A

Filter

58
Q

the specified data you need– When you tell excel which rows in a table you want to see. Temporarily hides the rows that do not meet parameters.

A

Criteria

59
Q

a visual representation of worksheet data.

A

Chart

60
Q

horizontal line at base of chart shows categories

A

Horizontal axis (x-axis)-

61
Q

at left edge of the chart provides values. Sometimes called the value axis

A

Vertical axis (y-axis)

62
Q

– identify the values on each !axis!

A

Axis titles

63
Q

a sequence of related numbers that shows a trend

A

Data series

64
Q

a single chart symbol that represents one value in a data series

A

Data marker-

65
Q

identifies what each data series represents

A

Chart legend

66
Q
  • vertical and horizontal lines that help identify the value for each data series
A

Gridlines in the chart

67
Q

– the part of the chart contained within the horizontal and vertical axes

A

Plot area

68
Q

the entire chart and all the chart elements

A

Chart area

69
Q

good for comparing values

A

Column charts

70
Q

compare values across categories with minmal emphasis on time

A

Bar charts

71
Q

showing trends by category over time

A

Line charts

72
Q

showing relationships of parts to whole

A

Pie charts

73
Q
  • reason charts are so useful is they make it easy to see trends and draw conclusions from the underlying worksheet data.
A

TRUE

74
Q

for most charts, you should avoid including totals when selecting worksheet cells.

A

TRUE

75
Q

you can also move and resize many of the individual components of a chart such as the chart background or legend.

A

Chart elements or chart objects

76
Q
  • enlarges to new dimensions
A

Sizing handle

77
Q

a predefined arrangement of chart elements

A

Chart layout-

78
Q

predefined set of chart !colors and fills!

A

Chart style-

79
Q
  • square with paintbrush
A

Chart styles button

80
Q
  • in a chart is a !grid! containing the charts underlying !worksheet data!, which is added below the x-axis in certain type charts.
A

Data table-

81
Q

a sheet in a workbook that contains only a chart; it contains no worksheet cells.

A

Chart sheet

82
Q

tiny charts that fit in one cell and illustrate trends in selected cells.

A

Sparklines

83
Q

you can find headers and footers in the

A

Page layout view

84
Q

dates are stored as

A

serial values

85
Q

this is used to highlight or emphasize !certain! information in a worksheet.

A

Conditional formatting

86
Q

colored bars that makes it easy to quickly identify the large and small values in range of cells and also highlights the relative value of cells to one another.

A

Data bars

87
Q

can be added at the bottom of a table when you want to add totals

A

total row

88
Q

in a table this is the row at the top that contains column headings

A

header row

89
Q

a tab that only appears when a particular type of object is selected.

A

contextual tab

COMPUTER (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions