MS Excel Which of the following series type is not valid for Fill Series dialog box ? Linear Time Autofill Growth Linear Time Autofill Growth ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F9 F8 F10 F11 F9 F8 F10 F11 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply 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 All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following options is not located in the page setup dialog box ? Page Break Preview Page Orientation Margins Headers and Footers Page Break Preview Page Orientation Margins Headers and Footers ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Border Copy handle Insert handle Fill handle Border Copy handle Insert handle Fill handle ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS