MS Excel You can use the formula palette to Enter assumptions data Copy a range of cells Create and edit formula containing functions Format cells containing numbers Enter assumptions data Copy a range of cells Create and edit formula containing functions Format cells containing numbers ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? Financial Math & Trigonometry Logical Statistical Financial Math & Trigonometry Logical Statistical ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can auto fit the width of column by Double clicking on the column name on column header Double clicking on the column left border of column header Double click on the cell pointer in worksheet Double clicking on column right border on column header Double clicking on the column name on column header Double clicking on the column left border of column header Double click on the cell pointer in worksheet Double clicking on column right border on column header ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a way to complete a cell entry? Pressing any arrow key on the keyboard Pressing enter Clicking the Enter button on the Formula bar Pressing spacebar Pressing any arrow key on the keyboard Pressing enter Clicking the Enter button on the Formula bar Pressing spacebar ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F9 F8 F11 F10 F9 F8 F11 F10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can set condition to look for Bold and apply Italics on them You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can set condition to look for Bold and apply Italics on them ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS