Futureheights Training & Consultant Pvt. Ltd (Set-2)
.PNG "Futureheights Training & Consultant Pvt. Ltd (Set-2) - Quiz")
Questions and Answers
- 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?
- A.
MS word
- B.
Outlook
- C.
MS Excel
- D.
None of the above
Correct Answer
C. MS ExcelExplanation
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.Rate this question:
-
- 2.
Mention the shortcut key combinations used for navigating to the top of the worksheet
- A.
CTRL + HOME
- B.
CTRL + END
- C.
ALT + HOME
- D.
ALT + END
Correct Answer
A. CTRL + HOMEExplanation
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.Rate this question:
-
- 3.
Which symbol always comes before an Excel formula?
- A.
,
- B.
=
- C.
-
- D.
%
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.Rate this question:
-
- 4.
Address of first cell in a worksheet is
- A.
A1
- B.
1
- C.
1A
- D.
None of the above
Correct Answer
A. A1Explanation
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.Rate this question:
-
- 5.
You can automatically adjust the size of text in a cell if they do not fit in width by
- A.
Double clicking on the right border of column header
- B.
From Format choose Columns and then Autofit Selection
- C.
From Format Cells dialog box mark Shrink to fit check box
- D.
All of above
Correct Answer
D. All of aboveExplanation
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.Rate this question:
-
- 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-
- A.
=SUM(A2+B2+C2+D2)
- B.
=SUM(A1:E2)
- C.
=SUM(C2+D2+E2)
- D.
SUM(C2+D1+E2)
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.Rate this question:
- 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
- A.
F2/ 5% and then drag
- B.
=F2* 5% and then drag
- C.
=G2*5% and then drag
- D.
–AVG(C1:D1)
Correct Answer
B. =F2* 5% and then dragExplanation
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.Rate this question:
- 8.
Click on the right option to freeze a column-
- A.
View- freeze first column
- B.
Data- freeze column
- C.
Insert- freeze
- D.
Home – freeze
Correct Answer
A. View- freeze first columnExplanation
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.Rate this question:
-
- 9.
Merge cells option can be applied from
- A.
Format Cells dialog box Alignment Tab
- B.
Formatting toolbar
- C.
Both of above
- D.
None of above
Correct Answer
A. Format Cells dialog box Alignment TabExplanation
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.Rate this question:
-
- 10.
Long text can be broken down into many lines within a cell. You can do this through
- A.
Wrap Text in Format >> Cells
- B.
Justify in Edit >> Cells
- C.
Text Wraping in Format >> Cells, Layout tab
- D.
All of above
Correct Answer
A. Wrap Text in Format >> CellsExplanation
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.Rate this question:
-
- 11.
The file type _____ indicates the file is a Word document
- A.
.msw
- B.
.wor
- C.
.wrd
- D.
.doc
Correct Answer
D. .docExplanation
The file type ".doc" indicates that the file is a Word document.Rate this question:
-
- 12.
Using Find command in Word, we can search?
- A.
Word
- B.
Formats
- C.
Story
- D.
All of the above
Correct Answer
A. WordExplanation
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.Rate this question:
-
- 13.
By default, on which page the header or the footer is printed?
- A.
on first page
- B.
On alternate page
- C.
On every page
- D.
None of the above
Correct Answer
C. On every pageExplanation
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.Rate this question:
-
- 14.
Which menu/Ribbon shows paragraph option-
- A.
Home
- B.
View
- C.
Page layout
- D.
None of the above
Correct Answer
A. HomeExplanation
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.Rate this question:
-
- 15.
Which key should be pressed to start a new paragraph in MS-Word?
- A.
Down Cursor Key
- B.
Enter Key
- C.
Shift + Enter
- D.
Ctrl + Enter
Correct Answer
B. Enter KeyExplanation
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.Rate this question:
-
- 16.
What is the function of Ctrl + I in Ms-Word
- A.
It converts selected text into the next larger size of the same font
- B.
It adds a line break to the document
- C.
It makes the selected text bold
- D.
It applies Italic formatting to the selected text
Correct Answer
D. It applies Italic formatting to the selected textExplanation
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.Rate this question:
-
- 17.
Why headers and footers used in MS –Word
- A.
To enhance the overall appearance of the document
- B.
To mark the starting of a page
- C.
To make large document more readable
- D.
To allow page headers and footers to appear on document when it is printed
Correct Answer
D. To allow page headers and footers to appear on document when it is printedExplanation
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.Rate this question:
-
- 18.
Which menu/Ribbon in MSWord can be used to insert Watermark?
- A.
Insert
- B.
Page layout
- C.
Format
- D.
Data
Correct Answer
B. Page layoutExplanation
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.Rate this question:
-
- 19.
There can be many ways to insert page number in a document. Which of the following lets you insert page number
- A.
Page number from Insert menu
- B.
Footnote from Insert menu
- C.
Page Setup from file menu
- D.
Both a & b
Correct Answer
D. Both a & bExplanation
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.Rate this question:
-
- 20.
Which is the correct keyboard shortcut for CUT
- A.
CTRL + C
- B.
CTRL + D
- C.
CTRL + V
- D.
CTRL + X
Correct Answer
D. CTRL + XExplanation
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.Rate this question:
-
- 21.
Before Sending email I should,
- A.
Read mail twice
- B.
Check spellings
- C.
Check Subject
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
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.Rate this question:
-
- 22.
How Quickly Should I reply to an email?
- A.
As soon as I can
- B.
I don’t have to reply
- C.
When I get around
- D.
Doesn’t matter
Correct Answer
A. As soon as I canExplanation
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.Rate this question:
-
- 23.
Why shouldn’t I type emails in all CAPS?
- A.
It makes you look lazy
- B.
It shows arrogant
- C.
Its shows you are yelling.
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
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.Rate this question:
-
- 24.
If you don't want to type your name at the end of every email you send, what you can you do instead?
- A.
Don't sign at all .. people know who the email is from thanks to your return email address
- B.
Only sign emails to business associates, but you can exclude this step with friends and family
- C.
Create a signature that will attach to every email you send
- D.
None of the above
Correct Answer
C. Create a signature that will attach to every email you sendExplanation
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.Rate this question:
-
- 25.
What is the most important thing I should do with every e-mail?
- A.
Spell check, use full sentence structure and use proper grammar
- B.
Have a nice greeting: Hi, Hello, etc
- C.
Include signature
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
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.Rate this question:
-
- 26.
To attach a file what do you click on?
- A.
Paper clip
- B.
Insert
- C.
New
- D.
Format
Correct Answer
B. InsertExplanation
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.Rate this question:
-
- 27.
When sending a message, you should copy ("cc"):
- A.
Your boss and his boss
- B.
Only those people who need to know
- C.
The whole world
- D.
Family members
Correct Answer
B. Only those people who need to knowExplanation
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.Rate this question:
-
- 28.
Which is the correct format for a signature
- A.
Name| designation| company address | Phone number| email id
- B.
Designation| Name| company address | Phone number| email id
- C.
Email id | Name| company address | Phone number|
- D.
None of the above
Correct Answer
A. Name| designation| company address | Phone number| email idExplanation
The correct format for a signature is to include the name, designation, company address, phone number, and email id in that order.Rate this question:
-
- 29.
Which application is used for sending an email-
- A.
MS word
- B.
Outlook
- C.
Excel
- D.
Power point
Correct Answer
B. OutlookExplanation
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.Rate this question:
-
- 30.
Netiquette suggests a business email should be replied within a business day.
- A.
Correct
- B.
Incorrect
- C.
Don’t reply until you get a call
- D.
None of the above
Correct Answer
A. CorrectExplanation
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.Rate this question:
-
- 31.
What is internet?
- A.
A single network
- B.
A vast collection of different networks
- C.
Interconnection of local area networks
- D.
None of the mentioned
Correct Answer
B. A vast collection of different networksExplanation
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.Rate this question:
-
- 32.
Software which allows user to view the webpage is called ___
- A.
Website
- B.
OS
- C.
Internet browser
- D.
None of the above
Correct Answer
C. Internet browserExplanation
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.Rate this question:
-
- 33.
Which of the follow is a valid website address?
- A.
Www..abc.com
- B.
- C.
Www_pineapple.com
- D.
Www.pineapple.com
Correct Answer
D. Www.pineapple.comExplanation
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.Rate this question:
-
- 34.
What is the full form of ROM?
- A.
Random access Memory
- B.
Random Allotted Memory
- C.
Read Only Memory
- D.
None of the above
Correct Answer
C. Read Only MemoryExplanation
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.Rate this question:
-
- 35.
When you open a website main page is called as _____
- A.
Home page
- B.
Backend page
- C.
None of the above
- D.
Start page
Correct Answer
A. Home pageExplanation
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.Rate this question:
-
- 36.
Keyboard short cut for refreshing computer
- A.
F5
- B.
F4
- C.
F3
- D.
F2
Correct Answer
A. F5Explanation
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.Rate this question:
-
- 37.
What happens if we press + E
- A.
It shows all open word doucments
- B.
It opens my computer.
- C.
It opens up start menu
- D.
None of the above
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.Rate this question:
-
- 38.
Which is not a browser?
- A.
Internet Explorer
- B.
Mozilla
- C.
Google Chrome
- D.
MS Excel
Correct Answer
D. MS ExcelExplanation
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.Rate this question:
-
- 39.
Which is not an Operating System?
- A.
MS office
- B.
Windows 7
- C.
Linux
- D.
Macintosh
Correct Answer
A. MS officeExplanation
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.Rate this question:
-
- 40.
Which is new release of Microsoft for Operating System?
- A.
Windows 8.1
- B.
Windows 8
- C.
Windows 8.2
- D.
Windows 7
Correct Answer
A. Windows 8.1Explanation
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.Rate this question:
-
.PNG "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-")
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 02, 2015Quiz Created by
ErVshalM
Back to top