Exam 3 Flashcards
For a future value syntax should it include the rate value, number of payments, quarterly payments, and the present value of the loan?
Yes
What is the order of the payment syntax?
Rate value, the number of payments specified, and the amount of the loan
What is the required syntax for NPER (number of payments)?
Interest rate per quarter, the quarterly payments value, and the present value
For the present value syntax is interest rate per quarter, number of payments, and size of quarterly payments needed?
Yes
Which for the Interest payment function syntax are absolute?
Rate per period, payment, and loan
What is the CUMIPMT and CUMPRIC syntax?
Absolute references to Rate, NPER, and PV, and normal to start and end quarter, then 0
Does the straight line syntax require absolutes to cost, salvage, and life?
Yes
Does the RATE syntax involve NPER, PMT, and PV, and calculate interest rates for investments?
Yes
What is the NPV syntax?
Desired rate of return and return paid to investors
Does IRR syntax contain startup: last year?
Yes
Does the CUMPRINC function calculate the total interest paid on a loan over a full year?
No
What kind of investment has a low internal rate or return?
A good investment
Can DB (declining balance) calculate depreciation of an asset?
Yes
Does the PPMT calculate what proportion of your period payment is going towards principal in a particular period?
Yes
What cells does excel identify when tracing errors in a workbook?
Precedent cells of current worksheet, other worksheets, and independent cells on current worksheet
Do forecast sheets have the ability to analyse seasonal data in which values follow a periodic pattern during the calendar year?
Yes
How do you access data from an external source?
Using a data query
Must the data gathered externally be unchanged for a worksheet?
Yes
Where can you retrieve data from a comma-separated values file?
Use the from text/csv button in the get and transform group
Which type of file allows you to retrieve data values from a query and add them to a table?
CSV
What is a database?
Structured collection of data values organised into a table with each focusing on a single subject
What should you do if the snapshot from the query has values that change?
Refresh the connection
How is the hierarchy for fields structured?
The most general at the top and most specific at the bottom
State 3 data sources that a new query could gather data from?
excel table in another workbook, database table, and a CSV text file
Which data is affected when columns are removed from a query?
Only data imported to excel
Where can the imported data be used once in a query?
Text file, PivotChart, and PivotTable
What is it called when small graphics illustrate different data levels?
Icon sets
How should the difference in revenue be calculated when represented in a PivotTable?
By creating a calculated item
Does excel limit you to one calculated field per PivotTable?
No
Is PivotTable automatically sorted ascending when containing numeric data?
No
Can you sort a PivotTable on a single field using manual?
Yes
What does the DCOUNT function do?
Is used when does not actually need to know their particular values
What can the DCOUTNA function do?
Counts the number of cells that match specified search criteria
Is calculated item seen as a new item within a field?
Yes
Why is the compact PivotTable layout beneficial?
Puts multiple fields from rows area in one column
Is a calculated field used for calculations across one or more fields?
Yes
When do cells in excel become locked?
When the worksheet is protected
Does some items on the shortcut menu when sheet tabs are right clicked being grey mean that the worksheet is hidden?
No
What is a validation rule’s purpose?
Defines what data values are allowed in a cell
What appears in a cell with data validation to indicate the type of data that can be inputted?
Input message
Where can a macro’s actions be changed?
In the VBA editor
How else apart from on the ribbon can macros be run?
By assigning macros to shapes
State one way in which macros can be started?
By pressing the shortcut key assigned to the macro
What form can be used to run a macro?
Button
How can you identify that a workbook has come from a trusted author?
Digital signature
Can a form control enter data and run commands?
Yes
Where can you find the code of every past macro?
Code window
How are macros stored in the VBA?
Blocks of code called sub procedures
How can you edit a macro?
On the developer tab, in code group, click macros. In macro name box click the one you want to edit and click edit.
