MS Excel In the formula, which symbol specifies the fixed columns or rows ? & $ % * & $ % * ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by Dragging over the desired cells Pressing the Shift key and an arrow key 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 Ctrl key while dragging over the desired cells Dragging over the desired cells Pressing the Shift key and an arrow key 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 Ctrl key while dragging over the desired cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F Ctrl + Shift + R Ctrl + H Ctrl + R Ctrl + F ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Choose the new command from the file menu Select the cell you want to place the formula into Enter the formula using any input values and the appropriate mathematical operators that make up your formula Type the equals sign (=) to tell Excel that you’re about to enter a formula Choose the new command from the file menu Select the cell you want to place the formula into Enter the formula using any input values and the appropriate mathematical operators that make up your formula Type the equals sign (=) to tell Excel that you’re about to enter a formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel To activate the previous cell in a pre-selected range, press The Enter key The Alt key The Tab key None of these The Enter key The Alt key The Tab key None of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel Getting data from a cell located in a different sheet is called ___ Accessing Functioning Referencing Updating Accessing Functioning Referencing Updating ANSWER DOWNLOAD EXAMIANS APP