MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F11 F10 F8 F9 F11 F10 F8 F9 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel You can decide whether to look for the whole word or not You can search for bold and replace with italics You can search in formula too You can search by rows or columns or sheets You can decide whether to look for the whole word or not You can search for bold and replace with italics You can search in formula too You can search by rows or columns or sheets ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet ? Press Alt + Home Press Home Press Ctrl + Home Press Shift + Home Press Alt + Home Press Home Press Ctrl + Home Press Shift + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two ? Review > window View > window > split Window > split View > split Review > window View > window > split Window > split View > split ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar None of the listed here Shows the name of workbook currently working on Shows the name of cell or range currently working on Shows the name of worksheet currently working on None of the listed here Shows the name of workbook currently working on Shows the name of cell or range currently working on Shows the name of worksheet currently working on ANSWER DOWNLOAD EXAMIANS APP