Futureheights Training & Consultant Pvt. Ltd (Set-4)
.PNG "Futureheights Training & Consultant Pvt. Ltd (Set-4) - 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, 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.Rate this question:
-
- 2.
Mention the shortcut key combinations used for navigating to the END column of 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 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.Rate this question:
-
- 3.
Which symbol always comes before an Excel formula?
- A.
++
- B.
=
- C.
-
- D.
%
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.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, 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.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 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.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 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.Rate this question:
- 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
- A.
F2/ 6% and then drag
- B.
=F2* 6% and then drag
- C.
=G2*6% and then drag
- D.
–AVG(C1:D1)
Correct Answer
B. =F2* 6% and then dragExplanation
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.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, 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.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 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.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 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.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 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.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
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.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 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.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. 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.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 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.Rate this question:
-
- 16.
What is the function of Ctrl + U in Ms-Word
- A.
It converts selected text into the next larger size of the same font
- B.
It Underlines the selected text
- C.
It makes the selected text bold
- D.
It applies Italic formatting to the selected text
Correct Answer
B. It Underlines the selected textExplanation
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.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 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.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 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.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. 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.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 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.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
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.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 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.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 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.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 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.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 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.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 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.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 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.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 "Name| designation| company address | Phone number| email id". This format includes all the necessary information in a professional manner.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 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.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
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.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
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.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 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.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, 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).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
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."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 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."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. 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.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 running.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 browsers such as Internet Explorer, Mozilla, and Google Chrome, MS Excel is not designed for browsing the internet or accessing web pages.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, 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.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 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.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