MS Excel Which function is not available in the Consolidate dialog box ? Average Max Sum Pmt Average Max Sum Pmt ANSWER DOWNLOAD EXAMIANS APP
MS Excel The shortcut key Ctrl + R is used in Excel to Remove the cell contents of selected cells None of above Fill the selection with active cells to the right Right align the content of cell Remove the cell contents of selected cells None of above Fill the selection with active cells to the right Right align the content of cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. Auto correct Auto sum Auto format AutoFill Auto correct Auto sum Auto format AutoFill ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? =10+50 =B7*B1 10+50 =B7+14 =10+50 =B7*B1 10+50 =B7+14 ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you: Press the Edit Formula button Press the Enter button Press the Erase key Press Esc Press the Edit Formula button Press the Enter button Press the Erase key Press Esc ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true about Find and Replace in Excel 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 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 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS