MS Excel In Excel, a Data Series is defined as what? A collection of related data A type of chart A division of results A cell reference A collection of related data A type of chart A division of results A cell reference ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Ctrl + Home Press Shift + Home Press Home Press Alt + Home Press Ctrl + Home Press Shift + Home Press Home Press Alt + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel The command Edit > Fill Across Worksheet is active only when None of the listed here One sheet is selected When many sheets are selected When no sheet is selected None of the listed here One sheet is selected When many sheets are selected When no sheet is selected ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can set Page Border in Excel from From Border tool in Formatting toolbar You can not set Page Border in Excel From Line style tool in Drawing toolbar From Border tab in Farmat cells dialog box From Border tool in Formatting toolbar You can not set Page Border in Excel From Line style tool in Drawing toolbar From Border tab in Farmat cells dialog box ANSWER DOWNLOAD EXAMIANS APP