MS Excel What does COUNTA () function do? Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells Counts empty cells Counts cells having alphabets Counts cells having number Counts non-empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet range is a A command used for data modeling A group of worksheets A range of values such as from 23 to 234 A group of cells A command used for data modeling A group of worksheets A range of values such as from 23 to 234 A group of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Format Painter button on the standard toolbar The Edit > Copy Format and Edit>Paste Format commands form the menu There is no way to copy and apply formatting in Excel – You have to do it manually The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Format Painter button on the standard toolbar The Edit > Copy Format and Edit>Paste Format commands form the menu 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 How do you select an entire column? Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Click the column heading letter Select Edit > Select > Column from the menu Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Click the column heading letter Select Edit > Select > Column from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Average Pmt Sum Max Average Pmt Sum Max ANSWER DOWNLOAD EXAMIANS APP