MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) 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 The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To insert a background To add shading or color to a cell range To add borders To select a distribution of figures To insert a background To add shading or color to a cell range To add borders To select a distribution of figures ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to track the progress of the stock market on a daily basis. Which type of chart should you use? Line chart Pie chart Column chart Row chart Line chart Pie chart Column chart Row chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following options is not located in the page setup dialog box ? Page Break Preview Margins Page Orientation Headers and Footers Page Break Preview Margins Page Orientation Headers and Footers ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data, Form Data, Sort Data Subtotals Data, Table Data, Form Data, Sort Data Subtotals Data, Table ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? Select the row heading where you want to insert the new row and select Edit >Row from the menu All of the listed here Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu Select the row heading where you want to insert the new row and select Edit >Row from the menu All of the listed here Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS