Which function in MS Excel is used to show the current date and time?

Computer Mcqs for PPSC, FPSC, NTS, and Pakistan government job tests. Select an option below, then read the explanation.

PPSCFPSCNTSPakistan govt jobs
Subject
Computer Mcqscomputer-mcqs
Published
10 Feb 2025
Last updated
28 May 2026

Browse all Computer Mcqs

Choose the correct answer

Explanation

To display the current date and time in Excel, enter the formula =NOW() in a cell. This function updates automatically whenever the worksheet recalculates. Note that pressing "Ctrl + ;" inserts the current date, while "Ctrl + Shift + ;" inserts the current time.

SolveExam — free MCQs and past papers for Pakistan government job tests. Content is for educational practice only.