Formula | MCQs

Explanation

Explanation

Initialize a formula in an excel cell using the = (equals to) sign. The value of 2^3 stands for 23, which results in a value of 8. The 16 is divided by 23, which equals 16/8, and that results in a value of 2.

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

Explanation

• Basic functions formulae (SUM, AVERAGE, COUNT, MAX & MIN)
***

• The Average function calculates the average, or arithmetic mean, of its arguments.
• The Max function finds the maximum value.
• The Min function finds the minimum value.
• The Sum function calculates the sum of its arguments.
  
  

Explanation

The formula for the number of possible communication channels in a round table meeting is: n(n-1)/2.

Explanation

Name Box refers to an input box directly to the left of the formula bar.

The Name Box normally displays the address of the "active cell" on the worksheet.

You can also use the name box to quickly create a named range.

Explanation

Note: Formula Bar is only present in MS-Excel not MS-Word. 

Explanation

An array formula is a formula that can perform multiple calculations on one or more of the items in an array.