Tag Archive: Basic IT

Objective Questions on Ms Excel in Ms Office set-2

In this set of objective questions on Ms Excel in MS office includes MCQ questions of basic step in creating a worksheet, formatting of data level, entering values and formulas, embedded chart, worksheet design criterion, data marker on a chart, absolute cell reference in ms excel and short-cut key to create a chart on chart sheet. 1) You can insert labels for A. All the data makers on a chart B. A data series C. A selected data marker D….
Read more

Solved MCQ on Microsoft Excel in Ms Office set-1

Here you can find Solved Multiple Choice Questions(MCQs) on Microsoft Excel in Ms Office includes objective questions on MS excel worksheet data and chart, integrating MS word and excel, comments put in cells, getting data from a cell located in a different sheet, graphic object on a chart, concatenation of text and  inserting a blank embedded MS excel object in a word document. 1) You can convert existing Ms Excel Worksheet data and chart to on HTML document by using…
Read more

Objective Questions on Ms Power Point in Ms Office set-2

1) A chart can be put as a part of the presentation using A. Chart From Insert Menu B. Picture and Choose Chart From Insert Menu C. Chart From Tools Menu D. Chart From Format Menu 2) Which of the following can you used to add times to the slide in a presentation? A. Slide show menu B. Rehearse timing button C. Slide transaction button D. All of the above 3) Which of the following provides a printed copy of…
Read more

Solved MCQ on Ms PowerPoint in Ms Office set-1

1) Which of the following toolbars provide different options in various master views? A. Common Task Toolbar B. Drawing Toolbar C. Formatting Toolbar D. Standard Toolbar 2) Which of the following allow you to select more than one slides in slide sorter view? A. Alt+Click on each slide B. Shift+Drag each slide C. Shift+Click on each slide D. Ctrl+Click each slide 3) The handout master contains placeholders for all of the following except A. Slide number B. Title C. Footer…
Read more

Interview Questions on Microsoft Excel with Answer set-6

1) When you insert an excel file into a word document. The data areA. Hyper-linked place in a word table B. Linked C. Embedded D. Use the word menu bar and toolbars 2) All worksheet formula A. Manipulate values B. Manipulate labels C. Return a formula result D. Use the addition operator 3) Which of the following is available in Formula Auditing? A. Trace Precedents B. Trace Dependents C. Trace Error D. All 4) Concatenation of text can be done…
Read more

Objective Questions on Microsoft Excel with Answer set-5

1) Getting data from a cell located in a different sheet is calledA. Accessing B. Referencing C. Updating D. Functioning 2) The default header for a worksheet is A. Your name B. The date and time C. None D. The sheet tab name 3) Excel worksheet cells work very similarly to what common element of the windows graphical user interface. A. Option buttons B. List boxes C. Text boxes D. Combo boxes 4) Which element of a worksheet can be…
Read more

MCQ on Microsoft Excel in Ms Office with Answer set-4

1) A cell contain up to .. A. 56400 character B. 32000 character C. 45000 character D. None of the above 2) To hold down column titles in place so that they do not scroll when you scroll a worksheet click the A. Unfreeze panes command on the window menu B. Freeze panes command on the window menu C. Hold titles command in the edit menu D. Split command on the window menu 3) You want to track the progress…
Read more

MCQ Questions on Microsoft Excel in Ms Office set-3

1) You can hyper-links from an Excel Workbook to A. A web page on company Internet B. A web page on the Internet C. Other office application documents D. All of the above 2) To activate the previous cell in a preselected range, press A. The alt key B. The tab key C. The enter key D. None of the above 3) Using the F11 short cut key to crate a chart on a chart sheet creates A. A default…
Read more

Objective Questions on Microsoft Word set-10

1) Which of the following best describes detect and repair? A. A command on the help menu that detects malfunctioning hardware B. A command on the tools menu that detects missing or damaged files and repairs them C. A command on the help menu that detects missing or damaged files and repairs them D. None of the above 2) The select a whole sentence at once .. A. Hold down shift, and click the sentence B. Hold down ctrl, and…
Read more

Solved Interview Questions on Ms Word set-9

1) The cropping button is available in the … A. Standard toolbar B. Picture toolbar C. Border & Table toolbar D. Drawing Toolbar 2) In office programs, personalized menu automatically A. Promote frequently used menu commands B. Demote infrequently used menu command C. Expand to revel more command D. All of the above 3) When you modify a standard, built-in office template, which of the following occurs? A. Nothing, because you are not allowed to modify buit-in templates B. A…
Read more