Question: Excel Case 2 . Create a workbook for a mobile services provider to calculate revenue from purchased mobile apps. Enter and format data, use SUMPRODUCT

 Excel Case 2 . Create a workbook for a mobile services

Excel Case 2 . Create a workbook for a mobile services provider to calculate revenue from purchased mobile apps. Enter and format data, use SUMPRODUCT to determine revenue by category, use TODAY, select a theme, add a footer, and set document properties In cell A1, enter a name for your mobile services company. In cell A2, type Last Month's Activity, In cells B3 D3, enter the labels App Name, Times Downloaded, and Cost. In cell A4, type Books as the first category. In cells A7, A10, and A13, type the names of three other categories of mobile applications. Examples might be Travel, Entertainment, Games, Health, Sports, and so on. In cells B5:06, complete data for two apps in the Books category. Then do the same for the other categories. Starting in row 18, create a section that calculates revenue from each app category using the SUMPRODUCT function. In a cell below the data, use the TODAY function and format the date to show a short date. Select a workbook theme if desired, use cell styles, or set your own formatting. Add a footer that shows the current date in the left section and your name in the right section Set document properties to show your name as the author and a title of your choice. Spell check the workbook if necessary. . . The completed file will be names as follows: yourinitials Case-2.xlsx Excel Case 2 . Create a workbook for a mobile services provider to calculate revenue from purchased mobile apps. Enter and format data, use SUMPRODUCT to determine revenue by category, use TODAY, select a theme, add a footer, and set document properties In cell A1, enter a name for your mobile services company. In cell A2, type Last Month's Activity, In cells B3 D3, enter the labels App Name, Times Downloaded, and Cost. In cell A4, type Books as the first category. In cells A7, A10, and A13, type the names of three other categories of mobile applications. Examples might be Travel, Entertainment, Games, Health, Sports, and so on. In cells B5:06, complete data for two apps in the Books category. Then do the same for the other categories. Starting in row 18, create a section that calculates revenue from each app category using the SUMPRODUCT function. In a cell below the data, use the TODAY function and format the date to show a short date. Select a workbook theme if desired, use cell styles, or set your own formatting. Add a footer that shows the current date in the left section and your name in the right section Set document properties to show your name as the author and a title of your choice. Spell check the workbook if necessary. . . The completed file will be names as follows: yourinitials Case-2.xlsx

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!