When the workbook is completed, rows beyond the loan term should look blank on your screen. For example, if the term is set to $10$ then rows for periods $11-20$ should not be visible, i$.$e$.,$ "blanked out".Devise a way to accomplish this using the IF function with $""(2$ double quotes$)$ for "blanked out" cells and the ROW function to calculate the End of Period$)$ cell value. There are other ways of accomplishing this, so be sure to use only this method for displaying "blanked out" cell contents. $($Do not use conditional formatting to "blank out" rows or use a custom number format $($ex$."$ :$"$ or similar$)$ to blankout cells in the workbook.