28. In Excel, a cell can contain what types of data? 29. What a range reference?
ID: 3920492 • Letter: 2
Question
28. In Excel, a cell can contain what types of data? 29. What a range reference? Explain with some examples 30. What is an Adjacent Range? 31. Describe what dates are. 32. What are the reason(s) why ###### are displayed in a cell instead of a value? Explain 33. A blinking border around a range indicates what? 34. a. The first character that you type in a cell to represent a formula or a math's expressi b. Write 3 examples of a math expression or formula in Excel 35. Explain what happens when you copy and paste a formula.Explanation / Answer
28) Cell can have 3 types of data: labels, values, and formulas. Labels are descriptive information, values can take any values such as text, numeric, date,etc and formula is mathematical expression defining values that cell can take.
29) Range reference it the set of values from a set of columns that a particular cell can have. E.g. cell E10 can refer D5 to D15.
30) When range reference of cell is the adjacent cell or column range then its called adjacent range.
31) Date is a built-in function which can be entered within a formula to access data utilities in the different formats.
32) Excel displayes #s when cell value exceeds 256 characters. Cell value is converted to text and #s are inserted to indicate value is too long to be held in the cell.
33) Blinking border indicates that selected range is active at that point of time which can also be copied and will be cleared if ESC is pressed.
34)
a) '=' is typed to represent a formula.
b)
= SUM(A1,A2) Sum A1 and A2
= COUNT(H2:H10) Count numbers in the range H2-H10
= DAYS(D4,D5) Calculate number of days between dates in the cells D4 and D5
35) Copy pasting the cell with formula to another cell doesn't copy the value in the cell instead it copies the formula and everytime it is pasted, only the formula is pasted not the value.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.