Flashcards
Spreadsheets basic
Cards in this deck (12)
- 1What two keys do you operate to "show formulas"Ctrl + "Alice" known as the Tilde button
Also choose Formulas Tab
& "Show formulas" - 2How do you format the date as Tuesday 16-Dec-2013dddd- dd-mmm-yyyy
- 3What icon do you select if you want to clone the format for a cellFormat Painter
- 4How can you launch the Format dialogue box?
- 5What is the generic formula for a total or sum?=sum(range)
- 6What formula inserts the current date and time into a cell?=NOW()
- 7What function key do you select to refresh the worksheetF9
- 8What function key do you select to do a spell check?F7
- 9How do you insert a "Thousand separator"?
- 10Name an "Inclusive" FontArial, Calibri, Verdana, Tahoma, Comic Sans MS
(BDA) - 11What can you do to force people to only input what you want?Data Validation
NOT
Condition Formatting - 12What can you do to a rage of cells that changes the colour of the contents when data is entered?Condition Format
Information
- Description
- Flashcards on Spreadsheets basic, created by mikematty on 16/10/2013.
- Created by
- mikematty
- Views
- 18
- Rating