Learning Objectives By the end of this section, you will be able to: WorldCorp has sufficient savings for capital investment for the Fairfax project, yet the chief financial officer (CFO) wants to borrow from a bank about 50 percent of…
Figure 10.1 Manufacturing involves a lot of data analysis, and Excel’s data analytics supports corporations every day. (credit: modification of “Man Standing Beside Heavy Equipment” by Kateryna Babaieva/Pexels, CC0) Chapter Outline 10.1 Data Tables and Ranges 10.2 More About Formulas 10.3 Using Arithmetic, Statistical, and…
Microsoft Excel Basics Text and Numbers in Microsoft Excel Calculations and Basic Formulas in Microsoft Excel Formatting and Templates in Microsoft Excel Google Sheets Basics Text and Numbers in Google Sheets Calculations and Basic Formulas in Google Sheets Formatting and…
Learning Objectives By the end of this section, you will be able to: Google Sheets has the same formatting features that Microsoft Excel does. The cell formatting of fonts and shading of cells is part of everyday use when making…
Learning Objectives By the end of this section, you will be able to: Microsoft Excel has been around for decades, yet there are no functions for subtracting or dividing numbers. Users must still build formulas with the appropriate mathematical operator…
Learning Objectives By the end of this section, you will be able to: There is a great need for text and numeric data in databases. For example, in WorldCorp’s database, the client’s surnames and given names are in two separate…
Learning Objectives By the end of this section, you will be able to: Google Sheets is another spreadsheet application that has much of the same functionality as Microsoft Excel. They have similar GUIs, in that they use window menus and…
Learning Objectives By the end of this section, you will be able to: At WorldCorp, there is so much data that it is impossible to look at it all at once. For example, on a long worksheet with several hundred…
Learning Objectives By the end of this section, you will be able to: At WorldCorp, you manage several account teams, each of which has a sales team. Part of your job is to compare the sales agents’ revenues using some…
Learning Objectives By the end of this section, you will be able to: WorldCorp receives many orders every day, and they rely on databases for recording all data. Large corporations like WorldCorp also keep an inventory of direct materials for…