Futureheights Training & Consultant Pvt. Ltd (Set-3)
.PNG "Futureheights Training & Consultant Pvt. Ltd (Set-3) - 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 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.Rate this question:
-
- 2.
Mention the shortcut key combinations used for navigating to the END column of the end row of the working worksheet
- A.
CTRL + HOME
- B.
CTRL + END
- C.
ALT + HOME
- D.
ALT + END
Correct Answer
B. CTRL + ENDExplanation
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.Rate this question:
-
- 3.
Which symbol always comes before an Excel formula?
- A.
++
- B.
=
- C.
-
- D.
%
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.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 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.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
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.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 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.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 and displays it in column G.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
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.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 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.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 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.Rate this question:
-
- 11.
The file type _____ indicates the file is a Word document
- A.
.docx
- B.
.wor
- C.
.doc
- D.
Both a & c
Correct Answer
D. Both a & cExplanation
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.Rate this question:
-
- 12.
Using Find command in Word, we can search?
- A.
Word
- B.
Equation
- C.
Comment
- D.
All of the above
Correct Answer
D. All of the aboveExplanation
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.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 content will be displayed consistently on each page of the document.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, 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.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. 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.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 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.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 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.Rate this question:
-
- 18.
Which is the correct keyboard short cut for line Spacing
- A.
CTRL + 1
- B.
CTRL + 4
- C.
CTRL + 8
- D.
CTRL + 9
Correct Answer
A. CTRL + 1Explanation
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.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 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.Rate this question:
-
- 20.
Which is the correct keyboard shortcut for Paste
- A.
CTRL + C
- B.
CTRL + D
- C.
CTRL + V
- D.
CTRL + X
Correct Answer
C. CTRL + VExplanation
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.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 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.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 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.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 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.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 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.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 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.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 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.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. 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.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 start with the name, followed by the designation, company address, phone number, and email id.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 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.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 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."Rate this question:
-
- 31.
What is intranet?
- A.
A single network
- B.
A vast collection of different networks
- C.
Interconnection of local area networks
- D.
None of the mentioned
Correct Answer
C. Interconnection of local area networksExplanation
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.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 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.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 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".Rate this question:
-
- 34.
What happens if we press + L
- A.
Lock your workstation
- B.
Search
- C.
Find
- D.
None of the above
Correct Answer
A. Lock your workstationExplanation
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.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". 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.Rate this question:
-
- 36.
What is the full form of CPU?
- A.
Center Process Unit
- B.
Central Processing Unit
- C.
Central Process Unix
- D.
None of the above
Correct Answer
B. Central Processing UnitExplanation
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.Rate this question:
-
- 37.
What happens if we press + M
- A.
It shows all open word doucments
- B.
It opens my computer.
- C.
It opens up start menu
- D.
It minimizes all the application/software running
Correct Answer
D. It minimizes all the application/software runningExplanation
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.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. Internet Explorer, Mozilla, and Google Chrome are all web browsers that allow users to access and view websites on the internet.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 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.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 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.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 21, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 04, 2015Quiz Created by
ErVshalM
Back to top