Brainscape's Knowledge GenomeTM

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


See full index

bus 140 > Excel - Ch 1 > Flashcards

Excel - Ch 1 Flashcards

1
Q

Electronic file that contains grid of columns/rows used to organize related data ; displays results of calculations, enabling interpretation of quantitative data for decision making

A

Spreadsheet

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

Single spreadsheet that typically includes labels, numeric values, formulas, functions, and graphical representations of data

A

Worksheet

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

Collection of 1+ related worksheets; housed within single file to keep organized

A

Workbook

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

Element located below Ribbon, displays address of the current active cell (can use to go to cell, assign name to cell, select function)

A

Name Box

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

Dialogue box that pops up, used to search for & select a function into the active cell

A

Insert Function

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

Below ribbon, right of insert function; shows content of active cell; enter/edit here or in cell directly

A

Formula Bar

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

Letters A - Z, AA - ZZ, etc.

A

Column Headings (Horizontal)

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

Numbers 1 - x

A

Row Headings (Vertical)

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

Current Cell, indicated by a dark green border

A

Active Cell

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

Visual Label, looks like folder tab; can be renamed and coloured

A

Sheet Tab

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

Display at bottom of Excel; shows info of selected command / operation in progress

A

Status Bar

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

Normal. Page Layout, Page Break Preview

A

View Controls

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

Displays worksheet without margins, headings, footers, page breaks

A

Normal View

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

Shows margins, header/footer area, ruler

A

Page Layout View

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

Indicates where worksheet will be divided into pages

A

Page Break View

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

Intersection of columns/row

A

Cell

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

Identified by column letter/row number; unique

A

Cell Address

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

Moves to Cell A1

A

Ctrl+Home

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

Moves to last cell with data

A

Ctrl+End

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

Region in the worksheet to contain formulas dependant on values in input area

A

Output Area

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

Region in worksheet to store & change variables used on calculations

A

Input Area

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

Any combination of letters/numbers/symbols/spaces not used in a calculation

A

Text

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

Searches/Automatically displays any other label in same column that matches

A

Autocomplete

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

Helps you complete sequence of word/values (days, months, other key words)

A

Autofill

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

Small green square in bottom-right corner of active cell

A

Fill Handle

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

Uses data in previous columns as you type in a new label in an adjoining column to determine what to fill in

A

Flash Fill

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

Numbers that represent a quantity or measurable amount; align at right of cell margin

A

Value

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

Combines cell references, arithmetic operations, values, and/or functions used in calculations; use to help analyze how results change as input changes

A

Formulas

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

Order of Operations [ ( ) , ^ , * , / , + , - ]

A

PEDMAS

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

Process of selecting cell/ranges of cells for entering cell references as you create formulas

A

Semi-Selection

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

Horizontal measurements of a column in table worksheet

A

Column Width

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

How to fix ###### in a cell

A

Double Click to AutoAdjust

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

Vertical measurement of row; should always be bigger than font size

A

Row Height

34
Q

Refers to group of adjacent/contiguous cells in a worksheet; may be 1 cell or many long; specified by indicating top left & bottom right cells

A

Range

35
Q

Contains multiple ranges, not connected

A

Nonadjacent Range

36
Q

Paste Options - Formulas but no Formatting

A

Paste Formulas

37
Q

Paste Options - Formula & Number Formatting (Currency, etc.) but not Font

A

Paste Formulas & Number Formatting

38
Q

Paste Options - Cell contents & Formatting from copied cells

A

Paste Keep Source Formatting

39
Q

Paste Options - Cell contents, number formatting, and text except borders

A

Paste No Borders

40
Q

Paste Options - Cell contents, number & text formatting, and column width of source data

A

Paste Keep Source Column Widths

41
Q

Paste Options - Changes data from rows to columns

A

Paste Transpose

42
Q

Paste Options - Unformatted values that are result of formulas (not the formulas)

A

Paste Values

43
Q

Paste Options - Values that are results from formulas (but not the formulas); preserves number but not text formatting

A

Paste Values & Number Formatting

44
Q

Paste Options - Values that are results from formulas (not actual formulas); fa dfjafo ajfl

A

Paste Values & Source Formatting

45
Q

Paste Options - Number & text formatting only from copied cells; no cell contents

A

Paste Formatting

46
Q

Paste Options - Creates reference to source cells, not cell contents; preserves # format but not text format

A

Paste Link

47
Q

Paste Options - Creates picture image of copied data; pasted data is not editable

A

Paste Picture

48
Q

Paste Options - Creates picture with reference to copied cells; changes if original changes

A

Paste Linked Picture

49
Q

Paste Options - Opens special paste dialogue box

A

Paste Special

50
Q

Collection of format settings to provide consistent appearance (font, font colour, font size, borders/fill borders, alignment, number formatting)

A

Cell Style

51
Q

How data is positioned in boundaries of cell; different defaults depending on data (text = left ; dates/values = right)

A

Alignment

52
Q

How to create titles; select the cells you want included

A

Merge (& Center; Across)

53
Q

Specifies position of data between left/right margins

A

Horizontal Alignment

54
Q

Specifies position of data between top/bottom of cell margins (Bottom alignment is default)

A

Vertical Alignment

55
Q

Make data appear on multiple lines

A

Wrap Text

56
Q

Change to offset data from current alignment (left or right)

A

Indent

57
Q

Line that surrounds cell or range of cells; can use to offset data from the rest

A

Border

58
Q

Background colour that displays behind data in cells to standout; should contrast w/ cell font colour

A

Fill Colour

59
Q

Settings that control how value is displayed in cell

A

Number Formats

60
Q

Number Formats : number shows as entered originally (##)

A

Number Formats : General

61
Q

Number Formats : number without comma, with decimal points at end; negatives are -

A

Number Formats : Number

62
Q

Number Formats : has $ and commas where appropriate ; 2 decimal places by default

A

Number Formats : Currency

63
Q

Number Formats : $ is on left margin, separate from the number; 2 decimal places

A

Number Formats : Accounting

64
Q

Number Formats : formatted with comma every 3 digits

A

Number Formats : Comma Style

65
Q

Number Formats : Long Date (October 15th 1990) or Short Date (10/15/1990)

A

Number Formats : Date

66
Q

Number Formats : standard or military

A

Number Formats : Time

67
Q

Number Formats : value as it would be multiplied by 100 with %

A

Number Formats : Percentage

68
Q

Number Formats : number as fraction

A

Number Formats : Fraction

69
Q

Number Formats : number as decimal fraction followed by whole exponent of 10

A

Number Formats : Scientific

70
Q

Number Formats : data left aligned; useful for numerical vales that have leading zeros (address, phone #)

A

Number Formats : Text

71
Q

Number Formats : number w/ editing characters (like hyphens); used for SIN, phone #, etc)

A

Number Formats : Special

72
Q

Number Formats : predefined customized # formats or special symbols; create your own

A

Number Formats : Custom

73
Q

.75” top/bottom ; .70” left/right

A

Margin Defaults

74
Q

Header/Footer Elements : &[Page]

A

Header/Footer Elements : Page #

75
Q

Header/Footer Elements : &[Date]

A

Header/Footer Elements : Current Time

76
Q

Header/Footer Elements : &[Pages]

A

Header/Footer Elements : Display Total # of Pages to Print

77
Q

Header/Footer Elements : &[File]

A

Header/Footer Elements : Displays File Name

78
Q

Header/Footer Elements : &[Path] &[File]

A

Header/Footer Elements : Displays File Path & Name

79
Q

Header/Footer Elements : &[Tab]

A

Header/Footer Elements : Displays Sheet Tab Name

80
Q

Header/Footer Elements : &[Picture]

A

Header/Footer Elements : Display & Print Picture as Background

bus 140 (18 decks)

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