M S Office And Internet

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Mohsin Khan
M
Mohsin Khan
Community Contributor
Quizzes Created: 2 | Total Attempts: 3,519
Questions: 30 | Attempts: 135

SettingsSettingsSettings
M S Office And Internet - Quiz


Max Time:40 Minutes
No. Of Questions: 30
Read All Questions Carefully
No Negative Marking
-:All the Best:-


Questions and Answers
  • 1. 

    What will be the output of =product(12,5) ?

    • A.

      17

    • B.

      60

    • C.

      7

    • D.

      None

    Correct Answer
    B. 60
    Explanation
    The correct answer is 60. The "product" function is typically used to multiply numbers. In this case, the function is being called with the arguments 12 and 5. Therefore, the function will multiply 12 and 5 together, resulting in an output of 60.

    Rate this question:

  • 2. 

    Which menu contains the option to insert the table in our document?

    • A.

      Insert menu

    • B.

      Table menu

    • C.

      Format menu

    • D.

      Edit menu

    Correct Answer
    B. Table menu
    Explanation
    The correct answer is "Table menu" because this menu specifically contains the option to insert a table in the document. The Insert menu may have other options but not specifically for tables. The Format menu is generally used for formatting text or objects, and the Edit menu is used for editing functions such as copy, paste, etc. Therefore, the Table menu is the most appropriate menu for inserting a table in the document.

    Rate this question:

  • 3. 

    What is the use of Ctrl+f4 command?

    • A.

      Opens a new document

    • B.

      Closes the current document

    • C.

      Applies the changes to font

    • D.

      Creates an auto text

    Correct Answer
    B. Closes the current document
    Explanation
    The Ctrl+F4 command is used to close the current document. This shortcut is commonly used in various applications to quickly close the active window or tab without having to use the mouse. It is a convenient way to close documents or tabs when you are finished with them or want to clear up clutter on your screen.

    Rate this question:

  • 4. 

    If you press s and it writes sunil automatically, so which option is used by any other user

    • A.

      Auto text

    • B.

      Auto correct

    • C.

      Auto format

    • D.

      Auto fit

    Correct Answer
    B. Auto correct
    Explanation
    When a user presses the letter "s" and it automatically writes "sunil," it indicates the use of auto correct. Auto correct is a feature commonly found in word processing software and mobile devices that automatically corrects misspelled or mistyped words. In this case, when the user presses "s," the auto correct feature replaces it with the word "sunil" based on the predefined settings or learned patterns.

    Rate this question:

  • 5. 

    Toolbar option is used to show the title bar.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    The given statement is true. The toolbar option is indeed used to show the title bar. The title bar is the topmost horizontal bar in a window that displays the title of the window or application. The toolbar option typically includes various buttons or icons that provide quick access to commonly used functions or features. By enabling the toolbar option, the title bar with its associated functionality is displayed to the user.

    Rate this question:

  • 6. 

    Hyperlink is used to create link between.

    • A.

      Two files

    • B.

      Two words

    • C.

      Two lines

    • D.

      None of above

    Correct Answer
    A. Two files
  • 7. 

    The zooming value of MS WORD lies between

    • A.

      10% to 400%

    • B.

      50% to 400%

    • C.

      10% to 500%

    • D.

      25% to 300%

    Correct Answer
    C. 10% to 500%
    Explanation
    The zooming value of MS Word can be adjusted between 10% to 500%. This means that users can choose to view their document at a zoom level as low as 10% or as high as 500% of the normal size. This feature allows users to customize their viewing experience based on their preferences and requirements, whether they want to see a more detailed view or a broader overview of the document.

    Rate this question:

  • 8. 

    Which menu contains the font attributes

    • A.

      Edit menu

    • B.

      View menu

    • C.

      Format menu

    • D.

      Tools menu

    Correct Answer
    C. Format menu
    Explanation
    The Format menu is the correct answer because it typically contains options related to formatting text, including font attributes such as font type, size, style (bold, italic, underline), and color. This menu is commonly found in various software applications, including word processors, graphic design programs, and web development tools. By selecting the Format menu, users can easily access and modify the font attributes of their text to customize its appearance according to their preferences.

    Rate this question:

  • 9. 

    What's the advantage of using a style to format a document?

    • A.

      A style gives you access to the Font dialog box, which has many design choices.

    • B.

      A style's purpose is to apply many types of formatting at once.

    Correct Answer
    B. A style's purpose is to apply many types of formatting at once.
    Explanation
    Using a style to format a document has the advantage of applying multiple types of formatting simultaneously. This saves time and effort as it eliminates the need to manually adjust each formatting element individually. By using a style, one can easily apply consistent formatting throughout the document, ensuring a professional and cohesive appearance. Additionally, styles provide a convenient way to make global changes to the formatting, as modifying the style automatically updates all instances where it is applied.

    Rate this question:

  • 10. 

    Which one of these is NOT a way of using keystrokes?

    • A.

      To move around menus.

    • B.

      To cut, copy, and paste text.

    • C.

      To move around toolbars.

    • D.

      By using a mouse, a tracker ball, or a touchpad

    Correct Answer
    D. By using a mouse, a tracker ball, or a touchpad
    Explanation
    The given answer states that using a mouse, a tracker ball, or a touchpad is not a way of using keystrokes. This is because keystrokes refer specifically to the act of pressing keys on a keyboard, whereas using a mouse, tracker ball, or touchpad involves using physical movements or gestures to navigate or interact with a computer.

    Rate this question:

  • 11. 

    What is the use of Ctrl+E in MS PAINT.

    • A.

      Copy

    • B.

      Attributes

    • C.

      Clear Image

    • D.

      None of Above

    Correct Answer
    B. Attributes
    Explanation
    Ctrl+E in MS Paint is used to access the "Attributes" menu. This menu allows users to modify the properties of selected objects or elements in the image, such as the size, color, and style. By pressing Ctrl+E, users can quickly access this menu and make changes to the attributes of the selected objects without having to navigate through the menu manually.

    Rate this question:

  • 12. 

    .XLS is the extension of which application

    • A.

      Work Sheet

    • B.

      Work Book

    • C.

      Chart

    • D.

      Document

    Correct Answer
    B. Work Book
    Explanation
    .XLS is the extension used for Microsoft Excel workbooks. A workbook is a collection of worksheets, charts, and other data that are all stored together in a single file. Therefore, the correct answer is Work Book.

    Rate this question:

  • 13. 

    Ctrl+1 short key is used to

    • A.

      Edit cell

    • B.

      Format cell

    • C.

      Delete cell

    • D.

      None

    Correct Answer
    B. Format cell
    Explanation
    Ctrl+1 is a keyboard shortcut used to format cells in Microsoft Excel. By pressing Ctrl+1, the Format Cells dialog box opens, allowing users to customize the formatting of the selected cell or range of cells. This includes options such as changing the number format, applying font styles, adjusting cell alignment, and adding borders or fill colors. Therefore, the correct answer is "Format cell".

    Rate this question:

  • 14. 

    Which process is used to clear the comment only from a cell?

    • A.

      Format > cell

    • B.

      Insert > comment

    • C.

      Edit > clear > comment

    • D.

      Edit > clear > all

    Correct Answer
    C. Edit > clear > comment
    Explanation
    The correct answer is "Edit > clear > comment." This option is used to specifically clear the comment from a cell in a spreadsheet. The other options listed do not specifically mention clearing comments, but rather refer to formatting cells, inserting comments, or clearing all content from a cell. Therefore, "Edit > clear > comment" is the appropriate process to use when wanting to remove only the comment from a cell.

    Rate this question:

  • 15. 

    Output of =fact(5) will be_____.

    • A.

      5

    • B.

      120

    • C.

      50

    • D.

      25

    Correct Answer
    B. 120
    Explanation
    The output of the function `fact(5)` will be 120. This is because the function `fact()` is likely designed to calculate the factorial of a given number. In this case, the factorial of 5 is 5 x 4 x 3 x 2 x 1, which equals 120.

    Rate this question:

  • 16. 

    Count Function is used to ____________.

    • A.

      Counts the blank cells

    • B.

      Counts the filled cells

    • C.

      Count the filled and blank cells both

    • D.

      None of above

    Correct Answer
    B. Counts the filled cells
    Explanation
    The Count Function is used to count the number of cells in a range that contain numerical values. It does not count blank cells or cells with text or other non-numeric values. Therefore, the correct answer is "Counts the filled cells."

    Rate this question:

  • 17. 

    Paste as hyperlink is used to ____________.

    • A.

      Link two files

    • B.

      Link two cells

    • C.

      Link two rows

    • D.

      Link two columns

    Correct Answer
    B. Link two cells
    Explanation
    "Paste as hyperlink" is a feature that allows you to create a hyperlink to a specific location within a document or workbook. When you select and copy a cell or range of cells, and then use the "Paste as hyperlink" option, it creates a hyperlink in the destination cell that links to the copied cells. This can be useful for quickly navigating to related information within a document or workbook.

    Rate this question:

  • 18. 

    If you press Ctrl+W then what action will be done?

    • A.

      It will close the application

    • B.

      It will close the worksheet

    • C.

      It will close the workbook

    • D.

      It will do nothing in MS EXCEL

    Correct Answer
    C. It will close the workbook
    Explanation
    Pressing Ctrl+W in MS Excel will close the workbook. This shortcut key is commonly used to quickly close the currently active workbook without closing the entire Excel application. It is a convenient way to close a workbook when you are done working on it and want to free up memory and resources.

    Rate this question:

  • 19. 

    By which option we can apply the border to any particular cell or set of cells

    • A.

      Format > Border and Shading

    • B.

      Format > Cells

    • C.

      Format > Sheet

    • D.

      Format > Row

    Correct Answer
    B. Format > Cells
    Explanation
    The correct answer is "Format > Cells" because this option allows us to apply borders to any particular cell or set of cells. By selecting this option, we can choose the border style, color, and thickness, and apply it to the desired cells. This option provides more flexibility in customizing the borders compared to the other options listed.

    Rate this question:

  • 20. 

    If a cell contains a formula, comment and some format. A user want to use the formula of this cell in another cell, so which option can be used by that user?

    • A.

      Insert > function

    • B.

      Copy > paste

    • C.

      Copy > paste special

    • D.

      None of above

    Correct Answer
    C. Copy > paste special
    Explanation
    The user can use the option "Copy > paste special" to use the formula of a cell in another cell. This option allows the user to copy not only the value but also the formatting and formulas of the selected cell. By using "Copy > paste special", the user can ensure that the formula is correctly transferred to the new cell without any errors or modifications.

    Rate this question:

  • 21. 

    What's 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 these

    Correct Answer
    B. For each new slide, select a layout from the Slide Layout task pane.
    Explanation
    The best way to design the layout for your slides is to select a layout from the Slide Layout task pane for each new slide. This allows you to choose a pre-designed layout that fits your content and presentation style. By selecting a layout, you can ensure consistency in the design and formatting of your slides, making it easier for your audience to follow along and understand the information presented.

    Rate this question:

  • 22. 

    How do you print your slides in a handout that includes lines for notes?

    • A.

      In the Print dialog box, select Handouts and set the number of slides per page to 3.

    • B.

      In the Print dialog box, select Handouts and a number of slides per page, then select the Include comment pages option.

    • C.

      In the Print dialog box, select Notes Pages instead of Handouts.

    • D.

      None of these

    Correct Answer
    A. In the Print dialog box, select Handouts and set the number of slides per page to 3.
    Explanation
    To print slides in a handout that includes lines for notes, you need to select Handouts in the Print dialog box and set the number of slides per page to 3. This option allows you to print multiple slides on each page with space for notes next to them.

    Rate this question:

  • 23. 

    You've got a bunch of digital holiday photos you want to put into a slide show. What's the quickest method?

    • A.

      Apply a multiple-picture layout to several slides, and use the Clip Art icon on the slides to import your pictures.

    • B.

      On the Insert menu, point to Picture, click From File, and select your pictures in a group for each slide.

    • C.

      On the Insert menu, point to Picture, and click New Photo Album.

    • D.

      None of these

    Correct Answer
    C. On the Insert menu, point to Picture, and click New Photo Album.
    Explanation
    The quickest method to create a slide show with a bunch of digital holiday photos is to use the "New Photo Album" feature. This allows you to easily insert and organize your pictures into slides without having to manually apply layouts or import pictures one by one.

    Rate this question:

  • 24. 

    How would you create the following diagram in PowerPoint?

    • A.

      Use AutoShapes 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.

      None of these

    Correct Answer
    B. Open the Diagram Gallery from the Drawing toolbar and choose this diagram type.
    Explanation
    To create the diagram in PowerPoint, you would open the Diagram Gallery from the Drawing toolbar and choose the specific diagram type. This option provides the necessary tools and templates to create the desired diagram efficiently and effectively. Using AutoShapes and the Drawing toolbar or importing a chart from the Insert menu are not the correct methods for creating this particular diagram.

    Rate this question:

  • 25. 

    Using a custom animation effect, how do you make text appear on a slide letter by letter?

    • A.

      Apply the animation scheme Fade in one by one.

    • B.

      Apply an entrance effect, and then set it to By letter in the Effect Options dialog box.

    • C.

      Apply the Fly In entrance effect to the text, and then set its speed to Very Slow.

    • D.

      None of these

    Correct Answer
    B. Apply an entrance effect, and then set it to By letter in the Effect Options dialog box.
    Explanation
    To make text appear on a slide letter by letter, you need to apply an entrance effect and then set it to "By letter" in the Effect Options dialog box. This will animate each letter of the text to appear one by one. Applying the animation scheme "Fade in one by one" or setting the speed of the "Fly In" entrance effect to "Very Slow" will not achieve the desired effect.

    Rate this question:

  • 26. 

    Where we can write the domain name in web browser?

    • A.

      Toolbar

    • B.

      Standard bar

    • C.

      Address bar

    • D.

      None of these

    Correct Answer
    C. Address bar
    Explanation
    The domain name can be written in the address bar of a web browser. This is the space where the URL (Uniform Resource Locator) of a website is entered. It allows users to directly access specific websites by typing in the domain name or the IP address of the website they want to visit. The address bar is typically located at the top of the browser window and is a crucial component for navigating the internet.

    Rate this question:

  • 27. 

    The most widely used web search engine is

    • A.

      Google

    • B.

      Yahoo

    • C.

      Aol

    • D.

      None of these

    Correct Answer
    A. Google
    Explanation
    Google is the most widely used web search engine due to its user-friendly interface, accurate search results, and extensive database. It continuously updates its algorithms to provide the most relevant and reliable information to its users. Google's dominance in the search engine market is evident from its market share, which is significantly higher than its competitors like Yahoo and AOL. Additionally, Google offers various other services like Google Maps, Gmail, and Google Drive, making it a one-stop solution for users' web-related needs.

    Rate this question:

  • 28. 

    Mozilla firefox is a

    • A.

      Web server

    • B.

      Web browser

    • C.

      Web search engine

    • D.

      None of above

    Correct Answer
    B. Web browser
    Explanation
    Mozilla Firefox is a web browser that allows users to access and navigate the internet. It is a software application that retrieves and displays web pages, allowing users to interact with websites, view multimedia content, and browse the internet. As a web browser, Mozilla Firefox is designed to interpret and render HTML, CSS, and other web technologies, enabling users to access and consume online content.

    Rate this question:

  • 29. 

    Internet is a based on ___________ technology.

    • A.

      Local Area Network

    • B.

      Main Area Network

    • C.

      Wide Area Network

    • D.

      Campus Area Network

    Correct Answer
    C. Wide Area Network
    Explanation
    Internet is based on Wide Area Network (WAN) technology. A Wide Area Network is a network that covers a large geographical area, connecting multiple smaller networks together. The Internet is a global network of networks, connecting computers and devices from all around the world. It uses WAN technology to transmit data across long distances, allowing users to access information and communicate with each other. Therefore, the Internet is based on Wide Area Network technology.

    Rate this question:

  • 30. 

    Which option is used to block unwanted mails?

    • A.

      Pop up

    • B.

      Privacy

    • C.

      Filter

    • D.

      Delete

    Correct Answer
    C. Filter
    Explanation
    The correct answer is "Filter." Filters are commonly used to block unwanted emails by automatically sorting incoming messages based on certain criteria, such as sender, subject, or content. By setting up a filter, users can prevent unwanted emails from reaching their inbox, helping to reduce spam and improve email management.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Apr 03, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • May 24, 2010
    Quiz Created by
    Mohsin Khan
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.