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 3 > Flashcards

Exam 3 Flashcards

1
Q

For a future value syntax should it include the rate value, number of payments, quarterly payments, and the present value of the loan?

A

Yes

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

What is the order of the payment syntax?

A

Rate value, the number of payments specified, and the amount of the loan

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

What is the required syntax for NPER (number of payments)?

A

Interest rate per quarter, the quarterly payments value, and the present value

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

For the present value syntax is interest rate per quarter, number of payments, and size of quarterly payments needed?

A

Yes

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

Which for the Interest payment function syntax are absolute?

A

Rate per period, payment, and loan

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

What is the CUMIPMT and CUMPRIC syntax?

A

Absolute references to Rate, NPER, and PV, and normal to start and end quarter, then 0

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

Does the straight line syntax require absolutes to cost, salvage, and life?

A

Yes

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

Does the RATE syntax involve NPER, PMT, and PV, and calculate interest rates for investments?

A

Yes

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

What is the NPV syntax?

A

Desired rate of return and return paid to investors

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

Does IRR syntax contain startup: last year?

A

Yes

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

Does the CUMPRINC function calculate the total interest paid on a loan over a full year?

A

No

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

What kind of investment has a low internal rate or return?

A

A good investment

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

Can DB (declining balance) calculate depreciation of an asset?

A

Yes

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

Does the PPMT calculate what proportion of your period payment is going towards principal in a particular period?

A

Yes

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

What cells does excel identify when tracing errors in a workbook?

A

Precedent cells of current worksheet, other worksheets, and independent cells on current worksheet

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

Do forecast sheets have the ability to analyse seasonal data in which values follow a periodic pattern during the calendar year?

A

Yes

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

How do you access data from an external source?

A

Using a data query

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

Must the data gathered externally be unchanged for a worksheet?

A

Yes

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

Where can you retrieve data from a comma-separated values file?

A

Use the from text/csv button in the get and transform group

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

Which type of file allows you to retrieve data values from a query and add them to a table?

A

CSV

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

What is a database?

A

Structured collection of data values organised into a table with each focusing on a single subject

22
Q

What should you do if the snapshot from the query has values that change?

A

Refresh the connection

23
Q

How is the hierarchy for fields structured?

A

The most general at the top and most specific at the bottom

24
Q

State 3 data sources that a new query could gather data from?

A

excel table in another workbook, database table, and a CSV text file

25
Q

Which data is affected when columns are removed from a query?

A

Only data imported to excel

26
Q

Where can the imported data be used once in a query?

A

Text file, PivotChart, and PivotTable

27
Q

What is it called when small graphics illustrate different data levels?

A

Icon sets

28
Q

How should the difference in revenue be calculated when represented in a PivotTable?

A

By creating a calculated item

29
Q

Does excel limit you to one calculated field per PivotTable?

A

No

30
Q

Is PivotTable automatically sorted ascending when containing numeric data?

A

No

31
Q

Can you sort a PivotTable on a single field using manual?

A

Yes

32
Q

What does the DCOUNT function do?

A

Is used when does not actually need to know their particular values

33
Q

What can the DCOUTNA function do?

A

Counts the number of cells that match specified search criteria

34
Q

Is calculated item seen as a new item within a field?

A

Yes

35
Q

Why is the compact PivotTable layout beneficial?

A

Puts multiple fields from rows area in one column

36
Q

Is a calculated field used for calculations across one or more fields?

A

Yes

37
Q

When do cells in excel become locked?

A

When the worksheet is protected

38
Q

Does some items on the shortcut menu when sheet tabs are right clicked being grey mean that the worksheet is hidden?

A

No

39
Q

What is a validation rule’s purpose?

A

Defines what data values are allowed in a cell

40
Q

What appears in a cell with data validation to indicate the type of data that can be inputted?

A

Input message

41
Q

Where can a macro’s actions be changed?

A

In the VBA editor

42
Q

How else apart from on the ribbon can macros be run?

A

By assigning macros to shapes

43
Q

State one way in which macros can be started?

A

By pressing the shortcut key assigned to the macro

44
Q

What form can be used to run a macro?

A

Button

45
Q

How can you identify that a workbook has come from a trusted author?

A

Digital signature

46
Q

Can a form control enter data and run commands?

A

Yes

47
Q

Where can you find the code of every past macro?

A

Code window

48
Q

How are macros stored in the VBA?

A

Blocks of code called sub procedures

49
Q

How can you edit a macro?

A

On the developer tab, in code group, click macros. In macro name box click the one you want to edit and click edit.

50
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