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 Ramesh Ahuja's 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 features such as sorting, filtering, and creating charts that make it easy to manage and analyze large amounts of data. MS Word is primarily used for creating documents, while Outlook is an email and calendar application. None of these applications are designed specifically for data storage and analysis like MS Excel.
2.
Mention the shortcut key combinations used for navigating to the END column of the end row of the working worksheet
Correct Answer
B. CTRL + END
Explanation
The shortcut key combination CTRL + END is used to navigate to the end column of the last row of the working worksheet. This means that when you press CTRL + END, the cursor will move to the last cell containing data or formatting in the worksheet. This shortcut is helpful when you want to quickly jump to the end of a large worksheet without scrolling through all the rows and columns.
3.
Which symbol always comes before an Excel formula?
Correct Answer
B. =
Explanation
The symbol "=" always comes before an Excel formula. In Excel, the "=" sign is used to indicate that the following characters or expression is a formula and not a regular text entry. It is the starting point to enter any formula or calculation in Excel.
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 Excel and other spreadsheet programs, cells are identified by their column letter and row number. The letter "A" represents the first column, and the number "1" represents the first row. Therefore, the intersection of column A and row 1 is the first cell in the worksheet.
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
The correct answer is "All of above" because all three options mentioned (double clicking on the right border of column header, using the Autofit Selection option in the Format menu, and selecting the "Shrink to fit" checkbox in the Format Cells dialog box) are valid ways to automatically adjust the size of text in a cell if it does not fit in the width.
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 this formula correctly calculates the total price for each customer by summing the values in the Science, Maths, and Computers columns (C2, D2, and E2 respectively). By using the SUM function, the formula adds these three values together and displays the result 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 and displays it in column G.
8.
Click on the right option to freeze a column-
Correct Answer
A. View- freeze first column
Explanation
This option allows the user to freeze the first column in the current view. Freezing a column means that it will remain visible on the screen even when scrolling horizontally, providing easy access to important information in that column. This can be useful when working with large datasets or when comparing data across different columns.
9.
Merge cells option can be applied from
Correct Answer
A. Format Cells dialog box Alignment Tab
Explanation
The merge cells option can be applied from the Format Cells dialog box Alignment Tab. This option allows users to merge multiple cells into one cell, combining their content and formatting. By selecting the Alignment Tab in the Format Cells dialog box, users can access the merge cells option and apply it to the selected cells.
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 suggests that the long text can be broken down into multiple lines within a cell by using the "Wrap Text" feature in the "Format" menu under the "Cells" section. This feature allows the text to automatically wrap within the cell, making it easier to read and fit within the cell's dimensions. The other options mentioned, such as "Justify in Edit >> Cells" and "Text Wrapping in Format >> Cells, Layout tab," are not the correct ways to achieve text wrapping in this context.
11.
The file type _____ indicates the file is a Word document
Correct Answer
D. Both a & c
Explanation
The file type ".docx" and ".doc" both indicate that the file is a Word document. The ".docx" extension is used for Word documents created in Microsoft Word 2007 and later versions, while the ".doc" extension is used for Word documents created in earlier versions of Microsoft Word. Therefore, both extensions are valid indicators of a Word document. The ".wor" extension is not a recognized file type for Word documents, so it is not a correct answer.
12.
Using Find command in Word, we can search?
Correct Answer
D. All of the above
Explanation
Using the Find command in Word, we can search for various elements such as words, equations, and comments. The Find command allows users to locate specific content within a document, making it easier to navigate and edit large amounts of text. By selecting "All of the above" as the correct answer, it suggests that the Find command can be used to search for any of these elements in Word.
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 content will be displayed consistently on each page of the document.
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, such as Microsoft Word or Google Docs, typically contains options for formatting and editing text, including paragraph options such as alignment, indentation, and spacing. The Home menu is usually where users can find the tools and features related to the content and formatting of their document.
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. Pressing the Enter key creates a line break and moves the cursor to the next line, starting 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 used in MS-Word to apply Italic formatting to the selected text. This means that when this shortcut is used, the text will be displayed in a slanted or sloping manner, giving it emphasis and a different visual appearance compared to the surrounding text.
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 at the top or bottom of each page. It enhances the professionalism and readability of the document by providing consistent and organized information throughout. Additionally, headers and footers also help in marking the starting of a new page and making large documents more readable by providing visual cues and navigation aids.
18.
Which is the correct keyboard short cut for line Spacing
Correct Answer
A. CTRL + 1
Explanation
The correct keyboard shortcut for line spacing is CTRL + 1. This shortcut is commonly used in word processing programs to set the line spacing to single spacing. It is a quick and efficient way to adjust the spacing between lines in a 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 feature in the Insert menu that specifically allows you to insert page numbers. Option b, "Footnote from Insert menu", may seem unrelated to page numbers at first, but footnotes can also be used to insert page numbers at the bottom of each page. Therefore, both options a and b provide a way to insert page numbers in a document.
20.
Which is the correct keyboard shortcut for Paste
Correct Answer
C. CTRL + V
Explanation
The correct keyboard shortcut for Paste is CTRL + V. This shortcut is commonly used to paste copied or cut content into a document or application. By pressing CTRL + V, the content that was previously copied or cut is inserted at the current cursor position. This shortcut is widely recognized and used across various operating systems and software applications.
21.
Before Sending email I should,
Correct Answer
D. All of the above
Explanation
Before sending an email, it is important to ensure that it is error-free and conveys the intended message effectively. Reading the email twice helps in identifying any grammatical or typographical errors. Checking the spellings ensures that the content is accurate and professional. Verifying the subject line is crucial as it gives recipients a clear idea of the email's purpose. Therefore, all of the given options are necessary steps to take before sending an email.
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 show professionalism, efficiency, and respect for the sender's time. Delayed responses can lead to misunderstandings, missed opportunities, and a negative impression. By replying promptly, you demonstrate that you value effective communication and prioritize the sender's needs.
23.
Why shouldn’t I type emails in all CAPS?
Correct Answer
D. All of the above
Explanation
Typing emails in all capital letters is considered inappropriate because it can convey different negative impressions. Firstly, it can make you look lazy as it appears that you are not taking the time to properly format your message. Secondly, using all caps can be seen as arrogant because it can give the impression that you believe your message is more important than others. Lastly, typing in all caps is often associated with yelling or shouting, which can come across as aggressive or disrespectful. Therefore, all of the given reasons are valid explanations for 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 will attach 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 know who the email is from without you having to explicitly sign it every time.
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 spell checking, using full sentence structure, and proper grammar. Additionally, having a nice greeting such as "Hi" or "Hello" helps to establish a friendly tone. Lastly, including a signature provides essential contact information. Therefore, all of the options mentioned are important and should be done with every 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 typically allows you to insert various elements into a document or file, such as images, tables, or in this case, attachments. By selecting "insert," you can browse your files and choose the one you want to attach to the document.
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. This ensures that the relevant individuals receive the information they require to perform their duties or make informed decisions. Copying unnecessary recipients can lead to confusion, overload their inboxes, and compromise the confidentiality of the message. By limiting the recipients to only those who need to be informed, the communication process becomes more efficient and effective.
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 start with the name, followed by the designation, company address, phone number, and email id.
29.
Which application is used for sending an email-
Correct Answer
B. Outlook
Explanation
Outlook is the correct answer because it is an email client application that is specifically designed for sending, receiving, and managing emails. Unlike MS Word, Excel, and Powerpoint, which are primarily used for creating documents, spreadsheets, and presentations respectively, Outlook is dedicated to email communication. It provides features like organizing emails, creating folders, managing contacts, scheduling meetings, and integrating with other applications, making it a popular choice for sending emails.
30.
Netiquette suggests a business email should be replied within a business day.
Correct Answer
A. Correct
Explanation
Netiquette is a set of guidelines for online communication, including email etiquette. It suggests that in a business setting, it is appropriate to reply to a business email within a business day. This ensures timely communication and professionalism. Therefore, the correct answer is "Correct."
31.
What is intranet?
Correct Answer
C. Interconnection of local area networks
Explanation
An intranet refers to the interconnection of local area networks (LANs). It is a private network that allows the sharing of information, resources, and services within an organization. It is not a single network but rather a network of networks, connecting multiple LANs within an organization. This interconnection enables efficient communication, collaboration, and access to shared resources among employees or members of the organization.
32.
Software which allows user to view the webpage is called ___
Correct Answer
C. Internet browser
Explanation
An internet browser is a software that allows users to view webpages. It is specifically designed to access and display information on the internet. Unlike an operating system (OS) which manages computer hardware and software resources, or a website which is a collection of webpages hosted on a server, an internet browser acts as a user interface for accessing and navigating the internet. Therefore, an internet browser is the correct answer for the given question.
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 standard format for a website address. It starts with "www." which stands for World Wide Web, followed by the domain name "pineapple" and ends with a valid top-level domain ".com".
34.
What happens if we press + L
Correct Answer
A. Lock your workstation
Explanation
If we press "+ L", it will lock our workstation. This keyboard shortcut is commonly used to quickly lock the computer screen and prevent unauthorized access. It is a security feature that is especially useful when stepping away from the computer temporarily.
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". This is the page that typically serves as the entry point for users and provides an overview of the website's content and navigation options. It is called the home page because it is often the first page that users see when they visit a website, similar to how a home is the starting point for a person when they enter a house. The terms "backend page" and "start page" are not commonly used to describe the main page of a website.
36.
What is the full form of CPU?
Correct Answer
B. Central Processing Unit
Explanation
The correct answer is "Central Processing Unit". CPU stands for Central Processing Unit, which is the primary component of a computer that carries out instructions of a computer program by performing basic arithmetic, logical, control, and input/output operations. It is often referred to as the "brain" of the computer as it is responsible for executing most of the tasks and calculations within the system.
37.
What happens if we press + M
Correct Answer
D. It minimizes all the application/software running
Explanation
Pressing the combination of the "+" key and the "M" key on the keyboard minimizes all the application/software currently running. This means that all the open windows and programs will be hidden from view, allowing the user to quickly access the desktop or switch to other tasks without closing or exiting any of the applications.
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. Internet Explorer, Mozilla, and Google Chrome are all web browsers that allow users to access and view websites on the internet.
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 applications developed by Microsoft, including software like Word, Excel, and PowerPoint. While operating systems like Windows 7, Linux, and Macintosh provide the foundation for running computer programs, MS Office is a collection of programs that run on top of an operating system.
40.
Which is new release of Microsoft for Operating System?
Correct Answer
A. Windows 8.1
Explanation
Windows 8.1 is the correct answer as 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.