Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

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
Small green square in bottom-right corner of active cell
Fill Handle
26
Uses data in previous columns as you type in a new label in an adjoining column to determine what to fill in
Flash Fill
27
Numbers that represent a quantity or measurable amount; align at right of cell margin
Value
28
Combines cell references, arithmetic operations, values, and/or functions used in calculations; use to help analyze how results change as input changes
Formulas
29
Order of Operations [ ( ) , ^ , * , / , + , - ]
PEDMAS
30
Process of selecting cell/ranges of cells for entering cell references as you create formulas
Semi-Selection
31
Horizontal measurements of a column in table worksheet
Column Width
32
How to fix ###### in a cell
Double Click to AutoAdjust
33
Vertical measurement of row; should always be bigger than font size
Row Height
34
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
Range
35
Contains multiple ranges, not connected
Nonadjacent Range
36
Paste Options - Formulas but no Formatting
Paste Formulas
37
Paste Options - Formula & Number Formatting (Currency, etc.) but not Font
Paste Formulas & Number Formatting
38
Paste Options - Cell contents & Formatting from copied cells
Paste Keep Source Formatting
39
Paste Options - Cell contents, number formatting, and text except borders
Paste No Borders
40
Paste Options - Cell contents, number & text formatting, and column width of source data
Paste Keep Source Column Widths
41
Paste Options - Changes data from rows to columns
Paste Transpose
42
Paste Options - Unformatted values that are result of formulas (not the formulas)
Paste Values
43
Paste Options - Values that are results from formulas (but not the formulas); preserves number but not text formatting
Paste Values & Number Formatting
44
Paste Options - Values that are results from formulas (not actual formulas); fa dfjafo ajfl
Paste Values & Source Formatting
45
Paste Options - Number & text formatting only from copied cells; no cell contents
Paste Formatting
46
Paste Options - Creates reference to source cells, not cell contents; preserves # format but not text format
Paste Link
47
Paste Options - Creates picture image of copied data; pasted data is not editable
Paste Picture
48
Paste Options - Creates picture with reference to copied cells; changes if original changes
Paste Linked Picture
49
Paste Options - Opens special paste dialogue box
Paste Special
50
Collection of format settings to provide consistent appearance (font, font colour, font size, borders/fill borders, alignment, number formatting)
Cell Style
51
How data is positioned in boundaries of cell; different defaults depending on data (text = left ; dates/values = right)
Alignment
52
How to create titles; select the cells you want included
Merge (& Center; Across)
53
Specifies position of data between left/right margins
Horizontal Alignment
54
Specifies position of data between top/bottom of cell margins (Bottom alignment is default)
Vertical Alignment
55
Make data appear on multiple lines
Wrap Text
56
Change to offset data from current alignment (left or right)
Indent
57
Line that surrounds cell or range of cells; can use to offset data from the rest
Border
58
Background colour that displays behind data in cells to standout; should contrast w/ cell font colour
Fill Colour
59
Settings that control how value is displayed in cell
Number Formats
60
Number Formats : number shows as entered originally (##)
Number Formats : General
61
Number Formats : number without comma, with decimal points at end; negatives are -
Number Formats : Number
62
Number Formats : has $ and commas where appropriate ; 2 decimal places by default
Number Formats : Currency
63
Number Formats : $ is on left margin, separate from the number; 2 decimal places
Number Formats : Accounting
64
Number Formats : formatted with comma every 3 digits
Number Formats : Comma Style
65
Number Formats : Long Date (October 15th 1990) or Short Date (10/15/1990)
Number Formats : Date
66
Number Formats : standard or military
Number Formats : Time
67
Number Formats : value as it would be multiplied by 100 with %
Number Formats : Percentage
68
Number Formats : number as fraction
Number Formats : Fraction
69
Number Formats : number as decimal fraction followed by whole exponent of 10
Number Formats : Scientific
70
Number Formats : data left aligned; useful for numerical vales that have leading zeros (address, phone #)
Number Formats : Text
71
Number Formats : number w/ editing characters (like hyphens); used for SIN, phone #, etc)
Number Formats : Special
72
Number Formats : predefined customized # formats or special symbols; create your own
Number Formats : Custom
73
.75" top/bottom ; .70" left/right
Margin Defaults
74
Header/Footer Elements : &[Page]
Header/Footer Elements : Page #
75
Header/Footer Elements : &[Date]
Header/Footer Elements : Current Time
76
Header/Footer Elements : &[Pages]
Header/Footer Elements : Display Total # of Pages to Print
77
Header/Footer Elements : &[File]
Header/Footer Elements : Displays File Name
78
Header/Footer Elements : &[Path] &[File]
Header/Footer Elements : Displays File Path & Name
79
Header/Footer Elements : &[Tab]
Header/Footer Elements : Displays Sheet Tab Name
80
Header/Footer Elements : &[Picture]
Header/Footer Elements : Display & Print Picture as Background

BUS 140 (18 decks)

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