MS Excel The auto calculate feature Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts empty cells Counts cells having number Counts non-empty cells Counts cells having alphabets Counts empty cells Counts cells having number Counts non-empty cells Counts cells having alphabets ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To add borders To add shading or color to a cell range To insert a background To select a distribution of figures To add borders To add shading or color to a cell range To insert a background To select a distribution of figures ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can activate a cell by Pressing an arrow key Pressing the Tab key Clicking the cell All of these Pressing an arrow key Pressing the Tab key Clicking the cell All of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by 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 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 + F Ctrl + H Ctrl + Shift + R Ctrl + R Ctrl + F Ctrl + H Ctrl + Shift + R Ctrl + R ANSWER DOWNLOAD EXAMIANS APP