MS Excel The autofill feature Automatically adds range of cell values All of the listed here Extends a sequential series of data Applies a boarder around the selected cells Automatically adds range of cell values All of the listed here Extends a sequential series of data Applies a boarder around the selected cells 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 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 All of above Use =if() function to format the required numbers red 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 All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data Subtotals Data, Form Data, Table Data, Sort Data Subtotals Data, Form Data, Table Data, Sort ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you link data maintained in an excel workbook to a word document The word document cannot be edit The word document contains a reference to the original source application The word document contains a copy of the actual data The word document must contain a hyperlink The word document cannot be edit The word document contains a reference to the original source application The word document contains a copy of the actual data The word document must contain a hyperlink ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a popular DOS based spreadsheet package? Smart cell Lotus 1-2-3 Excel Word Smart cell Lotus 1-2-3 Excel Word ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP