2.99 See Answer

Question: What do the [ ] (brackets) signify in an


What do the [ ] (brackets) signify in an Access formula?


> What additional argument is added for these depreciation functions?

> What other depreciation functions are built into Excel?

> What is the purpose of a depreciation summary?

> Create a new What SUP Cost Analysis a. Using the ch7-02 file to start your work, create a worksheet to do the following: i. Calculate the Hi-Lo Method variable cost/hour open and fixed cost. ii. Predicted expense under the Hi-Lo Method assuming 2,000 ope

> Should references used as arguments to the SLN function be absolute or relative?

> Why should the arguments in the SLN function be values or references?

> Should the arguments in the SLN function be values or references?

> What arguments does the SLN function take?

> Describe the shape of the three lines in a depreciation comparison chart depicting straight-line, double declining balance, and sum-of-the-year’s digits depreciation.

> What function is built-into Excel to help you calculate straight-line depreciation?

> Which ratios are usually formatted as percentages?

> Why is the point-and-click method of cell referencing easier than typing references directly into worksheet cells?

> What do solvency ratios represent?

> What do liquidity ratios represent?

> Create a new What SUP Present Value Analysis a. Using the ch7-01 file to start your work, modify that worksheet to do the following: i. Calculate the annuity payment required at the end of each year for the next 4 years at 4 percent such that the value i

> What do profitability ratios represent?

> What base amount is used for horizontal analysis of both income statements and balance sheets? Give an example.

> What base amount is used for vertical analysis of a balance sheet?

> What base amount is used for vertical analysis of an income statement?

> Which ratios are usually formatted as numbers?

> What is another term for vertical analysis?

> Explain the importance of parentheses in formulas.

> Explain the arguments used in the SUM function.

> How are formulas written in Excel?

> What does the Format Painter tool do?

> Create a new What SUP Operating Cash Payments Budget Using the ch6-03 file to start your work, create a worksheet similar to the one created in this chapter to budget operating cash payments by month for 3 months. Place assumption information in the cell

> How do you control the appearance of data in a worksheet?

> Explain the process for changing column width or row height.

> What does it mean when a cell or cells in a worksheet include a series of # signs?

> Identify the difference between labels and values.

> How does the AutoFill feature of Excel help the worksheet user?

> Explain how information is entered into an Excel worksheet.

> What is the recommended procedure for printing a workbook or worksheet?

> How do you change the name of a sheet in a workbook?

> Describe the procedure used to insert a column or row into a worksheet.

> How do you change a relative reference to an absolute reference?

> Create a new What SUP Operating Cash Receipts Budget Using the ch6-02 file to start your work, create a worksheet similar to the one created in this chapter to budget operating cash receipts by month for 3 months. Place assumption information in the cell

> Why would you want to use absolute references instead of relative references?

> What are the key accounting topics addressed in this text that relate to your learning Excel?

> What is the quickest way to get help while in Excel?

> What is the Page Layout view?

> How do you modify the Quick Access Toolbar to add the Open command?

> Describe the three basic components of the Ribbon.

> What and where is the Quick Access Toolbar?

> Describe the nature of the commands found on the File and Home tabs.

> What function is used (and how is it written) to count records in a report?

> What type of control is used in a report to add values?

> Using the ch5-04 file to start your work, create a worksheet (similar to the one created in this chapter) that calculates the bond proceeds for a $2,500,000, 10-year, 4 percent stated interest bond issued when the market interest rate is 5 percent. Inclu

> How do you determine where information appears in a report?

> Is it possible to group more than one item?

> When creating a report, what does the process of summarizing accomplish?

> When creating a report, what does grouping accomplish?

> Can you always add a field from any table to a report based on a query?

> Describe the process of adding lines to a report.

> Why create a report from a query? Why not just print your query results?

> Why must an existing relationship be deleted before modifying a field’s data type?

> When is the Lookup Wizard used?

> Create a new What SUP Loan Amortization Schedule Using the ch5-03 file to start your work, create a worksheet (similar to the one created in this chapter) that calculates the required annual payment for an $850,000, 7-year loan at 5 percent and includes

> Why are check box controls used on a form instead of list box controls?

> Why are calculated controls used on a form?

> Why are combo box controls used on a form?

> Why are list box controls used on a form?

> Why are text box controls used on a form?

> What is the difference between bound and unbound controls?

> What type of relationship must exist if a sub-form is used on a form?

> What view of a form is used to edit an existing form?

> What is a parameter query?

> What is an action query? Give examples.

> You are to add another depreciation chart for What SUP. Use the ch4-01_Chart_student_name workbook you created in this chapter. Add a new depreciation chart by changing the name of Sheet2 to Asset 1002. Following the steps shown in the chapter, create a

> Are the results of a calculation stored as a field in a table?

> What will compound criteria allow you to accomplish in Access?

> What are the three key comparison operators used in a query?

> Describe the process for adding to an existing query a field that exists in a table not currently included in the query.

> How and why are wildcards used in a query?

> Describe the process for using criteria in a query using the Design view method.

> When might you use a delete query?

> Describe the difference between the Query Wizard and Design view methods of creating a query.

> What is referential integrity?

> What are input masks?

> Modify What SUP’s Sum-of-the-Year’s Digits Depreciation Schedule You are to add another depreciation schedule for What SUP. Use the ch4-01_SYD_student_name worksheet you created in this chapter. Add a new depreciation worksheet, labeled Asset 1003, using

> Why would you establish default values for a field?

> What is the process for adding a validation rule to a field?

> What do validation rules do?

> Why would you want to change the column width and/or row height of a table?

> What can you do in Access to change the structure of a database?

> Define OLE.

> What rules must be followed if referential integrity is enforced?

> Describe the process for deleting a record from a table.

> How are controls used to create forms?

> From where does most of the information in a form come?

> You are to add another depreciation schedule for What SUP. Use the ch4-01_DDB_student_name worksheet you created in this chapter. Add a new depreciation worksheet, labeled Asset 1003, using the Move or Copy Shortcut menu. The asset to be depreciated is t

> Create a trial balance for What SUP as of March 31, 2019 You are to create a trial balance in a format identical to that created in this chapter. Include a debit and credit column, totals for each column, and appropriate labels and formatting. Start with

> On June 1, 2019, Father sold land to Son for $300,000. Father reported the gain by the installment method, with the gain to be spread over five years. In May 2021, Son received an offer of $400,000 for the land, to be paid over three years. What would be

> A seller and a buyer agree that the sales/purchase price for land is $1,500,000 down and two annual payments of $1,500,000 each to be made over the next two years. The buyer intends to construct a building on the land that will be used as the buyer’s war

> Mallard Corporation was formed in December 2021 and plans to use the cash basis of accounting. Mallard incurred one-half of its organizational expenses in December 2021 and one-half in January 2022. The payment of these expenses also occurred in these tw

> What conditions cause the golden parachute rules to apply?

> Sanjay Henry calls you and asks about setting up a savings incentive match plan for his employees (SIMPLE). Prepare a memo for the tax files with your response.

> Bob is notified by the city public housing authority on May 3, 2021, that his apartment building is going to be condemned as part of a commercial development project. On June 1, 2021, Stella offers to buy the building from Bob. Bob sells the building to

> Maize Corporation (a calendar year taxpayer) was formed on April 1, 2021. Calculate the maximum deduction for organizational expenses for 2021 if these costs were: a. $4,000. b. $24,000. c. $54,000. d. $64,000. e. Using spreadsheet software such as Micro

> Green Corporation, a calendar year taxpayer, has ordinary income of $10,000 and a long-term capital loss of $12,000 in 2021. Green incurred a long-term capital gain of $2,500 in 2018 and a long-term capital gain of $5,000 in 2020. a. How much of the long

2.99

See Answer