TYPES OF CELL REFERENCES

THE SIMPLEST OPERATIONS IN EXCEL. TYPES OF CELL REFERENCES AND THEIR USE IN VARIOUS ANALYSIS PROBLEMS.

Cosa c’è su questa ruota (17 opzioni)

  • 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?

Continua a girare