vefsites.blogg.se

If you press …., the cell accepts your typing as its contents.ī. To copy cell contents using drag and drop, press theĢ7. Which of the following is not a worksheet design criterion?Ģ6. You can open the Highlight Changes dialog box by choosing Track Changes from the …. To protect a worksheet, you can choose Protection and the Protect Sheet from the …. You can quickly change the appearance of your work by choosing Auto Format from the …. Which of the following is not an option in the spelling dialog box?Ģ2. Which of the following methods cannot be used to edit the content of cell? | Ms Excel McqsĪns: a 21. Using the Format – Cells – Font menu itemĢ0. Using the Tools – Wizard – Web Form menu itemĬ. Which of the following will not set text in selected cells to italics? | Ms Excel Mcqsī. Clicking the enter button to the formula barġ9. Which of the following methods cannot be used to enter data in a cell? | Ms Excel Mcqsĭ. Point to speech on the tools menu, and then click speech recognitionġ8. Point to speech on the tools menu, and then click show text to speech toolbar.Ĭ. How do you activate this feature? | Ms Excel McqsĪ. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. Which function calculates your monthly mort age payment? | Ms Excel Mcqsġ7. On the tools menu, click Add-Ins, and select the Euro Currency Tools check boxġ6. On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.ī. How can you have Excel convert those sums to Euros? | Ms Excel McqsĪ. Your German supplier still invoices for parts in deutsche marks. On the view menu, click custom views, then click addġ5. On the file menu, click print, and then click selection under print whatĬ. On the file menu, point to print area, and then click set print area.ī. How should you print a selected area of a worksheet, if you’ll want to print a different area next time? | Ms Excel McqsĪ. A function inside another function is called a …. Addition and subtraction, positive and negative values, exponentiationĪns: d 13.

Multiplication and division, positive and negative values, addition and subtractionĬ. Multiplication and division, exponential positive and negative valueī. Which of the following is a correct order of precedence in a formula calculation? | Ms Excel McqsĪ. Moving the chart to a chart sheet before you print.Īns: d 12. You can print only an embedded chart by | Ms Excel McqsĪ. The be turned off for display and printingĪns: d 11. May be turned off for display but turned on for printingĬ. Checks whether text is the same in one cell as in the nextĪ. What does the VLOOKUP function do? | Ms Excel Mcqsī. How are data organized in a spreadsheet? | Ms Excel McqsĪns: c 9. Bar charts, line graphs and pie chartsĪns: c 8. Which types of charts can excel produce? | Ms Excel McqsĬ. It can contain many sheets including worksheets and chart sheetsĪns: c 7. Each excel file is called a workbook because | Ms Excel McqsĬ. You can open the consolidate dialog box byte choosing Consolidate from the …. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result. When you insert an Excel file into a Word document, the data are _. What function displays row data in a column or column data in a row? | Ms Excel McqsĢ. As per my experience good interviewers hardly plan to ask any particular question during your Job interview and these model questions are asked in the online technical test and interview of many IT & Non IT Industry.ġ. These Objective type MS Excel are very important for campus placement test and job interviews. Best MS Excel Objective type Questions and Answersĭear Readers, Welcome to MS Excel Objective Questions and Answers have been designed specially to get you acquainted with the nature of questions you may encounter during your Job interview for the subject of MS Excel Multiple choice Questions.