Questions from Microsoft Excel and Access for Accounting

Q: Describe the PMT function in Excel and its arguments.

Describe the PMT function in Excel and its arguments.

Q: Describe the FV function in Excel and its arguments.

Describe the FV function in Excel and its arguments.

Q: Describe the Excel functions used in the Hi-Lo method of

Describe the Excel functions used in the Hi-Lo method of predicting costs.

Q: Create new forms for What SUP (use the Ch9-02

Create new forms for What SUP (use the Ch9-02 file) a. Create and print a form for What SUP that lists all fields from the supplier table in a columnar format. (Note: Once again, use the supplier tabl...

Q: Describe the Excel functions used in the Least Squares/Regression method

Describe the Excel functions used in the Least Squares/Regression method of predicting costs.

Q: Describe how to create a trend line for a chart.

Describe how to create a trend line for a chart.

Q: Describe how Excel can be used to calculate an allowance for uncollectible

Describe how Excel can be used to calculate an allowance for uncollectible accounts using the percent of sales method.

Q: Describe how Excel can be used to calculate an allowance for uncollectible

Describe how Excel can be used to calculate an allowance for uncollectible accounts using the aging method.

Q: What is a DBMS?

What is a DBMS?

Q: Describe ways in which Access is used in Accounting.

Describe ways in which Access is used in Accounting.