Microsoft | MCQs

Explanation

An array formula is a formula that can perform multiple calculations on one or more of the items in an array.

We can think of an array as a row of values, a column of values, or a combination of rows and columns of values.

Array formulas can return either multiple results or a single result.

Explanation

Microsoft Word is commonly used to create CVs (Curriculum Vitae) due to its text formatting, templates, and ease of use.

Other options like Adobe Photoshop might be used for more graphic-heavy CVs, but Word is the standard.

Explanation

To exit Microsoft PowerPoint, clicking the "X" button at the top-right corner of the window will close the application.

This action properly exits the program.

Explanation

 The MS Access report object is primarily used to display and print formatted data from tables or queries in an organized and visually appealing manner.

It's not used for data entry or editing like forms.

Explanation

Minimize (collapse) or restore the ribbon. (CTRL+F1)

Display the shortcut menu for the selected item. (SHIFT+F10)

Move the focus to select the active tab, your Word document, task pane, or status bar. (F6)

Explanation

Bill Gates is the co-founder of Microsoft and philanthropist.

Bill Gates belongs to USA.

Bill Gates was conferred upon Hilal-e-Pakistan on February 17, 2022

Explanation

 "Window 2007" is a common way to refer to Windows Vista, 

It is the version of the Windows operating system released by Microsoft in 2007. 

Windows Vista: This operating system was a major release of the Windows NT family,

Released to manufacturing on November 8, 2006, and internationally on January 30, 2007. 

Explanation

A hyperlink in a MS Word document is a link that allows you to click and jump to another location or document, such as:

• A website URL
• An email address
• A file on your computer or network
• A specific location within the same document
• A different document or file

Explanation

The AVERAGEIF function returns the average of cells in a range that meet the criteria you provide.

****

ND20-1-2023

Explanation

Arfa Karim became the youngest Microsoft Certified Professional (MCP) in 2004.

Arfa Karim died on 14 January 2012.

Arfa Karim belonged to Pakistna.