Summary: It
- 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
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.
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding