The formula to calculate the average of a given range of data from cell B2 to cell D4 in a Microsoft Excel worksheet is

The formula to calculate the average of a given range of data from cell B2 to cell D4 in a Microsoft Excel worksheet is "=AVERAGE(B2:D4)". This formula uses the "AVERAGE" function in Excel, which calculates the average of a range of values. The range of values is specified by the parameters inside the parentheses, which in this case are "B2:D4". The colon (:) between B2 and D4 indicates that the range includes all the cells between and including B2 and D4. By using this formula, Excel will calculate the average of all the values within the specified range and display the result in the cell where the formula is entered.