Exam 3

Question 1

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

Answer 1

Yes

Question 2

What is the order of the payment syntax?

Answer 2

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

Question 3

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

Answer 3

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

Question 4

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

Answer 4

Yes

Question 5

Which for the Interest payment function syntax are absolute?

Answer 5

Rate per period, payment, and loan

Question 6

What is the CUMIPMT and CUMPRIC syntax?

Answer 6

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

Question 7

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

Answer 7

Yes

Question 8

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

Answer 8

Yes

Question 9

What is the NPV syntax?

Answer 9

Desired rate of return and return paid to investors

Question 10

Does IRR syntax contain startup: last year?

Answer 10

Yes

Question 11

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

Answer 11

No

Question 12

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

Answer 12

A good investment

Question 13

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

Answer 13

Yes

Question 14

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

Answer 14

Yes

Question 15

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

Answer 15

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

Question 16

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

Answer 16

Yes

Question 17

How do you access data from an external source?

Answer 17

Using a data query

Question 18

Must the data gathered externally be unchanged for a worksheet?

Answer 18

Yes

Question 19

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

Answer 19

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

Question 20

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

Answer 20

CSV

Question 21

What is a database?

Answer 21

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

Question 22

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

Answer 22

Refresh the connection

Question 23

How is the hierarchy for fields structured?

Answer 23

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

Question 24

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

Answer 24

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

Question 25

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

Answer 25

Only data imported to excel

Question 26

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

Answer 26

Text file, PivotChart, and PivotTable

Question 27

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

Answer 27

Icon sets

Question 28

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

Answer 28

By creating a calculated item

Question 29

Does excel limit you to one calculated field per PivotTable?

Answer 29

No

Question 30

Is PivotTable automatically sorted ascending when containing numeric data?

Answer 30

No

Question 31

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

Answer 31

Yes

Question 32

What does the DCOUNT function do?

Answer 32

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

Question 33

What can the DCOUTNA function do?

Answer 33

Counts the number of cells that match specified search criteria

Question 34

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

Answer 34

Yes

Question 35

Why is the compact PivotTable layout beneficial?

Answer 35

Puts multiple fields from rows area in one column

Question 36

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

Answer 36

Yes

Question 37

When do cells in excel become locked?

Answer 37

When the worksheet is protected

Question 38

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

Answer 38

No

Question 39

What is a validation rule's purpose?

Answer 39

Defines what data values are allowed in a cell

Question 40

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

Answer 40

Input message

Question 41

Where can a macro's actions be changed?

Answer 41

In the VBA editor

Question 42

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

Answer 42

By assigning macros to shapes

Question 43

State one way in which macros can be started?

Answer 43

By pressing the shortcut key assigned to the macro

Question 44

What form can be used to run a macro?

Answer 44

Button

Question 45

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

Answer 45

Digital signature

Question 46

Can a form control enter data and run commands?

Answer 46

Yes

Question 47

Where can you find the code of every past macro?

Answer 47

Code window

Question 48

How are macros stored in the VBA?

Answer 48

Blocks of code called sub procedures

Question 49

How can you edit a macro?

Answer 49

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