Question 2 - When creating a spreadsheet formula in Excel the $ in front of the letter and number (ex. $A$4) in the cell address means that

a) -The answer will always be shown in the same cell address such as A4 even is a new file is opened

b) -The answer will be shown with a dollar sign such as $100

c) - The cell remains constant even if the formula is copied to another location

Question 6 - When creating deciding among different alternative using spreadsheet software, the best formula to use would be:

a) - Sum

b) - If

c) - Average

Question 10 - Spreadsheet software can be used to determine the amount of simple interest owed on a 30 day note. What mathematical operations would be used?

a) -addition and subtraction

b) -multiplication and division

c) -addition and division

Question 11 - When creating a spreadsheet if the cell contain #### this means

a) -The cell needs to be adjusted

b) -That you have arrived to the correct solution

c) - That you have arrived to the incorrect solution

Question 12 - When preparing an depreciation schedule using spreadsheet software, you would need to identify the following except:

a) -Estimated life of the asset

b) -Estimated salvage value

c) -Market Value

Question 14 - When preparing an payroll register using spreadsheet software, you would need to identify the following except:

a) -Hours worked

b) -Withholding tax amount

c) -Last year's payroll expense

Question 17 - Charts in spreadsheet software are used in presenting accounting data

a) - For up to 10 worksheets of data all at one time

b) - In a visual format

c) - To show the demonstrate the features of spreadsheets software

Question 18 - When writing a report based on ratio analysis from spreadsheet software, how would you structure the report?

a) -Provide the ratios only and no narrative, that is up to management to provide and interpret.

b) -Provide the ratios and a narrative describing any relationship between ratios

c) -Provide the formulas only for the ratios so management can calculate their own ratios to ensure they are accurate

Question 19 - From an ethical standpoint, it would be acceptable to use a spreadsheets what-if analysis function for

a) -Determining what income level to report to the IRS to lower your taxes

b) -Determining what income level to report to the SEC so that earning per share meets investor expectations

c) -Determining the optimal selling price for a company's product