after figuring out how to create discrete distribution without coding macros, filling in bins of data using frequency, i've found out how to do:
- fill a range of data for cumulative prob in one key! use ctrl+d to fill a selected range down a cell or ctrl+r to fill a selected range to the right of a cell (okay, that's 2 keys.)
- construct a chart in one key! select the data range, use ctrl+f11
- ctrl+page up/down moves to previous/next sheet in the same workbook (i so need this.)
Other trivial keys:
- ctrl+shift+& applies the outline borders to a cell
- ctrl+shift+_ removes those borders. (you can imagine me holding on to ctrl+shift and playing between & and _ =p)
- ctrl+shift+F or ctrl+1 opens the format cell options with font tab; i need this to do the subscript and superscript. the ise laptop kings guo jun and jordan once taught me the shortcut keys to subscript and superscript - but yes, it slipped the mind of miss scatterbrain. grrs.
i want to find the shortcut keys for:
subscript/superscript as mentioned;
left/centre/right/justified alignment
merge cells
(and/or) wrap text
(maybe) apply inside borders for the numerous tables for the problems i'm creating too.
(back to simulation assignment. wish me luck, i so need it.)
No comments:
Post a Comment