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

The symbol that always comes before an Excel formula is the equal sign (=). This is because the equal sign is used to indicate that the following characters are part of a formula and not just regular text. It tells Excel to evaluate the expression and perform the necessary calculations. Without the equal sign, Excel would treat the characters as plain text and not as a formula.

Ctrl + U is a keyboard shortcut in MS-Word that underlines the selected text. This formatting option is commonly used to emphasize or highlight important information in a document.

The main page of a website is commonly referred to as the "home page." It is the initial page that is displayed when a user visits a website and typically provides an overview of the website's content and navigation options. The term "backend page" refers to the administrative section of a website that is not visible to regular users. "Start page" is not a commonly used term in web design and development. Therefore, the correct answer is "Home page."

The correct answer is Central Processing Unit. The CPU, or Central Processing Unit, is the primary component of a computer that performs most of the processing inside the computer. It is often referred to as the "brain" of the computer as it carries out instructions of a computer program by performing basic arithmetic, logical, control, and input/output (I/O) operations. The CPU is responsible for executing instructions, managing data storage, and controlling the flow of information within a computer system.

The correct answer is =SUM(C2+D2+E2) because it correctly calculates the total price by summing the values in cells C2, D2, and E2. The other formulas either include incorrect cell references or do not sum the correct cells.

The Enter key should be pressed to start a new paragraph in MS-Word. When the Enter key is pressed, the cursor moves to the next line, creating a new paragraph. This allows for better organization and readability of the document. The other options mentioned, such as the Down Cursor Key, Shift + Enter, and Ctrl + Enter, do not have the same function of starting a new paragraph in MS-Word.

The correct keyboard shortcut for Paste is CTRL + V. This combination is widely used across different operating systems and applications to paste copied or cut content into a document or field. By pressing CTRL + V, the content stored in the clipboard is inserted at the current cursor location.

MS Excel is not a browser. It is a spreadsheet program developed by Microsoft and is used for creating, organizing, and analyzing data. Unlike browsers such as Internet Explorer, Mozilla, and Google Chrome, MS Excel is not designed for browsing the internet or accessing web pages.

Pressing "+ L" on a computer keyboard is a shortcut command that locks the workstation. This means that the user's current session will be secured, and they will need to enter their password to regain access. Locking the workstation is a security measure that helps protect sensitive information and prevent unauthorized access when the user is away from their computer. Therefore, the correct answer is "Lock your workstation."

The correct format for a signature is "Name| designation| company address | Phone number| email id". This format includes all the necessary information in a professional manner.

Outlook is the correct answer because it is an email client application developed by Microsoft. It allows users to send, receive, and manage their emails. Unlike MS Word, Excel, and Powerpoint, which are primarily used for creating documents, spreadsheets, and presentations respectively, Outlook specifically focuses on email communication and provides features such as organizing emails, creating folders, scheduling meetings, and managing contacts.

MS Office is not an operating system, but rather a suite of productivity software applications developed by Microsoft. It includes programs such as Word, Excel, and PowerPoint, which are used for creating documents, spreadsheets, and presentations. On the other hand, Windows 7, Linux, and Macintosh are all examples of operating systems that provide the fundamental software infrastructure and control the computer's hardware resources.

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, analyze, and manipulate data in a tabular format. It provides various features such as creating tables, sorting and filtering data, performing calculations, and generating charts and graphs. These features make it ideal for managing and tracking data related to monthly visits, such as recording dates, schools visited, and any other relevant information. MS Word is primarily used for word processing, while Outlook is an email and personal information management program.

The correct answer is "All of the above" because before sending an email, it is important to read the email twice to ensure that there are no errors or mistakes. Checking the spellings is essential to avoid any typos or misspellings in the email. Additionally, checking the subject is necessary to ensure that it accurately reflects the content of the email and is appropriate for the recipient. Therefore, all of these actions should be taken before sending an email.

It is important to reply to an email as soon as possible because timely responses show professionalism and respect for the sender's time. Delaying a response could lead to misunderstandings or missed opportunities. Additionally, prompt replies help maintain effective communication and build strong relationships with colleagues, clients, or business partners.

Typing emails in all caps can give the impression that the sender is lazy because it is often associated with lack of effort or attention to detail. Additionally, it can be seen as arrogant because it can come across as if the sender believes their message is more important than others. Lastly, typing in all caps is often interpreted as yelling, which can be perceived as aggressive or rude in written communication. Therefore, all of the given options are valid reasons for why one should not type emails in all caps.

The address of the first cell in a worksheet is A1. This is because in Excel, the columns are labeled alphabetically starting from A, and the rows are numbered starting from 1. Therefore, the first cell is at the intersection of column A and row 1, which is denoted as A1.

The correct keyboard shortcut for line spacing is CTRL + 1. This shortcut is commonly used in word processing applications to set the line spacing to single spacing. By pressing CTRL + 1, the user can quickly adjust the spacing between lines in their document to a standard single line spacing.

When sending a message, it is important to copy only those people who need to know. This ensures that the information is shared with the relevant individuals who require it for their work or decision-making. Copying unnecessary recipients can lead to confusion, overload of information, and potential breaches of confidentiality. Therefore, it is best practice to be selective and include only those individuals who are directly involved or have a need to be aware of the message.

The correct answer is www.pineapple.com because it follows the standard format for a website address, which includes the "www" prefix, a valid domain name (pineapple), and a valid top-level domain (.com). The other options are not valid website addresses because they either contain incorrect characters (such as ".." or "_") or use an invalid domain name (gmail).

The shortcut key combination CTRL + END is used for navigating to the last cell of the last row in the working worksheet. This allows the user to quickly jump to the end of the data without scrolling or manually navigating through the spreadsheet. It is a convenient shortcut for efficient navigation in large worksheets.

To freeze a column in a spreadsheet, the correct option is "View - freeze first column". This option allows the user to keep the first column of the spreadsheet visible while scrolling horizontally. This can be useful when working with large datasets or when the first column contains important information that needs to be constantly visible. By selecting this option, the user can ensure that the first column remains fixed in its position while navigating through the rest of the spreadsheet.

Pressing the combination of the "+" key and the "M" key on the keyboard minimizes all the application/software running.

The correct answer is "Correct" because netiquette, which refers to the set of rules and guidelines for online communication, recommends that a business email should be replied to within a business day. This means that it is considered good practice and polite to respond to business emails within a reasonable timeframe to maintain professional communication and avoid leaving the sender waiting for a response.

The correct answer is Home. The Home menu/ribbon in most word processing software usually contains options related to formatting and editing text, including paragraph options such as alignment, indentation, spacing, and bullet points. Therefore, it is the most likely menu/ribbon to have the paragraph option.

To attach a file, you would click on the "insert" option. This option typically allows you to insert various types of content into a document or email, including files. Clicking on "insert" would provide you with the necessary options and tools to attach a file to your document or email.

The correct answer is "Wrap Text in Format >> Cells". This option is the most specific and accurate explanation for breaking 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," are not as precise or relevant to the given question.

By creating a signature that attaches to every email you send, you can avoid the need to manually sign 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. This way, recipients will automatically see your signature at the end of the email, saving you time and effort.

The correct answer is "=F2* 6% and then drag". This formula calculates the discount at 6% for each customer and displays it in column G. The formula multiplies the value in cell F2 by 6% to calculate the discount. By dragging the formula down, it automatically applies the same calculation to the rest of the cells in column G for each customer.

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 adds a professional touch. Therefore, all of the options mentioned are equally important in order to make a good impression and communicate effectively through email.

An internet browser is a software application that allows users to view webpages. It is specifically designed to access and display websites, providing a graphical interface for users to navigate through different webpages, view content, and interact with websites. Unlike an operating system (OS), which manages computer hardware and software resources, an internet browser is solely focused on facilitating web browsing and accessing online content. Therefore, the correct answer is internet browser.

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 every page of a document or a website. It provides consistent information or navigation options throughout the entire document or website, making it easier for the reader to navigate or identify the content.

The correct answer is "both a & c". The file types .docx and .doc indicate that the file is a Word document. The .docx file type is the newer version of Word documents, while the .doc file type is the older version. Both of these file types are used to indicate that the file is a Word document. The .wor file type mentioned in option b is not a valid file type for Word documents, so it is not included in the correct answer.

Windows 8.1 is the correct answer because it is a new release of Microsoft for an operating system. It is an updated version of Windows 8, which includes various improvements and additional features compared to its predecessor. Windows 8.2 and Windows 7 are not the latest releases, making them incorrect options.

Both option "a" and option "b" allow you to insert page numbers in a document. The "Insert" menu typically provides options for adding elements such as page numbers, headers, and footers to a document. Option "a" refers to inserting page numbers directly from the "Insert" menu, while option "b" refers to inserting page numbers through the use of footnotes, which can also be found in the "Insert" menu. Therefore, both options allow you to insert page numbers in a document.

Headers and footers are used in MS Word to allow important information or elements to appear consistently at the top and bottom of each page when the document is printed. This helps in providing context, such as page numbers, document title, author name, etc., and ensures that the document is properly organized and professional-looking. By including headers and footers, the document becomes more visually appealing and easier to navigate, making it more readable for the readers.

The Find command in Word allows users to search for specific words, phrases, or formatting in a document. It can be used to search for words in the main body of the document (Word), equations within the document (Equation), or comments that have been added to the document (Comment). Therefore, the correct answer is "All of the above" as the Find command can be used to search in Word, equations, and comments.

All of the given options can be used 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 will automatically adjust the width of the column to fit the text. Choosing the "Autofit Selection" option from the Format menu will also adjust the column width to fit the text. Additionally, marking the "Shrink to fit" checkbox in the Format Cells dialog box will shrink the text to fit within the cell if it is too wide. Therefore, all of the given options are correct.

Intranet refers to the interconnection of local area networks. It is a private network that is limited to a specific organization or company. It allows for the sharing of information, resources, and communication within the organization. Unlike the internet, which is a vast collection of different networks, an intranet is restricted to a single organization. Therefore, the correct answer is the interconnection of local area networks.

The merge cells option can be applied from the Format Cells dialog box Alignment Tab. This tab allows users to customize the alignment of cell contents, including merging cells. The Formatting toolbar does not have a specific option for merging cells. Therefore, the correct answer is the Format Cells dialog box Alignment Tab.