A 1 in Microsoft Excel is a value. A1 is a cell in column A and row 1.
The MODE function.
=MAX(X100:X111,Y20:Y57)
For each category, you should have an observed value and an expected value. Calculate (O-E)2 / E for each cell. Add the values across the categories. That is your chi-square test statistic.
ED50V10 (Readme) is an Excel add-in for calculating IC50/EC50 values. Input your data in the left columns, and your results will be shown in the right half of the Excel table. To calculate IC50, input 50 in the "INTERPOLATE..." table (highlighted in blue), the result will be shown on the right (highlighted in green).
VLOOKUP is a function of Microsoft Excel. You can use VLOOKUP to find a value in a table or list on an Excel sheet. It looks at a value in a column and finds the corresponding value in another column in the same row.
You would use the MEDIAN function. If the cells with your data were from A2 to D50, then the function would be:=MEDIAN(A2:D50)
=ROUND(8.4999,0) function will return 8.
Logical Test
The FV function.
depends on what context you mean it. if you want to deduct a certain cell value from the other cell value then minus sign will do just that.
It is called Merging in Microsoft Excel. There is one issue though, you gotta be careful when merging as either of the cell value could get deleted.