Homechevron_rightEngineeringchevron_rightComputer Sciencechevron_rightMicrosoft Officechevron_rightMicrosoft Excel

Microsoft Excel MCQs

  • 1. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  • filter_dramaExplanation
    Answer is : D
  • 2. How can you remove borders applied in cells?
  • filter_dramaExplanation
    Answer is : C
    On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button.
    --OR--
    Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.
  • 3. Where can you set the shading color for a range of cells in Excel?
  • filter_dramaExplanation
    Answer is : D
    The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell.
  • 4. You can set Page Border in Excel from
  • filter_dramaExplanation
    Answer is : D
    There is no option to set page border in Excel.
  • 5. You can set Page Border in Excel from
  • filter_dramaExplanation
    Answer is : D
    There is no option to set page border in Excel.
  • 6. You can check the conditions against __________ when applying conditional formatting
  • filter_dramaExplanation
    Answer is : C
    We can check the conditions against Cell value or Formula when applying conditional formatting.
  • 7. Which of the following is not true regarding Conditional Formatting?
  • filter_dramaExplanation
    Answer is : B
    In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.
  • 8. Which of the following is invalid statement?
  • filter_dramaExplanation
    Answer is : D
    The width of a row and be specified manually or fit automatically is invalid statement.
  • 9. You can use the formula palette to
  • filter_dramaExplanation
    Answer is : B
    Formula palette is used to create and edit formula.
    It is also possible to type a function directly into a cell, however, as there are over 300 functions built into Microsoft Excel, some of which are quite complex, Excel provides the Formula Palette to simplify the process.
  • 10. You can use the formula palette to
  • filter_dramaExplanation
    Answer is : B
    Formula palette is used to create and edit formula.
    It is also possible to type a function directly into a cell, however, as there are over 300 functions built into Microsoft Excel, some of which are quite complex, Excel provides the Formula Palette to simplify the process.
leaderboardLeaderboard
  • Rahul Kumar

    191 Points

  • VIKRAM JEET

    54 Points

  • GEETHIKA CHOWDARY

    53 Points

  • Zain

    49 Points

  • Shubham Raina

    35 Points