Excel Exercise
RSS
Learning Excel
1-Excel Keywords
2-First Calculation
3-Number Format
4-Formula with cell reference
5-Function SUM
6-Copy Paste
7-Reference with Dollar
8-Fill Series
9-Quiz for beginner
Quizzes
Quiz Excel for Beginners
Quiz Excel for Advanced Users
Quiz Excel for Expert Users
Quiz Excel Keywords
Quiz Excel Shortcuts
Exercises
Functions
Tips and Tricks
Pivot Table
French
Most Viewed Posts
Displaying Negative Numbers in Parentheses – Excel
(260,220)
How to make automatic calendar in Excel
(160,740)
Dash for 0 in Excel
(132,732)
Convert YYYYMMDD to DD/MM/YYYY
(116,809)
Date Format in Excel
(112,679)
Excel Split Date and Time
(90,870)
How to calculate VAT in Excel?
(88,666)
Exchange rate in Excel
(80,633)
UNIQUE Function – Remove duplicates with formulas
(67,384)
Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde
(63,487)
Quiz Excel Shortcuts
Do you know some tricky Excel shortcuts?
Start
<<
1
2
3
4
5
6
7
8
9
10
>>
1.
Which shortcut allows you to add dollars to your references?
1.
F4
2.
F2
3.
F8
4.
SHIT + F3
2.
Which shortcuts open a new workbook?
1.
ALT + N
2.
CTRL + N
3.
ALT + CTRL + N
4.
CTRL + SHIFT + N
3.
Which keyboard shortcut allows you to select the entire column where the active cell is located?
1.
CTRL + SPACE
2.
CTRL + ALT + C
3.
CTRL + SHIFT + C
4.
SHIFT + F5
4.
Which shortcuts select the entire row?
1.
SHIFT + SPACE
2.
CTRL + SPACE
3.
CTRL + SHIFT + R
4.
ALT + SHIFT + R
5.
Which shortcuts insert the day of today in a cell? The date as value, not the function TODAY()
1.
CTRL + D
2.
CTRL + ;
3.
CTRL + :
4.
CTRL + SHIFT + D
6.
Which shortcut allows you to edit the content of a cell?
1.
F2
2.
F8
3.
F12
4.
F4
7.
Which shortcut autocompletes a formula?
1.
ALT + RIGHT ARROW
2.
SHIT + TAB
3.
TAB
4.
CTRL + SHIT + A
8.
Which shortcuts paste in values? (Available only with Excel 365)
1.
CTRL + SHIFT + C
2.
CTRL + ALT + V
3.
SHIFT + C
4.
CTRL + SHIFT + V
9.
Which shortcut removes the borders?
1.
Ctrl + ]
2.
Ctrl + 9
3.
Ctrl + [
4.
Ctrl + Shift + -
10.
What is the shortcut to open the dialog box "Save As"?
1.
CTRL + SHIFT + S
2.
ALT + S
3.
F12
4.
SHIFT + S
Your email address:
Your name:
Loading...
Recent Posts
Move a cell with the mouse in Excel
Excercise for beginners: Create a drop-down menu
Excercise for beginner: Create an Invoice with Excel
Exercise for beginners: functions SUM, MIN, MAX Excel
Exercise for beginners: Dollars in Excel Formula
{"mobile_concate":{"mobile-menu":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/mobile-menu.min.css"},"tf_base":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/css\/base.min.css","v":"7.1.1"},"themify_common":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/css\/themify.common.min.css","v":"7.1.1"},"builder-styles-css":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/themify-builder-style.min.css","v":"7.1.1"},"tb_tbp":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/plugins\/themify-builder-pro\/public\/css\/tbp-style.min.css","v":"3.0.8"},"tf_theme_site-logo":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/styles\/modules\/site-logo.min.css","v":"7.1.1"},"tf_theme_site-description":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/styles\/modules\/site-description.min.css","v":"7.1.1"},"tf_search_form":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/css\/modules\/search-form.min.css","v":"7.1.1"},"tb_post-content":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/text.min.css","v":"7.1.1"},"wp-block-library":{"s":"https:\/\/www.excel-exercise.com\/wp-includes\/css\/dist\/block-library\/style.min.css","v":"6.2"},"tb_image":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/image.min.css","v":"7.1.1"},"tb_app":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/appearance.min.css","v":"7.1.1"},"tb_image_top":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/image_styles\/top.min.css","v":"7.1.1"},"tb_text":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/themify\/themify-builder\/css\/modules\/text.min.css","v":"7.1.1"},"theme-style":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/style.min.css","v":"7.1.1"},"themify-media-queries":{"s":"https:\/\/www.excel-exercise.com\/wp-content\/themes\/themify-infinite\/media-queries.min.css","v":"7.1.1","m":"(max-width:1200px)"}}