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 function is used to calculate depreciation, rates of return, future values and loan payment amounts? Math & Trigonometry Financial Logical Statistical Math & Trigonometry Financial Logical Statistical ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is the oldest spreadsheet package? Excel Lotus 1-2-3 VisiCalc StarCalc Excel Lotus 1-2-3 VisiCalc StarCalc 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 What happens when you press Ctrl + X after selecting some cells in Excel? The cells selected are marked for cutting The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up The cell content of selected cells disappear from cell and stored in clipboard The cells selected are marked for cutting The selected cells are deleted and the cells are shifted left The selected cells are deleted and cells are shifted up The cell content of selected cells disappear from cell and stored in clipboard ANSWER DOWNLOAD EXAMIANS APP
MS Excel A circular reference is Geometric modeling tool A formula that either directly or indirectly depends on itself A cell that points to a drawing object Always erroneous Geometric modeling tool A formula that either directly or indirectly depends on itself A cell that points to a drawing object Always erroneous ANSWER DOWNLOAD EXAMIANS APP