SP | MCQs

Explanation

All important questions about " MS EXCEL"

Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation.

MS-Excel uses the _____ function when creating a data table.

spreadsheet

****

Which of the following functions in Microsoft Excel is used to count items in a cell range?

Count

***

In MS Excel, which function automatically total a column or row of values?

SUM

***

MS Excel's function arguments are always written in----------?

Parenthesis

***

In MS Excel, which function automatically totals a column or row of values?

SUM

****

Columns in MS Excel are called?

Fields

***

Constant value in excel also called?

Number

***

Ctrl +D in MS Excel?

Fill down in the selection

***

Ctrl+R is used in Excel too?

Fill the selection with active cells to the right

***

MOD () function is used in MS Excel to get

Remainder

****

ND30-4-2023

Explanation

• In MS Excel, Conditional Formatting is in the Home tab
• ..
• Apply conditional formatting to text
• Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.
• On the Home tab, click Conditional Formatting.
• Point to Highlight Cells Rules, and then click Text that Contains.
• Type the text that you want to highlight, and then click OK.

• ****

  RY 16-01-2023

Explanation

Formula Bar area in an Excel window allows entering values and formulas.

It is labeled with a function symbol (fx).

By clicking the Formula Bar, or when you type an equal (=) symbol in a cell, the Formula Bar will activate.

Explanation

In MS Excel 2016, you can split the window into two panes using the following steps:

• Go to the "View" tab in the ribbon
• Click on "Window" in the "Window" group
• Select "Split" from the dropdown menu

Alternatively, you can also use the shortcut key:

Alt + W + S

Explanation

Minimum Players required for games/sports

Cricket: 11

Football: 11

Hockey: 11

Basketball: 5

Rugby football: 15

Polo: 4

Water polo: 7

Volleyball: 6

Kabaddi: 7

Snooker: 1

Boxing: 2

Gymnastics: 8

Ice Hockey: 6

Explanation

Summer Olympics 2020: Japan

Winter Olympics 2022: China

Summer Olympics 2024: France

Winter Olympics 2026: Italy

Summer Olympics 2028: USA

Explanation

 The first Winter Olympic Games were held in Chamonix, France from January 25 to February 5, 1924

The event was originally called the "International Winter Sports Week" 

The event was a success, with 10,004 paying spectators and 258 athletes from 16 countries competing in 16 events

**

The first Olympic game was held in Athens on April 6, 1896

*****

Explanation

Know about Hazrat Shoaib (AS)

Born: Midian 

Grave Location: Jordan

Father-in-law of Hazrat Moosa (AS)

Title: Speaker of Prophets 

Sh19-8-2023

Explanation

• On July 16, 1990, Pakistan launched its first satellite, Badr-1 (also known as PRSS-1), into space.
• Pakistan becoming the first Islamic country to venture into space exploration.
• It was launched as a secondary payload on a Long March 2E rocket from the Xichang Satellite Launch Center (XSLC) in China.

Explanation

All important questions about " MS EXCEL"

Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation.

MS-Excel uses the _____ function when creating a data table.

spreadsheet

****

Which of the following functions in Microsoft Excel is used to count items in a cell range?

Count

***

In MS Excel, which function automatically total a column or row of values?

SUM

***

MS Excel's function arguments are always written in----------?

Parenthesis

***

In MS Excel, which function automatically totals a column or row of values?

SUM

****

Columns in MS Excel are called?

Fields

***

Constant value in excel also called?

Number

***

Ctrl +D in MS Excel?

Fill down in the selection

***

Ctrl+R is used in Excel too?

Fill the selection with active cells to the right

***

MOD () function is used in MS Excel to get

Remainder

****

ND30-4-2023