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
Contact
French
Most Viewed Posts
Displaying Negative Numbers in Parentheses – Excel
(261,116)
How to make automatic calendar in Excel
(161,518)
Dash for 0 in Excel
(133,275)
Convert YYYYMMDD to DD/MM/YYYY
(117,392)
Date Format in Excel
(113,317)
Excel Split Date and Time
(91,470)
How to calculate VAT in Excel?
(89,052)
Exchange rate in Excel
(81,138)
UNIQUE Function – Remove duplicates with formulas
(67,904)
Convert Latitude and Longitude from Decimal to Degree, Minute, Seconde
(63,906)
Quiz Excel Shortcuts
Do you know some tricky Excel shortcuts?
Start
<<
1
2
3
4
5
6
7
8
9
10
>>
1.
Which shortcuts insert the SUM function in a cell?
1.
CTRL + F7
2.
Alt + =
3.
SHIFT + F4
4.
CTRL + ALT + S
2.
Which shortcut autocompletes a formula?
1.
CTRL + SHIT + A
2.
ALT + RIGHT ARROW
3.
SHIT + TAB
4.
TAB
3.
Which shortcut allows you to add dollars to your references?
1.
F2
2.
F8
3.
SHIT + F3
4.
F4
4.
Which shortcuts open a new workbook?
1.
CTRL + N
2.
CTRL + SHIFT + N
3.
ALT + CTRL + N
4.
ALT + N
5.
Which shortcut can audit a part of your formula?
1.
F12
2.
F5
3.
F9
4.
F11
6.
Which shortcuts paste in values? (Available only with Excel 365)
1.
CTRL + SHIFT + C
2.
CTRL + SHIFT + V
3.
SHIFT + C
4.
CTRL + ALT + V
7.
Which shortcut removes the borders?
1.
Ctrl + Shift + -
2.
Ctrl + [
3.
Ctrl + 9
4.
Ctrl + ]
8.
What is the shortcut to open the dialog box "Save As"?
1.
SHIFT + S
2.
ALT + S
3.
CTRL + SHIFT + S
4.
F12
9.
Which shortcuts select the entire row?
1.
SHIFT + SPACE
2.
ALT + SHIFT + R
3.
CTRL + SPACE
4.
CTRL + SHIFT + R
10.
Which shortcuts insert the day of today in a cell? The date as value, not the function TODAY()
1.
CTRL + SHIFT + D
2.
CTRL + D
3.
CTRL + ;
4.
CTRL + :
Your email address:
Your name:
Loading...
Recent Posts
Calculate Quarter with Excel
Move a cell with the mouse in Excel
Change the language of Excel
Excercise for beginners: Create a drop-down menu
Excercise for beginner: Create an Invoice with Excel
{"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)"}}