M S Office And Internet
(118).webp "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. 60Explanation
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 menuExplanation
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 documentExplanation
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 correctExplanation
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. TrueExplanation
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 menuExplanation
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 touchpadExplanation
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. AttributesExplanation
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 BookExplanation
.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 cellExplanation
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 > commentExplanation
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. 120Explanation
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 cellsExplanation
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 cellsExplanation
"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 workbookExplanation
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 > CellsExplanation
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 specialExplanation
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 barExplanation
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. GoogleExplanation
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 browserExplanation
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 NetworkExplanation
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. FilterExplanation
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, 2024Quiz Edited by
ProProfs Editorial Team -
May 24, 2010Quiz Created by
Mohsin Khan
Back to top