Flashcards
Spreadsheets basic
Flashcards do conjunto (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
Informações
- Descrição
- FlashCards sobre Spreadsheets basic, criado por mikematty em 16-10-2013.
- Criado por
- mikematty
- Visualizações
- 18
- Avaliação