FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Excel 2016 will treat “October” as a
A
Date
B
Text string
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -The DATEVALUE function in Excel converts a date in the text format to a serial number that Excel recognizes as a date. So, the formula to convert a text value to date is as simple as =DATEVALUE(A1), where A1 is a cell with a date stored as a text string.

Detailed explanation-2: -Select the cell with the formula, press F2, and then press ENTER. The cell displays the value. In the same cell, click Cells on the Format menu. The cell format category will be Text.

Detailed explanation-3: -Strings are blocks of text that appear in Excel, like names of people, names of cities, e-mail addresses, or names of items sold in a store. When we type strings into Excel, we always use quotation marks around them to tell Excel that what it’s about to read is one coherent block of text.

There is 1 question to complete.