USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
NOW
|
|
|
COMCATENATE
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -To insert the current date, press Ctrl+; (semi-colon). To insert the current time, press Ctrl+Shift+; (semi-colon). To insert the current date and time, press Ctrl+; (semi-colon), then press Space, and then press Ctrl+Shift+; (semi-colon).
Detailed explanation-2: -Sometimes you may want to insert a date or time whose value is updated automatically. You will use a formula – the “TODAY” and “NOW” functions – to return a dynamic date or time. On a worksheet, select the cell into which you want to insert the current date.
Detailed explanation-3: -To create a date with the current time, use NOW . TODAY will always represent the current date the last time the spreadsheet was recalculated, rather than remaining at the date when it was first entered.
Detailed explanation-4: -The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.
Detailed explanation-5: -The TODAY function syntax has no arguments. Note: Excel stores dates as sequential serial numbers so they can be used in calculations.