Brainscape's Knowledge GenomeTM

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


See full index

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
Q

Identifies that shows the exact value of a cell

A

Data label

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

Group of related data points

A

Data series

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

Office setting that remain in effect

A

Default

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

Character used to separate data a text file

A

Delimiter

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

Software application used to organize records,financial information in the form of worksheets.

A

Excel

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

Smallest data element in a table

A

Field

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

Directory into which you place data files

A

Folder

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

A formula that use the equal sign

A

Formula

33
Q

Shows the content of the active cell

A

Formula bar

34
Q

Process of keeping rows

A

Freezing

35
Q

Predefined computation that simplifies creating a complex calculation

A

Function

36
Q

Tool that identifies the necessary input value

A

Goal seek

37
Q

Tabular display of data frequencies

A

Histogram

38
Q

Electronic market to another location

A

Hyperlink

39
Q

Logical function that evaluates a condition

A

IF function

40
Q

Orientation that’s wider

A

Landscape

41
Q

An office feature that provides a preview

A

Live preview

42
Q

Expression that evaluate true or false

A

Logical test

43
Q

Set of instructions that tells excel which commands

A

Macro

44
Q

Statistical function that finds the highest value

A

MAX function

45
Q

Finds the lowest value

A

MIN function

46
Q

An identifier that display the address or range

A

Name box

47
Q

Default view of a document

A

Normal view

48
Q

Software that direct computer activities

A

Operating System(OS)

49
Q

Set of rules that determine the sequence

A

Order of operations

50
Q

Data will start on another printed page

A

Page break

51
Q

Shows worksheet data and page break break

A

Page break preview

52
Q

The process of placing a cut item in another location

A

Paste

53
Q

A chart that shows each data point as a slice in a circle

A

Pie chart

54
Q

Financial function in Excel

A

PMT Function

55
Q

Orientation For displayed page;taller

A

Portrait

56
Q

Creat dynamic presentations

A

PowerPoint

57
Q

Range of cells within a worksheet

A

Print area

58
Q

Sequence which the page are printed

A

Print order

59
Q

Calculates the present value

A

PV function

60
Q

A group of adjacent cells

A

Range

61
Q

Group of fields

A

Record

62
Q

Connection btw two or more tables

A

Relationship

63
Q

The long bar of tabs

A

Ribbon

64
Q

Visual element that shows a name of a worksheet

A

Sheet tab

65
Q

Using snipping tool

A

Snip

66
Q

Provides the ability to capture an image

A

Snipping tool

67
Q

Electronic file that contains a grid of columns

A

Spreadsheet

68
Q

Calculates the total of values

A

SUM function

69
Q

Calculates the total of a range of values

A

SUMIF function

70
Q

A component of the ribbon

A

Tab

71
Q

Object used to store and organize data

A

Table

72
Q

Collection of designs

A

Theme

73
Q

Identifies the current file name

A

Title bar

74
Q

Switching from one setting to another

A

Toggle

75
Q

Changing variables observe how change affect calculated results

A

What-if analysis

76
Q

Word processing software application

A

Word

77
Q

Collection of one or more worksheets

A

Workbook

78
Q

A single spreadsheet that contains descriptive lables

A

Worksheets

79
Q

Makes data appear on multiple lines

A

Wrap text

Electronic Spreadsheet (2 decks)

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