MS Excel How do you rearrange the data in ascending or descending order? Data, Table Data, Sort Data Subtotals Data, Form Data, Table Data, Sort Data Subtotals Data, Form ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following format you can decide to apply or not in AutoFormat dialog box? Font format Border format All of above Number format Font format Border format All of above Number format ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The selected cells are deleted and cells are shifted up The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and the cells are shifted left ANSWER DOWNLOAD EXAMIANS APP
MS Excel The autofill feature Extends a sequential series of data Applies a boarder around the selected cells All of the listed here Automatically adds range of cell values Extends a sequential series of data Applies a boarder around the selected cells All of the listed here Automatically adds range of cell values ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of following is Not one of Excel's what-if function? Scenario manager Auto Outline Solver Goal seek Scenario manager Auto Outline Solver Goal seek ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? None of above Both of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Click on Sheet 3 and from Edit menu choose Delete None of above Both of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Click on Sheet 3 and from Edit menu choose Delete ANSWER DOWNLOAD EXAMIANS APP