30 multiple-choice questions (MCQs) with answers based on Microsoft Word 2019

 30 multiple-choice questions (MCQs) with answers based on Microsoft Word 2019 for a GCC-TBC typing exam.

 

Basic Operations :-

 

Which shortcut key is used to save a document?

 

a) Ctrl + N

b) Ctrl + S

c) Ctrl + P

d) Ctrl + X

 

Answer: b) Ctrl + S

 

 

What is the default file extension for Word 2019 documents?

 

a) .txt

b) .pdf

c) .docx

d) .xls

 

 

Answer: c) .docx

 

 

Which tab allows you to open an existing document?

 

a) Insert

b) File

c) View

d) Design

 

 

Answer: b) File

 

 

How do you create a new blank document?

 

a) Ctrl + C

b) Ctrl + N

c) Ctrl + P

d) Ctrl + O

 

 

Answer: b) Ctrl + N

 

 

Which command closes the current document without exiting Word?

 

a) Ctrl + Q

b) Ctrl + W

c) Alt + F4

d) Ctrl + E

 

 

Answer: b) Ctrl + W

 

 

Formatting :-

 

Which shortcut is used to make text bold?

 

a) Ctrl + U

b) Ctrl + I

c) Ctrl + B

d) Ctrl + A

 

 

Answer: c) Ctrl + B

 

 

How do you change the font of selected text?

 

a) Home tab → Font group

b) Insert tab → Font group

c) Layout tab → Font group

d) View tab → Font group

 

 

Answer: a) Home tab → Font group

 

 

What is the shortcut for aligning text to the left?

 

a) Ctrl + E

b) Ctrl + R

c) Ctrl + L

d) Ctrl + J

 

 

Answer: c) Ctrl + L

 

 

Which tab contains the Format Painter tool?

 

a) Insert

b) Home

c) Review

d) References

 

 

Answer: b) Home

 

 

How can you apply a predefined style to a paragraph?

 

a) Using the Design tab

b) Using the Styles group in the Home tab

c) Using the View tab

d) Using the Insert tab

 

 

Answer: b) Using the Styles group in the Home tab

 

 

Page Layout :-

 

Where can you change the page orientation?

 

a) Home tab

b) Insert tab

c) Layout tab

d) Review tab

 

 

Answer: c) Layout tab

 

 

What are the options for page orientation?

 

a) Portrait and Horizontal

b) Portrait and Landscape

c) Vertical and Horizontal

d) Vertical and Landscape

 

 

Answer: b) Portrait and Landscape

 

 

How do you add margins to a document?

 

a) Home tab → Paragraph group

b) Insert tab → Text group

c) Layout tab → Page Setup group

d) Design tab → Themes group

 

 

Answer: c) Layout tab → Page Setup group

 

 

Which feature is used to create columns in Word?

 

a) Page Orientation

b) Margins

c) Breaks

d) Columns

 

 

Answer: d) Columns

 

 

What is the shortcut to insert a page break?

 

a) Ctrl + P

b) Ctrl + Enter

c) Ctrl + Shift + N

d) Ctrl + Shift + B

 

 

Answer: b) Ctrl + Enter

 

 

Inserting Objects :-

 

Which tab allows you to insert a table?

 

a) Home

b) Layout

c) Insert

d) Design

 

 

Answer: c) Insert

 

 

How do you add a hyperlink to a document?

 

a) Ctrl + K

b) Ctrl + H

c) Ctrl + J

d) Ctrl + L

 

 

Answer: a) Ctrl + K

 

 

Which of the following cannot be inserted into a Word document?

 

a) Picture

b) Table

c) Video

d) Folder

 

 

Answer: d) Folder

 

 

How do you insert a header into a document?

 

a) File tab → Header

b) Insert tab → Header

c) Design tab → Header

d) View tab → Header

 

 

Answer: b) Insert tab → Header

 

 

Which tab is used to insert a SmartArt graphic?

 

a) Layout

b) Review

c) Design

d) Insert

 

 

Answer: d) Insert

 

 

Review and Proofing :-

 

Which tool checks the spelling and grammar in a document?

 

a) Review tab → Word Count

b) Home tab → Clipboard

c) Review tab → Spelling & Grammar

d) Insert tab → Proofing

 

 

Answer: c) Review tab → Spelling & Grammar

 

 

What is the shortcut for opening the Thesaurus?

 

a) Shift + F7

b) Ctrl + F7

c) Alt + F7

d) Ctrl + Shift + F7

 

 

Answer: a) Shift + F7

 

 

What does the Track Changes feature do?

 

a) Counts the words in a document

b) Tracks edits made to a document

c) Highlights grammatical errors

d) Creates a new document

 

 

Answer: b) Tracks edits made to a document

 

 

How can you accept changes made in Track Changes?

 

a) Click Accept in the Design tab

b) Click Accept in the Review tab

c) Click Accept in the Home tab

d) Click Accept in the Insert tab

 

 

Answer: b) Click Accept in the Review tab

 

 

Which tab contains the Word Count feature?

 

a) Home

b) Review

c) Insert

d) Layout

 

 

Answer: b) Review

 

 

Advanced Features :-

 

How do you protect a document with a password?

 

a) File tab → Options → Protect Document

b) Home tab → Styles → Protect Document

c) File tab → Info → Protect Document

d) Insert tab → Text → Protect Document

 

 

Answer: c) File tab → Info → Protect Document

 

 

How can you insert a watermark in a Word document?

 

a) Layout tab → Watermark

b) Design tab → Watermark

c) Insert tab → Watermark

d) Review tab → Watermark

 

 

Answer: b) Design tab → Watermark

 

 

What is the function of the Inspect Document feature?

 

a) Adds a table of contents

b) Identifies and removes hidden metadata

c) Highlights grammar errors

d) Converts Word documents to PDF

 

 

Answer: b) Identifies and removes hidden metadata

 

 

How do you create a mail merge?

 

a) Layout tab → Mail Merge

b) Insert tab → Mail Merge

c) Mailings tab → Start Mail Merge

d) Home tab → Start Mail Merge

 

 

Answer: c) Mailings tab → Start Mail Merge

 

 

Which feature converts a Word document into a PDF?

 

a) File tab → Save As → PDF

b) Home tab → Export → PDF

c) File tab → Export → Create PDF/XPS

d) Insert tab → Save As → PDF

 

 

Answer: c) File tab → Export → Create PDF/XPS

 

Explain about “Header & Footer” option in Microsoft Word 2019

 

Microsoft Word 2019

1) Header :-

 

The header option allows you to insert and customize a header at the top of each page in your document

 

A)  Inserting a Header:

1.       Click on the "Insert" tab on the Ribbon.

2.       In the "Header & Footer" group, click on the "Header" button.

3.       A drop-down menu will appear with built-in header styles. You can select one of these styles or choose "Edit Header" to create a custom header.

B)  Editing the Header:

1.       Once you have inserted a header, you can double-click inside the header area to activate it for editing.

2.       You can type text directly into the header area, format it using the options in the "Header & Footer Tools" Design tab that appears when the header is selected, and insert elements such as page numbers, date, time, or pictures.

C)  Formatting the Header:

1.       With the header selected, you can use the options in the "Header & Footer Tools" Design tab to format the text and other elements in the header.

2.       You can change the font, font size, font color, alignment, and other formatting options to customize the appearance of the header.

D)  Different Headers for Different Sections:

1.       Word allows you to have different headers for different sections of your document. To do this, you can insert section breaks and then unlink the headers in each section to create unique headers for each section.

E)  Closing the Header:

1.       To close the header and return to the main document, you can double-click outside the header area or click on the "Close Header and Footer" button in the "Close" group on the Design tab.

 

2) Footer :-

 

In Microsoft Word 2019, the footer option allows you to insert and customize a footer at the bottom of each page in your document.

 

A)  Inserting a Footer:

1.       Click on the "Insert" tab on the Ribbon.

2.       In the "Header & Footer" group, click on the "Footer" button.

3.       A drop-down menu will appear with built-in footer styles. You can select one of these styles or choose "Edit Footer" to create a custom footer.

B)  Editing the Footer:

1.       Once you have inserted a footer, you can double-click inside the footer area to activate it for editing.

2.       You can type text directly into the footer area, format it using the options in the "Header & Footer Tools" Design tab that appears when the footer is selected, and insert elements such as page numbers, date, time, or pictures.

C)  Formatting the Footer:

1.       With the footer selected, you can use the options in the "Header & Footer Tools" Design tab to format the text and other elements in the footer.

2.       You can change the font, font size, font color, alignment, and other formatting options to customize the appearance of the footer.

D)  Different Footers for Different Sections:

1.       Word allows you to have different footers for different sections of your document. To do this, you can insert section breaks and then unlink the footers in each section to create unique footers for each section.

E)  Closing the Footer:

1.       To close the footer and return to the main document, you can double-click outside the footer area or click on the "Close Header and Footer" button in the "Close" group on the Design tab.

 

Microsoft Word alignment explained

The primary text alignment options in Microsoft Word 2019 :-

1.  Left Alignment :- Text is aligned along the left margin, creating a straight edge on the right side. This is the default alignment for most documents, as it's the most natural alignment for readers of left-to-right languages like English.

2.  Center Alignment :- Text is centered between the left and right margins of the document. Center alignment is often used for titles, headings, or other elements you want to draw attention to.

3.  Right Alignment :- Text is aligned along the right margin, creating a straight edge on the left side. Right alignment is sometimes used for special formatting purposes or when dealing with right-to-left languages like Arabic or Hebrew.

4.  Justified Alignment :- In justified alignment, text is aligned along both the left and right margins, creating a straight edge on both sides. This alignment option automatically adjusts the spacing between words and characters to make the text fit within the margins. It's often used for professional-looking documents like reports and formal essays.

    You can change the alignment of text in your Word document by selecting the text you want to modify and using the alignment options in the "Paragraph" group on the Home tab of the Ribbon. These options include buttons for left, center, right, justified, and distributed alignment. Simply click on the desired alignment button to apply it to the selected text.

    Remember that the alignment options can be applied to the entire paragraph or individual lines, depending on how you select the text. You can also use these alignment options in combination to create different effects within a single document or paragraph.

About Advanced Excel

 Advanced Excel refers to the more complex and sophisticated features and functionalities available in Microsoft Excel, which is a widely used spreadsheet application. While basic Excel skills involve data entry, simple calculations, and basic formatting, advanced Excel skills enable users to perform more intricate data analysis, create interactive dashboards, automate tasks, and work with large datasets efficiently.

Advanced Excel skills are highly valued in various professions, including finance, accounting, data analysis, business intelligence, and project management, among others. Mastering these features can significantly enhance productivity and decision-making capabilities when dealing with large and complex datasets.

 

Here are some key concepts and features related to Advanced Excel :-

Formulas and Functions :- Advanced Excel involves mastering complex formulas and functions. Users can utilize mathematical, statistical, logical, and text functions to perform advanced calculations and analysis on data.

PivotTables and PivotCharts :- These tools allow users to summarize, analyze, and visualize large datasets quickly. PivotTables enable users to reorganize and summarize data interactively, while PivotCharts offer dynamic and visually appealing chart representations of the data.

Data Analysis Tools :- Excel provides various data analysis tools, such as Goal Seek, Solver, Scenario Manager, and Data Tables, which enable users to perform what-if analysis, optimization, and sensitivity analysis.

Macros and VBA (Visual Basic for Applications) :- VBA is a programming language integrated into Excel, allowing users to automate repetitive tasks and create custom functions and procedures. Macros are scripts recorded in VBA that can be run to automate tasks.

Data Validation :- Advanced Excel users can implement data validation rules to control the type and range of data entered in cells, reducing errors and maintaining data integrity.

Conditional Formatting :- This feature allows users to apply formatting to cells based on specific conditions, making it easier to spot trends, patterns, or outliers in the data.

Lookup and Reference Functions :- Functions like VLOOKUP, HLOOKUP, INDEX, and MATCH enable users to find and retrieve information from different parts of the spreadsheet.

Array Formulas :- Array formulas allow users to perform complex calculations on multiple values at once, enhancing calculation efficiency and reducing formula complexity.

Power Query and Power Pivot :- These are add-ins in Excel that provide advanced data transformation, modeling, and analysis capabilities. Power Query allows users to connect, transform, and load data from various sources, while Power Pivot allows for more robust data modeling and analysis.

Explained Computer Keyboard Function key

 

The function keys (F1 to F12) are a set of keys located at the top row of the computer keyboard that have different functions depending on the software or application being used. Here's a brief explanation of each function key :-

F1: Opens the help menu or help documentation for the active software or application.

F2: Edits the selected cell or object. In Windows, it also renames a file or folder when selected.

F3: Opens the search or find and replace feature in most software and applications.

F4: Repeats the last action performed. In Windows, it opens the address bar in file explorer.

F5: Opens the "Go To" dialog box, allowing you to navigate to a specific cell or location in a worksheet.

F6: Moves the cursor to the address bar in web browsers and file explorer. In Excel, it moves the cursor to the next pane.

F7: Opens the spell-checker in most software and applications.

F8: Activates the extended selection mode in Excel, allowing you to select cells using the arrow keys.

F9: Calculates all formulas in the active worksheet in Excel.

F10: Activates the menu bar in most software and applications.

F11: Creates a chart in Excel.

F12: Saves the current document or file in most software and applications. In Excel, it opens the "Save As" dialog box.

 

These are just some of the common uses of the function keys in most software and applications.

Microsoft Excel 2019 15 basic formulas

 

Here are 15 basic formulas in Excel 2019:

1.   SUM: This formula is used to add up a range of numbers.

Syntax: =SUM(number1,number2,...)

Example: =SUM(A1:A10)

 

2.   AVERAGE: This formula is used to calculate the average of a range of numbers.

Syntax: =AVERAGE(number1,number2,...)

Example: =AVERAGE(A1:A10)

 

3.   MAX: This formula is used to find the largest number in a range.

Syntax: =MAX(number1,number2,...)

Example: =MAX(A1:A10)

 

4.   MIN: This formula is used to find the smallest number in a range.

Syntax: =MIN(number1,number2,...)

Example: =MIN(A1:A10)

 

5.   COUNT: This formula is used to count the number of cells that contain numbers in a range.

Syntax: =COUNT(number1,number2,...)

Example: =COUNT(A1:A10)

 

6.   COUNTA: This formula is used to count the number of cells that contain any type of data (numbers, text, formulas, etc.) in a range.

Syntax: =COUNTA(value1,value2,...)

Example: =COUNTA(A1:A10)

 

7.   ROUND: This formula is used to round a number to a specified number of decimal places.

Syntax: =ROUND(number,num_digits)

Example: =ROUND(A1,2)

 

8.   IF: This formula is used to test a condition and return one value if the condition is true and another value if the condition is false.

Syntax: =IF(condition,value_if_true,value_if_false)

Example: =IF(A1>10,"Yes","No")

 

9.   SUMIF: This formula is used to add up values in a range that meet a specified criterion.

Syntax: =SUMIF(range,criteria,sum_range)

Example: =SUMIF(A1:A10,">10",B1:B10)

 

10.         AVERAGEIF: This formula is used to calculate the average of values in a range that meet a specified criterion.

Syntax: =AVERAGEIF(range,criteria,average_range)

Example: =AVERAGEIF(A1:A10,"Apples",B1:B10)

 

11.         TRIM: This formula is used to remove extra spaces from text.

Syntax: =TRIM(text)

Example: =TRIM(" Apple ")

 

12.         LEFT: This formula is used to extract a specified number of characters from the beginning of a text string.

Syntax: =LEFT(text,num_chars)

Example: =LEFT("Apple",3)

 

13.         RIGHT: This formula is used to extract a specified number of characters from the end of a text string.

Syntax: =RIGHT(text,num_chars)

Example: =RIGHT("Apple",2)

 

14.         LEN: This formula is used to count the number of characters in a text string.

Syntax: =LEN(text)

Example: =LEN("Apple")

 

15.         CONCATENATE: This formula is used to join two or more text strings into one.

Syntax: =CONCATENATE(text1, text2, ...)

Example: =CONCATENATE("John ","Doe")