ppti.info Personal Growth Computer Awareness Book By Alok Kumar

COMPUTER AWARENESS BOOK BY ALOK KUMAR

Friday, May 17, 2019


Dr alok kumar has written a textbook on computers and computing technologies for the unexposed mind. Titled computer general awareness, the book was. Dr Alok Kumar has written a textbook on computers and computing technologies for the unexposed mind. Titled Computer General Awareness, the book was. Read MCQs on Computer book reviews & author details and more at ppti.info Alok Kumar (Author). out of 5 stars 5 Objective Computer Awareness.


Author:SHEILA SCHEMBRA
Language:English, Spanish, French
Country:Mozambique
Genre:Technology
Pages:789
Published (Last):24.12.2015
ISBN:562-6-66312-557-5
ePub File Size:24.71 MB
PDF File Size:20.73 MB
Distribution:Free* [*Regsitration Required]
Downloads:29837
Uploaded by: MATILDE

Download MCQs on Computer By Dr. Alok Kumar (Upkar's) – This Book (Share & Gain Knowledge) Join EasyEngineering Whatsapp/Telegram Group. Computer General Awareness. Book Summary: The book was designed for young and old minds alike, to understand and apply computers and its related. MCQs On Computer by Dr. Alok Kumar. Book Summary: This Book contains computer science multiple choice questions and answers on computer science.

In Excel.. In Excel the drag and drop method of copying or moving A Can be used between worksheets but not workbooks B Can be used between workbooks but not worksheets C Can be used between workbooks but not worksheets D None.

C Automatically creates formulas and adds them to a worksheet D None of the above In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the.. In Excel if you press.. In Excel the auto fill feature A Extends a sequential series of data B Automatically adds a range of cell values C Applies a boarder around selected cells D None of above In Excel you can use the formula palette to A Format cells containing numbers B Create and edit formulas containing functions C Entered assumptions data D Copy a range of cells.

In Excel the auto calculate feature A Can only add values in a range of cells B Provides a quick way to view the results of an arithmetic operation on a range of cells. What excel feature can you use if you want to work with one record at a time? In Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?

In Excel which elements of worksheet can be protected from accidental modification?

MCQs on Computer by Dr. Alok Kumar [PDF] ~Stark

In Excel it is acceptable ot let long text flow into adjacent cells on a worksheet when A Data will be entered in the adjacent cells B No data will be entered in the adjacent cells C There is nt suitable abbreviation of the text D There is not time to format the next In Excel how can you delete a record?

Right clicking something in Excel A Deletes the object B Nothing the right mouse button is there for left handed people C Opens a shortcut menu listing everything you can do to the object D Selects the object In Excel which of the following is not a worksheet design criterion?

In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page? A Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.

B Click page setup on the file menu, click the page tab, click the options button, then enter your choices. C Click page setup on the finle menu, click the sheet tab, and make a selection under the print heading. D All of above In Excel a fast way to add up this column of number is to click in the cell below the numbers and then A Click subtotals on the data menu B View the sum in the formula bar C Click the autosum button on the standard toolbar, then press enter D All of above In Excel which of the following is an absolute cell reference?

In Excel what symbol is used before a number to make it a label? In Excel which symbol must all formula begin with? In Excel which of the following formulas is not entered correctly? In Excel Tab scrolling button A Allow you to view a different worksheet B Allow you to view additional worksheet rows down C Allow you to view additional worksheet columns to the right D Allow you to view additional sheets tabs.

In Excel which of the following formulas will Excel not be able to calculate? A5 In Excel numeric value can be treated as a label value if it precedes with A Apostrophe B Exclamation!

In Excel typical worksheet has. Number of columns A B C D In Excel how many characters can be typed in a single cell? A B C 32, D 65, In Excel worksheet can have a maximum of. Number of rows A B C 32, D 65, In Excel you can use drag-and-drop to embed excel worksheet data in a word document A By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key B By dragging a range of excel data to the word button on the taskbar while pressing Shift key C By dragging a range of excel data to the word button on the taskbar while pressing Alt key D None of above.

In Excel Chart wizard term data categories refers to A A chart plot area B A horizontal axis C The organization of individual values with a charts data series D The data range that supply chart data In Excel the auto calculate feature A Can only add values in a range of cells B Provides a quick way to view the result of an arithmetic operation on a range of cells C Automatically creates formulas and adds them to a worksheet D A and C In Excel to view a cell comment A Click the edit comment commands on the Insert menu B Click the Display comment command on the window menu C Position the mouse pointer over the cell D Click the comment command on the view menu.

In Excel say that you want to paste a formula result but not the underlying formula to another cell. In excel , you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next? A Click the Paste button on the standard toolbar B Click the arrow on the paste button on the standard toolbar, then click formulas C Click the arrow on the paste button on the standard toolbar, then click values. In Excel you can select a single range of cells by 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 Pressing the Ctrl key while dragging over the desired cells C Pressing the Shift key and an arrow key D Dragging over the desired cells In Excel you can use a function to combine text from two cells into one cell.

But you can use an operator to do the same thing. Which operator is that? A2 D A1 plus A2 In Excel using the F11 shortcut key to create a chart on chart sheet creates A A default chart B A 2-dimensional column chart C A 2-dimensional bar chart D A 3-dimensional line chart In Excel advantage of using a spreadsheet is A calculations can be done automatically.

B changing data automatically updates calculations C more flexibility D all of the above In Excel intersection of a row and column is called: A Cata B A field. C A cell D An equation. There are three types of data found in a spreadsheet A data, words, numbers B equations, data, numbers C words, numbers, labels D numbers formulas, labels. In Excel to select a column the easiest method is to A Double click any cell in the column B Drag from the top cell in the column to the last cell in the column C Click the column heading D Click the column label In Excel if you press , the cell accepts your typing as its contents.

In Excel to view a cell comment A Click the edit comment command on the insert menu B Click the display comment command on the window menu C Position the mouse pointer over the cell D Click the comment command on the view menu In Excel when you want to insert a blank imbedded excel object in a word document you can A Click the object command on the insert menu B Click the office links button on the standard toolbar C Click the create worksheet button on the formatting toolbar D Click the import excel command on the file menu In Excel you can select a single range of cells by 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 Pressing the Ctrl key while dragging over the desired cells C Pressing the Shift key and an arrow key D Dragging over the desired cells.

In Excel when you copy a formula A Excel erases the original copy of the formula B Excel edits cell references in the newly copied formula C Excel adjusts absolute cell references D Excel doesnt adjust relative cell references In Excel autofill feature A Extends a sequential series of data B Automatically adds range of cell values C Applies a boarder around the selected cells D None of the above In Excel which is not an advantage of using computerized spreadsheets?

In Excel To hold row and 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 on the edit menu D Split command on the window menu In Excel which of the following is not a way to complete a cell entry?

In Excel how do you insert a row? In Excel how do you select an entire column?

Computer General Awareness

D Hold down the Ctrl key as you click anywhere in the column. In Excel how can you print three copies of a workbook? C Enter the formula using any input values and the appropriate mathematical operators that make up your formula D Choose the new command from the file menu In Excel to center worksheet titles across a range of cells, you must A Select the cells containing the title text plus the range over which the title text is to be centered B Widen the columns C Select the cells containing the title text plus the range over which the title text is to be enfettered D Format the cells with the comma style In Excel how do you delete a column?

In Excel name box A Shows the location of the previously active cell B Appears to the left of the formula bar C Appears below the status bar D Appears below the menu bar. In Excel which is used to perform what if analysis?

In Excel you can use the horizontal and vertical scroll bars to A Split a worksheet into two panes B View different rows and columns edit the contents of a cell C Edit the contents of a cell D View different worksheets In Excel Multiple calculations can be made in a single formula using A standard formulas B array formula C complex formulas D smart formula The cells in row 26 that contain data have a dark grey background, when you click the Print button A nothing will print because some cells with data have been omitted B only the cells with gray background will print C the whole sheet will print D only the cells with white background will print In Excel constant is another name for this type of data A number B equation C formula D description In Excel AutoCalculate will quickly add selected cells if you A right click on the status bar and select Sum B click the AutoCalculate button on the toolbar.

In Excel when you are typing an equation into a cell the first thing that must be entered is A the first cell referenced B parenthesis C quotation marks D an equal sign In Excel using the AutoSum button will replace in the selected cell A the sum of values in the cells column B nothing until you select a range of cells C the sum of the cells row unless you change the range D a formula which will add values in the range Excel guesses you want to add In Excel to select an individual data marker or data label, you must A Double click the data series B Right click selected marker C Click once to select the series markers or labels and click the desired marker or label again D Double click the marker or label.

This type of software contains rows and columns. In Excel to open an existing workbook, you can click the Open button on the toolbar. In Excel the following setup options cannot be set in the page setup dialog box? In Excel got functions? You need the insert function dialog box. How do you get it? In Excel the following describes how to select all the cells in a single column?

In Excel when you use the fill effects in the format data series dialog box, you cannot A Rotate text on the chart B Select a fore ground color C Select a pattern D Select a background color In Excel Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

A Adds up cell values based on a condition B Adds all the numbers in a range of cells C Returns a subtotal in a list or database D All of above In Excel Tab scrolling buttons A Allow you to view a different worksheet B Allow you to view additional worksheet row down C Allow you to view additional worksheet columns to the right D Allow you to view additional sheet tabs In Excel All macro keyboard shortcuts include the..

In Excel which of these will not select all the cells in a document? In Excel you can use the formula palette to A Format cells containing numbers B Create and edit formulas containing functions C Enter assumptions data D Copy a range of cells. In Excel which of the following is a correct order of precedence in formula calculation? A Multiplication and division exponentiation positive and negative values B Multiplication and division, positive and negative values, addition and subtraction C Addition and subtraction, positive and negative values, exponentiation D All of above.

In Excel the Paste Special command lets you copy and paste A Multiply the selection by a copied value B Cell comments C Formatting options D The resulting values of a formula instead of the actual formula. In Excel circular reference is A Geometric modeling tool B A cell that points to a drawing object C A formula that either directly or indirectly depends on itself D Always erroneous. In Excel the numbers in our worksheet look like this: You want them to look like this: How can you accomplish this?

In Excel when you insert an excel file into a word document. In Excel each excel file is called a workbook because A It can contain text and data B It can be modified C It can contain many sheets including worksheets and chart sheets D You have to work hard to create it In Excel you can enter which types of data into worksheet cells?

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 In Excel which of the following options is not located in the Page Setup dialog box?

A Page Break Preview. In Excel one want to track the progress of the stock market on a daily basis. Which type of chart should one use? In Excel without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Which of the following methods cannot be used to edit the contents of a cell In Excel?

Return And Refund Process

In Excel which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell A Count B Average C Sum D None of above In Excel LEN function does what?

In Excel to center worksheet titles across a range of cell, you must A Select the cells containing the title text and use the fill handle to center the text across a range of cells B Widen the columns C Select the cells containing the title text and use the fill handle to center the text across a range of cells D Widen the column In Excel how do you change column width to fit the contents?

A Single-click the boundary to the left to the column heading B Double click the boundary to the right of the column heading C Press Alt and single click anywhere in the column D All of above In Excel when you work with large worksheets, you may need to A Size the worksheet to fit on the specific number of pages B Add and remove page breaks C Specify only certain print areas D All of above In Excel you can use the horizontal and vertical scroll bars to A Split a worksheet into two panes B View different rows and columns C Edit the contents of a cell D View different worksheets What do we call a computer program that organizes data in rows and columns of cells?

You might use this type of program to keep a record of the money you earned moving lawns over the summer. In Excel when creating a vertical page break A The active cell must be A1 B The active cell can be anywhere in the worksheet C The active cell must be in row 1 D The active cell must be in column A When you print preview a worksheet A the entire worksheet is displayed B the selected range is displayed C the active portion of the worksheet is displayed D All of the above In Excel which do you press to enter the current date in a cell?

In Excel it is acceptable to let long text flow into adjacent cells on a worksheet when A Data will be entered in the adjacent cells B No data will be entered in the adjacent cells C There is no suitable abbreviation for the text D There is not time to format the text When you link data maintained in Excel workbook to a Word document A The Word document cannot be edited B The Word document contains a reference to the original source application C The word document must contain a hyperlink D The word document contains a copy of the actual data In Excel when you see a cell with a red triangle in the top right corner, what does this signify?

A There is an error in the cell B There is a comment associated with the cell C The font color for text in the cell is red D A formula cannot be entered into the cell.

In Excel to hold row and column titles in places 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 on the edit menu D Split command on the window menu In Excel which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

A Use Ctrl to select all three cells, then click the paste button on the standard toolbar B Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify C Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to D All of above To edit data in an embedded Excel worksheet object in a Word document A Use the Excel menu bar and toolbars inside the word application B Edit the hyperlink C Edit the data in a Excel source application D Use the Word menu bar and toolbars In Excel Rounding errors can occur A When you use multiplication, division, or exponentiation in a formula B When you use addition and subtraction in a formula C Because excel uses hidden decimal places in computation D When you show the results of formulas with different decimal places that the calculated results In Excel one can copy data or formulas A With the copy, paste and cut commands on the edit menu B With commands on ta shortcut menu C With buttons on the standard toolbars D All of the above In Excel you cannot link excel worksheet data to a word document A With the right drag method B With a hyperlink C With the copy and paste special commands D With the copy and paste buttons on the standard toolbar.

In Excel one can use the format painter multiple times before one turn it off by A You can use the format painter button on ly one time when you click it B Double clicking the format painter button C Pressing the Ctrl key and clicking the format painter button D Pressing the Alt key and clicking the format painter button In Excel you can open the scenario Manager dialog box by choosing scenarios from the..

In Excel you can open the Sort dialog box by choosing Sort from the.. In Excel to edit in an embedded excel worksheet object in a word document A Use the excel menu bar and toolbars inside the word application B Edit the hyperlink C Edit the data in a excel source application D Use the word menu bar and toolbars In Excel to create a formula, you can use A Values but not cell references B Cell references but not values C Values or cell references although not both at the same time D Value and cell references In Excel when working in the page break preview, you can A View exactly where each page break occurs B Add or remove page breaks C Change the print area D All of above C There is no way to copy and apply formatting in Excel You have to do it manually D The Format Painter button on the standard toolbar In Excel In a worksheet you can select A The entire worksheet B Rows C Columns D All of the above When you link data maintained in an excel workbook to a word document A The word document cannot be edit B The word document contains a reference to the original source application.

C The word document must contain a hyperlink D The word document contains a copy of the actual data Which area in an excel window allows entering values and formulas? In Microsoft PowerPoint what are lines, curve, freeform, and scribble A Emphasis effects that can be applied to animations B Types of custom motion paths C Predefined entrance and exit effects D All of the above 5.

In Microsoft PowerPoint the easy way to apply varied animations to test on slides A Apply effects in the custom animation text pane B Apply an animation scheme C Customize bullets with animated clipart D All of above 9. In Microsoft PowerPoint using a custom animation effect, how do you make text appear on a slide by letter A Apply the animation scheme fade in one by one.

In Microsoft PowerPoint to exit the PowerPoint application, you should A Click the application minimize button B Click the document close button C Double click the application control menu icon D Double click the document control menu icon In Microsoft PowerPoint you have customized a design template in one presentation and you want to use it in another presentation. What the best way to do this? A Use the browse feature in the slide design task pane to find the file that has your design template and apply it to the current file.

B Copy and paste the slide with the design template you want to include the new presentation; inserted slide will inherit the design. In Microsoft PowerPoint the following displays when an image is selected A Add clip art only if it relates to your topic B Be sure to place at least one clipart image per slide C Resize the image so it takes up as much space as your text D Both A and B The Microsoft clip gallery allows you to A Add word art images to a slide B Spell check your presentation C Add clip art images to a slide or slides D Add slides to a presentation In Microsoft PowerPoint to edit the text within the boxes of an organization chart, you A Select the box and text, then make changes B Select the box, then make the dchanges C Highlight the text, them make the changes D A and B both In Microsoft PowerPoint the following options in the printer dialog box would you select to prit slides 5 and 12 in a presentation?

In Microsoft PowerPoint the best way to design the layout for your slides A Create layouts for slides, handouts and notes using the Master Layout dialog box in slide master view B For each new slide, select a layout from the Slide Layout task pane C Apply templates from the Slide Design task pane D None of above In Microsoft PowerPoint toolbars that are displayed by default in the PowerPoint window includes A Menu bar, standard toolbar, formatting toolbar, drawing toolbar, status bar B Menu bar, standard toolbar, formatting toolbar, drawing toolbar, status bar C Standard toolbar, formatting toolbar, drawing toolbar, status bar D Menu bar, standard toolbar, status bar, drawing toolbar In Microsoft PowerPoint slide show options available to the presenter include all of the following except A Transitions command B Speaker notes command C Meeting reminder command D Navigation commands In Microsoft PowerPoint you can show the shortcut menu during the slide show by A Clicking the shortcut button on the formatting toolbar B Right clicking the current slide C Clicking an icon on the current slide D A and B both In Microsoft PowerPoint auto clipart is a feature that A Automatically places clipart in your presentation B Scans your presentation for incorrect spelling in your words on each slide C Scans your presentation for incorrect spelling in Word Arts objects D All of above Which file format can be added to a PowerPoint show?

In Microsoft PowerPoint two kind of sound effects files that can be added to the presentation are A. In Microsoft PowerPoint size of a table object A Is dependent on the amount of text within the table B Is determined by the presentation design but can be changed C Is determined by the presentation design and cannot be changed D A and C both are true In Microsoft PowerPoint size of an organization chart object A Is determined by the presentation design and cannot be changed B Is determined by the presentation design but can be changed in PowerPoint C Is dependent on the amount of text within the organization chart D Both A and C are true In Microsoft PowerPoint to edit the text within the boxes of an organization chart, you A Select the box and text, then make the changes B Select the box, then make the changes C Highlight the text, then make the changes D Highlight the text then make the change In Microsoft PowerPoint the following best describes serifs A Serifs on characters help to differentiate between similar looking letters B Serifs fonts are best for viewing test at a distance C Serifs are fine cross strokes that appear at the bottom and top of a letter D Serif font are very simple in appearance In Microsoft PowerPoint the following must be used with the mouse when you want to resize an image from the center and keep it proportioned A The space bar B The alt key C The ctrl key D The shift key In Microsoft PowerPoint one way to make a PowerPoint slide display animations is to A Select the slide in normal view; and click Format, Animation B Click the PowerPoint window and move it around vigorously with the mouse for a manual animation effect C Select the slide in slide sorter view, right click and choose preset animations from the shortcut menu D PowerPoint does not have an animation feature In Microsoft PowerPoint an image is selected, it displays which of the following?

In Microsoft PowerPoint what is a slide-title master pair?

A The title area and text area of a specific slide B A slide master and title master merged into a single slide C A slide master and title master for a specific design template D All of above In Microsoft PowerPoint the following should you use if you want all the slide in the presentation to have the same look A The slide layout option B Add a slide option C Outline view D A presentation design template In Microsoft PowerPoint in the context of animations, what is a trigger?

A An action button that advances to the next slide B An item on the slide that performs an action when clicked C The name of a motion path D All of above In Microsoft PowerPoint to preview a motion path effect using the custom animation task pane, you should A Click the play button B Click the show effect button C Double click the motion path D All of above Which of the following will not advance the slides in a slide show view?

To import text from a word document that uses headings into a PowerPoint presentation: Format painter A To paint pretty pictures on your slides B To copy formatting from one object or piece of text and then apply it elsewhere C To change the background color of your slides D To paint pretty pictures on background of slides Slide show options available to the presenter include all of the following except A Transitions command B Speaker notes command C Meeting minder command D Navigation commands.

Which of the following is an example for automatic text formatting A Underlining hyperlink B Adjusting extra space C Replacing two -s with an em hyphens D All of above Which of the following is not a way to create a new presentation?

Which of the following toolbars provide different options in various master views? How can you create a uniform appearance by adding a background image to all slides? How do you create speaker note pages that show the slides, related notes, and your company logo on each page? A Edit the notes master and add your company logo B Edit the slide master and insert your company logo and notes pane C Edit the handout master to include your company logo and one slide per page with additional note space D All of the above Which option on the custom animation task pane allows you to apply a preset or custom motion path?

What is the term used when a clip art image changes the direction of faces? The slide that is used to introduce a topic and set the tone for the presentation is called the A Table slide B Graph slide C Bullet slide D Title slide.

Which of the following tool enables you to add text to a slide without using the standard placeholders? Which of the following features should you use when typing in the notes text box? Want your logo in the same position on every slide, automatically.

Which of the following views is the best view to use when setting transition effects for all slides in a presentation? Which option allows you to select line, curve, freeform or scribble tools?

In Microsoft PowerPoint you can embed a MS-Organization Chart in a slide by A Clicking the object command on the edit menu B Clicking the object command on the edit menu C Clicking the insert new slide button the standard toolbar, then double click the organization chart button on the formatting toolbar D Clicking the MS-Organization Chart button on the standard toolbar In Microsoft PowerPoint to select one hyperlink after another during a slide presentation, what do you press?

In Microsoft PowerPoint which application view works best for adding slide transitions? Which option can be used to set custom timings for slides in a presentation? Which of the following should be used when you want to add a slide to an existing presentation? Which of the following provides a means of printing out feature notes with a miniature slide on a printed page? Which command brings you to the first slide in your presentation?

In normal view, how can you quickly change to handout master view? A Click the outline tab and select handout master view B Press the shift key and click the handout master view button C On the view menu, click slide sorter, and click handouts. How can you quickly reinstate a deleted footer placeholder in master view?

Which of the following can you use to add times to the slides in a presentation? You have got a bunch of digital holiday photo you want to put into a slide show. What the quickest method? A Apply a multiple-picture layout to several slides, and use the clipart icon on the slides to import your picture B On the insert menu, point to the picture, click from file, and select your picture in a group for each slide C On the insert menu, point the picture and click new photo album D All of the above In Microsoft PowerPoint which of the following uses the spelling and grammar feature to indicate an incorrect spelling?

A The incorrect word appears in all capital letters B The incorrect word has a wavy red line under it C The incorrect word appears italicized D The incorrect word appears bold In Microsoft PowerPoint in Microsoft PowerPoint which of the following bypasses the print dialog box when printing individual slides or an entire presentation?

In Microsoft PowerPoint how do you add degrees of transparency to shapes such as arrows, so that the slide background shows though?

In Microsoft PowerPoint auto clip art is a feature that A Automatically places clip art in your presentation B Scans your presentation for incorrect spelling of words on each slide. C Scans your presentation for incorrect spelling in word art objects D All of the above In Microsoft PowerPoint to select all the boxes of an organization chart A Click edit, select all B Right click the chart background click select all C Press and hold the shift key and click each box D All of the above In Microsoft PowerPoint to adjust the width of table columns, you A Click table menu.

Column width, then make adjustments B Drag the vertical gridline between two columns C Drag the column markers on the table ruler bar D Both B and C In Microsoft PowerPoint to add a new row to a table you would A Click the insert rows command on the insert menu B Press the enter key C Click the insert rows button on the standard toolbar D None of the above In Microsoft PowerPoint after moving a clip art image to a particular location on the slide, you can immediately reverse the action using the A Click the not do move object command on the edit menu B Click on the undo button C Click on redo button D All of above.

You edit an embedded table object by A Clicking the edit sub command of the document object command on the edit menu B Double clicking the table object C Right clicking the table object, then clicking edit document on the edit menu D All of above.

In Microsoft PowerPoint you can embed a Microsoft Word tale in a slide by A Clicking the insert new slide button on the standard toolbar, then double clicking table B Clicking the insert Microsoft word table button on the formatting toolbar C Clicking the insert Microsoft word table button on the standard toolbar D Both A and C In Microsoft PowerPoint you can embed a organization chart in a slide by A Clicking the object command on the edit menu B Clicking the insert new slide button on the standard toolbar, then double clicking the organization chart auto layout C Clicking the ms organization chart button on the formatting toolbar D Clicking the ms organization chart button on the standard toolbar In Microsoft PowerPoint you can add multiple subordinates to a position by A Clicking the subordinate button as you press and hold shift B Clicking the subordinate button each and every time you add a subordinate C Clicking the subordinate button as many times as the desired boxes D All of above How would you create the following diagram in PowerPoint A Use auto shapes and the drawing toolbar to create the diagram and design it B Open the diagram gallery from the drawing toolbar and choose this diagram type C Use the chart command on the insert menu to import the diagram D All of above Which of the following provides a means of printing out features notes with a miniature slide on a printed page?

In Microsoft PowerPoint you were giving your presentation, and you need to click a slide thats few slides back. How do you get there? A Press ESC to get back into a normal view; click the slide thumbnail in normal view; then click the resume slide show button B Press backspace until your desired slide C Right click, point to go on the shortcut menu, point to by title, and click the slide you want to go to D All of above In Microsoft PowerPoint which of the following should you do to bring a bullet back to a previous level?

In Microsoft PowerPoint your presentation is ready to go, but you dont know if PowerPoint is installed on the computer, you will use to present with whats the safe way A Save your presentation as a web page B Set up your presentation to be browse as a kiosk C Use the Pack and Go wizard D All of the above In Microsoft PowerPoint the following should you use if you want all the slides in the presentation to have the same look A The slid layout option B The add a slide option C Outline view D A presentation design template Which of the following is not a transition effect?

In Microsoft PowerPoint to change font size of a selected slide title, you A Click the toolbars font dropdown arrow and choose the font you prefer B Click format, title and choose a font from the font tab C Click the toolbars increase font size button D Click title, new font, ok.

In Microsoft PowerPoint you can show the shortcut menu during the slide show by A Clicking the shortcut button in the formatting toolbar B Right clicking the current slide C Clicking an icon on the current slide D A and b In Microsoft PowerPoint after choosing a predefine template,. In Microsoft PowerPoint we can replace a font on all slides with another font using the. In Microsoft PowerPoint Animation schemes can be applied to..

Which of the following you must first complete in order to delete an object? In Microsoft PowerPoint auto shapes tool provides you with A Fancy text to place on your slide B usually found shapes C Any shape you want to add on a slide D Clip art that is related to your presentation An organization has a president, vice president, managers and supervisors. In Microsoft PowerPoint press animation effects allows you to A Add clip art images to your slides B Create a custom transition to the nect slide C Show bullet items as they are discussed D None of above In Microsoft PowerPoint the following features allows you to view slides in a slide show without manually advancing each slide A Adding build effects B Setting slide times C Adding transitions D All of these.

The arrangement of elements such as Title and Subtitle text, pictures, tables etc. In Microsoft PowerPoint the option can be used to create a new slide show with the current slides but presented in a different order A Rehearsal B Custom slider show C Slide show setup D Slide show view Which option in PowerPoint allows to carry slides from one computer to another? C A D B In Access to Refresh the contents of a Lookup field Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or stores a static set of values.

When using Access Database, use this feature to have Access select only certain records in the database to prepare form letters. In Access press. In Access press F11 to A Toggle the Navigation Pane B Cycle between open windows C Restore the selected minimized window when all windows are minimized D Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window According to Access Help, whats a good way to design a database?

A Start from data access pages and work backward B Sketch the design of your database using a pencil and paper C Use the Table Analyzer to reverseengineer your flat source data. D None of above Which editor was provided for use with Access Basic? A The Visual Basic 1. Which of the following type s of queries are action queries? A Update queries. A query prompts a user for a data and then displays only records that contain the specified date.

Which of the following is NOT a report section? How can you display the relationship in a database? If you are creating a cross tab query, what must table you are querying contain? A query summarizes information in a grid, organized by regions and months.

Which type of query is this? What type of text box does the toolbox and to a form? The filter by selection feature allows you to filter A Those records that match an entity in a field B Records based on a criterion you specify C Records that meet any of several criteria you specify D All of above What is the memo data type field used for? A To add table B To store objects created in other programs C For long text entries D For shout text entries of no more than characters What is the purpose of the description column in Table Design View?

A To define the data type applied to each field within the table B To describe the data that should be entered in each field C To enter lookup data that the field should refer to. D None of the above What is the propose to a sub datasheet? A To provide a hierarchial view of related tables or queries in a single window B To display grouped data in a report C To display summarized data.

D All of the above Which of the following is not a selection technique? A To select a word, double click the word B To select an entire table click the empty bosx to the left of the field names C To select a row, click the record selector box to the left of the row D To select a column, double click anywhere in the column.

How can you display Pivot Table report summary data in a currency format? What method can you use to add a new table to your database? Which action do you use in a a macro to automatically send a report snapshot in an email message? How can you display sales grouped by country, region, and salesperson, all at the same time?

A Use the Sort Descending command. In Excel All macro keyboard shortcuts include the …. This type of software contains rows and columns.. In Excel got functions? You need the insert function dialog box. In Excel to delete and embedded object. In Excel to move to the previous worksheet. In Excel Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

In Excel you can enter which types of data into worksheet cells? A Labels. In Excel when you insert an excel file into a word document. In Excel you can use the formula palette to A Format cells containing numbers B Create and edit formulas containing functions C Enter assumptions data D Copy a range of cells You want them to look like this: In Excel each excel file is called a workbook because A It can contain text and data B It can be modified C It can contain many sheets including worksheets and chart sheets D You have to work hard to create it In Excel which of these will not select all the cells in a document?

How can you accomplish this? In Excel one want to track the progress of the stock market on a daily basis.

In Excel which of the following is a correct order of precedence in formula calculation? A Multiplication and division exponentiation positive and negative values B Multiplication and division.

In Excel which of the following options is not located in the Page Setup dialog box? A Page Break Preview. In Excel the Paste Special command lets you copy and paste A Multiply the selection by a copied value B Cell comments C Formatting options D The resulting values of a formula instead of the actual formula 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 In Excel circular reference is A Geometric modeling tool B A cell that points to a drawing object C A formula that either directly or indirectly depends on itself D Always erroneous Which type of chart should one use?

In Excel the numbers in our worksheet look like this: In Excel to cancel the marquee. In Excel to balance your checkbook.

In Excel without using the mouse or the arrow keys. In Excel this function kilometers. In Excel to name a constant. In Excel LEN function does what? In Excel to center worksheet titles across a range of cell. In Excel when integrating Ms-Word and Excel. In Excel which formula can add the all the numeric values in a range of cells. In Excel to activate the previous cell in a preselected range. In Excel when you work with large worksheets. When you link data maintained in Excel workbook to a Word document A The Word document cannot be edited B The Word document contains a reference to the original source application C The word document must contain a hyperlink D The word document contains a copy of the actual data In Excel to access the Go To Special feature.

In Excel when you see a cell with a red triangle in the top right corner. In Excel you can use the horizontal and vertical scroll bars to A Split a worksheet into two panes B View different rows and columns C Edit the contents of a cell D View different worksheets In Excel how do you change column width to fit the contents?

A Single-click the boundary to the left to the column heading B Double click the boundary to the right of the column heading C Press Alt and single click anywhere in the column D All of above A There is an error in the cell B There is a comment associated with the cell C The font color for text in the cell is red D A formula cannot be entered into the cell.

When you print preview a worksheet A the entire worksheet is displayed B the selected range is displayed C the active portion of the worksheet is displayed D All of the above In Excel when the formula bar is activated. What do we call a computer program that organizes data in rows and columns of cells?

You might use this type of program to keep a record of the money you earned moving lawns over the summer. In Excel to drag a selected range of data to another worksheet in the same workbook. In Excel which do you press to enter the current date in a cell?

In Excel it is acceptable to let long text flow into adjacent cells on a worksheet when A Data will be entered in the adjacent cells B No data will be entered in the adjacent cells C There is no suitable abbreviation for the text D There is not time to format the text In Excel to edit in an embedded excel worksheet object in a word document A Use the excel menu bar and toolbars inside the word application B Edit the hyperlink C Edit the data in a excel source application D Use the word menu bar and toolbars In Excel you can open the scenario Manager dialog box by choosing scenarios from the ….

In Excel to hold row and column titles in places so that they do not scroll when you scroll a worksheet. In Excel one can copy data or formulas A With the copy.

In Excel Rounding errors can occur A When you use multiplication. In Excel you can open the Sort dialog box by choosing Sort from the …. In Excel when working in the page break preview.

To edit data in an embedded Excel worksheet object in a Word document A Use the Excel menu bar and toolbars inside the word application B Edit the hyperlink C Edit the data in a Excel source application D Use the Word menu bar and toolbars In Excel one can use the format painter multiple times before one turn it off by A You can use the format painter button on ly one time when you click it B Double clicking the format painter button C Pressing the Ctrl key and clicking the format painter button D Pressing the Alt key and clicking the format painter button In Excel you cannot link excel worksheet data to a word document A With the right drag method B With a hyperlink C With the copy and paste special commands D With the copy and paste buttons on the standard toolbar In Excel which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

A Use Ctrl to select all three cells C There is no way to copy and apply formatting in Excel — You have to do it manually D The Format Painter button on the standard toolbar In Excel In a worksheet you can select A The entire worksheet B Rows C Columns D All of the above When you link data maintained in an excel workbook to a word document A The word document cannot be edit B The word document contains a reference to the original source application.

C The word document must contain a hyperlink D The word document contains a copy of the actual data Which area in an excel window allows entering values and formulas? Answer Sheet 1. In Microsoft PowerPoint what are lines, curve, freeform, and scribble A Emphasis effects that can be applied to animations B Types of custom motion paths C Predefined entrance and exit effects D All of the above 5.

In Microsoft PowerPoint the easy way to apply varied animations to test on slides A Apply effects in the custom animation text pane B Apply an animation scheme C Customize bullets with animated clipart D All of above 9. In Microsoft PowerPoint using a custom animation effect, how do you make text appear on a slide by letter A Apply the animation scheme fade in one by one.

In Microsoft PowerPoint to exit the PowerPoint application, you should A Click the application minimize button B Click the document close button C Double click the application control menu icon D Double click the document control menu icon In Microsoft PowerPoint you have customized a design template in one presentation and you want to use it in another presentation. A Use the browse feature in the slide design task pane to find the file that has your design template and apply it to the current file.

B Copy and paste the slide with the design template you want to include the new presentation; inserted slide will inherit the design. In Microsoft PowerPoint the following displays when an image is selected A Add clip art only if it relates to your topic B Be sure to place at least one clipart image per slide C Resize the image so it takes up as much space as your text D Both A and B The Microsoft clip gallery allows you to A Add word art images to a slide B Spell check your presentation C Add clip art images to a slide or slides D Add slides to a presentation In Microsoft PowerPoint to edit the text within the boxes of an organization chart, you A Select the box and text, then make changes B Select the box, then make the dchanges C Highlight the text, them make the changes D A and B both In Microsoft PowerPoint the following options in the printer dialog box would you select to prit slides 5 and 12 in a presentation?

In Microsoft PowerPoint the best way to design the layout for your slides A Create layouts for slides, handouts and notes using the Master Layout dialog box in slide master view B For each new slide, select a layout from the Slide Layout task pane C Apply templates from the Slide Design task pane D None of above Which file format can be added to a PowerPoint show? In Microsoft PowerPoint slide show options available to the presenter include all of the following except A Transitions command B Speaker notes command C Meeting reminder command D Navigation commands In Microsoft PowerPoint two kind of sound effects files that can be added to the presentation are A.

In Microsoft PowerPoint you can show the shortcut menu during the slide show by A Clicking the shortcut button on the formatting toolbar B Right clicking the current slide C Clicking an icon on the current slide D A and B both In Microsoft PowerPoint auto clipart is a feature that A Automatically places clipart in your presentation B Scans your presentation for incorrect spelling in your words on each slide C Scans your presentation for incorrect spelling in Word Arts objects D All of above In Microsoft PowerPoint the following bypasses the print dialog box when printing individual slides or an entire presentation A File.

In Microsoft PowerPoint you can edit an embedded organization chart object by A Clicking edit object B Double clicking the organization chart object C Right clicking the chart object.

In Microsoft PowerPoint to maintain the perspective height and width ratio of an object when resizing. In Microsoft PowerPoint the following best describes serifs A Serifs on characters help to differentiate between similar looking letters B Serifs fonts are best for viewing test at a distance C Serifs are fine cross strokes that appear at the bottom and top of a letter D Serif font are very simple in appearance In Microsoft PowerPoint size of a table object A Is dependent on the amount of text within the table B Is determined by the presentation design but can be changed C Is determined by the presentation design and cannot be changed D A and C both are true In Microsoft PowerPoint to edit the text within the boxes of an organization chart.

In Microsoft PowerPoint size of an organization chart object A Is determined by the presentation design and cannot be changed B Is determined by the presentation design but can be changed in PowerPoint C Is dependent on the amount of text within the organization chart D Both A and C are true In Microsoft PowerPoint in order to edit a chart.

In Microsoft PowerPoint what is a slide-title master pair? A The title area and text area of a specific slide B A slide master and title master merged into a single slide C A slide master and title master for a specific design template D All of above In Microsoft PowerPoint in the context of animations.

In Microsoft PowerPoint the following tools enable you to add text to a slide without using the standard placeholders A Text box tool B Line tool. A An action button that advances to the next slide B An item on the slide that performs an action when clicked C The name of a motion path D All of above C Fill color D Auto shapes tool Animation B Click the PowerPoint window and move it around vigorously with the mouse for a manual animation effect C Select the slide in slide sorter view.

In Microsoft PowerPoint an image is selected. In Microsoft PowerPoint the following must be used with the mouse when you want to resize an image from the center and keep it proportioned A The space bar B The alt key C The ctrl key D The shift key In Microsoft PowerPoint to preview a motion path effect using the custom animation task pane, you should A Click the play button B Click the show effect button C Double click the motion path D All of above Which of the following will not advance the slides in a slide show view?

To import text from a word document that uses headings into a PowerPoint presentation: Format painter A To paint pretty pictures on your slides B To copy formatting from one object or piece of text and then apply it elsewhere C To change the background color of your slides D To paint pretty pictures on background of slides Slide show options available to the presenter include all of the following except A Transitions command B Speaker notes command C Meeting minder command D Navigation commands.

Which of the following is not a way to create a new presentation? Which of the following toolbars provide different options in various master views? How can you create a uniform appearance by adding a background image to all slides? How do you create speaker note pages that show the slides, related notes, and your company logo on each page? A Edit the notes master and add your company logo B Edit the slide master and insert your company logo and notes pane C Edit the handout master to include your company logo and one slide per page with additional note space D All of the above Which option on the custom animation task pane allows you to apply a preset or custom motion path?

What is the term used when a clip art image changes the direction of faces? The slide that is used to introduce a topic and set the tone for the presentation is called the A Table slide B Graph slide C Bullet slide D Title slide.

Which of the following tool enables you to add text to a slide without using the standard placeholders? Which of the following features should you use when typing in the notes text box? Want your logo in the same position on every slide, automatically. Which of the following views is the best view to use when setting transition effects for all slides in a presentation? Which option allows you to select line, curve, freeform or scribble tools?

In Microsoft PowerPoint you can embed a MS-Organization Chart in a slide by A Clicking the object command on the edit menu B Clicking the object command on the edit menu C Clicking the insert new slide button the standard toolbar, then double click the organization chart button on the formatting toolbar D Clicking the MS-Organization Chart button on the standard toolbar In Microsoft PowerPoint to select one hyperlink after another during a slide presentation, what do you press?

In Microsoft PowerPoint which application view works best for adding slide transitions? Which option can be used to set custom timings for slides in a presentation? Which of the following should be used when you want to add a slide to an existing presentation? Which of the following provides a means of printing out feature notes with a miniature slide on a printed page?

Which command brings you to the first slide in your presentation? In normal view, how can you quickly change to handout master view? A Click the outline tab and select handout master view B Press the shift key and click the handout master view button C On the view menu, click slide sorter, and click handouts. How can you quickly reinstate a deleted footer placeholder in master view? Which of the following can you use to add times to the slides in a presentation? You have got a bunch of digital holiday photo you want to put into a slide show.

What the quickest method? A Apply a multiple-picture layout to several slides, and use the clipart icon on the slides to import your picture B On the insert menu, point to the picture, click from file, and select your picture in a group for each slide C On the insert menu, point the picture and click new photo album D All of the above In Microsoft PowerPoint which of the following uses the spelling and grammar feature to indicate an incorrect spelling?

A The incorrect word appears in all capital letters B The incorrect word has a wavy red line under it C The incorrect word appears italicized D The incorrect word appears bold In Microsoft PowerPoint in Microsoft PowerPoint which of the following bypasses the print dialog box when printing individual slides or an entire presentation? In Microsoft PowerPoint how do you add degrees of transparency to shapes such as arrows, so that the slide background shows though?

In Microsoft PowerPoint auto clip art is a feature that A Automatically places clip art in your presentation B Scans your presentation for incorrect spelling of words on each slide. C Scans your presentation for incorrect spelling in word art objects D All of the above In Microsoft PowerPoint to select all the boxes of an organization chart A Click edit, select all B Right click the chart background click select all C Press and hold the shift key and click each box D All of the above In Microsoft PowerPoint to adjust the width of table columns, you A Click table menu.

Column width, then make adjustments B Drag the vertical gridline between two columns C Drag the column markers on the table ruler bar D Both B and C In Microsoft PowerPoint to add a new row to a table you would A Click the insert rows command on the insert menu B Press the enter key C Click the insert rows button on the standard toolbar D None of the above In Microsoft PowerPoint after moving a clip art image to a particular location on the slide, you can immediately reverse the action using the A Click the not do move object command on the edit menu B Click on the undo button C Click on redo button D All of above.

You edit an embedded table object by A Clicking the edit sub command of the document object command on the edit menu B Double clicking the table object C Right clicking the table object, then clicking edit document on the edit menu D All of above. In Microsoft PowerPoint you can embed a organization chart in a slide by A Clicking the object command on the edit menu B Clicking the insert new slide button on the standard toolbar. How do you get there?

A Press ESC to get back into a normal view. In Microsoft PowerPoint you were giving your presentation. In Microsoft PowerPoint you can embed a Microsoft Word tale in a slide by A Clicking the insert new slide button on the standard toolbar.

How would you create the following diagram in PowerPoint A Use auto shapes and the drawing toolbar to create the diagram and design it B Open the diagram gallery from the drawing toolbar and choose this diagram type C Use the chart command on the insert menu to import the diagram D All of above Which of the following provides a means of printing out features notes with a miniature slide on a printed page? In Microsoft PowerPoint which of the following should you do to bring a bullet back to a previous level?

In Microsoft PowerPoint you can add multiple subordinates to a position by A Clicking the subordinate button as you press and hold shift B Clicking the subordinate button each and every time you add a subordinate C Clicking the subordinate button as many times as the desired boxes D All of above In Microsoft PowerPoint your presentation is ready to go.

Which of the following is not a transition effect? New Font. In Microsoft PowerPoint the key deletes text before. Fonts B Tools. Replace Fonts D Format.

In Microsoft PowerPoint we can replace a font on all slides with another font using the …. In Microsoft PowerPoint to insert a new slide in the current presentation. Now Save from the menu D click the saver button on the formatting toolbar In Microsoft PowerPoint you can show the shortcut menu during the slide show by A Clicking the shortcut button in the formatting toolbar B Right clicking the current slide C Clicking an icon on the current slide D A and b In Microsoft PowerPoint after choosing a predefine template.

In Microsoft PowerPoint to change font size of a selected slide title. In Microsoft PowerPoint the following features allows you to view slides in a slide show without manually advancing each slide A Adding build effects B Setting slide times C Adding transitions D All of these In Microsoft PowerPoint the following should be used when you want to add a slide to an existing presentation A File. The arrangement of elements such as Title and Subtitle text. In Microsoft PowerPoint auto shapes tool provides you with A Fancy text to place on your slide B usually found shapes C Any shape you want to add on a slide D Clip art that is related to your presentation An organization has a president.

In Microsoft PowerPoint the following statements is not true A Holding down the Shift key while you draw an object creates perfect squares. Which of the following you must first complete in order to delete an object? In Microsoft PowerPoint boxes that are displayed to indicate that the text. When using Access Database. In Access. In Access press ……………………. In Access press…………………….

In Access to switch between the upper and lower portions of a window Design view of queries. Navigation Pane. In Access press to Cycle through the field grid. Be thorough with the exam pattern and syllabus. Plan your studies accordingly.

Alok Kumar Books

As you have less preparation time left time management plays an important role. You need to be relaxed and devote your as much time in studies as possible. Avoid taking single, big breaks from your study time and break into multiple breaks of several minutes. This will help in concentrating better and keep you refreshed throughout the day.

This will not only help you revise your preparation but also help you evaluate it.Disha Experts. In Excel to balance your checkbook. The concept used to support multi programming environment on a computer is A Virtual memory B Hierarchy of physical memory C Display of multiple windows D None the above. Computer output which is displayed on the screen of a terminal without a permanent copy is called A Soft copy B Hard copy C Hardware D None of these The mail box and ports are examples of A Indirect process communication B Direct process communication.

Product details Paperback:

RENA from Hawaii
I do enjoy reading novels helplessly . See my other articles. I enjoy beadwork.