MS Excel
To create a formula, you can use:

Values but not cell references
Values or cell references although not both at the same time
Value and cell references
Cell references but not values

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

From Edit menu choose Clear and then Formats
Double click the Format Painter and then press Esc key in keyboard
Click on Remove Formatting tool on Standard Toolbar
From Edit menu choose Delete

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
Where can you set the shading color for a range of cells in Excel?

All of above
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar

ANSWER DOWNLOAD EXAMIANS APP