EXCEL_Unit 1 - 2 Introduction and Formatting Flashcards
Why care about formatting
2 notes
- Communicate more eff.
- Percieved as professional
Which tab on the ribbon will provide the most common formattting
Home Tab
True or false
The number Formatting option changes only the how a numer looks; There is no effect on the value that is stored
True
What two monetary formats does Excel suppport?
- Currency Format
- Accouinting Format
How is Currency Format shown?
- Currency symbol ($) is to the immmediatle LEFT of value
- Negative sign (-) to the LEFT of value
- $0.00 - how to write zero
How is Accounting Format Shown?
- Currency symbol ($) is on the LEFT EDGE of the column
- Negative numbers written in parenthsis - ex. (10.55)
- — = how to write zero
You entered a value that is far larger than the cells visable size
What will the cell return after youve entered the value?
”#######” - Hashmarks indicate that the cell is not wide enough to display the digits in the number
In Excel, are Dates and Times are stored as texts or numbers? and Why?
Numbers - you are able to apply diff formats w/o affecting the values
Short Date Format
mm/dd/yyyy
Long Date Format
Day, Month, Year - written out fully
What will happen if Excel does not recognize the time you want to enter?
Excel will respond with a text format entered into the cell
you merged multiple cells
what would the entire area be represented by?
Retails only the content and cell reference of the cell in the top left corner
There are 4 conditional Formating formats
What are they ?
- Data bars
- Highlighting
- Color Scales
- Icon Sets
This Tool appears after selecting a range of cells to provide the most c
What is this tool?
The Quick Anaysis Tool
What can you use in Excel to reproduce the format settings in one area to another area?
The Format Painter Tool
