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 When you copy a formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you set the shading color for a range of cells in Excel? Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar Choose required color on Fill Color tool in Drawing toolbar All of above Choose required color form Patterns tab of Format Cells dialog box Choose required color on Fill Color tool in Formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; A horizontal axis The data range that supply chart data The organization of individual values with a chart’s data series A chart plot area A horizontal axis The data range that supply chart data The organization of individual values with a chart’s data series A chart plot area ANSWER DOWNLOAD EXAMIANS APP
MS Excel The name box Appears below the status bar Appears to the left of the formula bar Shows the location of the previously active cell Appears below the menu bar Appears below the status bar Appears to the left of the formula bar Shows the location of the previously active cell Appears below the menu bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two ? View > split View > window > split Review > window Window > split View > split View > window > split Review > window Window > split ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS