Belajar microsoft excel 2010 lengkap pdf

If you place mouse point over the triangle it will show the comment typed. The cell canвЂ™t accept formula Correct answer: ans2 Explanation: A red triangle at the top right corner of cell indicates a comment associated. The font color of the text in cell is red d. There is a comment associated with the cell c. Red triangle at the top right corner of a cell indicates a. Start with a basic formula of =A2&B2 Read this tutorial If you donвЂ™t know to search for Concatenate, then you will never learn that the concatenation operator is an ampersand.

Heck, I donвЂ™t think any normal person ever uses u ses the word concatenate. This is one of those questions that you can never find in Excel help, because no one thinks to search for the word вЂњConcatenationвЂќ. Hash (#) Correct answer: ans3 Explanation: Ampersand (&) can be used to concantenate text in excel. Which of the following is concantenating operator? a. None of these Correct answer: ans2 Explanation: You can access Data > Sort menu to arrange data in ascending or descending order.ДЇ. Data can be arranged in ascending or descending order by using a. + Correct answer: ans1 Explanation: A number is entered preeceding by a single quote (вЂ) to enter it as label.Д®. What symbol is used to enter number as text? a. Similarly, if unformatted number does not fit, it displays the number in scientific format.Д. None of these Correct answer: ans1 Explanation: If a formatted number does not fit within a cell it displays #. When a formatted number does not fit within a cell, it displays a. 64536 Correct answer: ans2 Explanation: An worksheet consists 256 columns and 65536 rows.Д¬. A consumer of service is client and producer of service is server.Д«. None of these Correct answer: ans2 Explanation: When integrating Word and Excel, Word is usually the client because Excel serves the data and word uses these data in document. When integrating Word and Excel, Word is usually the a. Microsoft Excel Multiple Choice Question and Answers with Explanation Set 1 a.

Belajar microsoft excel 2010 lengkap pdf