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

Excel uses three types of references:

1. Relative
2. Absolute
3. Mixed

These determine how cell references adjust when formulas are copied across cells.

Explanation

A column chart is ideal for comparing the performance of two employees in 2021 because it allows for a side-by-side comparison of their performance metrics, such as sales, productivity, or revenue.

Pie Chart: Shows how different components contribute to a whole.

Dot Chart: Displays a small number of data points.

Column Chart: Compares performance metrics side-by-side.

Line Chart: Shows trends over time.

Explanation

The formula evaluates as:

(7-3)×(4+3)/4 = 4×7/4 = 28/4 = 7.

Explanation

Pie charts

• Pie charts are used to show parts of a whole.

• Specifically, pie charts illustrate meaningful relationships between percentages or parts of 100%.

• If the data that we want to display adds up to 100%, a pie chart is the best choice.

• When creating a pie chart, the description of each section is called the category, and the number connected to the category is called the value.

Explanation

Data can be transferred between worksheets using linking or referencing formulas.

Explanation

In Excel, Texture describes a background that appears as a grainy, non-smooth surface.

This tab shows a number of different surface textures that can be used to fill in the drawing object.

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, you can use the horizontal and vertical scroll bars to view different rows and columns in a worksheet.

The scroll bars are located on the right side and bottom of the Excel window, respectively.

• The vertical scroll bar allows you to scroll up and down to view different rows.
• The horizontal scroll bar allows you to scroll left and right to view different columns.

Explanation

• Excel 2024 is the latest standalone/perpetual version.
• It is part of Microsoft Office 2024.
• It includes updated data analysis and charting features.

Last update 0n 21-07-2026 by NA