ITM Exam 1 Questions & Answers 2024/2025
ITM Exam 1 Questions & Answers 2024/2025 Pressing Shift+F3 opens the Insert Function dialog box. - ANSWERSTrue The PMT function assumes the borrower makes regular payments and the loan has a constant interest rate. - ANSWERSTrue Which of the following is not a basic rule for naming a cell range? - ANSWERSBegin a range name with a number. An IF function can test if monthly revenue is above or below average and display "Yes" or "No" in the cell. - ANSWERSTrue Which of the following Formula Auditing tools displays lines with arrows to identify all cells referenced in the formula in the active cell? - ANSWERSTrace precedents Which of the following functions multiplies the cells identified in its array arguments and then total those individual products? - ANSWERSSUMPRODUCT A circular reference occurs when a formula references the wrong cell address. - ANSWERSFalse Which format should you use to save a file if you want it to be compatible with earlier versions of Microsoft Excel? - ANSWERSExcel 97-2003 Workbook, AutoComplete works for labels, values, and alphanumeric data. - ANSWERSFalse Which of the following views opens the header and footer areas, indicates margin areas, and shows rulers? - ANSWERSPage layout
Document information
- Uploaded on
- May 11, 2024
- Number of pages
- 6
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers