MS Excel Which of the following series type is not valid for Fill Series dialog box ? Growth Autofill Time Linear Growth Autofill Time Linear ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar None of above Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Double CAL indicator on status bar None of above Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button 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 Hold titles command on the edit menu Unfreeze panes command on the window menu Freeze panes command on the window menu Split command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu Freeze panes command on the window menu 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 Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Percentage Goal seek Divide Square Percentage Goal seek Divide Square ANSWER DOWNLOAD EXAMIANS APP
MS Excel The autofill feature Extends a sequential series of data Automatically adds range of cell values All of the listed here Applies a boarder around the selected cells Extends a sequential series of data Automatically adds range of cell values All of the listed here Applies a boarder around the selected cells ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS