Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Business 140 > Excell > Flashcards

Excell Flashcards

(101 cards)

Start Studying
1
Q

Spread Sheet

A

Electronic file that contains a grid of columns and rows used to orginize related data

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

Worksheet

A

Single spreadsheet that ususaly contains descriptive labels, numeric values, functions, etc..

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

Workbook

A

Collection of one or more related worksheets contained within a single file

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

Cell

A

Intersection of columns and rows

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

Cell Address

A

Unique description designated by a cell’s letter and number

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

Input Area

A

Specific region on a worksheet to store and change variables used in calculations

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

AutoComplete

A

Feature that searches for and automatically shows any other label in the same column that matches your search input

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

Auto Fill

A

Feature that helps complete a sequence of words or values

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

Fill Handle

A

Small green square in bottom right corner of the active cell

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

Values

A

Numbers that represent a quantity or measurable amount

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

Formula

A

Combine cell refrences, arithmatic, operations, values, and/or functions used in various calculations

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

Order of Operations

A

rules that control the sequence in which arithmetic operations are carried out

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

Semi-selection or Pointing

A

Selecting a cell or range for entering cell refrences

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

Column Width

A

Horizontal measurement of a column in a table or a worksheet

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

Row Height

A

Vertical measurement of the row

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

Nonadjacent Range

A

Containment of multiple ranges, to apply formatting

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

Cell Style

A

Collection of format settings to provide a consistant appearance within a worksheet

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

Alignment

A

How data is positioned in the boundaries of a cell

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

Horizontal Alignment

A

Position of data between the left and right margins

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

Vertical Alignment

A

Position of data between the top and bottom margins

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

Wrap Text

A

Makes data appear on multiple lines by adjusting row height

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

Indent

A

Offsets the cell contents from the current alingment

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

Border

A

Line that surrounds a cell or range

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

Fill color

A

Background color that displays behind the data in a cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Number Formats
Control how a value is displayed in a cell
26
General Format
A number as it was originally entered, in Integers
27
Number Format
A number with or without the 1,000 (comma separator) and with any number of decimal places
28
Comma Style Format
A number formatted with a comma for every 3 digits on the left side of the decimal and only 2 decimal points
29
Percent Style Format
Value as if it were a percent of 100
30
Relative Cell Refrence
A cell's relative location from the cell containing the formula
31
Absolute Cell Refrence
Constant reference to a specific cell, appears as two $B$6 in a formula and remains unchanged during the calculations
32
Mixed Cell Reference
Combination of an absolute and retaliative cell refrence
33
Function
Predefined computation that simplifies creating formulas
34
Syntax
Rules that dictate the structure and components required to preform calculations
35
Arguments
Specify inputs required to complete the operation
36
Function Screen Tip
Pop-Up that displays the functions's arguments
37
SUM
Totals values in one or morwe cells and displays results in the cell containing the function
38
AVERAGE
Calculates the arithmetic mean or average for the values in a range of cells
39
MEDIAN
Finds the midpoint value in a data set
40
MIN & MAX
Finds the smallest and largest values respectively
41
COUNT
Tallies the number of cells in a range containing numerical values
42
COUNTBLANK
Tallies the number of cells in a range that are blank
43
COUNTA
Tallies the number of cells in a range that aren't blank
44
Quick Analysis
Set of analytical tools used to apply formatting, create charts, insert basic functions, etc..
45
TODAY
Displays current date in the cell containing the function
46
NOW
Uses the computer's clock to display the current date and 24hr time in the cell containing the function
47
IF
Tests specified criteria if it's true or false, then returns one value when a condition is met, or is false
48
Logical test
Contains either a value or expression that evaluates to true or false
49
VLOOKUP
Accepts a value, looks for the value in the left column of a specified table array, and and returns another values located in the same row from a specified column
50
Lookup Value
Cell reference of the cell that contains the value to look up
51
Table Array
Range containing the lookup table
52
Column Index Number
Column number in the lookup table that contains the return values
53
Range_lookup
Argument determining how the VLOOKUP function handles lookup values that aren't an exact match
54
Lookup Table
Range containing a table of values and text from which data can be retrieved
55
Breakpoint
Lowest value for a category or series
56
HLOOKUP
Horizontal lookup table where first row contains the values or breakpoints
57
PMT
Calculates payments for a loan with a fixed amount at a fixed periodic rate for a fixed period of time
58
Rate
Interest rate per payment period
59
Nper
Total amount of payment periods
60
Pv
Present value of a loan
61
Data point
A cell in a spreadsheet containing a value
62
Data Series
A group of related data points displayed in a row or column
63
Category Axis
Axis that displays descriptive labels for data points plotted in a chart
64
Value Axis
Displays incremental numbers identifying approximate values of data points in a chart
65
Quick Analysis
Displays thumbnails of recommended charts based on the data a user has selected
66
Insert Tab
Contains commands for creating a variety of charts
67
Column Chart
compares values across categories, IE: Job titles or creating vertical Columns
68
Clustered Column Chart
Compares groups or clusters of columns set side by side
69
Stacked Column Chart
Shows relationship of individual data points to the whole catagory
70
100% Stacked Column Chart
Converts individual data points into percentages of the total value.
71
Bar Chart
Compares values across categories using horizontal bars
72
Line Chart
Displays lines connecting data points to show trends over equal time periods
73
Pie Chart
Shows each data point as a proportion to the whole data series; as a circle with slices pertaining to data points
74
Combo Chart
Combining two chart types; like Column and Line
75
X Y (scatter) Chart
Shows the relationship between two numerical variables using their X and Y coordinates
76
Stock Chart
Shows fluctuations in stock prices
77
Chart Element
Component that helps explain or completes the chart
78
Exploded Pie Chart
A specialized pie chart that draws attention to a specific piece, by separating 1 or more slices from the rest of the chart.
79
Chart Style
A collection of formatting that controls; the color of the chart area, plot area, and data series.
80
Chart Filter
Controls which data series and categories are visible in a chart
81
Sparkline
Small line, column, or win/loss chart contained in a single cell.
82
Freezing
Process of keeping rows and coulombs visible onscreen at all times
83
Page Break
Indicates where data will start on another printed page.
84
Print Area
Specific range of cells that will print on a sheet.
85
Print Order
Sequence in which the pages in a sheet are printed
86
Table
A structured range that contains related data, organized in a method that increases the ability to manage and analyze information.
87
Data Structure
Organization method used to manage multiple data points within a a data set.
88
Field
A column that represents an individual piece of data
89
Record
Collection of related data about one entity
90
Table Styles
Controls the fill color of the header row and rows of records
91
Structured Refrence
A tag or use of a table element such as a field heading, as a reference in a formula
92
Unqualified Reference
Use of field headings without row references in a structured formula
93
Fully qualified structured refrence
Structured formula that includes references such as; table name.
94
Sorting
Arranging records by the value of one or more fields within a table
95
Filtering
Specifying conditions to display only those records that meet certain conditions
96
Conditional Formatting
Application of special formatting to highlight or emphasize cells that meet specific criteria
97
Total Row
Displays below the last row of records in an Excel table and enables you to display summary statistics
98
SUBTOTAL Function
Calculates an aggregate value such as totals or averages in a range, table, or database
99
Data Bars
Apply a gradient or solid fill bar in which the width of the bar represents the current cell's value compared relatively to other cells
100
Color Scales
Format cells with different colors based on the relative value of a cell
101
Icon sets
Symbols or signs that classify data into 3, 4, or 5 categories based on data in a range

Business 140 (4 decks)

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