Question: TASK 6 - You are a librarian analyzing a small selection of checkout and book data at your library. Perform the following tasks: Task Summary

TASK 6 - You are a librarian analyzing a small selection of checkout and book data at your library. Perform the following tasks: Task Summary Required Actions XOn the Overdue Fines worksheet, write a formula in the Total Fine column that calculates each fine by multiplying the number of books checked out by the days overdue and 0.5. If there is no fine, it should display the words No Fine. XOn the Books worksheet, delete the row for A Memory of Light from the table. Do it in a way that doesn't leave a blank space and doesn't affect any data outside the table. On the Books worksheet, use Find and Replace to locate the ISBN containing the digits 5843. Replace them with the digits 4732. XRemove both conditional formatting rules from the Overdue Fines worksheet. Save the Books worksheet in the Documents folder as a .csv file. Keep the default filename. Evnlanation
 TASK 6 - You are a librarian analyzing a small selection

TASK 6 - You are a librarian analyzing a small selection of checkout and book data at your library. Perform the following tasks: Task Summary Required Actions XOn the Overdue Fines worksheet, write a formula in the Total Fine column that calculates each fine by multiplying the number of books checked out by the days overdue and 0.5 . If there is no fine, it should display the words No Fine. XOn the Books worksheet, delete the row for A Memory of Light from the table. Do it in a way that doesn't leave a blank space and doesn't affect any data outside the table. On the Books worksheet, use Find and Replace to locate the ISBN containing the digits 5843 . Replace them with the digits 4732 . XRemove both conditional formatting rules from the Overdue Fines worksheet. Save the Books worksheet in the Documents folder as a .cs.s. file. Keep the default filename

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!