MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Click on Sheet 3 and from Edit menu choose Delete Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above Both of above Click on Sheet 3 and from Edit menu choose Delete Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Financial Math & Trigonometry Logical Statistical Financial Math & Trigonometry Logical Statistical ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use drag-and-drop to embed excel worksheet data in a word document By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing Alt key By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of the listed here By dragging a range of excel data to the word button on the taskbar while pressing Alt key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Pressing an arrow key Clicking on the formula bar Pressing the Esc key Pressing the Tab key Pressing an arrow key Clicking on the formula bar Pressing the Esc key Pressing the Tab key ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a valid data type in Excel ? Date/Time Label Number Character Date/Time Label Number Character ANSWER DOWNLOAD EXAMIANS APP