MS Excel How do you rearrange the data in ascending or descending order? Data, Table Data Subtotals Data, Sort Data, Form Data, Table Data Subtotals Data, Sort Data, Form ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Chart sheet Data sheet Work sheet Macro sheet Chart sheet Data sheet Work sheet Macro sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet can have a maximum of ________ number of rows. 1048576 256 65535 1024 1048576 256 65535 1024 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Rounding errors can occur When you show the results of formulas with different decimal places that the calculated results Because excel uses hidden decimal places in computation When you use addition and subtraction in a formula When you use multiplication, division, or exponentiation in a formula When you show the results of formulas with different decimal places that the calculated results Because excel uses hidden decimal places in computation When you use addition and subtraction in a formula When you use multiplication, division, or exponentiation in a formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Edit > Delete command Deletes selected cells Deletes the comment of cell Deletes Formats of cell Deletes the content of a cell Deletes selected cells Deletes the comment of cell Deletes Formats of cell Deletes the content of a cell ANSWER DOWNLOAD EXAMIANS APP