Computer Skills: How Well Do You Know About MS Office And Email? Trivia Quiz
This trivia quiz is on Computer Skills. How Well Do You Know About MS Office And Email? Ms. Office is the most common use mode of communication for emails when it comes to most organizations, and people need to know about using the application correctly at the workplace. How about you give it a shot and learn something!
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 features such as formulas, functions, and charts that make it easy to input, calculate, and visualize data. With MS Excel, Ramesh can create a structured table to store information about his monthly visits, including dates, schools visited, and any other relevant details. He can also use filters and sorting options to analyze the data and generate reports if needed.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 or active cell will move to the first cell in the worksheet, which is typically A1. This shortcut is useful when you have a large worksheet and want to quickly move to the beginning of it without scrolling manually.Rate this question:
-
- 3.
Which symbol always comes before an Excel formula?
- A.
A common
- B.
An equal sign
- C.
Two times plus sign
- D.
A percentage sign
Correct Answer
B. An equal signExplanation
An equal sign always comes before an Excel formula. In Excel, the equal sign is used to indicate that the following characters or values are part of a formula and not just regular text. This allows Excel to recognize and calculate the formula correctly. Without the equal sign, Excel would treat the characters as text and not perform any calculations. Therefore, the equal sign is a crucial component in creating formulas in Excel.Rate this question:
-
- 4.
Address of second cell in a worksheet is
- A.
C2
- B.
2
- C.
2C
- D.
None of the above
Correct Answer
A. C2Explanation
The address of the second cell in a worksheet is C2. This is because in a worksheet, cells are identified by their column letter followed by their row number. In this case, the column letter is "C" and the row number is "2", so the address of the second cell is C2.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". This means that 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, 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 adjust the text size.Rate this question:
-
- 6.
Based on the spreadsheet given below answers the below QuestionsFormula for calculating the Total Marks as sum of Science, Maths & Computers for each student 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)". This formula calculates the total marks for each student by summing the values in the cells C2, D2, and E2. It correctly follows the instructions given in the question to calculate the total marks as the sum of Science, Maths, and Computers for each student and display the result in column F.Rate this question:
-
- 7.
Based on the spreadsheet given below answers the below QuestionsFormula for calculating the average marks for each student and display them in column G
- A.
=AVERAGE(C1:E2)
- B.
=AVERAGE(C2:E2)
- C.
=AVERAGE(C1:E2)
- D.
–AVG(C2:E2)
Correct Answer
B. =AVERAGE(C2:E2)Explanation
The correct answer is =AVERAGE(C2:E2). This formula calculates the average marks for the student in row 2 by taking the average of the values in columns C, D, and E. The other formulas mentioned in the spreadsheet are either duplicates or incorrect.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, making it easier to compare data in different columns. By selecting this option, the user can ensure that the first column remains fixed in place 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 adjust the alignment of cell contents, including merging cells. The Formatting toolbar does not have a specific option for merging cells, so it is not the correct answer. The option to merge cells is not available in both the Format Cells dialog box Alignment Tab and the Formatting toolbar, so "Both of above" is also not the correct answer. "None of above" is not the correct answer as the merge cells option can be found in 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 correct answer because it specifically mentions the action of wrapping text in the Format menu under the Cells category. The other options mentioned different actions or did not specify the exact location in the menu where the text wrapping feature can be found.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 is commonly used to indicate that a file is a Word document. This file extension is associated with Microsoft Word, a popular word processing software. When a file has the .doc extension, it suggests that it can be opened and edited using Microsoft Word or other compatible software.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 Find command in Word allows users to search for specific words or phrases within a document. This feature is useful for locating and navigating to specific content in a document, making it easier to edit or review the document.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 at the top or bottom of each page in a document or a webpage.Rate this question:
-
- 14.
Which menu in MSWord can be used to change character size and typeface?
- A.
View
- B.
Tools
- C.
Format
- D.
Data
Correct Answer
C. FormatExplanation
The Format menu in MS Word can be used to change the character size and typeface. This menu provides options to modify the formatting of text, such as changing the font, font size, and applying various text effects. By accessing the Format menu, users can easily customize the appearance of their text by selecting different typefaces and adjusting the size according to their preferences.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 beginning of the next line, effectively starting a new paragraph. This is a commonly used function in word processing software to create paragraphs and organize text.Rate this question:
-
- 16.
What is the function of Ctrl + B 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 t the selected text
Correct Answer
C. It makes the selected text boldExplanation
Ctrl + B is a keyboard shortcut in MS-Word that is used to make the selected text bold. This means that when a user selects a portion of text and presses Ctrl + B, the text will appear in a bold font style.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 adding important information such as page numbers, document titles, author names, and dates to the top and bottom of each page. It ensures consistency and professionalism in the document layout and provides additional context and navigation for readers.Rate this question:
-
- 18.
How to insert water mark-
- A.
Insert- watermark
- B.
Page layout- watermark
- C.
Home – watermark
- D.
None of the above
Correct Answer
B. Page layout- watermarkExplanation
The correct answer is "Page layout - watermark" because in most word processing software, including Microsoft Word, the option to insert a watermark is usually found under the "Page Layout" tab. This tab typically contains various formatting options related to the overall layout and design of the document, including the option to add a watermark. The other options mentioned, "Insert - watermark" and "Home - watermark," are not commonly used or recognized as the correct way to access the watermark feature in word processing software.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 options a and b allow you to insert page numbers in a document. The "Page Number" option from the Insert menu allows you to add page numbers directly to the document. On the other hand, the "Footnote" option from the Insert menu also allows you to insert page numbers, but in a different format, typically at the bottom of the page. Therefore, both options a and b provide ways to insert page numbers in a document.Rate this question:
-
- 20.
Which is the correct keyboard short cut for COPY
- A.
CTRL + C
- B.
CTRL + D
- C.
CTRL + E
- D.
CTRL + W
Correct Answer
A. CTRL + CExplanation
The correct keyboard shortcut for COPY is CTRL + C. This combination of keys allows the user to copy selected text or files to the clipboard. By pressing CTRL + C, the selected content is copied and can be pasted elsewhere using the CTRL + V shortcut.Rate this question:
-
- 21.
Before Sending very large attachments I should,
- A.
Compress them up( Zip them)
- B.
Send all attachments without compressing them
- C.
Don’t attach them
- D.
Send them in two separate email
Correct Answer
A. Compress them up( Zip them)Explanation
Compressing large attachments before sending them helps to reduce the file size, making it easier and quicker to send over email. By compressing the files into a zip folder, the overall size is reduced, and the recipient can easily unzip and access the files on their end. This method is commonly used to avoid any issues with file size limitations or slow transfer speeds when sending large attachments.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 communication is crucial in maintaining professional relationships and ensuring efficient workflow. Responding promptly shows respect for the sender's time and demonstrates professionalism. Delaying responses can lead to misunderstandings, missed opportunities, and a negative impression. Therefore, it is advisable to prioritize email replies and strive to respond as soon as one is able to.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 is discouraged because it can give the impression that the sender is lazy, arrogant, or yelling. This is because typing in all caps is considered to be the online equivalent of shouting, and it can come across as rude or aggressive. Therefore, it is generally recommended to avoid using all caps in emails to maintain a professional and respectful tone.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
Creating a signature that will attach to every email you send is a practical solution to avoid typing 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. By setting up this signature, it will automatically be added to all outgoing emails, 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 listed are essential for composing effective emails.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 add various elements, such as images, tables, or files, to a document or email. Clicking on "insert" would open a menu or dialog box where you can choose the file you want to attach and insert it into the desired location.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 clutter in communication. Copying your boss and his boss ensures that the relevant parties are informed and involved in the conversation. However, copying the whole world or family members is unnecessary and can compromise privacy and confidentiality. Therefore, the best practice is to only include individuals who have a direct 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 logical order, starting with the name and designation, followed by the company address, phone number, and email id.Rate this question:
-
- 29.
When writing an email message, paragraphs should
- A.
Be long
- B.
Be short
- C.
Be indented
- D.
None of the above
Correct Answer
B. Be shortExplanation
Paragraphs in an email message should be short. This is because long paragraphs can be overwhelming for the reader and may cause them to lose interest or miss important information. Short paragraphs are easier to read and understand, allowing the recipient to quickly grasp the main points being communicated. Additionally, shorter paragraphs make the email visually appealing and less cluttered, enhancing readability and overall communication effectiveness.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, responsiveness, and respect for the sender's time. By replying promptly, it helps maintain effective communication and fosters a positive business relationship. 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." The internet is not just a single network, but rather a global network that connects millions of different networks together. These networks can be local area networks, wide area networks, or even individual devices. The internet allows for communication and data transfer between these networks, enabling users to access information, services, and communicate with others from anywhere in 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 specifically designed to access and display information on the internet. It enables users to navigate through websites, view multimedia content, and interact with various web-based applications. Therefore, an internet browser is the correct answer as it perfectly aligns with the description provided in the 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, with "www" indicating the World Wide Web, followed by a domain name (in this case, "pineapple") and a top-level domain (in this case, "com"). The other options are not valid website addresses because they contain incorrect characters or do not follow the standard format.Rate this question:
-
- 34.
What is the full form of RAM?
- A.
Random access Memory
- B.
Random Allotted Memory
- C.
Read Access Memory
- D.
None of the above
Correct Answer
A. Random access MemoryExplanation
RAM stands for Random Access Memory. It is a type of computer memory that allows data to be read from or written to in almost the same amount of time regardless of the physical location of data inside the memory. It is called "random access" because it allows the computer to access any memory cell directly, without having to go through all the preceding cells. RAM is a volatile memory, meaning that its contents are lost when the power is turned off or interrupted.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 starting point for users when they visit a website. It usually contains an overview or introduction to the website, along with navigation links to other sections or pages within the site. The term "backend page" refers to the administrative or behind-the-scenes area of a website, which is not typically visible to regular users. Therefore, the correct answer is "Home page".Rate this question:
-
- 36.
Keyboard short cut for refreshing computer
- A.
F5
- B.
F4
- C.
F3
- D.
F2
Correct Answer
A. F5Explanation
The correct answer is F5 because F5 is the keyboard shortcut commonly used to refresh a computer. When pressed, it reloads the current page or document, updating any changes made since it was last loaded. This shortcut is widely used in web browsers, text editors, and other applications to quickly refresh content and ensure the most up-to-date version is displayed.Rate this question:
-
- 37.
What happens if we press ALT + TAB
- A.
It shows all open word doucments
- B.
It shows all open files
- C.
It opens up start menu
- D.
None of the above
Correct Answer
D. None of the aboveExplanation
Pressing ALT + TAB on a computer keyboard allows the user to switch between open applications or windows. It displays a list of all currently open applications, allowing the user to select the desired one by continuing to press TAB while holding down the ALT key. This feature is commonly used to quickly navigate between different tasks or programs without using the mouse.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 for creating and managing spreadsheets. Browsers, on the other hand, are software applications used to access and view websites on the internet. Internet Explorer, Mozilla, and Google Chrome are all examples of web browsers.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 applications developed by Microsoft. It includes programs like Word, Excel, PowerPoint, and Outlook, which are used for word processing, creating spreadsheets, making presentations, and managing emails respectively. While MS Office can run on various operating systems such as Windows, macOS, and Linux, it is not an operating system itself. Operating systems, on the other hand, are the software that manage computer hardware and software resources and provide common services for computer programs.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, with improvements and additional features. Windows 8.2 is not mentioned as an option, and Windows 7 is an older version of Windows, so they are not the correct answers.Rate this question:
-
.PNG "Based on the spreadsheet given below answers the below QuestionsFormula for calculating the Total Marks as sum of Science, Maths & Computers for each student 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 20, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 02, 2015Quiz Created by
ErVshalM
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top