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 From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Clear and then Formats From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard ANSWER DOWNLOAD EXAMIANS APP
MS Excel To record a sequence of keystrokes and mouse actions to play back later we use: Calculator Macro Recorder Media player Sound Recorder Calculator Macro Recorder Media player Sound Recorder ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Geometric modeling tool A cell that points to a drawing object Always erroneous A formula that either directly or indirectly depends on itself Geometric modeling tool A cell that points to a drawing object Always erroneous A formula that either directly or indirectly depends on itself ANSWER DOWNLOAD EXAMIANS APP
MS Excel To save a workbook, you: Click the save button on the standard toolbar from the menu Press Ctrl+ F5 Click Save on the Windows Start button Select Edit > Save Click the save button on the standard toolbar from the menu Press Ctrl+ F5 Click Save on the Windows Start button Select Edit > Save ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date only in MS Excel? Time () Date () Now () Today () Time () Date () Now () Today () ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Apply Conditional Formatting command on Format menu All of above 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 Apply Conditional Formatting command on Format menu All of above Use =if() function to format the required numbers red ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS