ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

Which function will you use to enter current time in a worksheet cell?

A) =today()

B) =now()

C) =time()

D) =currentTime()

user-image
تم إضافة السؤال من قبل FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials
تاريخ النشر: 2015/05/14
Muhammad Kabeer Ud Din
من قبل Muhammad Kabeer Ud Din , Trainee Engineer , pakistan machine tool factory

i thinkC is the answer.....

Ahmed Maher allam
من قبل Ahmed Maher allam , Senior IT Consultant , CBK - G&D - AXIS-olutions

=now() ."......".........."........

مستخدم محذوف‎
من قبل مستخدم محذوف‎

=now() enters the current date and time

=time(h,m,s) will enter e.g.10:10 AM

=timevalue()12:00 PM would be0.5 as it is half a day

 

So C) is the correct answer

 

I like the Control + Shift + : works well, and is a stable consistent time.

 

Azharuddin Mohammed Khaja
من قبل Azharuddin Mohammed Khaja , FINANCE & ADMINISTRATION EXECUTIVE , AIN CORPORATION SECURITY SOLUTIONS INDIA PVT LTD

In order to enter current time in a worksheet cell, use CTRL+SHIFT+; (semicolon).

qasim ali
من قبل qasim ali , IT specialist , Pakistan Punjab Police

use CTRL+SHIFT+; (semi-colon) to enter the current time in a cell

 

Mohammed Kaleem Uddin
من قبل Mohammed Kaleem Uddin , Product owner , Wells Fargo

Now() function. Current date and current time is displayed into the selected cell.

FITAH MOHAMED
من قبل FITAH MOHAMED , Financial Manager , FUEL AND ENERGY CO for transportion petroleum materials

B) >>>>>>>>>>>>>>>>>>>>=now()

Pankaj Singh- CMRP
من قبل Pankaj Singh- CMRP , Senior Reliability Engineer , Marafeq Qatar

C-time  is the right answer

The function that you will use to enter current time in a worksheet is time value

Yash Singh
من قبل Yash Singh , Nothing , Nothing

Answer would be B: =now() because its so the current time and the date on the worksheet cell

المزيد من الأسئلة المماثلة