MSIS 3223 EXAM 1 (APPENDIX A1, CH. 1-4) ACTUAL 2025/2026 QUESTIONS AND 100% CORRECT ANSWERS

MSIS 3223 EXAM 1 (APPENDIX A1, CH. 1-4) ACTUAL 2025/2026 QUESTIONS AND 100% CORRECT ANSWERS Cell references - Answer -_____ in formulas can be written with either relative addresses or absolute addresses. Relative - Answer -A(n) _____ address uses just the row and column label in the cell reference (for example A4 or C23). Absolute - Answer -A(n) _____ address uses a dollar sign ($) before either the row or column or both ($A2, C$23, or $B$15). B$4 - Answer -Using a dollar sign ($) before a row label (for example _____) keeps the reference fixed to row 4 but allows the column reference to change if the formula is copied to another cell. $B$4 - Answer -Using a dollar sign ($) before both the row and column (for example _____) will keep the reference fixed for both the row and column