MS Excel
To create a formula, you first:

Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that you’re about to enter a formula
Choose the new command from the file menu
Enter the formula using any input values and the appropriate mathematical operators that make up your formula

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

Apply Conditional Formatting command on Format menu
Use =if() function to format the required numbers red
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
How do you delete a column?

Select the column heading you want to delete and select the Delete Row button on the standard toolbar
Select the row heading you want to delete and select Edit>Delete from the menu
Right click the column heading you want to delete and select delete from the shortcut menu
Select the column heading you want to delete and select Insert Delete from the menu

ANSWER DOWNLOAD EXAMIANS APP