MS Excel You can select a single range of cells by Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Dragging over the desired cells Pressing the Shift key and an arrow key Pressing the Ctrl key while dragging over the desired cells Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells Dragging over the desired cells Pressing the Shift key and an arrow key Pressing the Ctrl key while dragging over the desired 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the formula palette to Create and edit formula containing functions Copy a range of cells Enter assumptions data Format cells containing numbers Create and edit formula containing functions Copy a range of cells Enter assumptions data Format cells containing numbers ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you link data maintained in an excel workbook to a word document The word document contains a reference to the original source application The word document must contain a hyperlink The word document cannot be edit The word document contains a copy of the actual data The word document contains a reference to the original source application The word document must contain a hyperlink The word document cannot be edit The word document contains a copy of the actual data ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? Cut and Paste Paste Special > Transpose None of above Both of above Cut and Paste Paste Special > Transpose None of above Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: The resulting values of a formula instead of the actual formula Formatting options Multiply the selection by a copied value Cell comments The resulting values of a formula instead of the actual formula Formatting options Multiply the selection by a copied value Cell comments ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS