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 .cs.s. file. Keep the default filename
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
