MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Goal seek Square Divide Percentage Goal seek Square Divide Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet range is a A range of values such as from 23 to 234 A group of worksheets A group of cells A command used for data modeling A range of values such as from 23 to 234 A group of worksheets A group of cells A command used for data modeling ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Both of above None of above Click on Sheet 3 and from Edit menu choose Delete Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above None of above Click on Sheet 3 and from Edit menu choose Delete Right click on Sheet Tab of third sheet and choose Delete from the context menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which button do you click to add up a series of numbers? The autosum button The quicktotal button The total button The Formula button The autosum button The quicktotal button The total button The Formula button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can search by rows or columns or sheets You can search in formula too You can decide whether to look for the whole word or not You can search for bold and replace with italics You can search by rows or columns or sheets You can search in formula too You can decide whether to look for the whole word or not You can search for bold and replace with italics ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F10 F8 F11 F9 F10 F8 F11 F9 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS