MS Excel In Excel, a Data Series is defined as what? A collection of related data A cell reference A division of results A type of chart A collection of related data A cell reference A division of results A type of chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Formatting options The resulting values of a formula instead of the actual formula Cell comments Multiply the selection by a copied value Formatting options The resulting values of a formula instead of the actual formula Cell comments Multiply the selection by a copied value ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) 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 The sheet tab is changed ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet can have a maximum of ________ number of rows. 1048576 1024 256 65535 1048576 1024 256 65535 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 None of above Cut and Paste Paste Special > Transpose Both of above None of above Cut and Paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Receives the data the user enters Only A and B Is defined by a bold border around the cell It is the formula bar Receives the data the user enters Only A and B Is defined by a bold border around the cell It is the formula bar ANSWER DOWNLOAD EXAMIANS APP