CSE Exam 1 Exam Review Solution Questions & Answers

CSE Exam 1 Exam Review Solution Questions & Answers When you change the format of how a cell is displayed, it doesn't affect the actual value stored by the computer. True False - Correct Ans-true What cells are contained in the range D4:D8 d5, d6, d7 none of the choices are correct d4, d8 d4, d5, d6, d7, d8 - Correct Ans-d4, d5, d6, d7, d8 how would you refer to a cell that is on a worksheet Sheet5 in the fourth column, second row in an excel workbook? 5!2D Sheet5!D2 Sheet5!2D Sheet 52D 5:D2 - Correct Ans-Sheet5!D2 How would you enter a formula to calculate the result of $25,000 times 2 in a cell such that the formula produces no error and shows $50,000 (assume the cell is formatted to display as currency)? $25,000*2 25000x2 =$25,000*2 =25000*2 - Correct Ans-=25000*2 When writing formulas for spreadsheets in Excel, you do NOT need to pay attention to or worry about the order of precedence. True False - Correct Ans-False The value that Excel displays for a cell is always the precise value you enter in the spreadsheet or the precise value resulting from a formula in that cell that is stored by the software. True False - Correct Ans-False Why is it important to use cell references in functions or formulas in Excel? it greatly improves the readability, maintenance and reliability of the spreadsheet the formula or function won't work otherwise it is required when multiple cells are used in a formula or function you won't get accurate results otherwise CONTINUES...