Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Beginners Excel
Resolved · Low Priority · Version Standard
Patrick has attended:
Excel Introduction course
What are the function buttons again (i.e. F1, F2, F3 etc.)
Hi Patrick how are you
the usage of the function keys is a good question and your answer is as follows
F1 = help, F2 = edit cell or formula
F4 = to insert dolloar signs (absolute ref)
F5 = go to window for navigation
F7 = will start a spell check
F9 = update field or cell data
F11 = Insert chart from selected cells
F12 = will open up the save as window
hope this helps you Patrick
Mark East
|
Excel tip:Counting BlanksSome times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted. |
We'll call during UK business hours
Server loaded in 0.08 secs.