MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.80 5436.8 6.8 5430 5436.80 5436.8 6.8 5430 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Hold down the shift key as you click anywhere in the column Select Edit > Select > Column from the menu Hold down the Ctrl key as you click anywhere in the column Click the column heading letter Hold down the shift key as you click anywhere in the column Select Edit > Select > Column from the menu Hold down the Ctrl key as you click anywhere in the column Click the column heading letter ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The status bar does not display the cell address Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created The status bar does not display the cell address Cell address will change when it is copied to another cell The sheet tab is changed An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP
MS Excel It is acceptable to let long text flow into adjacent cells on a worksheet when There is no suitable abbreviation for the text No data will be entered in the adjacent cells Data will be entered in the adjacent cells There is not time to format the text There is no suitable abbreviation for the text No data will be entered in the adjacent cells Data will be entered in the adjacent cells There is not time to format the text ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a term of MS-Excel? Document Columns Cells Rows Document Columns Cells Rows ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, a Data Series is defined as what? A division of results A collection of related data A type of chart A cell reference A division of results A collection of related data A type of chart A cell reference ANSWER DOWNLOAD EXAMIANS APP