MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F11 F10 F8 F9 F11 F10 F8 F9 ANSWER DOWNLOAD EXAMIANS APP
MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Click on Sheet 3 and from Edit menu choose Delete Both of above None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Click on Sheet 3 and from Edit menu choose Delete Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Replace cell references Return ASCII values of characters Show formula error value Concatenate and manipulate text Replace cell references Return ASCII values of characters Show formula error value Concatenate and manipulate text 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 Which command will you choose to convert a column of data into row? Paste Special > Transpose Both of above Cut and Paste None of above Paste Special > Transpose Both of above Cut and Paste None of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you delete a column? Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select Insert Delete from the menu Right click the column heading you want to delete and select delete from the shortcut menu Select the column heading you want to delete and select the Delete Row button on the standard toolbar Select the row heading you want to delete and select Edit>Delete from the menu Select the column heading you want to delete and select Insert Delete from the menu ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS