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, 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.
2.
Mention the shortcut key combinations used for navigating to the END column of end row of the working worksheet
Correct Answer
B. CTRL + END
Explanation
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.
3.
Which symbol always comes before an Excel formula?
Correct Answer
B. =
Explanation
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.
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, 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.
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 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.
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 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.
7.
Based on the spreadsheet given below answers the below Questions - Formula for calculating the Discount @ 6% for each customer and display them in column G
Correct Answer
B. =F2* 6% and then drag
Explanation
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.
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, 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.
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 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.
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 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.
11.
The file type _____ indicates the file is a Word document
Correct Answer
D. Both a & c
Explanation
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.
12.
Using Find command in Word, we can search?
Correct Answer
D. All of the above
Explanation
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.
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 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.
14.
Which menu/Ribbon shows paragraph option-​
Correct Answer
A. Home
Explanation
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.
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 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.
16.
What is the function of Ctrl + U in Ms-Word
Correct Answer
B. It Underlines the selected text
Explanation
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.
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 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.
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 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.
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. 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.
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 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.
21.
Before Sending email I should,
Correct Answer
D. All of the above
Explanation
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.
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 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.
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 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.
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 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.
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 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.
26.
To attach a file what do you click on?
Correct Answer
B. Insert
Explanation
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.
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 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.
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 "Name| designation| company address | Phone number| email id". This format includes all the necessary information in a professional manner.
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 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.
30.
Netiquette suggests a business email should be replied within a business day.
Correct Answer
A. Correct
Explanation
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.
31.
What is intranet?
Correct Answer
C. Interconnection of local area networks
Explanation
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.
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 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.
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, 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).
34.
What happens if we press + L
Correct Answer
A. Lock your workstation
Explanation
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."
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 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."
36.
What is the full form of CPU?
Correct Answer
B. Central Processing Unit
Explanation
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.
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 running.
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 browsers such as Internet Explorer, Mozilla, and Google Chrome, MS Excel is not designed for browsing the internet or accessing web pages.
39.
Which is not an Operating System?
Correct Answer
A. MS office
Explanation
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.
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 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.