question archive Shelly Cashman Excel 2019 Module 2:SAM Project 1b Edgerton-Norris Shelly Cashman Excel 2019 | Module 2: SAM Project 1b Format Worksheets GETTING STARTED Open the file SC_EX19_2b_FirstLastName_1
Subject:MS ExcelPrice:19.87 Bought3
Shelly Cashman Excel 2019 Module 2:SAM Project 1b
Caleb Ramos is a manager in the Accounts Receivable Department of Edgerton-Norris, a pharmaceutical company in Minneapolis, Minnesota. Caleb has started to create an Excel workbook to produce and track client invoices. He asks you to format the workbook to make the information clearer and easier to understand. Go to the Invoice worksheet. Change the name of the worksheet tab to Current Invoice to use a more descriptive name.
Caleb wants to keep a running count of the invoices sent to clients. In cell B3, enter a formula that uses the COUNTA function to count the values in the range A5:A15 to determine the number of invoices.
Caleb also wants to highlight the invoices that have not been paid. In the range F5:F15, use Conditional Formatting Highlight Cells Rules to format cells containing a cell value equal to N in Light Red Fill with Dark Red Text.
Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.