Explanation

Explanation

Ms. Excel is a Spreadsheet program

MS Excel is based on WINDOWS

shortcut key in  MS Excell:

which key is used for help in MS excel?

 F1

***

Which is the shortcut key to display active cells in Excell?

Shift+Backspace

**

Which key is used to enter the current date in Excel?

 Ctrl+;

***

Which key is used for the GO TO tab in Ms. Excel?

 F5 

***

Which key is used for excel column highlight?

CTRL + space

****

What is the keyboard shortcut to insert a SUM formula in MS Excel?

 ALT + =

***

The delete key of the keyboard is assigned to which command in excel?

 Edit > Clear > Contents

****

The shortcut key to insert a new worksheet in Excel is _____.

 Shift + F11

****

in excel which key is used to format numbers in comma format?

 shift+1

*****

In Excel which shortcut key is used to go to the formula tab?

 Alt+M

ND11-3-2023

Explanation

In Microsoft Excel, the divide symbol is a forward slash (/).

Explanation

 In MS Excel, the 'Wrap Text' feature is used to wrap extra-long text into multiple lines so that you can see all text.

ND5-2-2023

Explanation

B1*17 is incorrect because it mixes a cell reference (B1) with a direct number (17) in an improper way for a formula. 

Correct formulas should maintain consistent use of cell references or operators.

Explanation

The PMT function in Excel calculates the payment for a loan based on constant interest rates and payments, categorizing it under financial functions.

It uses inputs like rate (C10/12), number of periods (CB), and loan amount (C9) to compute the payment.

Explanation

Line graphs are used to track changes over short and long periods of time.

When smaller changes exist, line graphs are better to use than bar graphs

Explanation

Chart Wizard use to create a chart.

A wizard found in the Microsoft Excel program that takes users step-by-step through the process of creating a chart in Microsoft Excel.

f11 kay used to create auto chart.

********

VU CBT FIA PAPER 16-12-2021

Explanation

A spreadsheet (Excel) is a computer application or program that enables the user to tabulate and collate data.

Explanation

In Microsoft Excel, B2:B6 represents a range of cells.

In Excel, letters and numbers are used as row and column headings to refer to cells.

For example, B2 refers to the cell at the intersection of column B and row 2.