Excel | MCQs

Explanation

The MS excel worksheet are made up of rows and columns.

In worksheet, intersection of row and column is a rectangle, it is called as cell.

Cells are used to store the numbers, value, text or formula.

Document is not a term of MS excel

Explanation

The purpose of the TRANSPOSE function in Excel is to convert rows to columns,

i.e. switch the orientation of a given range from horizontal to vertical or vice versa.

The function takes just one argument:

TRANSPOSE(array)

Where array is the range of cells to transpose.

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, the "IF" function is used to check the particular condition.

It will return differently depending on whether the result of the condition was TRUE or FALSE.

***

ND18-1-2023 

The correct syntax for an IF statement in Excel is: A =IF(LogicalTest, TrueResult, FalseResult) This syntax states that if the logical test is true, the function will return the TrueResult, and if the logical test is false, the function will return the FalseResult. The other options are not correct.

Explanation

PMT, one of the financial functions, calculates the payment for a loan based on constant payments and a constant interest rate.

Explanation

On the Home tab, in the Alignment group, click Wrap Text.

Notes: Data in the cell wraps to fit the column width, so if you change the column width, data wrapping adjusts automatically.

Explanation

Transpose (rotate) data from rows to columns or vice versa.

To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose

Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK

Explanation

Transpose (rotate) data from rows to columns or vice versa.

To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose

Explanation

The default style for new data keyed in a new workbook is Normal.

Explanation

 press Ctrl ( Control key ) + A together if we want to select all the cells in the document .

This feature is different in MS Word where we need to press Ctrl + A in order to select the entire document .