MS Excel An excel workbook is a collection of Workbooks Worksheets Worksheets and charts Charts Workbooks Worksheets Worksheets and charts Charts ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? All of above Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color on Fill Color tool in Formatting toolbar Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Drawing toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel adjusts absolute cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select Insert Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select Insert Delete from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a popular DOS based spreadsheet package? Lotus 1-2-3 Word Smart cell Excel Lotus 1-2-3 Word Smart cell Excel ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet A and C Provides a quick way to view the result of an arithmetic operation on a range of cells ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS