MS Excel The shortcut key Ctrl + R is used in Excel to Remove the cell contents of selected cells Fill the selection with active cells to the right Right align the content of cell None of above Remove the cell contents of selected cells Fill the selection with active cells to the right Right align the content of cell None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you display current date and time in MS Excel ? Time() Now () Today () Date () Time() Now () Today () Date () 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? Click on Sheet 3 and from Edit menu choose Delete Both of above None 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 Both of above None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Pressing the Esc key Clicking on the formula bar Pressing an arrow key Pressing the Tab key Pressing the Esc key Clicking on the formula bar Pressing an arrow key Pressing the Tab key ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references 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 Work sheet Macro sheet Data sheet Chart sheet Work sheet Macro sheet Data sheet ANSWER DOWNLOAD EXAMIANS APP