3.3 Project: Excel Chapter 1 (SIMnet) Independent Project 1-4 скачать в хорошем качестве

3.3 Project: Excel Chapter 1 (SIMnet) Independent Project 1-4

For Complete solution of Assignments and for the deal of complete Courses. Contact Me Contact Me For Help in Your Assignments and Courses WhatsApp : +923209088014 Email : myitlabservice@gmail.com WhatsApp Direct Link :https://wa.me/923209088014 We are handling all online courses, Business and Management, Business and Finance, Business and Accounting, HRM (Human resources management), History, English, literature, Nursing, Psychology, Statistics, IT (information technology), Applied sciences, Computer Science, Database Management system and many more. We will help you in weekly quizzes, assignments, Exam, thesis writing, Dissertation writing, SIMnet, Cengage Mindtap, Pearson MYITLAB and graduation all courses. We are dealing with complete courses in very reasonable prices. We can do complete MyITLab course , Microsoft Word ,Microsoft PowerPoint , Microsoft Excel , Microsoft Access. #3.3 Project: Excel Chapter 1 (SIMnet) Independent Project 1-4 #3.3 Project: Excel Chapter 1 (SIMnet) #Independent Project 1-4 #Project: Excel Chapter 1 #(SIMnet) #independent Project 1-4 #3.3 Project: Excel Chapter 1 (SIMnet) Independent Project 1-4 #3.3 Project: Excel Chapter 1 (SIMnet) #Independent Project 1-4 #Project: Excel Chapter 1 #(SIMnet) #independent Project 1-4#ExcelChapter1 #SIMnetProject #3_3Project #FormattingData #ExcelBasics #PivotTables #DueThisWeek #Excel Chapter 1 (SIMnet) #COURSE NAME CIS108 - MASTER 20250127 | 202506E OL CIS108 #COURSE NAME CIS108 #MASTER 20250127 #202506E OL CIS108 Mark the steps as checked when you complete them. Open the workbook BlueLake-01.xlsx start file. If the workbook opens in Protected View, click Enable Editing in the security bar. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. Apply the Office theme to the worksheet. Edit worksheet data. Edit the title in cell A2 to display First Period Sales by Department. Edit the value in cell D6 to 1950. Unmerge cells and reformat data. Select cells A1:A2. Click the Merge & Center button arrow [Home tab, Alignment group]. Choose Unmerge Cells. The cells are no longer merged but the cells still have Center alignment. Click the Align Left button [Home tab, Alignment group]. Change the font size to 16. Set the row height for rows 1:2 to 24. Use the Fill Handle to complete a series. Select cell B3. Use the Fill Handle to complete the series to April in column E. AutoFit columns C:E. Use the AutoSum button and the Fill Handle to calculate values. Select cell F4 and double-click the AutoSum button [Home tab, Editing group]. The suggested range is B4:E4 and the result is 13300. Double-click the Fill pointer for cell F4 to copy the function to cells F5:F18. Select cell G4. Click the AutoSum button arrow [Home tab, Editing group] and choose Max. Click and drag to select cells B4:E4 as the correct argument range (Figure 1-107) and press Enter. Do not include a total in a range when looking for the maximum. Select the range for the MAX function Figure 1-107 Select the range for the MAX function Select cell H4 and use the MIN function to calculate the worst sales for cells B4:E4. Select cells G4:H4 and double-click the Fill pointer at cell H4. Delete the contents of cells G18:H18. Select cell B18, click the AutoSum button [Home tab, Editing group], and accept the suggested range. Select cell B18 and drag its Fill pointer to cell F18. Ignore the Auto Fill Options button. AutoFit columns that do not display the data. Format labels and values. Select cells B4:H18 and click the Accounting Number Format button [Home tab, Number group]. Decrease the decimal two times. Select cells B5:H17 and press Ctrl+1 to open the Format Cells dialog box. Click the Number tab. The Category list displays Custom because you decreased decimal places. Select Accounting in the Category list on the Number tab. Click the Symbol drop-down list and select None. Click OK. It is common practice to show currency symbols with the first and last rows in a dataset (Figure 1-108). The dollar sign is the currency symbol in the first and last rows Figure 1-108 Accounting Number Format with and without currency symbols Format cells A3:H3 as Bold with Center alignment. Apply the All Borders format to cells A3:H18. Insert a blank row at row 3 and then increase the row height for row 4 to 18. IMPORTANT NOTE: To ensure accurate grading, this step must be completed. Select cells A2:H2 and choose Thick Bottom Border from the Border drop-down list. Right-align cell A19 and apply Bold to cells A19:F19. Increase the row height of row 19 to 18. Select cells A4:H4, press Ctrl and select cells A19:H19, and apply Light Gray, Background 2 as Fill Color. AutoFit column widths if needed. Insert a footer and scale the data to print. Click the Insert tab and click the Header & Footer button [Text group]. In the left footer section, insert the Sheet Name field.