Brainscape's Knowledge GenomeTM

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


See full index

IS1403 - Excel 2016 > Chapter 1 > Flashcards

Chapter 1 Flashcards

1
Q

Cell References

A

Cell address in a formula

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

Types of cell references

A

Relative: adjusts to new location when formula is copied
Absolute: non-changing

Mixed Row: A$1 (rows are marked by #)
Mixed Column: $A1 (columns are marked by letters)

Shortcut for absolute/ adding $ sign: F4
Default: relative

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

Functions

A

Pre-programmed shortcuts for calculating equations

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

Function inputs

A

Arguments = values in calculations = cell reference

Multiple arguments are separated by comma [,]
Range can be written by using semi-colon [:]

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

Function data entry format

A

=FunctionName(argument, argument,) - Enter

=SUM(B1,B2)

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

Quick Analysis Tool

A 
Calculates totals down the column / across rows
5 functions: 
Sum
Average
Count
% Total
Running Total
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Workbook

A

An Excel file made of a collection of worksheets

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

Worksheet

A

An electronic ledger where you enter data. It’s made of rows (#) and columns (letters).

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

Cell address

A

A cell at the intersection of column and row

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

Cell range

A

Contiguous group of cells.
START: upper L corner
RANGE: range followed by a colon
END: lower R corner

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
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
12
Q

Name box

A

L side of the formula bar

Displays the address of the selected cell or the name of cells range

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

Status bar

A

Appears at the bottom of the worksheet grid

Can display information about selected data, including the number of cells selected that contain data, count, the average in the sum total

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

Protected view

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
15
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
16
Q

Trusted document

A

The 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
17
Q

Ready mode

A

The data entry method used to change the contents of the ENTIRE cell by clicking on the cell once and then typing in the data

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

Edit mode

A

The data entry method used to change a 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
19
Q

General number format

A

R-aligned
does not maintain a consistent number of decimal places (43.00 - 43, 42.25- 42.25) and does not display commas (1,2345- 12345)

20
Q

Accounting number format

A 
$ 
L aligned
Displays 2 places after decimal
Aligns all numbers at the decimal
0 amounts are displayed as dashes (-)
21
Q

Percent style format

A

% with zero places to the right of the decimal point

22
Q

Comma style format

A

Similar to the Accounting format but without the currency symbol

23
Q

Number format

A

Shows 2 decimal places by default but does not include commas (43 - 43.00)

24
Q

Currency format

A

$ immediately to the L of the number

Column of # do not align at the $ and the decimal as they do the Accounting

25
Q

Short date format

A

M/D/YYYY

26
Q

Long date format

A

Weekday, Month DD, YYYY

27
Q

Auto fill

A

Fills a group of cells with the same data or extends data series

28
Q

Fill handle tool

A

Appears at the lower Rcorner of a selected cell or group of cells and can be used to implement the auto fill feature

29
Q

Data series

A

A sequence of cells with a recognizable pattern (used with the auto fill feature)

30
Q

Formula

A

An equation used to calculate the value

31
Q

Order of operations (precedence)

A

A mathematical rule stating that mathematical operations in the formula are calculated in this order:

1) exponents and roots
2) multiplication and division
3) addition and subtraction

32
Q

Cell Reference

A

Cell’s address where it is referred in a formula

33
Q

Relative reference

A

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

34
Q

Absolute reference

A

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

35
Q

Mixed reference

A

A combination cell reference of the row position that stays constant with a changing column position (or vice versa)

36
Q

Function

A

Pre-programmed shortcuts for calculating complex equations (like the average of a group of numbers)

37
Q

Argument

A

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

38
Q

AutoSum

A

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

39
Q

Quick analysis tool

A

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

40
Q

Status bar

A

Appears at the bottom of the worksheet and can display information about the selected data

41
Q

Zoom slider

A

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

42
Q

Template

A

A file with pre-defined settings that can be used as a pattern to create a new file

43
Q

Tiled window arrangement

A

Places the window in a grid pattern

44
Q

Horizontal window arrangement

A

Places the window in a row next to each other

45
Q

Vertical window arrangement

A

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

46
Q

Cascade window

A

Places windows in a staggered, overlapping diagonal arrangement

47
Q

SHORTCUTS

A

F4 - changes cell reference

F7 - Spell checker

IS1403 - Excel 2016 (1 decks)

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