Ms excel basic mcq questions and answers pdf. MS Excel MCQs 2019-07-27

Ms excel basic mcq questions and answers pdf Rating: 7,2/10 1953 reviews

Microsoft Excel MCQ Questions

ms excel basic mcq questions and answers pdf

Edit the contents of a cell d. Right clicking something in Excel: a. Pressing the F2 key d. How many characters can be typed in a single cell in Excel? Press the Erase key b. Presently we have added total 5 sets of questions on microsoft excel for you to practice. Please visit for question banks, online quiz, downloads, subjective questions and answers.

Next

Microsoft Excel MCQ Questions

ms excel basic mcq questions and answers pdf

Which of the following is not a basic step in creating a worksheet? Excel probably considers the cell entry January 1, 2000 to be a a. Select the cells containing the title text plus the range over which the title text is to be enfettered d. Please visit for question banks, online quiz, downloads, subjective questions and answers. Select the column heading you want to delete and select Insert Delete from the menu c. To score high in the exams, the aspirants need to practice the mock tests and learn the Advanced Excel Questions and Answers. Which of the following formulas is not entered correctly? Please visit for question banks, online quiz, downloads, subjective questions and answers.

Next

MS Excel Questions And Answers Updated Daily

ms excel basic mcq questions and answers pdf

Select the column heading you want to delete and select the Delete Row button on the standard toolbar b. To create a formula, you can use: a. All of the above Ans: D 22. Please visit for question banks, online quiz, downloads, subjective questions and answers. To increase the knowledge in the Advanced Excel topic, the aspirants need to practice the Advanced Excel Online Tests. Please visit for question banks, online quiz, downloads, subjective questions and answers. How do you rearrange the data in ascending or descending order? Decrease the column width d.

Next

Advanced Excel Multiple Choice Questions and Answers

ms excel basic mcq questions and answers pdf

To save a workbook, you: a. To enable graphical representation of the data in Excel, charts are provided. Hover the mouse over it, and you can read the full comment. What do you call the chart that shows the proportions of how one or more data elements relate to another data element? Which of the following methods can not be used to edit the contents of a cell? The active portion of the worksheet is displayed d. Clarity Correct Answer: c Collection on 36. Please visit for question banks, online quiz, downloads, subjective questions and answers. When you want to insert a blank imbedded excel object in a word document you can a.

Next

MS Excel Questions And Answers Updated Daily

ms excel basic mcq questions and answers pdf

Select the object by clicking it c. There is no suitable abbreviation of the text d. Return a formula result d. To copy cell contents using drag and drop press the a. Which would you choose to create a bar diagram? Click the column heading letter c. It can contain many sheets including worksheets and chart sheets d. Clicking on the formula bar 2.

Next

MS

ms excel basic mcq questions and answers pdf

Choose the new command from the file menu 11. Opens a shortcut menu listing everything you can do to the object d. With the copy, paste and cut commands on the edit menu b. A range of values such as from 23 to 234 c. Getting data from a cell located in a different sheet is called….

Next

Advanced Excel Multiple Choice Questions and Answers

ms excel basic mcq questions and answers pdf

Multiple calculations can be made in a single formula using…. Please visit for question banks, online quiz, downloads, subjective questions and answers. In case of option d. It can contain text and data b. You can activate a cell by a. You can enter which types of data into worksheet cells? All of above Ans: B 87.

Next

Microsoft Excel mcq question and Answer

ms excel basic mcq questions and answers pdf

Which Chart can be created in Excel? Please visit for question banks, online quiz, downloads, subjective questions and answers. All of the above 72. Hyperlinked placed in a word table b. Appears below the status bar d. Allow you to view additional worksheet columns to the right d. AllIndiaExams provides you lots Advanced Excel Questions and Answers with proper explanation.

Next