MS Excel You can enter which types of data into worksheet cells? Labels and values but not formulas Values and formulas but not labels Formulas only Labels, values, and formulas Labels and values but not formulas Values and formulas but not labels Formulas only Labels, values, and formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Automatically creates formulas and adds them to a worksheet A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods can not be used to edit the contents of a cell? Pressing the F2 key Double clicking the cell Press the Alt key Clicking the formula bar Pressing the F2 key Double clicking the cell Press the Alt key Clicking the formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? All of the listed here Select the row heading where you want to insert the new row and select Edit >Row from the menu 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 All of the listed here Select the row heading where you want to insert the new row and select Edit >Row from the menu 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
MS Excel When a label is too long to fit within a worksheet cell, you typically must Adjust the row height Shorten the label Decrease the column width Increase the column width Adjust the row height Shorten the label Decrease the column width Increase the column width ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu All of above ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS