MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. Auto sum Auto correct Auto format AutoFill Auto sum Auto correct Auto format AutoFill ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy formatting from one area in a worksheet and apply it to another area you would use: The Format Painter button on the standard toolbar The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu There is no way to copy and apply formatting in Excel – You have to do it manually The Edit > Copy Format and Edit>Paste Format commands form the menu The Format Painter button on the standard toolbar The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu There is no way to copy and apply formatting in Excel – You have to do it manually The Edit > Copy Format and Edit>Paste Format commands form the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? 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 The selected cells are deleted and cells are shifted up ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the formula palette to Enter assumptions data Format cells containing numbers Create and edit formula containing functions Copy a range of cells Enter assumptions data Format cells containing numbers Create and edit formula containing functions Copy a range of cells 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 Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above Click on Sheet 3 and from Edit menu choose Delete Both of above Right click on Sheet Tab of third sheet and choose Delete from the context menu None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Sheet tabs Position tabs Reference tabs Location tabs Sheet tabs Position tabs Reference tabs Location tabs ANSWER DOWNLOAD EXAMIANS APP