EXCEL Flashcards
1
Q
an electronic grid consisting of rows and columns in which you can perform numeric calculations
A
Worksheet
2
Q
– the intersection of a row and column
A
Cell address
3
Q
an excel file that can contain one or more worksheets
A
Workbook
4
Q
a worksheet or a workbook
A
Spreadsheet
5
Q
– the cell with the dark border in the worksheet
A
Active cell
6
Q
the dark border surrounding the cell
A
Cell pointer
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
8
Q
shows the address of the selected cell
A
Name box
9
Q
– located just above the column headings, shows the contents of the selected cell
A
Formula bar
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
11
Q
a group of selected cells that share boundaries
A
Cell range
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
13
Q
click the cell or use arrow keys
A
To select a cell
14
Q
click the row heading or select a cell in the row, then press [shift][Spacebar]
A
To select a row
15
Q
click the column heading or select a cell in the column then press [ctrl][spacebar]
A
To select a column
16
Q
drag across the cells or press [shift], then press the arrow keys
A
To select a cell range
17
Q
- click the select All button to the left of column heading A, or press [ctrt][[A]
A
To select a worksheet
18
Q
text that describes data in a worksheet
A
Label
19
Q
numeric data that can be used in calculations
A
Values
20
Q
double clicking the cell
A
Edit mode
21
Q
– on the formula bar keeps cell active
A
Enter button
22
Q
– a rectangle above the worksheet column that contains a capital letter
A
Column heading
23
Q
the boxes containing numbers that run along the left edge of the worksheet
A
Row headings
24
Q
– double clicking a column boundary widens or narrow it to fit the longest entry in the column
A
Autofit
25
select row, click format button in the home TAB, in the cells group, click row height
Change row height
26
excel guesses that you want to type the same word
Autocomplete –
27
an equation that performs a calculation it starts with the equal sign (=)
Formula
28
a cell address that identifies the location of a value used in a calculation
Cell reference
29
parentheses, exponent, multiplication, division, addition, subtraction
Order of precedence
30
– 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
Relative cell referencing
31
the small dark square that you drag to copy info to cells
Fill handle
32
prewritten formulas designed for particular types of calculations.
Functions
33
most frequently used, totals all numbers and cell references included as function arguments.
Sum –
34
information a function needs to make a calculation
Argument
35
– this appears around the cells indicating that these are the cells that excel assumes you want to add together or use a formula on
Moving dotted border
36
when you enter data in a cell, excel automatically left aligns text, and right-aligns values.
Cell alignment
37
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.
Cell styles-
38
where the page is taller than it is wide
Portrait orientation
39
where the page is wider than it is tall
Landscape
40
an excel file that stores a spreadsheet
Workbook
41
a worksheet in an excel workbook that contains a chart (a visual representation of spreadsheet data)
Chart sheet
42
– contain more than one operator
Complex formulas
43
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)
Order of precedence
44
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)
Absolute cell references
45
- press it once to change a relative cell reference to an absolute cell reference.
[F4] key
46
- counts the number of cells in a range containing numbers
Count function
47
1. An equal sign 2. The function name 3. A set of parentheses 4. Arguments separated by commas and enclosed in parentheses.
Four parts to every function
48
any time you type an equal sign followed by a letter a list of valid functions and names beginning with that letter appears.
Formula autocomplete
49
a number in a sequential series of numbers. Date series values represent the number of days since January 1, 1900.
Serial value
50
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.
Quick analysis button
51
formatting that is applied to cells in a spreadsheet or fields in a form or report when !specified criteria! are met.
Conditional formatting
52
shading patterns that use two or three colors to show the relative values of a range of cells.
Color scales
53
rows and columns of data with a similar structure. you can analyze, sort, and filter !separately! from other cells in a worksheet.
Table
54
an organized collection of data related to a particular topic or purpose and stored electronically in a file
Database
55
excel table columns (such as Last Name field)
Fields
56
– rows of data in excel (such as a record for each customer)
Records
57
display only the data you need. Shows only rows that meet specific requirements. This does not change the order.
Filter
58
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.
Criteria
59
a visual representation of worksheet data.
Chart
60
horizontal line at base of chart shows categories
Horizontal axis (x-axis)-
61
at left edge of the chart provides values. Sometimes called the value axis
Vertical axis (y-axis)
62
– identify the values on each !axis!
Axis titles
63
a sequence of related numbers that shows a trend
Data series
64
a single chart symbol that represents one value in a data series
Data marker-
65
identifies what each data series represents
Chart legend
66
- vertical and horizontal lines that help identify the value for each data series
Gridlines in the chart
67
– the part of the chart contained within the horizontal and vertical axes
Plot area
68
the entire chart and all the chart elements
Chart area
69
good for comparing values
Column charts
70
compare values across categories with minmal emphasis on time
Bar charts
71
showing trends by category over time
Line charts
72
showing relationships of parts to whole
Pie charts
73
- reason charts are so useful is they make it easy to see trends and draw conclusions from the underlying worksheet data.
TRUE
74
for most charts, you should avoid including totals when selecting worksheet cells.
TRUE
75
you can also move and resize many of the individual components of a chart such as the chart background or legend.
Chart elements or chart objects
76
- enlarges to new dimensions
Sizing handle
77
a predefined arrangement of chart elements
Chart layout-
78
predefined set of chart !colors and fills!
Chart style-
79
- square with paintbrush
Chart styles button
80
- in a chart is a !grid! containing the charts underlying !worksheet data!, which is added below the x-axis in certain type charts.
Data table-
81
a sheet in a workbook that contains only a chart; it contains no worksheet cells.
Chart sheet
82
tiny charts that fit in one cell and illustrate trends in selected cells.
Sparklines
83
you can find headers and footers in the
Page layout view
84
dates are stored as
serial values
85
this is used to highlight or emphasize !certain! information in a worksheet.
Conditional formatting
86
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.
Data bars
87
can be added at the bottom of a table when you want to add totals
total row
88
in a table this is the row at the top that contains column headings
header row
89
a tab that only appears when a particular type of object is selected.
contextual tab
