Excel 2019 Bible

Chapter 33: Analyzing Data with the Analysis ToolPak 3333 these labels in the tables that it produces. Most tools also provide d ...

Part IV: Managing and Analyzing Data Two-factor with replication A two-way analysis of variance, with multiple samples (or repli ...

Chapter 33: Analyzing Data with the Analysis ToolPak 3333 FIGURE 33.3 The Correlation dialog box The resulting correlation matri ...

Part IV: Managing and Analyzing Data relative weighting of the previous data point and the previously predicted data point. You ...

Chapter 33: Analyzing Data with the Analysis ToolPak 3333 FIGURE 33.5 Output from the F-test tool Histogram The histogram tool i ...

Part IV: Managing and Analyzing Data FIGURE 33.6 Use the histogram tool to generate distributions and graphical output. Figure 3 ...

Chapter 33: Analyzing Data with the Analysis ToolPak 3333 FIGURE 33.7 A chart produced from data generated by the moving average ...

Part IV: Managing and Analyzing Data FIGURE 33.8 This dialog box enables you to generate a wide variety of random numbers. In th ...

Chapter 33: Analyzing Data with the Analysis ToolPak 3333 Discrete This option enables you to specify the probability that speci ...

Part IV: Managing and Analyzing Data As you can see, the Regression dialog box offers many options: Input Y Range The range that ...

Chapter 33: Analyzing Data with the Analysis ToolPak 3333 FIGURE 33.10 Output from the paired T-test dialog box Z-test (two-samp ...

769 C H A P T E R 34 Protecting Your Work IN THIS CHAPTER Protecting worksheets Protecting workbooks Protecting Visual Basic Pro ...

Part IV: Managing and Analyzing Data Protecting a Worksheet You may want to protect a worksheet for a variety of reasons. One co ...

Chapter 34: Protecting Your Work 34 By default, all cells are locked, and worksheets are unprotected. To change the Locked attri ...

Part IV: Managing and Analyzing Data FIGURE 34.3 Excel warns you if you attempt to change a locked cell. The Locked attribute ma ...

Chapter 34: Protecting Your Work 34 See Chapter 31, “Performing Spreadsheet What-If Analysis,” for more on creating and using sc ...

Part IV: Managing and Analyzing Data Dismiss the remaining dialog boxes by clicking OK. Protect the sheet. You can click the Pr ...

Chapter 34: Protecting Your Work 34 You need to perform these steps only once. You don’t need to specify the password every time ...

Part IV: Managing and Analyzing Data Protecting a workbook’s structure To prevent others (or yourself) from performing certain a ...

Chapter 34: Protecting Your Work 34 In previous versions of Excel, you could also protect a workbook’s windows. This type of pro ...