Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

Electronic Spreadsheet > Vocab Finals > Flashcards

Vocab Finals Flashcards

1
Q

relational database management software

A

Acess

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

The current cell in a worksheet

A

Active Cell

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

A program that can be added

A

Add-in

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

placement of data within cell boiundaries

A

Alignment

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

A feature that enable you to copy the content of a cell

A

Auto Fill

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

A statistical function that calculate mean or average

A

AVERAGE Function

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

A function that calculate the average

A

AVERAGE IF function

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

copy of a file

A

backup

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

line that surrounds a cell

A

border

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

insertion of a column and row

A

cell

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

unique identifier of a cell

A

cell address

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

set of formatting options

A

cell style

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

visual representation of numerical datea

A

chart

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

electronic illustration

A

clip art

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

temporarily holds selections that have been cut or stored

A

clipboard

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

Pointer to a cell in another worksheet

A

3-D reference

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

Used to store files

A

Cloud storage

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

A number format values with commas

A

Comma style

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

A text file that uses commas

A

Comma separated value(CSV) file

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

A tool that detect data that’s not compatible with previous versions

A

Compatibility checker

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

Process of duplicating an item from the original location

A

Copy

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

Statistical function that tallies the number of cells in a range

A

COUNTA function

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

A statistical function that counts the number of cells

A

COUNTIF function

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

Process of removing an item from the original location

A

Cut

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Identifies that shows the exact value of a cell
Data label
26
Group of related data points
Data series
27
Office setting that remain in effect
Default
28
Character used to separate data a text file
Delimiter
29
Software application used to organize records,financial information in the form of worksheets.
Excel
30
Smallest data element in a table
Field
31
Directory into which you place data files
Folder
32
A formula that use the equal sign
Formula
33
Shows the content of the active cell
Formula bar
34
Process of keeping rows
Freezing
35
Predefined computation that simplifies creating a complex calculation
Function
36
Tool that identifies the necessary input value
Goal seek
37
Tabular display of data frequencies
Histogram
38
Electronic market to another location
Hyperlink
39
Logical function that evaluates a condition
IF function
40
Orientation that's wider
Landscape
41
An office feature that provides a preview
Live preview
42
Expression that evaluate true or false
Logical test
43
Set of instructions that tells excel which commands
Macro
44
Statistical function that finds the highest value
MAX function
45
Finds the lowest value
MIN function
46
An identifier that display the address or range
Name box
47
Default view of a document
Normal view
48
Software that direct computer activities
Operating System(OS)
49
Set of rules that determine the sequence
Order of operations
50
Data will start on another printed page
Page break
51
Shows worksheet data and page break break
Page break preview
52
The process of placing a cut item in another location
Paste
53
A chart that shows each data point as a slice in a circle
Pie chart
54
Financial function in Excel
PMT Function
55
Orientation For displayed page;taller
Portrait
56
Creat dynamic presentations
PowerPoint
57
Range of cells within a worksheet
Print area
58
Sequence which the page are printed
Print order
59
Calculates the present value
PV function
60
A group of adjacent cells
Range
61
Group of fields
Record
62
Connection btw two or more tables
Relationship
63
The long bar of tabs
Ribbon
64
Visual element that shows a name of a worksheet
Sheet tab
65
Using snipping tool
Snip
66
Provides the ability to capture an image
Snipping tool
67
Electronic file that contains a grid of columns
Spreadsheet
68
Calculates the total of values
SUM function
69
Calculates the total of a range of values
SUMIF function
70
A component of the ribbon
Tab
71
Object used to store and organize data
Table
72
Collection of designs
Theme
73
Identifies the current file name
Title bar
74
Switching from one setting to another
Toggle
75
Changing variables observe how change affect calculated results
What-if analysis
76
Word processing software application
Word
77
Collection of one or more worksheets
Workbook
78
A single spreadsheet that contains descriptive lables
Worksheets
79
Makes data appear on multiple lines
Wrap text

Electronic Spreadsheet (2 decks)

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