### How to calculate Z-scores in Excel

To describe a value's relationship to the mean of a group of values , sometimes we need to calculate Z-scores. The formula used to calculate a Z-score is Z=(x-µ)/σ, where· x is the value that needs to be standardized· μ is the mean of the given dataset· σ is the standard deviation of the given datasetHere are the steps.1. Here we have a set of data that simulates the sales of coffee. Before calculating the Z-scores, we must calculate the mean and standard deviation of given data by....

### How to insert header and footer in Excel？

To make a table normative, we can insert header and footer when printing. The methods of header and footer are the same, so here we take header as an example. Here are the steps.1. Open your Excel document, click Menu > Print > Print Preview to enter the print preview mode. 2. Click Header and Footer on the toolbar to pop up a dialog. 3. We can select a built-in header from the drop-down menu. And check Different odd and even pages and Different first page according to actual needs. 4....

### IRR Function in EXCEL

· Description:IRR means the Internal Rate of Return that is represented by numbers for a series of cash flows. It requires that the cash flows are at regular intervals. · Syntax:(Value, guess) · Arguments:Value is an array or a reference to cells that contain numbers for which you want to calculate the internal rate of return.Guess is a number that you guess is close to the result of IRR; 0.1 (10 percent) of omitted. · Example:Suppose we want to calculate the IRR of this investment p....

### Date Format in EXCEL

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Date formats display date and time serial numbers as date values, which are commonly used in our daily life.· 1. What is the date format?Dates are stored as integers in a table, the way it represented as a date is only because of the set of cell format. The default day is 1990/1/1, which is the start of every other date. For example, 2021/12/10 is stored as ....

### How to add music on PowerPoint？

1. Select the slide in which we want to insert music. Click the Insert tab > the Audio drop-down button.2. There are four options: Insert Audio, Link to Sound, Background Music and Link Background Music. Tips:Audio: Played in the inserted slide.Background music: Played in all slides as background music.3. Here we take Insert Audio as an example. In the pop-up window, we select the audio that we want to insert, and click Open. Now, we have put this video in PowerPoint. 4. Then, we can p....

### How to make a picture transparent in PowerPoint

How can we make an inserted picture transparent? You may find it cannot be done by editing the picture. There is another method for you. 1. Click Insert > Shape> Rectangle to insert a rectangle of your desired picture’s size. 2. Double click the rectangle to pop-up a Object Formatting pane. Select Picture or texture to fill, and in the Picture Fill area, click the Select the picture button to select a desired picture. Then adjust its transparency in the lower region according to indivi....

### How to insert carriage return in Excel

· Option 1:1. Click the cell within the long sentence.2. Click where we want to insert carriage return, and press the shortcut Alt+Enter.3. Then, the carriage return has been inserted. We push the content to a new line in the same cell. · Option 2:We want to combine the values of several cells into a new cell. And, we need each value to be a new line in the new cell.If we use the shortcut key every time, it can be a very tedious task. In order to save time and improve efficiency, we ca....

### XIRR Function in EXCEL

· Description:IRR means the Internal Rate of Return that is represented by numbers for a series of cash flows. Compared with the IRR function.The XIRR function can calculate the IRR of irregular intervals, which can return the internal rate of return for a schedule of cash flows. · Syntax:(Value, dates, guess) · Arguments:Value is a series of cash flows that correspond to a schedule of payments in dates. Dates is a schedule of payment dates that corresponds to the cash flow payments.G....