MS Excel You can convert existing excel worksheet data an charts to an HTML document by using Import wizard Internet assistant wizard Intranet wizard FTP wizard Import wizard Internet assistant wizard Intranet wizard FTP wizard ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in row, select the same number of cells in row and paste 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 column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste 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 column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Getting data from a cell located in a different sheet is called ___ Functioning Updating Accessing Referencing Functioning Updating Accessing Referencing ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Sum Pmt Max Average Sum Pmt Max Average ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet range is a A group of worksheets A group of cells A command used for data modeling A range of values such as from 23 to 234 A group of worksheets A group of cells A command used for data modeling A range of values such as from 23 to 234 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Enter the formula using any input values and the appropriate mathematical operators that make up your formula Type the equals sign (=) to tell Excel that you’re about to enter a formula Choose the new command from the file menu Select the cell you want to place the formula into Enter the formula using any input values and the appropriate mathematical operators that make up your formula Type the equals sign (=) to tell Excel that you’re about to enter a formula Choose the new command from the file menu Select the cell you want to place the formula into ANSWER DOWNLOAD EXAMIANS APP