- Using Date and Time Functions - Creating Formulas Referencing Data Other Works

Question

- Using Date and Time Functions - Creating Formulas Referencing Data Other Worksheets Data from - Calculating Loan Payments Using the PMIT Function L. Open the start file EX2013-Fixlt-3-6. The file will be renamed automatically to include your name. 2. Ifthe workbook opens in Protected View, dick the Enable Editing button in the Messge Bar at the 3. On the Gwesd ist sheet, check all the formulas. Cells to check are illed with the light orange color. Most Change the project file name if directed to do so by your instructor, and save it. top of the workbook so you can modify the workbook of them need to be corrected. a. In the Name Tag column, enter a formula to display the guest name in this format BILL SMITH b. Correct the function used in cell A3 to calculate the sum of the values in the Nam Atending column. c. Correct the function used in cell A4 to count the number of values in the Streef column d. Correct the function used in cell A5 to count the number o blank cells in the Nam Attending column. c. Correct the function used in cell A6 to display the largest value in the Num Aitending column. f. Correct the function used in cell A7 to display the average valuc in the Num Attending column.

Explanation / Answer

a. =concatenate(c10," ",b10)

b. =sum(j10:j28)

c.. =counta(e10:e28)

d.=countblank(j10:j28)

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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