I 21. a. define and explain a workbook. B. New workbooks contain how many sheets by...

Transcribed Image Text:

I 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 SB$6) 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? I 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 SB$6) 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?

Answer rating: 100% (QA)

A1 A workbook is a collection of spreadsheets also known as worksheets that are used to store and organize data A workbook contains one or more worksh... View the full answer