18. Define and explain each of the following key terms/concepts of a Spreadsheet
ID: 3920472 • Letter: 1
Question
18. Define and explain each of the following key terms/concepts of a Spreadsheet: What is a Excel? 19. a. define and explain a cell. b. define and explain a cell reference 20. a. define and explain a worksheet. b. Explain how you will copy and/or move worksheets 21. a. define and explain a workbook. B. New workbooks contain how many sheets by default? 22. a. Define and explain a formula in Excel. b. Explain the formula bar. What displays here? 23. Define and explain a function in Excel 24. Differentiate between absolute (ex. Cell SBS6) and relative (ex. Cell B6) cell references. 25. In MS Excel, what actions are required to edit cell contents directly in a cell? 26. In Excel how do you select an entire row or column? 27. Explain Logical operators. And what is a statistical function? 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 t represent a formula or a math's expressionis 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
Please Note: You have posted more than one Question. I have answered the first 3 questions. Please Post Separate for the other Questions.
Q 18) What is Excel?
Answer)
Excel is software which is developed by Microsoft which allows us to organize data, format data and calculation with formulas. Excel uses the spreadsheet system and is a commercial spreadsheet application, designed to perform basic operations, graphic tools, creation of tables and macros.
Q19) Cell - A cell is the smallest unit of basic storage which is available in a spreadsheet program sheet, and appear like a box like structure.
Cell reference - A cell reference is a reference to the cell which is identified by the rows and columns so that formulas can be used using the data in the cells.
Q20) Worksheet - A worksheet is a single spreadsheet which contains the cell and rows and columns along with numbers.
Copy or move Worksheet - Select worksheet to move or copy. Next, select the Move or Copy Sheet option or click Move or Copy. Select the workbook to move or copy the copied worksheet to.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.