Assignment
Question 1 - If you want to take 100 divided by 2 then add the 25 using spreadsheet software, such as Excel, how would you write the formula?
a)+100/2 +25
b)=(100)(2)+25
c)=25 + 100/2
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 3 - When creating deciding among different alternative using spreadsheet software, the best formula to use would be:
a) - Sum
b) - If
c) - Average
Question 4 - 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 5- 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 6 - 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 7- 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 8- 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 9- 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 10- From an ethical standpoint, it would be acceptable to use a spreadsheet's 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