Explanation

A Pivot Table in Excel is used to quickly summarize, analyze, explore, and present large sets of data.

It helps in organizing data by categories, totals, averages, and filters without altering the original dataset.

Explanation

The absolute cell reference in excel is a cell address that contains a dollar sign ($).

It can precede the column reference, the row reference or both.

Explanation

A pie chart in MS Excel represents only one value for each variable.

It showing parts of a whole as slices of a circle.

It is ideal for visualizing the proportion of different categories within a dataset.

Explanation

CTRL+SHIFT+F6 Switch to the previous workbook window

Additional information:

CTRL+F7 When a workbook window is not maximized, perform the Move command 

CTRL+F6 When more than one workbook window is open, switch to the next workbook window.

Ctrl+Shift+F12 Prints the current worksheet.

 F7 Displays the Spelling dialog box to check spelling

Explanation

Equal to: =

Not equal to: <>

Greater than: >

Less than: <

Greater than or equal to: >=

Less than or equal to: <=

Explanation

The utility of Excel to fill columns or rows with a series of data is Auto Fill.

It allows users to quickly populate cells with a sequence or pattern based on the initial values entered.

Explanation

In the Format Cells box, click the Number tab. In the Category list, click Date, and then choose a date format you want in Type.

You can adjust this format in the last step below.

Go back to the Category list, and choose Custom.

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

The VLOOKUP function in Excel searches for a specified value in the first column of a table and returns a value from another column in the same row.

The VLOOKUP or Vertical Lookup function is used when data is listed in columns.

Explanation

The vertical dimension of a spreadsheet is called a Column.

Columns run from top to bottom and are identified by letters.

The horizontal dimension of a spreadsheet is called a Row.

Rows run from left to right and are identified by numbers.