MS Excel Which of the following is invalid statement? Sheet tabs can be colored You can set the column width automatically fit the amount of text Some picture can be applied as a background of a sheet The width of a row and be specified manually or fit automatically Sheet tabs can be colored You can set the column width automatically fit the amount of text Some picture can be applied as a background of a sheet The width of a row and be specified manually or fit automatically ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel B7:B9 indicates: Cells B7 and cell B9 only None of these Cells B7 through B9 Cell B8 only Cells B7 and cell B9 only None of these Cells B7 through B9 Cell B8 only 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 Rounding errors can occur Because excel uses hidden decimal places in computation When you show the results of formulas with different decimal places that the calculated results When you use multiplication, division, or exponentiation in a formula When you use addition and subtraction in a formula Because excel uses hidden decimal places in computation When you show the results of formulas with different decimal places that the calculated results When you use multiplication, division, or exponentiation in a formula When you use addition and subtraction in a formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel To save a workbook, you: Press Ctrl+ F5 Select Edit > Save Click the save button on the standard toolbar from the menu Click Save on the Windows Start button Press Ctrl+ F5 Select Edit > Save Click the save button on the standard toolbar from the menu Click Save on the Windows Start button ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS