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 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 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Logical Financial Statistical Math & Trigonometry Logical Financial Statistical Math & Trigonometry ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two Window > split Format > window View > split View > window > split Window > split Format > window View > split View > window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can auto fit the width of column by Double clicking on the column left border of column header Double click on the cell pointer in worksheet Double clicking on column right border on column header Double clicking on the column name on column header Double clicking on the column left border of column header Double click on the cell pointer in worksheet Double clicking on column right border on column header Double clicking on the column name on column header ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu There is no way to copy and apply formatting in Excel – You have to do it manually The Format Painter button on the standard toolbar The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu The Edit > Copy Format and Edit>Paste Format commands form the menu ANSWER DOWNLOAD EXAMIANS APP