MS Excel The auto calculate feature Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells A and C Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells A and C ANSWER DOWNLOAD EXAMIANS APP
MS Excel Text formulas: Show formula error value Concatenate and manipulate text Replace cell references Return ASCII values of characters Show formula error value Concatenate and manipulate text Replace cell references Return ASCII values of characters ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a label is too long to fit within a worksheet cell, you typically must Increase the column width Adjust the row height Decrease the column width Shorten the label Increase the column width Adjust the row height Decrease the column width Shorten the label ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Cancel and Enter buttons appear in the: Formula bar Menu bar Sheet tabs Title bar Formula bar Menu bar Sheet tabs Title bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you link data maintained in an excel workbook to a word document The word document contains a copy of the actual data The word document must contain a hyperlink The word document cannot be edit The word document contains a reference to the original source application The word document contains a copy of the actual data The word document must contain a hyperlink The word document cannot be edit The word document contains a reference to the original source application ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS