Summary: It

Study material generic cover image
  • This + 400k other summaries
  • A unique study and practice tool
  • Never study anything twice again
  • Get the grades you hope for
  • 100% sure, 100% understanding
PLEASE KNOW!!! There are just 26 flashcards and notes available for this material. This summary might not be complete. Please search similar or other summaries.
Use this summary
Remember faster, study better. Scientifically proven.
Trustpilot Logo

Read the summary and the most important questions on IT

  • Module 1

    This is a preview. There are 6 more flashcards available for chapter 17/09/2017
    Show more cards here

  • How many worksheets can you keep in Excel?

    Unlimited.
  • What are the two main elements of an excel worksheets?

    Cells and floating objects
  • How many values can a cell hold?

    1.
  • What are the properties of a floating object?

    - They don't have a address, but they do have a name
    - They refer to data in the worksheet, but not the other way around (they get data for a graph, but no cell has data from graph)
  • What are the two main data types in a cell?

    - Text
    - Numbers
  • In which forms can numerical data be presented?

    - Scientific
    - Data
    - Time
    - Plain numbers
    - Money format
  • How do you refer to a cell in a different excel file?

    [file_name]sheet_name!cell_name
  • How do you refer to a cell in a different work sheet?

    'sheet name'!celladdress
  • What are the 3 types of references?

    - Relative (A1)
    - Mixed reference ($A1 or A$1)
    - Absolute ($A$1)
  • What is the rule of precedence?

    That excel calculates from inside to the outside.
PLEASE KNOW!!! There are just 26 flashcards and notes available for this material. This summary might not be complete. Please search similar or other summaries.

To read further, please click:

Read the full summary
This summary +380.000 other summaries A unique study tool A rehearsal system for this summary Studycoaching with videos
  • Higher grades + faster learning
  • Never study anything twice
  • 100% sure, 100% understanding
Discover Study Smart