Brainscape's Knowledge GenomeTM

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


See full index

Computer-Based Data Systems > Excel Ch 1 > Flashcards

Excel Ch 1 Flashcards

1
Q

Workbook

A

An Excel file made up of a collection of worksheets.

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

Worksheet

A

An electronic ledger where you enter data in Excel (also called a sheet). The worksheet appears as a grid made up of rows and columns where you can enter and then manipulate data using functions, formulas, and formatting

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

Row

A

A horizontal group of cells. Rows are identified by numbers. Fro example, the third row is labeled with the number 3.

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

Column

A

A vertical group of cells. Columns are identified by letters. For example, the fourth column is labeled with the letter D.

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

Cell

A

The intersection of a row and column in a spreadsheet.

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

Cell Address

A

The column and row position that defines a cell. For example, the cell at the intersection of column B and Row 4 has a cell address of B4.

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

Cell range

A

A contiguous group of cells. A cell range is identified by the address of the cell in the upper left corner of the range, followed by a colon, and then the address of the cell in the lower right corner of the range. The cell range B3:D5 includes cells B3, B4, B5, C3, C4, C5, D3, D4, and D5.

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

Formula bar

A

Data entry area directly below the Ribbon and above the worksheet grid.

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

Name box

A

Appears at the left side of the formula bar and displays the address of the selected cell or the name of a named range.

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

Status bar

A

Appears at the bottom of the worksheet grid and can display information about the selected data, including the number of cells selected that contain data (count) and the average and sum (total) of the selected values (when appropriate).

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

Vertical scroll bar

A

The scrollbar located along the right side of the window. Click the arrows at the ends of the scroll bars to move up and down to see more cells in an individual worksheet.

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

Horizontal scroll bar

A

The scrollbar located at the bottom of the window. Click the arrows at the ends of the scroll bars to move left and right to see more cells in an individual worksheet.

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

Row selector

A

The box with the row numbers at the left side of the worksheet grid. Clicking this box will select the entire row.

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

Column selector

A

The box with the column letter at the top of the worksheet grid. Clicking this box will select the entire column.

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

Protected View

A

Provides a read-only format that protects your computer from becoming infected by a virus or other malware.

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

Message Bar

A

Displays a warning at the top of the window, below the ribbon, when a file is opened in Protected View.

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

Trusted Document

A

A document originally displayed in Protected View that has been marked as safe for editing.

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

Ready mode

A

The data entry method used in Excel to change the contents of the entire cell by clicking the cell once and then typing the data.

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

Edit mode

A

the data entry method used in Excel to change only part of the cell data by double-clicking the cell, and then moving the cursor within the cell to insert or delete data.

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

General number format

A

Number format that right-aligns numbers in the cells but does not maintain a consistent number of decimal places (43.00 appears as 43, while 42.25 stays 42.25) and does not display commas (so 1,123,456 appears as 1123456).

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

Accounting Number Format

A

Aligns the $ at the left side of the cell, displays two places after the decimal, and aligns all numbers at the decimal point. Zero amounts are displayed as dashes (-).

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

Percent Style format

A

Displays numbers as % with zero places to the right of the decimal point.

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

Comma Style format

A

Number format similar to the Accounting Number Format, but without the currency symbol.

24
Q

Number format

A

An Excel cell format that stores data as numbers and shows two decimal places by default (so 43 displays as 43.00) but does not include commas.

25
Q

Currency format

A

Number format that places the $ immediately to the left of the number, so columns of numbers do not align at the $ and at the decimal as they do with Accounting Number Format.

26
Q

Short Date format

A

Displays as (1/24/2025).

27
Q

Long Date format

A

Displays as (Friday, January 24, 2025).

28
Q

AutoFill

A

Feature used to fill a group of cells with the same data or to extend a data series.

29
Q

Fill Handle tool

A

Appears at the lower-right corner of a selected cell or group of cells and can be used to implement the AutoFill feature.

30
Q

Data series

A

A sequence of cells with a recognizable pattern (used with the AutoFill feature).

31
Q

Chart

A

A graphic that represents numeric data visually.

32
Q

Data points

A

Values from a cell range plotted on a chart.

33
Q

Data markers

A

Columns, bars, pie pieces, or other visual elements in a chart that represent data point values.

34
Q

Data series (chart)

A

A group of related data points plotted on a chart.

35
Q

Y axis

A

The vertical axis in a chart. It goes from bottom to top.

36
Q

X axis

A

The horizontal axis in a chart. It goes from left to right.

37
Q

Plot area

A

The area of the chart where the data series are plotted.

38
Q

Chart area

A

Encompasses the entire chart including the plot area and optional layout elements, such as title and legend.

39
Q

Chart title

A

A text box above or overlaying the chart.

40
Q

Legend

A

A key for a chart defining which data series is represented by each color.

41
Q

Formula

A

an equation used to calculate a value.

42
Q

Order of Operations (precedence)

A

A mathematical rule stating that mathematical operations in a formula are calculated in this order (1) exponents and roots, (2) multiplication and division, and (3) addition and subtraction.

43
Q

Cell reference

A

A cell’s address when it is used in a formula

44
Q

Relative reference

A

A cell reference that adjusts to the new location in the worksheet when the formula is copied.

45
Q

Absolute reference

A

A cell reference whose location remains constant when the formula is copied. the $ character before a letter or number in the cell address means that part of the cell’s address is absolute (non-changing).

46
Q

Mixed reference

A

A combination cell reference with a raw position that stays constant with a changing column position (or vice versa).

47
Q

Function

A

Preprogrammed shortcuts for calculating complex equations (like the average of a group of numbers).

48
Q

Argument

A

The part of the formula (input) that the function uses to calculate a value.

49
Q

AutoSum

A

Allows you to insert common functions (SUM, AVERAGE, COUNT, MIN, and MAX) with a single mouse click.

50
Q

Quick Analysis tool

A

Feature that helps you easily apply formatting, create charts, and insert formulas based on the selected data.

51
Q

Zoom slider

A

Slider bar that controls how large or small the file appears in the application window.

52
Q

Template

A

A file with predefined settings that can be used as a pattern to create a new file.

53
Q

Tiled window arrangement

A

Places the windows in a grid pattern.

54
Q

Horizontal window arrangement

A

Places the windows in a row next to each other.

55
Q

Vertical window arrangement

A

Places the windows in a stack one on top of the other.

56
Q

Cascade window arrangement

A

Places the windows in a staggered, overlapping, diagonal arrangement.

Computer-Based Data Systems (2 decks)

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