Ms excel mcq. Computer MS Excel Shortcuts Keys Info Quiz 1 Online Important Mcqs Questions 2018-10-10

Ms excel mcq Rating: 5,4/10 1460 reviews

Microsoft Office MCQs

ms excel mcq

The chart wizard term data series refers to a. Edit the contents of a cell d. This application software provide plenty of useful tools to format the documents according to user needs. Excel edits cell references in the newly copied formula c. Please visit for question banks, online quiz, downloads, subjective questions and answers. Excel uniquely identifies cells within a worksheet with a cell name a.

Next

MS Excel MCQ in Hindi, English

ms excel mcq

How many characters can be typed in a single cell in Excel? Pre-made sheet formats like Simple, Classic, Accounting, Colorful etc. In Excel ----------- is a group of cells that form a rectangle on the screen. To center worksheet titles across a range of cells, you must a. A group of worksheets 93. The selected range is displayed c. Please visit for question banks, online quiz, downloads, subjective questions and answers.

Next

MS Excel MCQ in Hindi, English

ms excel mcq

Click the column heading letter c. Which of the following formulas will Excel Not be able to calculate? No data will be entered in the adjacent cells c. A numeric value can be treated as a label value if it precedes with a. Rounding errors can occur a. To center worksheet titles across a range of cells, you must a. Please visit for question banks, online quiz, downloads, subjective questions and answers. Which of the following function will return a value of 8? With commands on the shortcut menu c.

Next

Microsoft Office MCQs

ms excel mcq

Please visit for question banks, online quiz, downloads, subjective questions and answers. A circular reference is a. How can you delete a record? Please visit for question banks, online quiz, downloads, subjective questions and answers. You can set Page Border in Excel from A From Border tab in Format Cells dialog box B From Border tool in Formatting toolbar C From Line Style tool in Drawing toolbar D You can not set page border in Excel 17. Source of input data c. Please visit for question banks, online quiz, downloads, subjective questions and answers. With the right drag method b.


Next

300+ TOP MICROSOFT EXCEL Questions and Answers MS EXCEL MCQ Quiz Questions

ms excel mcq

Concatenation of text can be done using a. A Choose required color form Patterns tab of Format Cells dialog box B Choose required color on Fill Color tool in Formatting toolbar C Choose required color on Fill Color tool in Drawing toolbar D All of above 16. Select your answer and tally with the correct answer which is given at the bottom of this question set. A Square B Percentage C Goal Seek D Divide 11. Which function will you use to enter current time in a worksheet cell? Please visit for question banks, online quiz, downloads, subjective questions and answers. To activate the previous cell in a pre-selected range, press a.


Next

MS Excel MCQ in Hindi, English

ms excel mcq

In Excel following term describes explanatory text attached to a cell Comment Answer Callout Dialog Extension 8. Click the object command on the insert menu B. When you link data maintained in an excel workbook to a word document a. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells b. Multiply the selection by a copied value b. Click the column heading letter c.

Next

300+ TOP MICROSOFT EXCEL Questions and Answers MS EXCEL MCQ Quiz Questions

ms excel mcq

Pressing the Tab key b. Allow you to view a different worksheet b. Select a foreground color C. You can edit a cell by a. Please visit for question banks, online quiz, downloads, subjective questions and answers. Please visit for question banks, online quiz, downloads, subjective questions and answers.

Next

MS Excel MCQs Test Online Quiz With Solved Answers

ms excel mcq

How to remove the unwanted action from recorded macro without recording the whole macro again? Only B and C 9-4. Please visit for question banks, online quiz, downloads, subjective questions and answers. Clicking the Cut button on the standard d. To create a formula, you first: a. Allow you to view additional worksheet columns to the right d. Clicking the Cut button on the standard d. Which of the following is a correct order of precedence in formula calculation? To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the a.

Next

MS Excel MCQ in Hindi, English

ms excel mcq

Right click the column heading you want to delete and select delete from the shortcut menu 13. Please visit for question banks, online quiz, downloads, subjective questions and answers. Clicking the Enter button on the Formula bar d. With commands on the shortcut menu c. It was first released on October 25, 1983. Select the column heading you want to delete and select Insert Delete from the menu c. Appears to the left of the formula bar c.

Next

Microsoft Excel (MCQs)

ms excel mcq

The word document cannot be edit b. Select the column heading you want to delete and select the Delete Row button on the standard toolbar b. Microsoft Forms provides a rich grading workflow that enables you, as the author, to efficiently award points per question to students and provide feedback in a number of ways. The chart wizard term data series refers to a. Please visit for question banks, online quiz, downloads, subjective questions and answers. What is the short cut key to replace a data with another in sheet? Please visit for question banks, online quiz, downloads, subjective questions and answers. In Excel you can quickly change the appearance of your work by choosing Auto Format from the ……….

Next