MS Excel Which of the following action removes a sheet from workbook? Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet Both of above None of above Select the sheet then choose Format > Sheet > Hide Select the sheet, then choose Edit > Delete Sheet Both of above None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of following is Not one of Excel's what-if function? Scenario manager Auto Outline Solver Goal seek Scenario manager Auto Outline Solver Goal seek 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 All of above 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 Use =if() function to format the required numbers red All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + F Ctrl + R Ctrl + H Ctrl + Shift + R Ctrl + F Ctrl + R Ctrl + H Ctrl + Shift + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? Press Ctrl + Home Press Home Press Alt + Home Press Shift + Home Press Ctrl + Home Press Home Press Alt + Home Press Shift + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Split command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu Split command on the window menu Freeze panes command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS