MS Excel The autofill feature All of the listed here Extends a sequential series of data Automatically adds range of cell values Applies a boarder around the selected cells All of the listed here Extends a sequential series of data Automatically adds range of cell values Applies a boarder around the selected cells ANSWER DOWNLOAD EXAMIANS APP
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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a valid data type in Excel ? Character Date/Time Number Label Character Date/Time Number Label ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Concatenate and manipulate text Show formula error value Return ASCII values of characters Replace cell references Concatenate and manipulate text Show formula error value Return ASCII values of characters Replace cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Apostrophe (') Ampersand (&) Hash (#) Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) Exclamation (!) ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? 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 Counts empty cells ANSWER DOWNLOAD EXAMIANS APP