Скачать или смотреть Excel 2021 In Practice - Ch 6 Advanced Project 6-7 | SU25 | OPIM-3103-Business Information Systems

Whatsapp: +923177402009
Whatsapp: +923084981394
Email: [email protected]
Whatsapp link: https://wa.me/qr/ALGVOLHWN4M2K1

Instagram link: https://www.instagram.com/alim25431?i...

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English, Literature, Nursing, psychology, Statistics, Information Technology, Applied Sciences and Many more
#Excel 2021 In Practice - Ch 6 Advanced Project 6-7
#Excel 2021 In Practice Ch 6 #Advanced Project 6-7
#Excel 2021 In Practice - Ch 6 Advanced Project 6-7
#Excel 2021 In Practice Ch 6 Advanced Project 6-7
#Excel 2021 In Practice Ch 6 Advanced Project 6-7
#Excel 2021 In Practice - Ch 6 Advanced Project 6 7
#Excel 2021 In Practice - Ch 6 Advanced Project 6
#Excel 2021 In Practice - Ch 6 Advanced Project 7
#Excel 2021 #In Practice - Ch 6 #Advanced Project 6-7
#Excel 2021 In Practice #Ch 6 Advanced Project 6-7
#simnet #COURSE NAME OPIM 3103 #SU25 | #SU 25 #Fitzgerald OPIM-3103- #Business Information Systems

Steps to complete This Project
Mark the steps as checked when you complete them.
1. Open the Livingood-06 workbook and click the Enable Editing button. The file will be renamed automatically to
include your name.
2. Nest an IFERROR function with the formula.
a.
b.
c.
Select cell E6 on the Accounts Aging sheet and review the formula. The formula subtracts the invoice date
from today’s date in cell G1.
Nest an IFERROR formula to display Check date. instead of a standard error message.
Copy the IFERROR formula to cells E7:E20.
3. Monitor edits in the Watch Window.
a.
b.
c.
d.
Add cells C6:C20 as a watch in the Watch Window.
Click the Aging Detail sheet tab.
Build a Find and Replace command to replace all occurrences of “accoustaff” with AccounStaff throughout the
workbook. Use search and replace strings that maintain the comma and the word “Inc.”
Delete the watch names and close the Watch Window.
4. Use SUMIFS to calculate totals that are late by 30 days or more.
a.
b.
c.
d.
Click the Aging Detail sheet tab.
Name cells A5:E20 as Detail.
Use SUMIFS in cell H6 to calculate the total due from AccounStaff that is 30 or more days late.
Use SUMIFS for Custom Tax in cell H7.
1/2
https://uconn.simnetonline.com/sp/ass...
6/12/25, 1:26 PM
Format cells H6:H7 as Currency.
Excel 2021 In Practice - Ch 6 Advanced Project 6-7 - SIMnet
e.
5. Use COUNTIFS to calculate how many invoices are late by 30 days or more.
a.
b.
Use COUNTIFS in cell I6 to calculate the number of AccounStaff invoices that are 30 or more days overdue.
Use COUNTIFS for Custom Tax in cell I7.
6. Nest TEXT and CONCAT to display a sentence about the current date.
a.
b.
c.
d.
e.
f.
7.
Click cell A22 and start a CONCAT formula.
Type Today is with a space after the word “is” for the Text1 argument.
Nest the TEXT function from the Text category for the Text2 argument.
Type today() for the Value argument. The equals sign is not included when the function is used as an
argument.
Click the Format_text box and use format codes to spell out the month, show the day without leading zeros,
display a comma, and show four digits for the year.
Click OK.
Save and close the workbook (
Figure 6-121). (Your dates are volatile and will not match dates shown in
121.)
Figure