TYPES OF CELL REFERENCES
THE SIMPLEST OPERATIONS IN EXCEL. TYPES OF CELL REFERENCES AND THEIR USE IN VARIOUS ANALYSIS PROBLEMS.
Liczba opcji na tym kole: 17
- 1.What is the file created in MS Excel called?
- 2.What are the main parts of the Excel interface?
- 3.What are the components of the Formula Bar?
- 4.Why is AutoFill (data series) useful?
- 5.What actions are available in the context menu for a cell, row, column, or sheet?
- 6.What is the Format Cells dialog box used for?
- 7.What tabs are included in the Format Cells dialog box?
- 8.Give examples of using conditional formatting.
- 9.How can you copy or remove cell formatting?
- 10.What is the difference between Delete (context menu) and the Delete key?
- 11.What is a formula in Excel?
- 12.How can formulas be entered in Excel?
- 13.What types of operators are used in formulas?
- 14.What are the worksheet view modes and how do you switch between them?
- 15.How can formulas be managed or checked in a worksheet?
- 16.What is a cell reference and what types exist?
- 17.Why are different types of cell references useful?