MS Excel Which of the following series type is not valid for Fill Series dialog box ? Time Growth Linear Autofill Time Growth Linear Autofill ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above Double CAL indicator on status bar None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above Double CAL indicator on status bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can merge the main document with data source in Excel. In mail merge operation, Word is usually Source Client None of these Server Source Client None of these Server ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet can have a maximum of ________ number of rows. 1024 65535 256 1048576 1024 65535 256 1048576 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 A10 Sheet3.A10 Sheet1!A10 Sheet3!A10 A10 Sheet3.A10 Sheet1!A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply All of above Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS