Brainscape's Knowledge GenomeTM

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


See full index

ISTM 210 > Prometheus Exam 2 > Flashcards

Prometheus Exam 2 Flashcards

1
Q

A ___ is an Excel file that stores all the information, previous calculations, and analyses that you may have already completed.

A

Workbook

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

A ___ is organized into a collection of cells arranged in the form of a table.

A

Worksheet

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

___ store individual pieces of data or calculations.

A

Cells

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

A ___ contains the actual data and calculations.

A

Worksheet

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

The ___ menu items are used to change how a worksheet is displayed on the screen.

A

View

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

The ___ menu items help in sharing an Excel workbook with colleagues.

A

Review

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

The ___ menu items are used to format the appearance of worksheets.

A

Page Layout

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

Items in the ___ area under the File Tab are used make this workbook available for colleagues.

A

Share

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

The ___ menu items allow you to manage users.

A

Account

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

Referring to more than one cell at a time as long as the cells are in a continuous block is called ___

A

Referencing a Range of Cells

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

The ___ feature allows you to automatically populate cells in a worksheet.

A

Fill

use Series dialogue window to fill a cell range… Step Value and Stop Value

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

When all the contents of a cell don’t fit/display in a cell, what function of Excel will you use to fix it?

A

“Column Width” under Format Tab

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

The ___ feature in Excel allows you to “Lock” rows and columns so that they don’t disappear when you navigate through the data table.

A

Freeze Panes

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

The menu items used to change the appearance of the contents of cells can be accessed from the ___ and ___ groups on the “Home” menu tab.

A

Font and Alignment

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

The ___ drop-down menu allows you to choose the font from the list of installed system fonts on your computer.

A

Font-Face

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

The ___ feature of Excel allows you to angle cell contents.

A

Orientation

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

Excel has a number of worksheet styles, called ___, which you can apply to quickly add colors and other style effects to your worksheets

A

Themes

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

The ___ and ___ features of Excel allow you to reorganize and limit the items in a table to help you make sense of the table.

A

Sorting and Filtering

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

The ___ feature in Excel allows you to display only specific information on a data table.

A

Filtering

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

___ can provide interesting insights not readily apparent in a data table

A

Sorting

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

We call cell references that automatically update when a formula is pasted to a new cell ___

A

Relative Cell References

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

A cell reference that remains constant when a formula is pasted into a new cell is called an ___

A

Absolute Cell Reference

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

The Insert function window is more commonly known as the ___

A

Function Wizard

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

What is the difference between the COUNT and COUNTA function?

A

COUNT
-counts all cells in a range that have a number

COUNTA
-counts all cells in a range that have data in them (numbers or letters)

*both do not count blank cells

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

___ calculates the interest rate earned for an investment given the number of payments made as part of the investment, the payment amount, and the current value of the investment.

A

RATE (nper, pmt, pv, [fv], [type], [guess])

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

___ calculates the annual percentage rate for an interest rate given the number of times per year that interest is charged.

A

EFFECT (nominal_rate, npery)

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

___ calculates the number of payments that will be made to pay off a loan given the interest rate, payment amount, and original loan amount.

A

NPER (rate, pmt, pv, [fv], [type])

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

___ calculates the payment amount for a loan given the interest rate, number of payments to be made to pay off the loan, and the original loan amount.

A

PMT (rate, nper, pv, [fv], [type])

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

___calculates the current value (accounting for compounding interest) of an investment given the interest rate, number of payments to be made, and the amount of the payment.

A

PV (rate, nper, pmt, [fv], [type])

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

___ calculates the future value of an investment given the interest rate, number of payments to be made, and the amount of the payment.

A

FV (rate, nper, pmt, [pv], [type])

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

___ feature allows you to see which cells are referenced in a particular formula or function.

A

Trace Precedents

32
Q

___ feature allows you to see which other cells reference a particular cell.

A

Trace Dependants

33
Q

___ feature displays the functions and formulas used in each cell of a worksheet instead of the formula or function results.

A

Show Formulas

34
Q

Who and when was Boolean Logic invented?

A

Invented by George Boole in 1800s

35
Q

What is it called when you have an “IF” function inside of another “IF” function?

A

Nesting

36
Q

If you need to accommodate 101 possible outcomes, how many IF functions will you have?

A

100

*Always one less

37
Q

___ allow you to perform calculations where the cell references used to complete the calculations depend on the values of other cells in a worksheet

A

Conditional Functions

38
Q

When working with a VLOOKUP(lookup_value, table_array, column_index_num, [range_lookup]):

What does TRUE/FALSE mean for “range_lookup”
What will Excel assume if you do not use it in your argument?

A

TRUE = approximate match
FALSE = exact match
*Excel will assume TRUE

39
Q

What is the difference between the “lookup_value” argument in VLOOKUP and HLOOKUP

A

VLOOKUP assumes that it will search in the first column of the table to find a match

HLOOKUP assumes that it will search in the first row of the table to find a match

40
Q

How does Excel treat a date?

How does Excel treat text?

A
  • Treats a date like a number

- Treats text like a string, or collection of useless Characters

41
Q

How many different ways are there to display a date in an Excel cell?

A

17

42
Q

When Excel expresses a date as a number, what do the numbers to left/right of the decimal place represent?

A

Left of the decimal place represents DATE

Right of the decimal place represents the specific point in time of the date (fraction of the date)

43
Q

What do the Excel functions TODAY() and NOW() return?

A

TODAY() returns the current date

NOW() returns the current time

44
Q

What are the number intervals that the SECOND, MINUTE, and HOUR functions can return?

A

0-59

45
Q

How many characters can Excel store in a one cell?

A

32,767

*can only visually show 1024 once printed

46
Q

When using the SEARCH function of Excel, does it return the beginning character account number of the specified text or the end character count?

A

Beginning

47
Q

The ___ function of Excel is used to replace characters in a block of text with other characters.

A

SUBSTITUTE

48
Q

What do you click to display numerical values of a chart’s data?

A

Data Labels

49
Q

The ___ tab of the “Chart Tools” menu scheme contains the menu items used to make high-level manipulations to your charts.

A

Design

50
Q

The ___ tab of the “Chart Tools” menu scheme contains the menu items that are used to modify the colors and textual elements of your charts.

A

Format

51
Q

___ are used to compare different categories of items or the same category over time

A

Column Charts

52
Q

A ___ is used to help the user differentiate between the various data series depicted in a chart.

A

Chart Legend

53
Q

A ___ is essentially a column chart rotated 90 degrees to the right.

A

Bar Chart

54
Q

___ breaks the categories into segments that represent subcategories that are consistent across the columns.

A

Stacked Column Charts

55
Q

Which type of chart is best suited to situations that require the comparison of categories?

A

Stacked Column Chart

56
Q

___ are used to compare the parts of category to the whole.

A

Pie Charts

57
Q

When inserting a pie chart, the horizontal axis represents the ___

A

categories

58
Q

Which type of chart is best used when all the parts of the category are known?

A

Pie Chart

59
Q

___ compare the particular values of a category overtime

A

Line Charts

60
Q

Which type of chart is best used for identifying trends in a dataset

A

Line Charts

61
Q

___ allow you to use spreadsheets to make good decisions based on sophisticated and relevant analyses of the problems you are trying to solve.

A

Models

62
Q

What are the 3 things every good model will have in Excel?

A
  • changeable inputs
  • outputs
  • intermediate calculations
63
Q

Generally, where are the changeable inputs and outputs found on an Excel model?

A

Changeable inputs @ top of worksheet

Outputs @ bottom of worksheet

64
Q

According to the author, what is the most important requirement for building an effective Excel spreadsheet model?

A

Thoroughly understanding the process

65
Q

What are the 3 specific tools Excel has for conducting a What-If-Analysis

A
  • Scenario Manager
  • Goal Seek
  • Data Table
66
Q

The ___ is useful for examining the impact of several inputs to a spreadsheet model changing at the same time

A

Scenario Manager

67
Q

The ___ compares each scenario and how each influences a specified model outcome.

A

summary worksheet

68
Q

Using the What-If-Analysis, ___ is used to work backwards from an outcome calculation to determine an input condition necessary to arrive at the desired outcome.

A

Goal Seek

69
Q

What are 2 limitations of goal seek?

A
  • you have to enter the exact desired outcome (no ranges)

- can only analyze one changeable input at a time

70
Q

When using the Data Table tool of the What-If-Analysis, what is it called when only one input is used? What is it called when two changeable inputs are used?

A 
1 = one-way data table
2= two-way data table
71
Q

___ provide a powerful and flexible way to analyze large amounts of data quickly and easily in Excel.

A

PivotTables

72
Q

True or False: When constructing a PivotTable in Excel, the Create PivotTable dialogue window allows the user the import data from a DIFFERENT workbook to use in the existing workbook if he/she chooses

A

True

73
Q

___ is used to screen the data as it is placed in a PivotTable.

A

Report Filter

74
Q

The PivotTable automatically calculates the ___

A

Grand Total for all the values on the table

75
Q

When dealing with PivotTables under the “Show Value as” function, what does the Index tool do?

A

Ranks the “relative importance” of the cell based on an Excel algorithm

76
Q

What are the two ways you can filter data in a PivotTable?

A

Report Filters and Slicing

ISTM 210 (10 decks)

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