MS Excel You can enter which types of data into worksheet cells? Formulas only Labels, values, and formulas Labels and values but not formulas Values and formulas but not labels Formulas only Labels, values, and formulas Labels and values but not formulas Values and formulas but not labels ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can merge the main document with data source in Excel. In mail merge operation, Word is usually Client None of these Source Server Client None of these Source Server ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Insert > Find from the menu Select Tools > Finder from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Click the Find button on the standard toolbar Select Insert > Find from the menu Select Tools > Finder from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Click the Find button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? =10+50 =B7+14 =B7*B1 10+50 =10+50 =B7+14 =B7*B1 10+50 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Apostrophe (') Exclamation (!) Ampersand (&) Hash (#) Apostrophe (') Exclamation (!) Ampersand (&) Hash (#) ANSWER DOWNLOAD EXAMIANS APP