Futureheights Training & Consultant Pvt. Ltd (Set-2)

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.

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.

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.

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.

The file type ".doc" indicates that the file is a Word document.

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.

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.

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.

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.

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.

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.

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.

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.

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.

The correct format for a signature is to include the name, designation, company address, phone number, and email id in that order.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.