A UNIT OF MAHAVIR COMPUTERS
STUDENT HELPLINE : 09931083325

वैकल्पिक प्रश्नावली


नोट- सही विकल्प को बोल्ड किया गया है|
  1. To move the insertion point to the beginning of data in a cell, press…………….
    2. A. Begin
    B. Page up
    C. End
    D. Home
  2. A saved workbook is a referred to as a ………………….
    3. A. Book
    B. Workbook
    C. Project
    D. File
  3. The……………..bar present information about the worksheet, the function of the button the mouse pointer is pointing to, or the mode of excel.
    4. A. Function
    B. indicator
    C. chart
    D. status
  4. The ……………..command in the Auto calculate area displays the number of non blank cells in the selected rang.
    5. A. Count
    B. Blank
    C. Zero
    D. Fill
  5. The small black square located in the lower-right corner of the heavy border around the active cell is called the………………..
    6. A. relative reference
    B. source area
    C. range
    D. Fill handle
  6. The ……………. Is a blinking vertical line that indicates where the next typed character will appear.
    7. A. Insertion point Key
    B. Tip
    C. Active cell
    D. Ribbon
  7. The basic unit of a worksheet into which you enter data is a called a……………….
    8. A. Tab
    B. Cell
    C. Box
    D. Range
  8. Each work- sheet has a sheet name that appears on a (n)……………. At the bottom of the worksheet.
    9. A. Name indicator
    B. Active tab
    C. Title tab
    D. Sheet tab
  9. A file name can have a maximum of ……………………. Character.
    10. A. 25
    B. 100
    C. 255
    D. 32,676
  10. The mouse pointer turns to a ………………….whenever you move it outside the work sheet.
    11. A. Hand
    B. Block arrow
    C. Double-headed arrow
    D. Crosshair
  11. The …………..located near the top of the Excel windows, is the control center in Excel.
    12. A. Ribbon
    B. Control bar
    C. Home tab
    D. Mode tab
  12. To emphasize certain entries and make the worksheet easier to read and understand, you………….. the worksheet .
    13. A. Format
    B. Edit
    C. Print
    D. Proofread
  13. By default, Excel positions text in a cell……………
    14. A. Left- aligned
    B. Right- aligned
    C. Centered
    D. Justified
  14. A cell is referred to by its unique address, called a(n)………………, which Is the coordinates of the intersection of a column and arrow.
    15. A. Cell reference
    B. Name box
    C. Unit
    D. Active Cell
  15. To save a workbook using the shortcut keys, press……………….
    16. A. ALT+S
    B.CTRL+S
    C. SHIFT+S
    D. CTRL+F2
  16. To enter a number as text, start the entry with a(n)……………
    17. A. Asterisk
    B. Hyphen
    C. Semicolon
    D. Apostrophe
  17. To center data in a cell, click the……………… button on the Ribbon.
    18. A. Move
    B. Align
    C. Center
    D. Best fit
  18. To determine the highest number in a range of number, click insert function box in the formula bar to display the insert function dialog box then select.
    19. A. RANGE
    B. SEARCH
    C. MAX
    D. SUM
  19. Excel has a ……………. You can use to check the worksheet for spelling errors.
    20. A. Dictionary
    B. Corrector
    C. Spell checker
    D. Spelling function
  20. A(n)……………….. takes a value or values, performs an operation, and returns a result to the cell
    21. A. Operation
    B. Cell
    C. Function
    D. Argument
  21. The default view for a worksheet is ………………
    22. A. Normal view
    B. Standard View
    C. Page view
    D. Basic View
  22. In the formula:=A4/B4+C5-D5*E6 the………….. operation is performed first.
    23. A. Multiplication
    B. Division
    C. Addition
    D. Exponentiation
  23. The…………….. Button gives option for how to fill cells following a fill operation.
    24. A. Insert option
    B. Auto fill option
    C. Auto Sum
    D. Format fill
  24. ………………. Cells is a technique you can use to hide data that might be sensitive or not relevant to a report.
    25. A. Securing
    B. Formatting
    C. Hiding
    D. Shadowing
  25. The arithmetic operator for multiplication is …………..
    26. A. %
    B. *
    C. x
    D. A
  26. The ……………dollar sign displays to the far left in a cell.
    27. A. Floating
    B. fixed
    C. Aligned
    D. Normal
  27. Excel automatically formats the data stamp to the date and time format……………..
    28. A. mm/dd/ yy hh:mm
    B. dd/mm/yy hh:mm
    C. m/d/yy h:mm
    D. mm/dd/yyyy hh:mm
  28. The………….. On the status bar can be used to change the size of entries to make them more readable.
    29. A. Fit in cell button
    B. Zoom slider
     C. View tab
    D. Fit in screen button
  29. To quite Excel, click the ……………… button on the title bar
    30. A. Exit
    B. Close
    C. Restore
    D. Save
  30. You can use the zoom in or zoom out buttons on the status bar to zoom from…………….. to ………………%.
    31. A. 2 and 500
    B. 0 and 10
    C. 10 and 400
    D. 0 and 100
  31. Using the …………… button on the Ribbon, You can Format a cell quickly by copying a cell’s format to another cell or range of cells.
    32. A. Formatter
    B. Format painter
    C. Copy
    D. Layout
  32. Excel display the errors message…………….. in cells to indicate a cell reference error.
    33. A. !REF#
    B.*REF*
    C. #REF#
    D. # REF!
  33. You can set a specific range of data to print each time you print a worksheet by using the …………
    34. A. Print Area
    B. Set Print Area
    C. Permanent Print Area
    D. Lock Print Area
  34. The …………Function returns the future value of investment.
    35. A. PMT
    B. FV
    C. PV
    D.PM
  35. To remove the print area so that the entire worksheet prints, click the …….. command
    36. A. Clear
    B. Remove Print Area
    C. Clear Print Area
    D. Clear Formatting
  36. The …….. Function returns the present value of an investment.
    37. A. FV
    B.PMT
    C.PV
    D.PVT
  37. Data is in ………… if it is sorted from Z to A
    38. A. alphabetical
    B. descending order
    C. ascending
    D. downward
  38. A…………..is printed at the bottom of every page in a printout.
    39. A. header
    B. footer
    C. margin
    D. comment
  39. The…………… define(s) the appearance and format of a page.
    40. A. header
    B. footer
    C. page setup
    D. margins
  40. A(n)………. Is printed at the top of every page in a printout
    41. A. brace
    B. arrow
    C. footer
    D. header
  41. To ensure that other will not unprotect your worksheet, create a(n)…… for you worksheet.
    42. A. macro
    B. password
    C. code
    D. application
  42. To record a macro, click……………… button on the Visual Basic Code
    43. A. New Macro
    B. Create Macro
    C. Start Record
    D. Record Macro
  43. A Comment indicator appears as which of the following colors?
    44. A. Red
    B. Blue
    C. Green
    D. Black

Please Follow and Like us: