Brainscape's Knowledge GenomeTM

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


See full index

LIT > Lesson 1 and 2: Spreadsheet > Flashcards

Lesson 1 and 2: Spreadsheet Flashcards

1
Q

scans data horizontally (down columns)

A

HLOOKUP

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

is simply a name you assign to a range of data and is much easier to remember than a cell address.

A

Range Name

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

are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure.

A

Functions

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

Structure of Function

A

The structure of a function begins with an equal sign (=), followed by the function name, an opening parenthesis, the arguments for the function separated by commas, and a closing parenthesis.

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

For a list of available functions, click a cell and press ________, which will launch the Insert Function dialog.

A

SHIFT + F3

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

can be numbers, text, logical values such as TRUE or FALSE, arrays, error values such as #N/A, or cell references.

A

Arguments

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

To enter a formula with a function, you need to do the following.

A
  1. Start the formula with an equal sign.
  2. Select or enter the function you want to use.
  3. Select or enter the arguments.
  4. Enter the completed formula
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

This function is used to describe quantities of data.

A

STATISTICAL FUNCTION

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

This function adds all of the values of the cells in the argument.

A

SUM

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

This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.

A

AVERAGE

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

This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range

A

COUNT

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

This function determines the highest cell value included in the argument.

A

MAX

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

This function determines the lowest cell value included in the argument.

A

MIN

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

These are the building blocks for creating intelligent and automated spreadsheets.

A

LOGICAL FUNCTION

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

evaluates a logical test and displays a specific value based on the outcome (TRUE or FALSE). It allows for conditional formatting based on set criteria.

A

IF Function

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

returns TRUE only if ALL of its arguments are TRUE. It is used to combine multiple conditions into a single logical statement.

A

AND function

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

returns TRUE if ANY of its arguments are TRUE. It allows for a more flexible approach to checking conditions.

A

OR function

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

reverses the logical state of its argument. It is used to negate a condition.

A

NOT function

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

This function is a valuable tool for handling errors that might arise when using formulas. It allows you to display a custom message or value instead of the default error code, making your spreadsheets more user-friendly and informative.

A

IFERROR Function

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

These functions are powerful tools that allow you to perform complex calculations, analyze data, and solve problems with ease.

A

MATHEMATICAL AND TRIGONOMETRY

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

Calculates the natural logarithm (base-e) of a number. Used in scientific and financial calculations.

A

LN Function:

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

Determines the square root of a positive number. Useful for calculating distances, area, and volumes.

A

SQRT Function:

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

Identifies the most frequent value within a dataset. Helps analyze data trends and identify common occurrences.

A

MODE Function

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

Raises a number to a specified power. Essential for exponential calculations and engineering applications.

A

POWER Function

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

Raises a number to a specified power. Essential for exponential calculations and engineering applications.

A

EXP Function

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

Calculates the sine of an angle in degrees. Used in trigonometry to find side lengths and angles in triangles.

A

SIN Function

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

Calculates the cosine of an angle in degrees. Used in trigonometry to find side lengths and angles in triangles.

A

COS Function

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

Calculates the tangent of an angle in degrees. Used in trigonometry to find side lengths and angles in triangles.

A

TAN Function

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

Sums cells that meet a specific criterion. Useful for conditional calculations based on specific data values.

A

SUMIF Function

30
Q

Creates a frequency table showing how often each value appears in a data set. Helps analyze data distribution and identify patterns.

A

FREQUENCY Function:

31
Q

Calculates the sum of squared deviations from the mean of a data set. Used in statistical analysis to measure the variability of data points.

A

DEVSQ Function:

32
Q

These functions allow you to extract specific parts of a date or time, perform calculations with dates and times, and format them for better readability.

A

DATE AND TIMES FUNCTION

33
Q

Returns a date, from a user supplied year, month and day.

A

DATE

34
Q

Counts the number of cells that meet a specific criterion. Useful for summarizing data and identifying trends.

A

COUNTIF Function:

35
Q

Returns a date, from a user supplied hour, time and second.

A

TIME

36
Q

Converts a test string showing a date, to an integer that represents the date in Excel’s date-time code.

A

DATEVALUE:

37
Q

Converts a text string showing a time, to a decimal that represents the time in Excel.

A

TIMEVALUE

38
Q

Returns the current date and time based on the computer’s date and time setting. This function has no arguments.

A

NOW

39
Q

Returns today’s date on the computer’s date setting. Also, this function has no arguments.

A

TODAY

40
Q

A function that converts text between Upper and Lower Case.

A

TEXT FUNCTION

41
Q

Converts all the characters in a supplied text string to lowercase.

A

LOWER

42
Q

Converts all characters in a supplied text string to proper case (i.e. leers that do not follow another leer are uppercase and other characters are lower case).

A

PROPER

43
Q

Converts all characters in a supplied text string to upper.

A

UPPER

44
Q

Replaces the existing text (second argument) in a specific cell (first argument) with new text (third argument).

A

SUBSTITUTE

45
Q

Repeats the text (first argument) in the specified cell a specified number of times (second argument).

A

REPT

46
Q

Useful for personal finance, helping with tasks like calculation loan payments and analyzing investments.

A

FINANCIAL FUNCTION

47
Q

o Financial Function

o Calculates periodic payments for a loan

o Useful for personal finance (savings and loans)

A

PMT Function

48
Q

interest rate per payment period (e.g., monthly interest rate for a monthly payment loan)

A

Rate Function

49
Q

total number of payment periods (e.g., total number for a loan)

A

Nper Function

50
Q

present value (initial amount borrowed)

A

PV Function

51
Q

future value (optional, default is 0). This represents the balance remaining after the final loan payment

A

FV Function

52
Q

These functions excel at retrieving specific data from a table within the spreadsheet.

A

LOOKUP FUNCTION

53
Q

scans data vertically (down columns)

A

VLOOKUP

54
Q

is a feature in Excel used to control what a user can enter into a cell. It can simply display a message to a user telling them what is allowed. It can also stop invalid user input.

A

Data Validation

55
Q

is the command center for defining your validation criteria. Here, you can choose from a variety of built-in validation rules, including options for data types like whole numbers, decimals, dates, and text lengths. You can also create custom validation rules using formulas for more complex validation needs.

A

Settings

56
Q

allows you to provide guidance to users about the expected format or range of valid data. This message is purely informational and has no impact on what the user can enter. It serves as a helpful reminder for users about what kind of data is appropriate for the specific field.

A

Input Message

57
Q

empowers you to decide how to handle invalid data entries.

A

ERROR ALERT

58
Q

acts as a gatekeeper, preventing users from entering invalid data until they enter a valid value.

A

Stop Style

59
Q

style provides a heads-up about invalid data but allows users to proceed if they choose.

A

Warning Style

60
Q

simply informs users about invalid data without any restrictions.

A

Information Style

61
Q

no validation is performed.

A

Any Value

62
Q

the values are presented to the user as a dropdown menu control. allowed values can be hardcoded directly into the settings tab, or specified as a range on the worksheet.

A

List

63
Q

validates input based on number of characters or digits.

A

Text Length

64
Q

tells Excel to not validate cells that contain no value. In practice, this setting seems to effect only the command “circle invalid data”.

A

Ignore Blank

65
Q

this setting will update validation applied to other cells when it matches the (original) validation of the cell(s) being edited.

A

APPLY THESE CHANGES TO OTHER CELLS WITH THE SAME SETTINGS

66
Q

These menus provide users with a predefined list of options to choose from, making data input faster and more consistent.

A

SIMPLE DROP-DOWN MENUS

67
Q

Steps to Create a Simple Drop-down Menu

A
  1. Prepare your data list.
  2. Select the cell for the Drop-Down Menu.
  3. Activate Data Validation.
  4. Define validation criteria.
  5. Apply Data Validation.
68
Q

Use the LEN Function to count the number of characters entered.

A

LIMIT TEXT LENGTH

69
Q

Use the SEARCH function to find a specific string of text

A

RESTRICT TO SPECIFIC TEXT

70
Q

Use the TODAY function and comparison operators.

A

VALIDATE DATES

LIT (11 decks)

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