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

****

SH31-07-23

ND30-4-2023

Explanation

To stop a slideshow in MS PowerPoint, you can press the Esc key on your keyboard.

You can also right-click and select End Show.

Additional information:

F5: Starts the slide show

Ctrl+P: Prints the presentation

Ctrl+S: Saves the presentation

Shift+F5: Starts a presentation from the current slide

Explanation

A computer application program that displays data arranged in rows and columns is called Spreadsheet.

The minimum number of rows and columns in an Ms word document is 1 X 1

***

ND24-1-2023 

Explanation

PPT is the proprietary, Microsoft PowerPoint Presentation binary file format used as the default presentation format for Microsoft Office 97-2003.

ND7-5-2023

Explanation

MS Office is Application Software

Microsoft Office is an example of Horizontal market software.

A feature of MS Word that saves the document automatically after certain interval is available on Save tab on Options dialog box is called Auto Recove

*****

RY17012023

ND10-3-2023

Explanation

In MS Word, the Thesaurus tool is used for synonyms and antonyms.

Shift + F7 is the shortcut key for the Thesaurus tool. 

Explanation

The Change Case feature converts selected text to all capital or small letters, or toggles cases.

Use Shift + F3 as a shortcut.

To apply, select the text, then go to Home > Change case, and choose the desired option, such as Sentence case or lowercase.

Explanation

The default for PowerPoint slides is landscape

Landscape orientation generally refers to the camera's orientation in a horizontal display. 

ND29-5-2023

Explanation

A spreadsheet consists of a table of cells arranged into rows and columns and referred to by the X and Y locations

the columns are normally represented by letters, "A," "B," "C," etc.,

while

rows are normally represented by numbers, 1, 2, 3, etc.

SH31-07-2023

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

****

SH31-07-23

ND30-4-2023