a. (Alt) b. [Spacebar) d. [6] Skills Review 1. View and arrange worksheets. a. Start orlopen the file EX -2.xlsx from the location where you store your Data files than it as EX F-Coffee. b. Open another instance of the workbook in a new window c. Activate the last sheet in the EX T-Coffee.xlsx: l workbook Activate the West sheet in the EX E.Coffee you workbook d. View the EX Coffee.xlsx:1 and EX F-Coffee.xlsx:2 workbooks tiled horizontally. View the workbooks in a vertical arrangement e. Hide the EX .Coffee xlsx 2 instance, then unhide the instance. Close the EX -Coffee xlsx:2 instance, maximize the EX .Coffee xlsx workbook 2. Protect worksheets and workbooks. a. On the East sheet, unlock the expense data in the range B12-F19. b. Protect the sheet without using a password. C. To make sure the other cells are locked, attempt to make an entry in cell 04 and exity that you receive an error message d. Change the first quarter mortgage expense in cell B12 to 5500 e. Protect the workbook's structure without applying a pasword. Right click the East and West sheet als to sety that you cannot insert, delete, rename, move, copy, hide, or unhide the sheets, or change their tab color f. Unprotect the workbook. Unprotect the East worksheet. & Save the workbook 3. Save custom views of a worksheet. a. Using the East sheet, create a custom view of the entire worksheet called Entire East Budget. b. Hide rows 10 through 23, then create a new view called Income showing only the income data. c. Use the Custom Views dialog box to display all of the data on the East worksheet. d. Use the Custom Views dialog box to display only the income data on the East worksheet. e. Use the Custom Views dialog box to return to the Entire East Budget View. f. Save the workbook. 2013 Managing Workbook Data Curl Gridlines s Zoom age brease tom Preview Layout Views Workbook Views 100% Zoom to New Selection Window Arrange Freeze All Panes - Switch Windows Unhide B Reset Window Position Window 115 X FGH for Campus Coffee Shop East Campus Quarterly Budget 1st QTR 2nd QTR 3rd QTR 4th QTR on WN - Description TOTAL% OF TOTAL 6 Coffee 7,155 S 6,957 S 3,977 S 18,090 $ Income 8,687 S 6,327 S 6,819 $ 4,719 S 8.719 S 19,725 $ 19,765 $ 8,234 S 6,819 $ 4,419 S 19,472 S 30,404 25,314 21,334 77,052 39.46% 32.85% 27.69% Pastries 9 TOTAL 100.00% 11 12 Mortgage 13 Payroll 14 Pastries 15 Utilities 16 Phone 17 Coffee 18 Tea 19 Advertising 20 TOTAL 5,400 $ 5,500 $ 1,350 $ 695 $ 3955 695 $ 295 $ 550 S 14,860 $ Expenses 5.400 S 5,400 S 5,500 S 5,500 $ 1,350 S 1,280 S 695 S 6955 395 S 395 $ 695 S 5905 370 S 354 S 550 $ 550 $ 14,955 S 14,764 $ 5,400 $ 6,950 $ 1,150 $ 695 $ 395 $ 695 5 4215 5505 16,256 S 21,600 23,450 5,130 2,780 1,580 2,675 1,440 2,200 60,855 35.49% 38.53% 8.43% 4.57% 2.60% 4.40% 2.37% 3.62% 100.00% Cash Flow 4,770 S 5,001 % 3,210 $ 3,216 S 16,197 West U new Selection Window Zoom range Freeze All Panes Show Macie Switch Windows Unhide Reset Window Position Window A2 4 Workbook Views : X A fx West Campus Quarterly Budget LE West Campus Quarterly Budget 1st QTR 2nd QTR 3rd QTR 4th QTR 3 Description ch WN TOTAL % OF TOTAL 6 Coffee Tea 8 Pastries 9 TOTAL 7,328 $ 6,927 $ 3,897 s 18,152 $ Income 8,208 $ 6,523 S 6,964 $ 4,664 S 9,315 $ 9,615 $ 24,487 S 20,802 $ 8,234 S 6,964 $ 9,915 S 25,113 $ 30,292 25,519 32,742 88,554 34.21% 28.82% 36.97% 100.00% O $ 5,500 5,314 1,550 12 Mortgage 13 Payroll 14 Pastries 15 Utilities 16 Phone 17 Coffee 18 Tea 19 Advertising 20 TOTAL 524 Expenses 5,500 $ 6,584 S 1,550 $ 624 S 425 $ 570 $ 570 S 422 S 322 $ 585 S 585 S 16,260 S 12,134 $ UU 5,500 5 4,512 s 4,211 s 563 S 425 $ 570 $ 411 S 425 570 $ 315 S 585 $ 14,783 S 22,000 19,631 8,591 1,942 1,700 2,280 1,470 2,340 59,954 36.69% 32.74% 14.33% 3.24% 2.84% 3.80% 2.45% 3.90% 100.00% 585 16,777 S Cash Flow 8,227 S 8,668 S 3,369 S 8,336 $ 28,600 East West READY 00172019 Student Dashboar.. ASA College Ne e X x Coffee a. (Alt) b. [Spacebar) d. [6] Skills Review 1. View and arrange worksheets. a. Start orlopen the file EX -2.xlsx from the location where you store your Data files than it as EX F-Coffee. b. Open another instance of the workbook in a new window c. Activate the last sheet in the EX T-Coffee.xlsx: l workbook Activate the West sheet in the EX E.Coffee you workbook d. View the EX Coffee.xlsx:1 and EX F-Coffee.xlsx:2 workbooks tiled horizontally. View the workbooks in a vertical arrangement e. Hide the EX .Coffee xlsx 2 instance, then unhide the instance. Close the EX -Coffee xlsx:2 instance, maximize the EX .Coffee xlsx workbook 2. Protect worksheets and workbooks. a. On the East sheet, unlock the expense data in the range B12-F19. b. Protect the sheet without using a password. C. To make sure the other cells are locked, attempt to make an entry in cell 04 and exity that you receive an error message d. Change the first quarter mortgage expense in cell B12 to 5500 e. Protect the workbook's structure without applying a pasword. Right click the East and West sheet als to sety that you cannot insert, delete, rename, move, copy, hide, or unhide the sheets, or change their tab color f. Unprotect the workbook. Unprotect the East worksheet. & Save the workbook 3. Save custom views of a worksheet. a. Using the East sheet, create a custom view of the entire worksheet called Entire East Budget. b. Hide rows 10 through 23, then create a new view called Income showing only the income data. c. Use the Custom Views dialog box to display all of the data on the East worksheet. d. Use the Custom Views dialog box to display only the income data on the East worksheet. e. Use the Custom Views dialog box to return to the Entire East Budget View. f. Save the workbook. 2013 Managing Workbook Data Curl Gridlines s Zoom age brease tom Preview Layout Views Workbook Views 100% Zoom to New Selection Window Arrange Freeze All Panes - Switch Windows Unhide B Reset Window Position Window 115 X FGH for Campus Coffee Shop East Campus Quarterly Budget 1st QTR 2nd QTR 3rd QTR 4th QTR on WN - Description TOTAL% OF TOTAL 6 Coffee 7,155 S 6,957 S 3,977 S 18,090 $ Income 8,687 S 6,327 S 6,819 $ 4,719 S 8.719 S 19,725 $ 19,765 $ 8,234 S 6,819 $ 4,419 S 19,472 S 30,404 25,314 21,334 77,052 39.46% 32.85% 27.69% Pastries 9 TOTAL 100.00% 11 12 Mortgage 13 Payroll 14 Pastries 15 Utilities 16 Phone 17 Coffee 18 Tea 19 Advertising 20 TOTAL 5,400 $ 5,500 $ 1,350 $ 695 $ 3955 695 $ 295 $ 550 S 14,860 $ Expenses 5.400 S 5,400 S 5,500 S 5,500 $ 1,350 S 1,280 S 695 S 6955 395 S 395 $ 695 S 5905 370 S 354 S 550 $ 550 $ 14,955 S 14,764 $ 5,400 $ 6,950 $ 1,150 $ 695 $ 395 $ 695 5 4215 5505 16,256 S 21,600 23,450 5,130 2,780 1,580 2,675 1,440 2,200 60,855 35.49% 38.53% 8.43% 4.57% 2.60% 4.40% 2.37% 3.62% 100.00% Cash Flow 4,770 S 5,001 % 3,210 $ 3,216 S 16,197 West U new Selection Window Zoom range Freeze All Panes Show Macie Switch Windows Unhide Reset Window Position Window A2 4 Workbook Views : X A fx West Campus Quarterly Budget LE West Campus Quarterly Budget 1st QTR 2nd QTR 3rd QTR 4th QTR 3 Description ch WN TOTAL % OF TOTAL 6 Coffee Tea 8 Pastries 9 TOTAL 7,328 $ 6,927 $ 3,897 s 18,152 $ Income 8,208 $ 6,523 S 6,964 $ 4,664 S 9,315 $ 9,615 $ 24,487 S 20,802 $ 8,234 S 6,964 $ 9,915 S 25,113 $ 30,292 25,519 32,742 88,554 34.21% 28.82% 36.97% 100.00% O $ 5,500 5,314 1,550 12 Mortgage 13 Payroll 14 Pastries 15 Utilities 16 Phone 17 Coffee 18 Tea 19 Advertising 20 TOTAL 524 Expenses 5,500 $ 6,584 S 1,550 $ 624 S 425 $ 570 $ 570 S 422 S 322 $ 585 S 585 S 16,260 S 12,134 $ UU 5,500 5 4,512 s 4,211 s 563 S 425 $ 570 $ 411 S 425 570 $ 315 S 585 $ 14,783 S 22,000 19,631 8,591 1,942 1,700 2,280 1,470 2,340 59,954 36.69% 32.74% 14.33% 3.24% 2.84% 3.80% 2.45% 3.90% 100.00% 585 16,777 S Cash Flow 8,227 S 8,668 S 3,369 S 8,336 $ 28,600 East West READY 00172019 Student Dashboar.. ASA College Ne e X x Coffee
