Futureheights Training & Consultant Pvt. Ltd (Set-4)

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By ErVshalM
E
ErVshalM
Community Contributor
Quizzes Created: 4 | Total Attempts: 958
| Attempts: 189
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/40 Questions

    Which symbol always comes before an Excel formula? 

    • ++
    • =
    • -
    • %
Please wait...
About This Quiz

This quiz from FutureHeights Training & Consultant Pvt. Ltd assesses knowledge in using MS Excel for data management. It covers practical skills like formula creation, navigation shortcuts, and cell formatting, essential for efficient data handling and analysis in educational and professional settings.

Futureheights Training & Consultant Pvt. Ltd (Set-4) - Quiz

Quiz Preview

  • 2. 

    What is the function of Ctrl + U in Ms-Word

    • It converts selected text into the next larger size of the same font

    • It Underlines the selected text

    • It makes the selected text bold

    • It applies Italic formatting to the selected text

    Correct Answer
    A. 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.

    Rate this question:

  • 3. 

    When you open a website main page is called as _____

    • Home page

    • Backend page

    • None of the above

    • Start page

    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."

    Rate this question:

  • 4. 

    What is the full form of CPU?

    • Center Process Unit

    • Central Processing Unit

    • Central Process Unix

    • None of the above

    Correct Answer
    A. 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.

    Rate this question:

  • 5. 
    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- - ProProfs

    Based on the spreadsheet given below answers the below Questions 
    1. Formula for calculating the Total Price as sum of Science, Maths & Computers for each Customer and display them in column F-

    • =SUM(A2+B2+C2+D2)

    • =SUM(A1:E2)

    • =SUM(C2+D2+E2)

    • SUM(C2+D1+E2)

    Correct Answer
    A. =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:

  • 6. 

    Which key should be pressed to start a new paragraph in MS-Word?

    • Down Cursor Key

    • Enter Key

    • Shift + Enter

    • Ctrl + Enter

    Correct Answer
    A. 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.

    Rate this question:

  • 7. 

    Which is the correct keyboard shortcut for Paste

    • CTRL + C

    • CTRL + D

    • CTRL + V

    • CTRL + X

    Correct Answer
    A. 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.

    Rate this question:

  • 8. 

    Which is not a browser?

    • Internet Explorer

    • Mozilla

    • Google Chrome

    • MS Excel

    Correct Answer
    A. 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.

    Rate this question:

  • 9. 
    What happens if we press   + L - ProProfs

    What happens if we press   + L

    • Lock your workstation

    • Search

    • Find

    • None of the above

    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."

    Rate this question:

  • 10. 

    Which is the correct format for a signature

    • Name| designation| company address | Phone number| email id

    • Designation| Name| company address | Phone number| email id

    • Email id | Name| company address | Phone number|

    • None of the above

    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.

    Rate this question:

  • 11. 

    Which application is used for sending an email-

    • MS word

    • Outlook

    • Excel

    • Power point

    Correct Answer
    A. 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.

    Rate this question:

  • 12. 

    Which is not an Operating System?

    • MS office

    • Windows 7

    • Linux

    • Macintosh

    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.

    Rate this question:

  • 13. 

    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?

    • MS word

    • Outlook

    • MS Excel

    • None of the above

    Correct Answer
    A. 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.

    Rate this question:

  • 14. 

    Before Sending email I should,

    • Read mail twice

    • Check spellings

    • Check Subject

    • All of the above

    Correct Answer
    A. 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.

    Rate this question:

  • 15. 

    How Quickly Should I reply to an email?

    • As soon as I can

    • I don’t have to reply

    • When I get around

    • Doesn’t matter

    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.

    Rate this question:

  • 16. 

    Why shouldn’t I type emails in all CAPS?

    • It makes you look lazy

    • It shows arrogant

    • Its shows you are yelling.

    • All of the above

    Correct Answer
    A. 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.

    Rate this question:

  • 17. 

    Address of first cell in a worksheet is

    • A1

    • 1

    • 1A

    • None of the above

    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.

    Rate this question:

  • 18. 

    Which is the correct keyboard short cut for line Spacing

    • CTRL + 1

    • CTRL + 4

    • CTRL + 8

    • CTRL + 9

    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.

    Rate this question:

  • 19. 

    When sending a message, you should copy ("cc"):

    • Your boss and his boss

    • Only those people who need to know

    • The whole world

    • Family members

    Correct Answer
    A. 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.

    Rate this question:

  • 20. 

    Which of the follow is a valid website address?

    Correct Answer
    A. 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).

    Rate this question:

  • 21. 

    Mention the shortcut key combinations used for navigating to the END column of end row of the working worksheet

    • CTRL + HOME

    • CTRL + END

    • ALT + HOME

    • ALT + END

    Correct Answer
    A. 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.

    Rate this question:

  • 22. 

    Click on the right option to freeze a column-

    • View- freeze first column

    • Data- freeze column

    • Insert- freeze

    • Home – freeze

    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.

    Rate this question:

  • 23. 
    What happens if we press   + M - ProProfs

    What happens if we press   + M

    • It shows all open word doucments

    • It opens my computer.

    • It opens up start menu

    • It minimizes all the application/software running

    Correct Answer
    A. 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.

    Rate this question:

  • 24. 

    Netiquette suggests a business email should be replied within a business day.

    • Correct

    • Incorrect

    • Don’t reply until you get a call

    • None of the above

    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.

    Rate this question:

  • 25. 
    Which menu/Ribbon shows  paragraph option-​ - ProProfs

    Which menu/Ribbon shows  paragraph option-​

    • Home

    • View

    • Page layout

    • None of the above

    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.

    Rate this question:

  • 26. 

    To attach a file what do you click on?

    • Paper clip

    • Insert

    • New

    • Format

    Correct Answer
    A. 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.

    Rate this question:

  • 27. 

    Long text can be broken down into many lines within a cell. You can do this through 

    • Wrap Text in Format >> Cells

    • Justify in Edit >> Cells

    • Text Wraping in Format >> Cells, Layout tab

    • All of above

    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.

    Rate this question:

  • 28. 

    If you don't want to type your name at the end of every email you send, what you can you do instead?

    • Don't sign at all .. people know who the email is from thanks to your return email address

    • Only sign emails to business associates, but you can exclude this step with friends and family

    • Create a signature that will attach to every email you send

    • None of the above

    Correct Answer
    A. 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.

    Rate this question:

  • 29. 
    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 - ProProfs

    Based on the spreadsheet given below answers the below Questions 
    1. Formula for calculating the Discount @ 6% for each customer and display them in column G

    • F2/ 6% and then drag

    • =F2* 6% and then drag

    • =G2*6% and then drag

    • –AVG(C1:D1)

    Correct Answer
    A. =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.

    Rate this question:

  • 30. 

    What is the most important thing I should do with every e-mail?

    • Spell check, use full sentence structure and use proper grammar

    • Have a nice greeting: Hi, Hello, etc

    • Include signature

    • All of the above

    Correct Answer
    A. 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.

    Rate this question:

  • 31. 

    Software which allows user to view the webpage is called ___

    • Website

    • OS

    • Internet browser

    • None of the above

    Correct Answer
    A. 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.

    Rate this question:

  • 32. 

    By default, on which page the header or the footer is printed?

    • on first page

    • On alternate page

    • On every page

    • None of the above

    Correct Answer
    A. 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.

    Rate this question:

  • 33. 

    The file type _____ indicates the file is a Word document

    • .docx

    • .wor

    • .doc

    • Both a & c

    Correct Answer
    A. 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.

    Rate this question:

  • 34. 

    Which is new release of Microsoft for Operating System?

    • Windows 8.1

    • Windows 8

    • Windows 8.2

    • Windows 7

    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.

    Rate this question:

  • 35. 

    There can be many ways to insert page number in a document. Which of the following lets you insert page number

    • Page number from Insert menu

    • Footnote from Insert menu

    • Page Setup from file menu

    • Both a & b

    Correct Answer
    A. 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.

    Rate this question:

  • 36. 

    Why headers and footers used in MS –Word

    • To enhance the overall appearance of the document

    • To mark the starting of a page

    • To make large document more readable

    • To allow page headers and footers to appear on document when it is printed

    Correct Answer
    A. 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.

    Rate this question:

  • 37. 

    Using Find command in Word, we can search?

    • Word

    • Equation

    • Comment

    • All of the above

    Correct Answer
    A. 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.

    Rate this question:

  • 38. 

    You can automatically adjust the size of text in a cell if they do not fit in width by

    • Double clicking on the right border of column header

    • From Format choose Columns and then Autofit Selection

    • From Format Cells dialog box mark Shrink to fit check box

    • All of above

    Correct Answer
    A. 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.

    Rate this question:

  • 39. 

    What is intranet?

    • A single network

    • A vast collection of different networks

    • Interconnection of local area networks

    • None of the mentioned

    Correct Answer
    A. 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.

    Rate this question:

  • 40. 

    Merge cells option can be applied from 

    • Format Cells dialog box Alignment Tab

    • Formatting toolbar

    • Both of above

    • None of above

    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.

    Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 04, 2015
    Quiz Created by
    ErVshalM

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.