MS Excel Which of the following is not the correct method of editing the cell content? Click the formula bar Press the Alt key Press the F2 key Double click the cell Click the formula bar Press the Alt key Press the F2 key Double click the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts non-empty cells Counts cells having alphabets Counts cells having number Counts empty cells Counts non-empty cells Counts cells having alphabets Counts cells having number Counts empty cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data, Table Data, Form Data Subtotals Data, Sort Data, Table Data, Form Data Subtotals Data, Sort ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can select a single range of cells by 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 Pressing the Shift key and an arrow key Dragging over the desired 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 The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel The numbers in our worksheet look like this 1000: You want them to look like this: $1,000.How can you accomplish this? None of the listed here You have to retype everything and manually add the dollar signs, commas, and decimals Select Format > Money from the menu Click the Currency Style button on the formatting toolbar None of the listed here You have to retype everything and manually add the dollar signs, commas, and decimals Select Format > Money from the menu Click the Currency Style button on the formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS