MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + Shift + R Ctrl + H Ctrl + F Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F Ctrl + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created The status bar does not display the cell address Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To add borders To add shading or color to a cell range To select a distribution of figures To insert a background To add borders To add shading or color to a cell range To select a distribution of figures To insert a background ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a basic step in creating a worksheet? Copy the worksheet Enter text and data Save workbook Modifiy the worksheet Copy the worksheet Enter text and data Save workbook Modifiy the worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel When integrating word and excel, word is usually the Destination Client Both b and c Server Destination Client Both b and c Server 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 select the Centered alignment From Format Cells dialog box click on Merge Cells check box 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 select the Centered alignment From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS