Question 1 If you want to take 100 divided by 2 then add the 25 using spreadshee

Question

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?

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

Question 3 One of the advantages of using spreadsheet software is that

Question 4 Using spreadsheet software how would you correct an error you discovered where you keyed in the amount of $10,000 and the amount should have been for $1,000 but you have already used that cell address with the incorrect number in another calculation

Question 5 Spreadsheet software can be used to communicate financing, investing and operating activities for a business. Which statement would contain this information?

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

Question 7 A pivot table can be used to

Question 8 When using a Vlookup formula

Question 9 Using spreadsheet software to communicate operating activities for a business to the users of financial statements can be done by preparing a(n)

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?

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

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

Question 13 When preparing a horizontal analysis, using software, the percentage of change for land would be calculated using a formula?

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

Question 15 A footer would be placed on a spreadsheet document _____to communicate additional information to the reader

Question 16 When preparing a horizontal analysis, using spreadsheet software, you must present this in

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

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

Question 20 You made an error in a spreadsheet formula. You know your spreadsheet will be the basis for an important business decision. Ethically, you should: T

Explanation / Answer

Q1) (A1/2) + 25, where A1 cell contains the value 100

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

ANS - Absolute Formulas - When a formula appears =$A$4 the column is fixed and the row is fixed.

Absolute cell references do not change when a formula is copied from one cell to another. Placing a dollar sign before either the row or column fixes the row or column so it will not be changed in the formula.

Question 3 One of the advantages of using spreadsheet software is that

Spreadsheets offer a range of advantages, particularly to business users. Popular spreadsheet programs such as Microsoft Excel provide the tools to analyze and visualize data sets in accessible ways. If you have a set of data related to numerical, financial, statistical or other information, you can use a spreadsheet not only to store this data but also to manage it, perform analytical processing on it and present it. Spreadsheets provide complex processing in ways that even people with little technical experience can access

Question 4 Using spreadsheet software how would you correct an error you discovered where you keyed in the amount of $10,000 and the amount should have been for $1,000 but you have already used that cell address with the incorrect number in another calculation

Just edit that cell value from $10,000 to correct value $1000 and since the cell address is used elsewhere in the spreadsheet, the changes in the value will automatically get reflected in the spreadsheet calculations

Question 5 Spreadsheet software can be used to communicate financing, investing and operating activities for a business. Which statement would contain this information? - Audit Statement

Question 6 When creating deciding among different alternative using spreadsheet software, the best formula to use would be - Determining the complexity and the nature of data that will be used for various computing and depending upon the complexity, choose the alternatives wisely.

Question 7 A pivot table can be used to - Use a pivot table to build a list of unique values. Because pivot tables summarize data, they can beused to find unique values in a field. This is a good way to quickly see all the values that appear in a field and also find typos, and other inconsistencies

Please let me know in case of any clarifications required. Thanks!

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.