MS Excel Which function is not available in the Consolidate dialog box ? Average Sum Max Pmt Average Sum Max Pmt ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Page Up Ctrl + C Ctrl + Space Bar Ctrl + Enter Ctrl + Page Up Ctrl + C Ctrl + Space Bar Ctrl + Enter ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: The resulting values of a formula instead of the actual formula Formatting options Cell comments Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Formatting options Cell comments Multiply the selection by a copied value ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Fill handle Border Insert handle Copy handle Fill handle Border Insert handle Copy handle ANSWER DOWNLOAD EXAMIANS APP
MS Excel The shortcut key Ctrl + R is used in Excel to Remove the cell contents of selected cells Right align the content of cell None of above Fill the selection with active cells to the right Remove the cell contents of selected cells Right align the content of cell None of above Fill the selection with active cells to the right ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods can not be used to edit the contents of a cell? Clicking the formula bar Double clicking the cell Press the Alt key Pressing the F2 key Clicking the formula bar Double clicking the cell Press the Alt key Pressing the F2 key ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS