1.
Ramesh Ahuja wants to store data of his monthly visits to schools over the last financial year. Which of the Office application is most suitable for this purpose?
Correct Answer
C. MS Excel
Explanation
MS Excel is the most suitable Office application for storing data of monthly visits to schools over the last financial year. MS Excel is a spreadsheet program that allows users to organize, manipulate, and analyze large amounts of data in a tabular format. It provides features like sorting, filtering, and creating formulas, which can be useful for managing and analyzing data related to monthly visits to schools. MS Word is more suitable for word processing tasks, while Outlook is an email and calendar management program. None of the above options are specifically designed for data storage and analysis like MS Excel.
2.
Mention the shortcut key combinations used for navigating to the top of the worksheet
Correct Answer
A. CTRL + HOME
Explanation
The shortcut key combination CTRL + HOME is used to navigate to the top of the worksheet. This means that when you press these keys together, the cursor will move to cell A1, which is the first cell in the worksheet. This shortcut is useful for quickly returning to the beginning of the worksheet, especially when working with large datasets or when you want to start from the top after scrolling down.
3.
Which symbol always comes before an Excel formula?
Correct Answer
B. =
Explanation
In Excel, the symbol "=" always comes before a formula. This is because the "=" sign is used to indicate that what follows is a formula and not a regular text or value. It tells Excel to evaluate the expression and perform the necessary calculations. Without the "=" sign, Excel would treat the input as plain text or a value rather than a formula. Therefore, the "=" sign is essential in Excel to initiate and distinguish formulas from other data.
4.
Address of first cell in a worksheet is
Correct Answer
A. A1
Explanation
The address of the first cell in a worksheet is A1. This is because in most spreadsheet software, such as Microsoft Excel, the cells are organized in a grid-like structure with columns labeled alphabetically (A, B, C, etc.) and rows labeled numerically (1, 2, 3, etc.). Therefore, the first cell is located at the intersection of column A and row 1, making its address A1.
5.
You can automatically adjust the size of text in a cell if they do not fit in width by
Correct Answer
D. All of above
Explanation
All of the options mentioned above are correct ways to automatically adjust the size of text in a cell if they do not fit in width. Double clicking on the right border of the column header, selecting Autofit Selection from the Format menu, and marking the Shrink to fit checkbox in the Format Cells dialog box are all valid methods to achieve this.
6.
Based on the spreadsheet given below answers the below Questions - Formula for calculating the Total Price as sum of Science, Maths & Computers for each Customer and display them in column F-
Correct Answer
C. =SUM(C2+D2+E2)
Explanation
The correct answer is =SUM(C2+D2+E2) because it accurately calculates the total price for each customer by summing the values in the Science, Maths, and Computers columns (C2, D2, and E2 respectively). This formula adds up the individual subject prices for each customer and gives the total price in column F.
7.
Based on the spreadsheet given below answers the below Questions - Formula for calculating the Discount @ 5% for each customer and display them in column G
Correct Answer
B. =F2* 5% and then drag
Explanation
The correct answer is "=F2* 5% and then drag". This formula calculates the discount at 5% for each customer in column F and displays the result in column G. The formula multiplies the value in cell F2 by 5% to calculate the discount amount, and then dragging the formula downwards applies the same calculation to all the cells in column F.
8.
Click on the right option to freeze a column-
Correct Answer
A. View- freeze first column
Explanation
To freeze a column in a spreadsheet, you need to click on the "View" option. Within the "View" menu, there is an option to freeze the first column. This means that the first column will remain in place while you scroll through the rest of the spreadsheet, allowing you to always see the data in that column. The other options mentioned, such as "Data," "Insert," and "Home," do not have a specific option to freeze a column.
9.
Merge cells option can be applied from
Correct Answer
A. Format Cells dialog box Alignment Tab
Explanation
The correct answer is "Format Cells dialog box Alignment Tab". This option allows users to merge cells in a spreadsheet. By selecting the Alignment tab in the Format Cells dialog box, users can access the merge cells option and apply it to their selected cells. The merge cells option combines multiple cells into a single cell, which can be useful for creating headers, labels, or organizing data in a more visually appealing way.
10.
Long text can be broken down into many lines within a cell. You can do this through
Correct Answer
A. Wrap Text in Format >> Cells
Explanation
The correct answer is "Wrap Text in Format >> Cells". This option is the most specific and accurate explanation for how to break down long text into multiple lines within a cell. The other options mentioned, such as "Justify in Edit >> Cells" and "Text Wrapping in Format >> Cells, Layout tab", do not explicitly mention the action of wrapping text, which is the key feature being described in the question. Therefore, "Wrap Text in Format >> Cells" is the most appropriate answer.
11.
The file type _____ indicates the file is a Word document
Correct Answer
D. .doc
Explanation
The file type ".doc" indicates that the file is a Word document.
12.
Using Find command in Word, we can search?
Correct Answer
A. Word
Explanation
The correct answer is "Word" because the question is asking what we can search using the Find command in Word. The Find command in Word allows users to search for specific words or phrases within a document. Therefore, the correct answer is "Word" as it is the application in which the Find command is being used.
13.
By default, on which page the header or the footer is printed?
Correct Answer
C. On every page
Explanation
The header or footer is printed on every page by default. This means that the header or footer will appear at the top or bottom of each page in a document or a website.
14.
Which menu/Ribbon shows paragraph option-​
Correct Answer
A. Home
Explanation
The correct answer is Home because the Home menu or Ribbon in most software applications, including word processors like Microsoft Word, typically contains options related to formatting and editing text, such as font styles, alignment, and paragraph settings. Therefore, it is likely that the paragraph option would be found in the Home menu or Ribbon.
15.
Which key should be pressed to start a new paragraph in MS-Word?
Correct Answer
B. Enter Key
Explanation
The Enter key should be pressed to start a new paragraph in MS-Word. When the Enter key is pressed, the cursor moves to a new line, creating a new paragraph. This allows for proper formatting and organization of text in a document.
16.
What is the function of Ctrl + I in Ms-Word
Correct Answer
D. It applies Italic formatting to the selected text
Explanation
Ctrl + I is a keyboard shortcut in MS-Word that applies italic formatting to the selected text. It is a quick way to emphasize or highlight specific words or phrases in a document.
17.
Why headers and footers used in MS –Word
Correct Answer
D. To allow page headers and footers to appear on document when it is printed
Explanation
Headers and footers are used in MS Word to allow page headers and footers to appear on the document when it is printed. This feature helps in providing important information such as page numbers, document title, author name, and date on every page. It enhances the professionalism and readability of the document. Additionally, headers and footers can also be utilized to mark the starting of a page and make large documents more organized and easier to navigate.
18.
Which menu/Ribbon in MSWord can be used to insert Watermark?
Correct Answer
B. Page layout
Explanation
The Page Layout menu/ribbon in MS Word can be used to insert a watermark. This menu/ribbon contains various options related to the layout of the document, including features like margins, orientation, and watermarks. By selecting the Page Layout menu/ribbon, users can access the Watermark option and insert a watermark into their document.
19.
There can be many ways to insert page number in a document. Which of the following lets you insert page number
Correct Answer
D. Both a & b
Explanation
Both option a and option b allow you to insert page numbers in a document. Option a, "Page number from Insert menu," refers to the specific feature in the Insert menu that allows you to insert page numbers directly. Option b, "Footnote from Insert menu," may seem unrelated, but footnotes often include page numbers, so inserting a footnote can indirectly insert page numbers as well. Therefore, both options a and b provide ways to insert page numbers in a document.
20.
Which is the correct keyboard shortcut for CUT
Correct Answer
D. CTRL + X
Explanation
The correct keyboard shortcut for CUT is CTRL + X. This shortcut is commonly used to cut or remove selected text or objects from a document or file. Once the text or object is cut, it can be pasted elsewhere using the CTRL + V shortcut.
21.
Before Sending email I should,
Correct Answer
D. All of the above
Explanation
Before sending an email, it is important to ensure that the content is error-free and professional. Reading the mail twice helps in identifying any mistakes or errors that may have been overlooked initially. Checking the spellings ensures that the message is clear and free from any spelling errors. Similarly, checking the subject of the email is crucial as it provides a concise summary of the email's content. Therefore, all of the mentioned actions should be taken before sending an email to ensure its accuracy and professionalism.
22.
How Quickly Should I reply to an email?
Correct Answer
A. As soon as I can
Explanation
It is important to reply to an email as soon as possible because timely responses demonstrate professionalism, efficiency, and respect for the sender's time. Delaying a response may lead to misunderstandings, missed opportunities, or the perception of being uninterested or unengaged. Additionally, prompt replies help maintain effective communication and build trust with the sender. Therefore, replying as soon as one can is the best practice.
23.
Why shouldn’t I type emails in all CAPS?
Correct Answer
D. All of the above
Explanation
Typing emails in all caps can give the impression that the sender is lazy because it may seem like they are not putting in the effort to type properly. It can also be seen as arrogant because it can be interpreted as the sender thinking that their message is more important than others. Additionally, typing in all caps is often associated with yelling or shouting, which can come across as aggressive or rude. Therefore, all of the given options are valid reasons why one should not type emails in all caps.
24.
If you don't want to type your name at the end of every email you send, what you can you do instead?
Correct Answer
C. Create a signature that will attach to every email you send
Explanation
By creating a signature that attaches to every email you send, you can avoid the need to manually type your name at the end of each email. This signature can include your name, contact information, and any other relevant details you want to include. It provides a professional touch to your emails and saves you time and effort in signing each email individually.
25.
What is the most important thing I should do with every e-mail?
Correct Answer
D. All of the above
Explanation
The most important thing to do with every email is to ensure that it is error-free by using spell check, full sentence structure, and proper grammar. Additionally, it is important to have a nice greeting, such as "Hi" or "Hello," to create a friendly tone. Lastly, including a signature at the end of the email provides important contact information and adds a professional touch. Therefore, all of the options mentioned are equally important in creating a well-crafted and effective email.
26.
To attach a file what do you click on?
Correct Answer
B. Insert
Explanation
To attach a file, you click on the "insert" option. This option allows you to insert various elements into a document or file, including images, tables, and in this case, attachments. By selecting "insert," you can browse your computer or device for the desired file and add it to the document or email you are working on.
27.
When sending a message, you should copy ("cc"):
Correct Answer
B. Only those people who need to know
Explanation
When sending a message, it is important to copy only those people who need to know. Including unnecessary recipients can lead to confusion and overload their inboxes. Copying your boss and his boss ensures that the relevant higher-ups are kept in the loop. However, including the whole world or family members is unnecessary and can compromise the privacy and confidentiality of the message.
28.
Which is the correct format for a signature
Correct Answer
A. Name| designation| company address | pHone number| email id
Explanation
The correct format for a signature is to include the name, designation, company address, phone number, and email id in that order.
29.
Which application is used for sending an email-
Correct Answer
B. Outlook
Explanation
Outlook is the correct answer because it is an application specifically designed for sending and receiving emails. MS Word, Excel, and Powerpoint are not primarily used for email communication, but rather for creating documents, spreadsheets, and presentations respectively. Outlook, on the other hand, is a comprehensive email client that allows users to manage their emails, contacts, calendars, and tasks efficiently.
30.
Netiquette suggests a business email should be replied within a business day.
Correct Answer
A. Correct
Explanation
Netiquette refers to the set of rules and guidelines for appropriate online behavior. In the context of a business email, it is considered good netiquette to reply within a business day. This shows professionalism, respect, and a prompt response to the sender's inquiry or request. It helps to maintain effective communication and build strong business relationships. Therefore, the correct answer is that a business email should be replied within a business day.
31.
What is internet?
Correct Answer
B. A vast collection of different networks
Explanation
The correct answer is "a vast collection of different networks." This is because the internet is not just a single network, but rather a global network of interconnected networks. It is made up of numerous different networks, ranging from local area networks to wide area networks, all connected together to allow for the exchange of information and communication across the world.
32.
Software which allows user to view the webpage is called ___
Correct Answer
C. Internet browser
Explanation
An internet browser is a software application that allows users to view webpages. It is designed to interpret and display HTML files, images, and other resources on the internet. With an internet browser, users can navigate through different websites, access web-based applications, and interact with various online content. It acts as a gateway for users to access information and services on the World Wide Web.
33.
Which of the follow is a valid website address?
Correct Answer
D. Www.pineapple.com
Explanation
The correct answer is www.pineapple.com because it follows the correct format for a website address. It begins with "www", followed by a period, and then the domain name "pineapple" which is followed by the top-level domain "com". This format is commonly used for website addresses and is recognized as a valid website address.
34.
What is the full form of ROM?
Correct Answer
C. Read Only Memory
Explanation
ROM stands for Read Only Memory. It is a type of computer memory that stores data permanently and cannot be modified or erased. The data stored in ROM is non-volatile, meaning it is retained even when the computer is powered off. ROM is commonly used to store firmware, system software, and other essential instructions that are required for the computer to boot up and function properly. Unlike Random Access Memory (RAM), which is temporary and volatile, ROM provides long-term storage for important data that should not be altered.
35.
When you open a website main page is called as _____
Correct Answer
A. Home page
Explanation
The main page of a website is commonly referred to as the "home page". It is the initial page that users see when they visit a website and often serves as an introduction or overview of the website's content and purpose. The home page typically includes navigation menus, featured content, and links to other pages within the website. It is designed to provide a user-friendly and visually appealing entry point for visitors.
36.
Keyboard short cut for refreshing computer
Correct Answer
A. F5
Explanation
Pressing the F5 key on a computer keyboard is a common shortcut for refreshing a webpage or document. This key is typically used in web browsers to reload the current page, ensuring that the latest version is displayed. It can also be used in other applications to refresh or update the content. Therefore, F5 is the correct answer for the keyboard shortcut to refresh a computer.
37.
What happens if we press + E
Correct Answer
B. It opens my computer.
Explanation
Pressing the keys "+ E" simultaneously opens the "My Computer" window. This window displays all the drives and devices connected to the computer, allowing users to easily access and manage their files and folders.
38.
Which is not a browser?
Correct Answer
D. MS Excel
Explanation
MS Excel is not a browser. It is a spreadsheet program developed by Microsoft and is used for creating, organizing, and analyzing data. Unlike the other options listed, MS Excel is not designed for browsing the internet or accessing websites.
39.
Which is not an Operating System?
Correct Answer
A. MS office
Explanation
MS Office is not an operating system. It is a suite of productivity software that includes applications like Word, Excel, and PowerPoint. An operating system, on the other hand, is a software that manages computer hardware and software resources and provides common services for computer programs. Windows 7, Linux, and Macintosh are all operating systems.
40.
Which is new release of Microsoft for Operating System?
Correct Answer
A. Windows 8.1
Explanation
Windows 8.1 is the correct answer because it is a newer release of Microsoft's operating system compared to Windows 8 and Windows 7. Windows 8.2 is not a valid option as it does not exist.