Office Automation Quiz: Viva Questions & MCQs
-
Powerpoint is saved as:
-
.pptx
-
.Xlsx
-
Txt
-
.Docx
-
Preparing for your office automation viva questions? This resource offers a comprehensive set of multiple-choice questions (MCQs) covering essential office automation concepts. Practice with these questions to solidify your understanding of topics like word processing, spreadsheets, presentations, database management, and networking.
This collection of office automation MCQs with answers provides a valuable tool for self-assessment. Each question is accompanied See moreby a correct answer, enabling you to identify your strengths and weaknesses. Use these MCQs to reinforce your learning and pinpoint areas where you need further study.
(162).jpg "Office Automation Quiz: Viva Questions & MCQs - Quiz")
Quiz Preview
- 2.
A collection of eight bits is called?
-
Word
-
Record
-
Byte
-
File
Correct Answer
A. ByteExplanation
A collection of eight bits is called a "byte". In computing, a byte is the basic unit of information storage and processing. It is commonly used to represent characters, numbers, and other types of data. A byte consists of 8 bits, which are binary digits that can represent either a 0 or a 1. Therefore, a byte is the correct term for a collection of eight bits.Rate this question:
-
- 3.
PowerPoint is best described as?
-
Presentation Software
-
PowerPoint is best described as?
-
Database Software
-
Desktop Publishing Software
Correct Answer
A. Presentation SoftwareExplanation
PowerPoint is best described as presentation software because it is specifically designed to create and deliver visual presentations. It provides users with a wide range of tools and features to create slideshows, add text, images, videos, and animations, and present them in a visually appealing and organized manner. PowerPoint allows users to create professional-looking presentations for various purposes, such as business meetings, educational lectures, and sales pitches. It is widely used in both professional and academic settings for its ease of use and ability to effectively communicate information through visual aids.Rate this question:
-
- 4.
You can insert the following on a slide
-
Picture
-
Text
-
Chart
-
All of the above
Correct Answer
A. All of the aboveExplanation
The correct answer is "All of the above" because the options mentioned, such as picture, text, and chart, are all valid elements that can be inserted on a slide. This answer implies that any combination of these elements can be used on a slide, giving the presenter the flexibility to include various types of content to enhance their presentation.Rate this question:
-
- 5.
What does WWW stand for?
-
World Wacky Web
-
World Wide Web
-
Wide World of Why
-
World Web Wide
Correct Answer
A. World Wide WebExplanation
The correct answer is "World Wide Web" because WWW is an acronym that stands for World Wide Web, which is a system of interconnected documents and resources accessed through the internet. It is a global network of information that allows users to navigate and access various websites and web pages using hyperlinks.Rate this question:
-
- 6.
___________is called as the Brain of the Computer.
-
Hard Disk
-
Central Processing Unit
-
Random Access Memory
-
DVD
Correct Answer
A. Central Processing UnitExplanation
The Central Processing Unit (CPU) is often referred to as the brain of a computer because it is responsible for executing instructions and performing calculations. It is the main component that carries out the majority of the computer's processing tasks, including interpreting and executing program instructions, performing arithmetic and logical operations, and managing data flow between different parts of the computer system. Without the CPU, a computer would not be able to carry out any tasks or functions.Rate this question:
-
- 7.
What type of computer would you choose for a salesman who has to travel frequently?
-
Laptop
-
Super computer
-
Microcomputer
-
Mainframe
Correct Answer
A. LaptopExplanation
A laptop would be the ideal choice for a salesman who travels frequently because it is portable and lightweight, allowing the salesman to easily carry it with them on their travels. Laptops also have all the necessary features and capabilities of a computer, making it convenient for the salesman to perform their work tasks while on the go. Additionally, laptops have a long battery life, ensuring that the salesman can use it for an extended period without needing to find a power source.Rate this question:
-
- 8.
What type of software controls all the hardware and software on a computer?
-
Word processor
-
Database
-
Operating system
-
Network security
Correct Answer
A. Operating systemExplanation
The operating system is the software that controls and manages all the hardware and software on a computer. It acts as an interface between the user and the computer, allowing the user to interact with the hardware and run various applications. The operating system handles tasks such as memory management, file system management, device drivers, and user interface. It is responsible for ensuring that all the components of the computer work together smoothly and efficiently.Rate this question:
-
- 9.
Border can be applied to
-
Cell
-
Paragraph
-
Text
-
All of the Above
Correct Answer
A. All of the AboveExplanation
The correct answer is "All of the Above" because a border can be applied to various elements such as a cell, paragraph, and text. Borders are commonly used to visually separate or highlight specific elements on a page, providing a clear distinction between different sections or content. By applying a border, it is possible to enhance the overall appearance and readability of the elements, making them more visually appealing and organized.Rate this question:
-
- 10.
Which of the following is not a font style?
-
Bold
-
Italic
-
Superscript
-
None of the above
Correct Answer
A. SuperscriptExplanation
Superscript is not a font style because it refers to a type of formatting that raises text above the baseline, typically used for mathematical or scientific notation. Font styles include bold and italic, which alter the appearance of the text by making it thicker or slanted respectively. Therefore, the correct answer is superscript.Rate this question:
-
- 11.
Which two tabs will appear on the ribbon bar when you are editing the (contents of) a table in Word 2010?
-
Compatibility and Drawing
-
Drawing and Preview
-
Design and Layout
-
Design and Compatibility
Correct Answer
A. Design and LayoutExplanation
When editing the contents of a table in Word 2010, the Design and Layout tabs will appear on the ribbon bar. The Design tab allows users to modify the overall design and formatting of the table, such as changing the table style, colors, and borders. The Layout tab, on the other hand, provides options for adjusting the structure and arrangement of the table, including adding or deleting rows and columns, merging cells, and changing cell alignment. These two tabs are specifically designed to assist users in customizing and organizing tables effectively.Rate this question:
-
- 12.
Which of the following can be inserted into a Word 2010 document as a table directly?
-
Impress presentation
-
Calc Spreadsheet
-
Excel Spreadsheet
-
Assembly source file
Correct Answer
A. Excel SpreadsheetExplanation
An Excel Spreadsheet can be directly inserted into a Word 2010 document as a table. Word 2010 has a built-in feature that allows users to insert an Excel Spreadsheet directly into a document. This feature enables users to create and edit tables using the powerful features of Excel within the Word document itself. It provides a convenient way to incorporate data from Excel into a Word document without the need for copy-pasting or importing data.Rate this question:
-
- 13.
1 GB =bytes ?
-
1042 terabytes
-
1024 megabytes
-
1024 kilobyte
-
8 bit
Correct Answer
A. 1024 megabytesExplanation
The correct answer is 1024 megabytes. This is because 1 GB is equal to 1024 megabytes. In computer storage, data is often measured in multiples of bytes, with each multiple being a power of 2. Therefore, 1 GB is equal to 1024 * 1024 kilobytes, which is equal to 1024 megabytes.Rate this question:
-
- 14.
In MS Word, for what does ruler help?
-
To set indents
-
To set tabs
-
To change page margins
-
All of the above
Correct Answer
A. All of the aboveExplanation
The ruler in MS Word helps with various formatting tasks. It can be used to set indents, which control the spacing between the edge of the page and the text. It also allows users to set tabs, which are used to align text at specific positions. Additionally, the ruler can be used to change page margins, adjusting the amount of space between the text and the edges of the page. Therefore, all of the given options are correct.Rate this question:
-
- 15.
Which menu in MSWord can be used to change page size & typeface?
-
View
-
Format
-
Tools
-
Data
Correct Answer
A. FormatExplanation
The Format menu in MS Word can be used to change the page size and typeface. This menu provides various options to modify the formatting of the document, including changing the page layout, margins, and paper size. Additionally, it allows users to select different typefaces, adjust font size, and apply formatting styles to the text. By accessing the Format menu, users can easily customize the appearance of their document according to their preferences.Rate this question:
-
- 16.
You can detect spelling and grammar error by
-
Press Shift+F7
-
Press F7
-
Press Ctrl+F7
-
Press Alt+F7
Correct Answer
A. Press F7Explanation
Pressing F7 is a common shortcut in many word processing programs to run a spell check. By pressing F7, the program will automatically scan the document for any spelling and grammar errors and provide suggestions for corrections. This feature is useful for ensuring that written content is free from mistakes and is grammatically correct.Rate this question:
-
- 17.
You do not like the style that Word 2010 uses as default. Is it possible to change it?
-
Yes
-
No
-
Only on Windows 7
-
Depends on the Edition
Correct Answer
A. YesExplanation
Yes, it is possible to change the default style in Word 2010. Users have the option to customize the default font, size, and other formatting settings according to their preferences. This can be done by accessing the "Font" settings in the "Home" tab and selecting the desired options.Rate this question:
-
- 18.
Which bar is usually located below the Title Bar that provides categorized options?
-
Status Bar
-
Menu bar
-
Tool bar
-
Scroll bar
Correct Answer
A. Menu barExplanation
The menu bar is usually located below the title bar and provides categorized options for the user. It typically contains various menus such as File, Edit, View, and Help, which further expand into submenus when clicked. The menu bar allows users to access different functions and features of the software or application they are using, making it an essential component of the user interface.Rate this question:
-
- 19.
The "boxes" going from left to right are called...
-
Columns
-
Rows
-
Letters
-
Titles
Correct Answer
A. RowsExplanation
The "boxes" going from left to right are called rows because rows are horizontal arrangements of data in a table or grid. In this context, the boxes are likely referring to the horizontal cells or sections in a table, and each row represents a separate set of data.Rate this question:
-
- 20.
Which of the following is true regarding the page Orientation of a Document?
-
Page Orientation of the document is determined by the printer.
-
Page Orientation must be set before start Typing
-
Page Orientation can be changed at any time.
-
Page Orientation of a document cannot be changed
Correct Answer
A. Page Orientation can be changed at any time.Explanation
The correct answer is that page orientation can be changed at any time. This means that the orientation of a document, whether it is portrait or landscape, can be adjusted even after the document has been created or while it is being edited. This flexibility allows users to adapt the document layout to their specific needs or preferences, without any limitations or restrictions.Rate this question:
-
- 21.
An Excel Workbook is a collection of?
-
Worksheets
-
Worksheets and Charts
-
Charts
-
Workbooks
Correct Answer
A. WorksheetsExplanation
An Excel workbook is a file that contains one or more worksheets, along with any associated charts, macros, and other Excel elements. Worksheets are individual spreadsheets within the workbook where you can enter and analyze data. The workbook acts as a container for organizing and managing related data and calculations.Rate this question:
-
- 22.
When a document file is opened from a hard disk, the information making up the file moves from ?
-
Hard disk to RAM
-
RAM to hard disk
-
ROM to RAM
-
Hard disk to ROM
Correct Answer
A. Hard disk to RAMExplanation
When a document file is opened from a hard disk, the information making up the file moves from the hard disk to RAM. This is because RAM (Random Access Memory) is a volatile memory that provides temporary storage for data that is actively being used by the computer. By moving the file from the hard disk to RAM, the computer can access and process the information more quickly, allowing for faster retrieval and manipulation of the file.Rate this question:
-
- 23.
How do you resize a 'shape'?
-
Drag the shape
-
Select the shape and drag the boundary/corner.
-
Select the shape and drag the 'green' dot that appears linked above the shape.
-
Right-click the shape and select 'move'.
Correct Answer
A. Select the shape and drag the boundary/corner.Explanation
To resize a shape in most applications like Microsoft Word, PowerPoint, or Excel, you need to select the shape and then drag the boundary or corner. When you click on a shape, small squares or circles (known as sizing handles) appear around the shape's boundary. By dragging these handles, you can adjust the shape's size proportionally or non-proportionally, depending on whether you drag from a corner or a side.Rate this question:
-
- 24.
What is the purpose of using headers and footers in a document?
-
They enhance the overall appearance of the document
-
To make large documents more readable.
-
They allow page headers and footers to appear on document when it is printed
-
To mark the starting and ending of a page.
Correct Answer
A. They allow page headers and footers to appear on document when it is printedExplanation
Headers and footers serve the purpose of allowing page headers and footers to appear on a document when it is printed. This feature is useful for including important information such as page numbers, document titles, author names, and dates on each page. It helps in organizing and providing context to the content of the document. Additionally, headers and footers enhance the overall appearance of the document by providing a consistent and professional look.Rate this question:
-
- 25.
Which among the following chart types do not have axes?
-
Doughnut charts
-
XY (Scatter) charts
-
Bar charts
-
Area charts
Correct Answer
A. Doughnut chartsExplanation
Doughnut charts do not have axes because they are circular charts that display data in a ring shape. The data is represented by segments within the ring, with each segment representing a different category or value. Unlike other chart types such as XY (Scatter) charts, Bar charts, and Area charts, which typically have both horizontal and vertical axes to show the scale and values of the data, doughnut charts rely solely on the size of the segments to convey the data. Therefore, they do not require axes for data visualization.Rate this question:
-
- 26.
By default, your documents print in _mode.
-
Page Setup
-
Print View
-
Portrait
-
Landscape
Correct Answer
A. PortraitExplanation
By default, documents are set to print in portrait mode. Portrait mode is a vertical orientation where the height of the page is greater than the width. This is the standard orientation for most documents and is suitable for reading and printing text-based content. Landscape mode, on the other hand, is a horizontal orientation where the width of the page is greater than the height. It is often used for printing documents that contain wide tables, charts, or images. However, the given question specifically asks for the default mode, which is portrait.Rate this question:
-
- 27.
To insert a new citation to a specific book in a Microsoft Word 2010 document, you should select:
-
References" >"Insert Citation" >"Add New Source
-
References" > "Style".
-
References" >"Insert Citation" >"Add New Placeholder.
-
None of the above
Correct Answer
A. References" >"Insert Citation" >"Add New SourceExplanation
To insert a new citation to a specific book in a Microsoft Word 2010 document, you should select "References" > "Insert Citation" > "Add New Source. This option allows the user to add a new citation to the document by specifying the necessary details such as the author, title, and publication year of the book. This citation can then be referenced within the document using the appropriate citation style.Rate this question:
-
- 28.
Which of the following is not a common function of spreadsheet software?
-
Performing calculations
-
Creating charts and graphs
-
Managing email
-
Sorting and filtering data
Correct Answer
A. Managing emailExplanation
Spreadsheet software like Microsoft Excel or Google Sheets primarily focuses on data analysis, calculations, visualization, and organization. 1 While some integration with email might be possible through scripting or add-ons, managing email is not a core function of spreadsheet software. Email management is typically handled by dedicated email clients or web-based email services.Rate this question:
-
- 29.
Which of the following options is not available in Insert >> Picture?
-
Chart
-
Word Art
-
Graph
-
Clip Art
Correct Answer
A. GraphExplanation
In the Insert >> Picture menu, options like Chart, Word Art, and Clip Art are available for inserting different types of images or visual elements into the document. However, the option for inserting a Graph is not available in this menu.Rate this question:
-
- 30.
Data can be arranged in ascending or descending order by using?
-
Sort command from Table menu
-
Sort command from Data menu
-
Sort command from Tools menu
-
None of these
Correct Answer
A. Sort command from Data menuExplanation
The correct answer is "Sort command from Data menu." This option is the most logical choice because the Data menu typically contains options related to manipulating and organizing data. The Sort command allows users to arrange data in ascending or descending order, which aligns with the question's context. The other menu options mentioned, such as Table menu and Tools menu, are not typically associated with sorting data.Rate this question:
-
- 31.
You learned in the practice that ###### means:
-
You've entered a wrong number.
-
The cell is not wide enough
-
You've misspelled something
-
None of above
Correct Answer
A. The cell is not wide enoughExplanation
The correct answer is "The cell is not wide enough" because when a cell is not wide enough, it means that the content within the cell is too long or too wide to be fully displayed. This can happen when there is a large amount of text or a number that is too long to fit within the cell's width. To solve this issue, the cell width needs to be adjusted to accommodate the content.Rate this question:
-
- 32.
Which of the following is not a document type that the mail merge wizard will work with?
-
Letter
-
Directory Email Message
-
Catalogue
-
Insert Merge Field
Correct Answer
A. Insert Merge FieldExplanation
The Mail Merge Wizard in Microsoft Word helps users create documents like Letters, Directory, Email Messages, and Catalogues by merging data from a data source (like an Excel spreadsheet or Outlook contacts) into a Word document template. However, "Insert Merge Field" is not a type of document. Instead, it is a feature within the Mail Merge process that allows users to add fields (such as names, addresses, etc.) to a document. This makes "Insert Merge Field" the correct answer, as it is a command used within the mail merge process rather than a document type that the wizard works with.Rate this question:
-
- 33.
Which of the following component displays the contents of active cell?
-
Name box
-
Formula bar
-
Menu bar
-
Status bar
Correct Answer
A. Formula barExplanation
The formula bar displays the contents of the active cell. It is located above the worksheet and shows the formula or value that is currently entered in the selected cell. This allows the user to view and edit the contents of the cell easily.Rate this question:
-
- 34.
Maximum font size of MS Word is?
-
72
-
1638
-
512
-
1024
Correct Answer
A. 1638Explanation
The maximum font size in MS Word is typically 1638. This size allows for larger and more visible text, which can be useful for certain purposes such as headings or titles. It is important to note that the actual maximum font size may vary depending on the version of MS Word being used.Rate this question:
-
- 35.
How to remove all character format ?
-
Ctrl + Spacebar
-
Shift + Spacebar
-
Shift + Enter
-
Ctrl +Enter
Correct Answer
A. Ctrl + SpacebarExplanation
Pressing Ctrl + Spacebar removes all character formatting in a document. This keyboard shortcut is commonly used to revert any applied formatting, such as font style, size, and color, back to the default formatting. It is a quick and convenient way to ensure consistent and uniform formatting throughout the document.Rate this question:
-
- 36.
What will the "New Window" button on the 'View' Ribbon do?
-
Create a new window with the default starting template for Word 2010
-
Create a new window with the same content as the present window which can be used for 'side by side' view
-
Create a new window with a new blank document
-
Save the current document and open its read-only version again
Correct Answer
A. Create a new window with the same content as the present window which can be used for 'side by side' viewExplanation
The "New Window" button on the 'View' Ribbon will create a new window with the same content as the present window. This new window can be used for 'side by side' view, allowing the user to view and work on different parts of the document simultaneously.Rate this question:
-
- 37.
In H2O, figure 2, appears lower Which effect has been applied?
-
Lowered
-
Superscript
-
Subscript
-
Laid down
Correct Answer
A. SubscriptExplanation
Subscript is a text formatting option where the characters are positioned slightly below the normal text line. In the chemical formula H2O, the "2" is subscripted, indicating that there are two atoms of hydrogen for every one atom of oxygen in a water molecule. This formatting is commonly used in chemical formulas, mathematical expressions, and other contexts where characters or numbers need to be displayed in a lower position relative to the baseline.Rate this question:
-
- 38.
What is meant by Drop Cap ?
-
Small Cap
-
All Caps
-
Title case
-
None of the above
Correct Answer
A. None of the aboveExplanation
The given options do not accurately define what a drop cap is. A drop cap is a decorative element typically used at the beginning of a paragraph or chapter in a book or magazine. It is a large capital letter that "drops" down multiple lines, often taking up several lines of text. It is used to visually enhance the appearance of the text and make it more visually appealing.Rate this question:
-
- 39.
To select multiple non-adjacent cells in a worksheet you will click them holding?
-
Ctrl+Shift key
-
Shift Key
-
CTRL key
-
ALT key
Correct Answer
A. CTRL keyExplanation
To select multiple non-adjacent cells in a worksheet, you will click them while holding the CTRL key. Holding the CTRL key allows you to select individual cells or ranges of cells that are not adjacent to each other. This is a common shortcut used in spreadsheet software to quickly select specific cells without selecting all the cells in between.Rate this question:
-
- 40.
USB stands for ________.
-
UNITED SERIAL BUS
-
UNIVERSAL SERIOUS BUS
-
UNIVERSAL SERIAL TRAIN
-
UNIVERSAL SERIAL BUS
Correct Answer
A. UNIVERSAL SERIAL BUSExplanation
The correct answer is "UNIVERSAL SERIAL BUS". USB stands for Universal Serial Bus, which is a standard connection interface used to connect devices to a computer. It is a widely used technology for connecting peripherals such as keyboards, mice, printers, and external storage devices to a computer.Rate this question:
-
- 41.
With which chart type(s) is the "Depth Gridlines" option available?
-
Bubble chart
-
Line chart
-
True 3D chart
-
All of the above
Correct Answer
A. All of the aboveExplanation
The "Depth Gridlines" option is available with all of the mentioned chart types: Bubble chart, Line chart, and True 3D chart. "Depth Gridlines" are used to display gridlines in the depth (Z) direction of the chart, providing a visual reference for the data points in 3D space. This feature can help in better understanding the position and relationships of data points within the chart.Rate this question:
-
- 42.
Short cut to insert current date in word?
-
Ctrl+d
-
Alt+shift+d
-
Ctrl+shift+d
-
Shift+d
Correct Answer
A. Alt+shift+dExplanation
The correct answer is alt+shift+d. This keyboard shortcut allows users to quickly insert the current date in Microsoft Word. By pressing alt+shift+d, the current date will be automatically inserted into the document at the cursor's location. This shortcut can save time and ensure that the date is accurately recorded in the document without the need to manually type it out.Rate this question:
-
- 43.
What is the shortcut Key of Paste Special?
-
Alt + V
-
Ctrl + V
-
Ctrl + Shift +V
-
Shift + V
Correct Answer
A. Ctrl + Shift +VExplanation
The shortcut key for Paste Special is Ctrl + Shift + V. This combination of keys allows the user to paste content in a special format or with specific options, such as formatting, values, or formulas, depending on the software being used. The other options listed (Alt + V, Ctrl + V, Shift + V) are not the correct shortcut keys for Paste Special.Rate this question:
-
- 44.
What view must be used when inserting a subdocument?
-
Print Layout
-
Web Layout
-
Outline
-
Full Screen Reading
Correct Answer
A. OutlineExplanation
When inserting a subdocument, the most suitable view to use is the "Outline" view. This view allows for a structured and organized approach to inserting subdocuments, as it provides a clear overview of the document's hierarchy and structure. In the Outline view, users can easily navigate through different levels of headings and subheadings, making it convenient to insert and manage subdocuments within the main document.Rate this question:
-
- 45.
What is name box used for?
-
To name a cell
-
To create a new sheet in the workbook
-
To jump to a cell
-
To rearrange the names of the cells automatically after adjustments
Correct Answer
A. To jump to a cellExplanation
The name box in Excel is used to jump to a specific cell in a worksheet. By entering the cell reference or name in the name box and pressing Enter, the cursor will move to the desired cell. This feature allows users to quickly navigate to different cells within a large spreadsheet without the need for scrolling or using the arrow keys.Rate this question:
-
Quiz Review Timeline (Updated): Feb 7, 2025 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Feb 07, 2025Quiz Edited by
ProProfs Editorial Team
Expert Reviewed by
Godwin Iheuwa -
Feb 05, 2015Quiz Created by
Intranetcomputr