MS Excel Which of the following option is not available in paste Special dialog box ? SQRT Subtract Add Divide SQRT Subtract Add Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two ? View > split Review > window View > window > split Window > split View > split Review > window View > window > split Window > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel The name box Shows the location of the previously active cell Appears to the left of the formula bar Appears below the menu bar Appears below the status bar Shows the location of the previously active cell Appears to the left of the formula bar Appears below the menu bar Appears below the status bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, a Data Series is defined as what? A cell reference 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data Subtotals Data, Sort Data, Table Data, Form Data Subtotals Data, Sort Data, Table Data, Form 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 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 Copy and Apply Formatting dialog box, located under the Format > Copy and Apply 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 Edit > Copy Format and Edit>Paste Format commands form the menu The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS