MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Work sheet Data sheet Macro sheet Chart sheet Work sheet Data sheet Macro sheet Chart sheet 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 None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above Click on Sheet 3 and from Edit menu choose Delete None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above 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 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 The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually 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 The Format Painter button on the standard toolbar There is no way to copy and apply formatting in Excel – You have to do it manually ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Position tabs Reference tabs Sheet tabs Location tabs Position tabs Reference tabs Sheet tabs Location tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar Shows the name of workbook currently working on Shows the name of worksheet currently working on None of the listed here Shows the name of cell or range currently working on Shows the name of workbook currently working on Shows the name of worksheet currently working on None of the listed here Shows the name of cell or range currently working on ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification Scenarios Contents Objects All of the listed here Scenarios Contents Objects All of the listed here ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS