Close Menu
Login
(Sponsored by Sir Tauqeer)
Join Sir Tauqeer Whatsaap group
(Sponsored by Sir Tauqeer)
Join Sir Tauqeer Whatsaap group
(Sponsored by Sir Tauqeer)
Join Sir Tauqeer Whatsaap group
By Computer Mcqs Microsoft Excel Mcqs PAST PAPERS PPSC Canal Patwari Past Papers 2023 MCQs PPSC PAST PAPERS No Comments

How do you display current date and time in MS Excel ?

A. Date()
B. Year()
C. Now()
D. Time()

Submitted by: Areesha Khan

Advertisement

To display the current date and time in MS Excel, type the formula =NOW() into a cell; this will automatically update to show the current date and time whenever the spreadsheet is recalculated.
Key points:
Function: Use the “NOW” function.
Shortcut: You can also quickly insert the current date by pressing “Ctrl + ;” and the current date and time by pressing “Ctrl + Shift + ;”.

Related Mcqs:

  1. Which key is used to enter the current date in Excel?
    A. Ctrl+: B. Ctrl+; C. Ctrl+Shift+: D. Ctrl+Shift+; Submitted by: Muhammad Danish...
  2. ____________ is the shortcut key to display active cell in Excel.
    A. Shift + Backspace B. Ctrl + Backspace C. Alt + Backspace D. None Submitted by: Muhammad Danish...
  3. In Excel which key is used to open the excel formula window?
    A. Shift+F6 B. Shift+F3 C. Alt+Shift+F3 D. Alt+Shift+F6 Submitted by: Muhammad Danish...
  4. In Excel which key is used for format number in date format?
    A. Ctrl+Shift+6 B. Ctrl+Shift+4 C. Ctrl+Shift+3 D. Shift+1 Submitted by: Muhammad Danish...
  5. In Ms Excel Ready made templates are available under _______ tab ?
    A. File B. Insert C. Design D. None of Above Submitted by: Ali Mallah...
  6. ________________________ is not a valid data type in excel?
    A. Number B. Label C. Character D. none...
  7. Which shortcut key is used for calculating current sheet in Ms Excel?
    A. Ctrl+F9 B. Shift+F9 C. F9 D. F7 Submitted by: Imran...
  8. Which of these key are used in ms excel to insert current time In workbook.
    A. Ctrl + Shift + ; B. Ctrl+! C. Ctrl+* D. None of these Submitted by: Angaiz Gill...
  9. Excel displays the current cells address in the __________?
    A. Formula bar B. Status bar C. Name box D. Title bar Submitted by: IJAZ UQAAB...
  10. What are the small squares arranged in rows and columns called in Excel?
    A. Cells B. Columns C. Blocks D. Rows Submitted by: Areesha Khan...
Advertisement

The correct answer to the question: "How do you display current date and time in MS Excel ?" is "Now()".

Share.
Leave A Reply

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

The reCAPTCHA verification period has expired. Please reload the page.