True, the computer will read from, say, a blu-ray and then transfer it to your RAM to before writing it to your hard drive and then, through the various other wonders of computers, it can be displayed on your monitor.
The option that shows how Excel recognize as a date is February 6 1947.
<h3>How does Excel see date?</h3>
The Excel date is often seen as a regular number that is said to have been formatted to often look like a date.
One can you change the cell format to 'General' so that one can see the type of date serial number. Most times, the integer portion of the date serial number stands for the day, and the decimal portion stands for the time.
Read more about Excel from
brainly.com/question/25879801
Answer:
a. =IF(H4>0,12*$D$5-J4,0)
Explanation:
a. =IF(H4>0,12*$D$5-J4,0)
If( H4>0 is the logical test,
12*$D$5-J4 is [value_if_true]
0 is [value_if_false]
b. Referencing to the above formula in (a), which is the required formula which should be typed in cell K4.
Absolute referencing of cell D5 means that this will not change while extending this formula to the entire column. Whereas, since cell H4 and J4 have relative cell referencing, these will change relatively as we extend the formula to the entire column.
Please give brainiest. It would make my day.
Answer:
to get the customer name for order 1004, the formula is: =VLOOKUP(1004,B5:F9,4,FALSE) //
