Explanation

 For calculating monthly salary and other expenditures in an office, the most suitable software for the Account Department would be  Microsoft Excel. 

Explanation

An apostrophe before a cell value forces Excel to interpret the value as text.

This is mostly useful for values that look like a number or date.

Explanation

To calculate the average in Excel, you can use the AVERAGE function: 

• Formula =AVERAGE(number1, [number2], …) 
• Arguments: Number1 is required, and Number2 is optional 
• Example =AVERAGE(A1:A20) returns the average of the numbers in the range A1:A20

Explanation

Any process of arranging items systemically

Explanation

Right-click the tab and choose Delete from its shortcut menu in All version of excel.

In Microsoft Excel 2010 onwards Choose Home > Delete > Delete Sheet on the Ribbon, press Alt+HDS

Microsoft Excel 2007 and earlier Press ‘ALT’ + ‘E’, then the ‘L’ key.

***************

vu FIA CBT PAPER 15-12-2021

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

***

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

ND5-2-2023

Explanation

The formula =5 + 2 * 3 follows the order of operations (PEMDAS):

• Multiply 2 and 3: 2 * 3 = 6
• Add 5 to the result: 5 + 6 = 11

Explanation

 Pivot tables are one of Excel’s most powerful features.

A pivot table allows you to extract the significance from a large, detailed data set.

Explanation

Select the Insert tab, then click the Pictures command in the Images group.

A dialog box will appear.

Locate and select the desired image file, then click Insert.

The picture will appear on the currently selected slide.

Explanation

Excel automatically saves changes to a workbook every 10 minutes by default.

the time interval between automatic saves can be changed in Excel's options.