MS Excel Which area in an Excel window allows entering values and formulas? Formula Bar Title Bar Standard Tool Bar Menu Bar Formula Bar Title Bar Standard Tool Bar Menu Bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Status indicators are located on the Standard toolbar Vertical scroll bar Horizontal scroll bar Formula bar Standard toolbar Vertical scroll bar Horizontal scroll bar Formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Pmt Sum Max Average Pmt Sum Max Average ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in row, select the same number of cells in row and paste 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 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 Copy the cells in row, select the same number of cells in row and paste 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Insert > Find from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Click the Find button on the standard toolbar Select Tools > Finder from the menu Select Insert > Find from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Click the Find button on the standard toolbar Select Tools > Finder from the menu ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS