Brainscape's Knowledge GenomeTM

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


See full index

ADM 1340 - App Tech Business > Module 2 - EXCEL > Flashcards

Module 2 - EXCEL Flashcards

1
Q

Spreadsheet

A

A grid of rows and columns in which you enter text, numbers, and the results of calculations.

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

Worksheet

A

A computerized spreadsheet, that may contain data include, text, numbers, formulas, charts, etc.

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

Workbook

A

a collection of related worksheets

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

status bar

A

Displays information about the selected command or operations in progress

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

Cell

A

an intersecting column (letter) and intersecting row (number) such as A5 or $A$5

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

Range

A

a set of cells described by the top left most cell of desired cells to the bottom right most cell of desired cell. (A1:B5 or $A$1:$B$5)

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

Relative References

A

used when you want to referenced cell to change along with the formula being copied from one place to another in a worksheet (A5 or A5:B6)

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

Absolute References

A

used when you want the referenced cells to remain the same when the formula is being copied from one place to another in a worksheet ($A$5 or $A$5:$B$6)

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

Mixed References

A
  • $A5 where the column will not change when copied, but the row will change.
  • A$5 where the column will change when copied, but the row will not change.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Auto Fill

A

An Excel feature that automatically fill cells with data, formatting, or both. By dragging the “fill handle” over adjacent cells

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

Functions

A

predefined worksheet formulas that enable you to perform complex calculations easily

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

Sorting

A

arranging data it in a certain order such as alphabetic or numeric

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

Filtering Data

A

the process of displaying only records that meet specific conditions

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

Flash Fill

A

A new feature in Excel that is similar to AutoFill.
When Excel recognizes a pattern based on other information in your workbook, it uses the pattern to enter data into several cells at once.

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

Filtering Unique Values

A

a data delivery function which is used to filter and deliver unique values from a list

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

Data Delivery Functions

A

These functions can be used to verify data, search for data, transform data or deliver data from one point to another, however they do not perform calculations.

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

Data Validation

A

A set of rules that determine what users can enter in a specific cell or range. Often used to create dropdown menus

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

lookup functions

A

used to retrieve values from a table based on lookup values

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

Lookup Tables

A

Tables containing data that computer programs can develop and use to simplify and shorten data entry

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

Subtotals

A

used to summarize a list of data after the list of data has been sorted by the field which you wish to use

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

Grouping

A

Organizing data so it can be viewed as a collapsible and expandable outline.

22
Q

Heuristics

A

Methods used to speed up the process of finding a good enough solution, where an exhaustive search or advanced problem-solving techniques are impractical.

23
Q

Logical test

A

Any expression that can be evaluated and returns as logical values. (true or false.)

24
Q

Logical Function

A

AND, OR, NOT functions are examples of this kind of function:

25
Q

AND Function

A

this logical function allows you to test the condition of more than one criterion and only returns true if all tested conditions are true

26
Q

OR Function

A

a logical function that returns a TRUE value if any of the logical conditions are true, and a FALSE value if none of the logical conditions are true

27
Q

NOT Functions

A

used when you want to make sure a value is not equal to one particular value

28
Q

Conditional Functions

A

Results of this functions may be a specified value or a calculated value (including IF, Count IF, SUM IF, Average IF)

29
Q

IF functions

A

evaluates whether a condition or a logical test is true or false and returns one value if the condition is true and another value if the condition is false

30
Q

Nested IF Function

A

when one IF function is placed inside another IF function to test an additional condition

31
Q

COUNT IF FUNCTION

A

Returns the number of cells in a range that meet a condition set forth in a formula

32
Q

SUM IF FUNCTION

A

used to calculate the total for a set of values that match a specific criterion

33
Q

AVERAGE IF FUNCTION

A

used to calculate the average for a set of values that match a specific criterion

34
Q

Types of Models (4)

A

Mental, Visual, Physical, Mathematical

35
Q

Models def (what they are)

A

Simplified versions of what they are representing

36
Q

A Computer Model

A

A set of mathematical relationships and logical assumptions implemented in a computer as a representation of some real-world object or phenomenon (ex. Spreadsheets)

37
Q

Decisions, Outcomes, structure, and data are components of :

A

Modelling Approach to Problem solving

38
Q

the percentage of all spreadsheets that have errors that affect their results

A

90%

39
Q

Dashboards

A

Reporting mechanisms that aggregate and display metrics and key performance indicators. helpful in decision making

40
Q

Types of Dashboards (3)

A

strategic, analytical, operational

41
Q

Strategic Dashboard

A

Provides an overview of an organization. Easy to access and read computer program that integrates a variety of performance measures into one display, usually with graphs or charts.

42
Q

Analytical Dashboards

A

support sophisticated data analysis by facilitating rich comparisons and fine-grained performance evaluations

43
Q

Operational Dashboards

A

uses simple display media to quickly identify and understand events and to ensure timely responses

44
Q

which dashboards are most common through the use of excel

A

Strategic

45
Q

Types of Visualization and Display Media for Dashboards

A

highlighted text, summarized text, Icons, Graphs, charts, and sparklines

46
Q

Charts

A

Graphic representation that present information in easily interpreted formats

47
Q

Conditional Formatting

A

Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.

48
Q

What-if analysis

A

changing a cells value to see how it will affect the formulas in the worksheet

49
Q

Goal seek

A

A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.

50
Q

Solver

A

An add-in application that manipulates variables based on constraints to find the optimal solution to a problem.

ADM 1340 - App Tech Business (5 decks)

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