46.Which of the following is false?

A.The keyboard shortcut to delete rows or columns is CTRL + minus sign

B.The keyboard shortcut to add more sheets to a workbook is CTRL + N

C.The keyboard shortcut to add more rows or columns is CTRL + plus sign

D.The keyboard shortcut to set row height ALT + H + O + H

47.The required financial statements for public traded companies include:

1. Income Statement
2. Statement of ComprehensiveIncome
3. Balance Sheet
4. Statement of Cash Flows
5. Statement of Shareholders' Equity
6. Statement of Retained Earnings

A.1,3,4,5,6

B.1,3,4,5

C.1,2,3,4,5

D.1,2,5,6

49.The company name "Apple Inc." is in cell A3. Use the concatenate function to write the equation which dynamically shows the following statement: Financial Statement Analysis - Apple Inc.

A.=CONCATENATE("Financial Statement Analysis - ",A3)

B.=CONCATENATE('Financial Statement Analysis', - ,A3)

C.=CONCATENATE('Financial Statement Analysis - ',A3)

D.=CONCATENATE("Financial Statement Analysis", - ,A3)

50.What formula can be entered into cell G3 to display the CAGR for revenue for the periods displayed?

A.=CAGR(B3:F3)

B.=Rate(G2,0,B3,-F3,0)

C.=Rate(G2,0,B3,F3,0)

D.=Average(B3:F3)

51.Why are economic moats advantageous?

A.Economic moats represent short-term initiatives which provide limited advantages for the company.

B.They help a company improve its brand.

C.They help make sure a company's CEO isn't too shallow.

D.They allow a company to generate profits and keep competitors at bay.

52.What is usually presented first in the notes to the financial statements?

A.Commitments and Contingencies

B.Significant Accounting Policies

C.Earnings Per Share Calculations

D.Accumulated Comprehensive Income

53.Prices for year-end AAPL stock are listed below. Write the Excel formula that will show average stock price in cell B7.

A.=AVG(B2:B6)

B.=AVERAGE(B2-B6)

C.=AVG(B2-B6)

D.=AVERAGE(B2:B6)

E.=SUM(B2:B6)/6

54.What is a common-size income statement?

A.A statement that expresses each item on the income statement as a percentage of total assets.

B.An income statement that groups all items of revenue together, then deducts all categories of expenses.

C.An income statement that provides intermediate profit measures.

D.A statement that expresses each item on the income statement as a percentage of net sales or revenues.

55.Which of the following will appear as a positive amount on a statement of cash flows that was prepared using the indirect method?

A.An increase in accounts receivable

B.A decrease in accounts payables

C.Depreciation expense

D.An increase in inventories

56.which of the following is considered the least important item from a Form 10-K for analyzing a business like APPLE?

A.Item 8 - Financial Statements & Supplementary Data

B.Item 4 - Mine Safety Disclosures

C.Item 7 - Management's Discussion & Analysis

D.Item 6 - Selected Financial Data

E.Item 1 - Business

F.Item 1A - Risk Factors

57.Which of the following is not true?

A.Publicly traded companies file the announcement of a materially significant in a form called 6-K.

B.Publicly traded companies file quarterly results with the SEC in a form called 10-Q.

C.Publicly traded companies file annual results with the SEC in a form called 10-K.

D.Private companies intending to go public in an IPO file form S-1.