MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can check the conditions against ____ when applying conditional formatting Cell value Both Formula None Cell value Both Formula None ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Data sheet Macro sheet Chart sheet Work sheet Data sheet Macro sheet Chart sheet Work sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Pressing the Shift key and an arrow key Dragging over the desired cells 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 Pressing the Shift key and an arrow key Dragging over the desired cells 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel To view a cell comment Click the edit comment command on the insert menu Position the mouse pointer over the cell Click the comment command on the view menu Click the display comment command on the window menu Click the edit comment command on the insert menu Position the mouse pointer over the cell Click the comment command on the view menu Click the display comment command on the window menu ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS