Flashcards
Spreadsheet Modelling
Cards in this deck (7)
- 1How to toggle to selection mode & have the typepad behave as though shift was held down?fn + UP + F8
- 2what does hitting fn + up + F5 do?Brings up the Go To box
- 3If you'd like to enter 10.15am, 10.30am and extrapolate so the rest of the day's timeslots is reflected in 15 min increments, what are the two things to look out for?1. Enter the first two times 10.15 am and 10.30 am and then autofill
2. Times must be entered in the following format: 12:30 PM
Any other formats will not be recognized - 4Aside from clicking and dragging, what other ways are there to autofill?Using the Fill Series command
- 5How to create a custom list on Excel?Create a custom list by typing in values
Click the Microsoft Office Button Office button image, and then click Excel Options.
Click the Popular category, and then under Top options for working with Excel, click Edit Custom Lists.
In the Custom Lists box, click NEW LIST, and then type the entries in the List entries box, beginning with the first entry.
Press ENTER after each entry.
When the list is complete, click Add.
The items in the list that you selected are added to the Custom lists box.
Click OK twice. - 6In the game of craps two dice are rolled with a total between 2 and 12 resulting. A 7 or 11 on first roll results in a win, a total of 2, 3 or 12 results in a loss, and otherwise the game continues. Write a formula that returns the game status after the first two dice are rolled.Try on Excel
- 7what excel function to use to convert numbers excel recognize only as text, into a number that is recognisable by excel?1. start a new column
2. use the function =VALUE( )
in the space, place the text u want to convert
Information
- Description
- Flashcards on Spreadsheet Modelling, created by Georgia Tan on 12/09/2015.
- Created by
- Georgia Tan
- Views
- 0
- Rating