Интерактивная таблица
Excel Exercises - Practice Problem Simulator

1. Number Formatting ShortcutsCOMPLETE2. Cell Selection ShortcutsIN PROGRESS3. COUNT Function4. True & False5. IF Function6. SUM Function7. Arrow Keys8. Wildcard Characters9. SUMIF Function10. SUMIFS Function11. SUM Functions Skill Summary12. SUMIF Practice13. SUMIFS Practice14. COUNTIF Function15. COUNTIFS Function16. COUNT Practice17. COUNT Skill Summary18. AND, OR, XOR Functions19. IS Functions20. IFS Function21. SWITCH Function22. Larger Cell Selections23. Row and Column Selections24. Cell Selection Shortcuts 225. Larger Cell Selections 226. Cell Selection Skill Summary27. VLOOKUP Function28. VLOOKUP Function 229. VLOOKUP Practice30. HLOOKUP Function31. HLOOKUP Function 232. XLOOKUP Function33. XLOOKUP Function 234. MATCH Function35. INDEX Function36. INDEX MATCH Lookup37. INDEX MATCH Practice38. Index Match Skill Summary39. LEN, LEFT, and RIGHT Functions40. MID Function41. LEN, LEFT, RIGHT, MID Practice42. FIND Function43. SEARCH Function44. Intro to Shortcuts45. Text Formatting Shortcuts46. Cut, Copy, Paste47. Data Shortcuts48. AVERAGE Function49. MIN, MAX, LARGE, SMALL Functions50. MIN, MAX, LARGE, SMALL Practice51. FLOOR & CEILING Functions52. DATE Function53. TODAY Function54. DATEDIF Function55. DAYS Function56. DATE Functions Skill Summary57. CONCAT Function58. TEXTJOIN Function59. UPPER, LOWER, and PROPER Functions60. SUBSTITUTE Function61. Pivot Tables 162. Pivot Tables 263. Table Filters64. Tables Skill Summary65. ODD and EVEN Functions66. Worksheets67. Conditional Formatting68. MEDIAN Function69. MODE Function

Cell Selection Shortcuts

0%

Let's try some keyboard shortcuts to quickly select cells. Don't use the mouse!
Hold Shift and press ➡ to select multiple cells


ABCDEFGH
1
2Select meMe too!
3
4
5
6
7
8
Skip this question


Today's High Scores ????
1. Lyu 18702
2. daotumi 8060
3. danieljcrabtree 7999
My Points Today: 125
Earn points and help your colleagues learn Excel! Share ExcelExercises on LinkedIn for 500 extra points!

Today's High Streaks ????
1. udbhav_rohatgi 5 days
2. SUPERXOXETE 4 days
3. gowda 4 days
My Streak Today: 1
Complete a lesson tomorrow to increase your streak!



Made on
Tilda