Find the best answer
Docx
Pptx
Exls
Xlsx
Ctrl + F2
Alt + F2
Shift + F2
Ctrl + Alt + F2
Formula Tab --> within Function Library group
Formula Tab --> within Defined Named group
Insert Tab --> within Function Library Group
Insert Tab --> within Defined Named group
=DATE(NOW)
=DAY(NOW)
=NOW()
=(DATE)
365
364.7
364
364.6
=CONSOLIDATE()
=CONCATENATE()
=TRIM()
=MID()
IV, 65536
XFD, 1048576
Unlimited
ZZZ, 999999
=SUMIF(D4:D10,">600")
=ROUNDUP(C2/C3,1)
=IF(AVERAGE(B3:B6)>25,SUM(B3:B6),0)
=LEFTS(D4)
$
&
%
#
True
False
Not good
Good
Not valid
No result appear
SUM(), LEFT(), DSUM()
FV(), CONCATENATE(), NOW()
FV(), NPV(), PV()
DAY(), Now(), Today()
Name of cell reference
Name of worksheet
Absolute reference
One of function in math and trig