Excel Functions | MCQs

Explanation

The DATEDIF() function is used to get days, months, or years between two dates.

Syntax: =DATEDIF (start_date, end_date, unit).

Additional information:

 DATEDIFF()

The DATEDIFF() function returns the difference between two dates.

Syntax. DATEDIFF(interval, date1, date2).

*

DAYSBETWEEN

The daysBetween function takes startDateValue and endDateValue 

Syntax. daysBetween( date1 , date2 ).

Explanation

Transpose (rotate) data from rows to columns or vice versa.

To use options from the Paste Special box, click Home > Paste > Paste Special > Transpose

Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK

Explanation

=SUM(A1:A5)/(10-10) is not calculated in excel because 10-10 is zero so something divided by zero is not defined in the excel function.

***

ND18-1-2023

****

RY17-012-23

Explanation

The quickest way to select a range of data on your worksheet is to use Ctrl+Shift+8.

Explanation

The COUNT function in Excel is used to count only numeric values in a specified range.

It ignores text and blank cells.

Unlike COUNTA which counts all non-empty cells.

Explanation

The process of passing something through a filter. Something that passes through a filter.

**** 

RY19012023

Explanation

The Excel FACT function returns the factorial of a given number. For example, = FACT(3) returns 6, equivalent to 3 x 2 x 1. FACT(0) + FACT(3) + FACT(5) = 1 + 3 x 2 x 1 + 5 x 4 x 3 x 2 x 1 FACT(0) + FACT(3) + FACT(5) = 1 + 6 + 120 FACT(0) + FACT(3) + FACT(5) = 127

Explanation

ALT is not a valid function in MS EXCEL

'Alternate' is the full form of Alt on the keyboard of the computer.

while 

The SUM () adds individual values, cell references or ranges, or a mix of all three 

The MAX Function[1] is categorized under Excel Statistical functions. 

MIN will return the minimum value in a given list of arguments.

Explanation

Explanation

The SUMIF function is a premade function in Excel, which calculates the sum of values in a range based on a true or false condition.

The condition is referred to as criteria , which can check things like: If a number is greater than another number >

***

RY24012023