MS Excel To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the Split command on the window menu Hold titles command on the edit menu Freeze panes command on the window menu Unfreeze panes command on the window menu Split command on the window menu Hold titles command on the edit menu Freeze panes command on the window menu Unfreeze panes command on the window menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Financial Statistical Logical Math & Trigonometry Financial Statistical Logical Math & Trigonometry ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the original copy of the formula Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Ctrl+ D shortcut key in Excel will None of the listed here Open the font dialog box Fill down in the selection Apply double underline for the active cell None of the listed here Open the font dialog box Fill down in the selection Apply double underline for the active cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a valid data type in Excel ? Number Date/Time Label Character Number Date/Time Label Character ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? None of above Double CAL indicator on status bar Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above Double CAL indicator on status bar Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS