Analytics My Brain
In the Veltronics project, how many vendors offer a discount of 4%?
14
What do you use to ask a question of data in a table without adding a new field?
A global filter.
How many different commands does ACL have?
18
Which Vendor has a ZIP code of 65061?
World Electric
When do accountants fall over?
When they lose their balance.
In the Veltronics project, how many vendors are in the list with unpaid invoices?
37
What command do you use to check validity of data or to ensure that the data conforms to the layout?
Verify Command
It’s _______ world.
Accrual
How many invoices are there with negative balances?
2
What do accountants like most about the weekends?
They get to wear their casual clothes to work.
In the Veltronics project, how many outstanding invoices are for vendor # 101?
4
What is the state abbreviation and city for the vendor "Flow Tech"?
TN (Tennessee); Oak Ridge
Welcome to the accounting department, where everybody _____.
Counts
How many invoices were issued, and what was the total amount in January 2019?
26 records; Total = $ 89,190.37
What command do you use to count the records in a table?
Count Command
In the Veltronics project, what is the average value per invoice?
$3,333.70
ACL filters allow the auditor to obtain information about data in a _____.
Table
Use the _____ command to locate duplicate invoice numbers in the Trans table.
Duplicate
How many outstanding invoices are for Vendor # 1475, and what is the total amount?
7 records; Total = $ 64,917.09
How does Santa’s accountant value his sleigh?
Net Present Value
In the Veltronics project, how many vendors have the state of New Hampshire?
6
What do you call an accountant with an opinion?
An auditor
A computed field is a logical expression about a data where a new _____ is created in the table.
Field
According to Content Snare: 12 Fun Facts About Accounting, what 2 famous musicians were pursuing accounting before they “made it big”?
Mick Jagger and Robert Plant (Rolling Stones & Led Zeppelin
What does an accountant say when getting on a train?
Mind the GAAP