Brainscape's Knowledge GenomeTM

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


See full index

Foundations in Business Analytics > Exam 2 > Flashcards

Exam 2 Flashcards

1
Q

What two indicators demonstrate that a worksheet is grouped?

A

Having the word in the title bar and it being in editing mode

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

On the move or copy dialog box, how can a worksheet be moved/copied?

A

Use the to book section to add the workbook you want to move to, then choose where you want to place it

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

How can flexible 3-D references be added?

A

By using a wildcard

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

If both the source and destination workbooks are open is data automatically replicated in the destination workbook?

A

Yes

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

How do you create a hyperlink?

A

Select the text/object want to use as the hyperlink, then click insert tab and hyperlink

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

Where can named ranges be made and where can they then be seen?

A

Created in the named ranges from labels workbook using create from selection command, and can view list of named ranges by opening the name manager dialog box in formulas on ribbon.

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

Are named ranges absolute cell references and once defined do all with equivalent names then get replaced?

A

Yes

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

How can additional information be added to a hyperlink?

A

Add a ScreenTip

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

Do you right click a cell with a hyperlink if do not want to activate it?

A

Yes

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

Can named ranges have dashes and where by default does excel store workbook templates?

A

No. User’s Custom Office Templates folder.

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

How does split command happen?

A

Window’s group of the view tab. This opens panes.

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

Where are records and fields found?

A

In the rows and the columns.

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

What should you do after each data range?

A

Provide a data definition table and a short description of each field.

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

How are duplicates removed?

A

Click any cell in the range, on data tab in data tools group then click remove duplicates button and choose which field of duplicates to remove

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

What does doing sorting in ascending order mean?

A

Alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest

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

Can you sort with a custom list?

A

Yes

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

Does outline tool for subtotal enable to hide some data?

A

Yes

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

How do you filter from multiple fields?

A

Select the filter button from other column headers in the data range.

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

Does the advanced filter combine fields using AND and OR logical operators?

A

Yes

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

State 3 features of excel tables that are not supported by ranges?

A

Built in sorting and filtering tools, table styles, and total rows.

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

Is a calculated field one that contains a formula that references other fields and have enclosed brackets with names in them?

A

Yes

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

What does @ stand for in structural field?

A

Current record or row in the table

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

Will VLOOKUP function automatically include additional rows as more records are added to lookup table?

A

Yes

24
Q

What does the 1 in =SUBTOTAL(1, Customers_Table(ID]) stand for?

A

The number of the function to use

25
Q

What would be the formula to calculate the income field from employees table?

A

=AVERAGE(Employees[Income])

26
Q

What would the VLOOKUP for 3rd field in Sales_Result that exactly matches the LOOKUP value in cell B10 look like?

A

=VLOOKUP(B10, Sales_Result, 3, False)

27
Q

Would =COUNTIF(Media[SITE], B4) be the syntax for the number of cells containing the value “Facebook” in the Media table?

A

Yes

28
Q

What is the syntax for HLOOKUP?

A

=HLOOKUP(lookup_value, table_array, row_index, index_num[range_lokkup]).

29
Q

How are character patterns created for partial lookups?

A

By the use of wildcards

30
Q

What is the syntax for the match function?

A

MATCH(lookup_value, lookup_array, [match_type=1]).

31
Q

What is IF function syntax?

A

=IF(logical_test1, value_if_true1, logical_test2, value_if_true2, …)

32
Q

When do AND and OR functions come out as true?

A

When all of the conditions are true and when one of the conditions are true respectively.

33
Q

What is syntax for both?

A

…(logical1, [logical2], [logical3], …)

34
Q

What is the only difference between COUNTIF and SUMIF functions?

A

SUMIF has sum_range as an extra in it’s syntax.

35
Q

What are the syntax for COUNTIFS and SUMIFS?

A

COUNTIFS(range1, criteria1, [range2], [criteria2], …). SUMIFS(sum_range, range1, criteria1, [range2], [criteria2], …)

36
Q

How does excel display missing combinations within the PivotTable?

A

Blank cells

37
Q

Is category related with the axis and series related with legend of PivotTable?

A

Yes

38
Q

How do you drill down a PivotTable?

A

Double click on any cell within the table, then excel opens sheet telling you how that value was created

39
Q

Does PivotTable arrange categories in a row or column alphabetically for text fields and by date for date fields?

A

Yes

40
Q

What is the difference between how one and two variable data tables perform what-if analyses?

A

One table: one input cell and several result cells. Two table: two input cells and one output cell.

41
Q

Does two variable data table contain a reference to the result cell at the intersection of first row and column?

A

Yes

42
Q

What is another name for cost volume-profit analysis?

A

Break-even analysis

43
Q

Where is the range of possible values for the input cell entered?

A

First column or row and in the subsequent

44
Q

What does scenario manager do?

A

Creates many scenarios that are used to complete what-if analyses

45
Q

What two places are where result cells are found?

A

Scenario summary and scenario pivot table reports

46
Q

How can scenario manager be opened?

A

Click on a cell that could change, go to the data tab, what-if analysis, and scenario manager

47
Q

What must be identified in order to create a report through a pivot table?

A

Result cells, values of input cells, and current worksheet values

48
Q

Where can objective cells be used within excel?

A

In the solver parameters dialog box

49
Q

Does every solver need an objective and one or more variable cells?

A

Yes

50
Q

How many types of constraints does a solver support?

A

6

51
Q

Are overall highpoints seen as global optimum and local optimum similar? Are these decisions based off of previous results?

A

Yes. Yes.

52
Q

Does solver support the iterative models Simplex LP method, GRG Nonlinear method, and Evolutionary method?

A

Yes

53
Q

What are the three reports solver generates and their definitions?

A

Answer report which summarises the results of a successful solution. Sensitivity and limits which is usually used to investigate mathematical aspects and check reliability.

54
Q

Is a binding constraint included in solver model and a limiting factor in getting to solution?

A

Yes

55
Q
A

Foundations in Business Analytics (3 decks)

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