Accueil
Tests et Exercices
- Exercices en ligne pour Excel
- Tests et questionnaires sur Excel
Fonctions
Astuces
Graphiques
Contact
English

Accueil » Test Raccourci-clavier Excel

Test Raccourci-clavier Excel

<<
1
2
3
4
5
6
7
8
9
10
>>

1. Quel raccourci permet de créer un nouveau classeur Excel ?

<img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" width="16" height="16" alt="Loading..." title="Loading..." />

Loading...

2. Quel raccourci-clavier vous permet d'afficher la boîte de dialogue Enregistrer Sous ?

Boite de dialogue Enregistrer sous

<img class="size-full wp-image-26523 alignleft" src="https://www.excel-exercice.com/wp-content/uploads/2017/11/fonction_F12.png" alt="fonction F12" width="74" height="74" />

<img class="size-full wp-image-26529 alignleft" src="https://www.excel-exercice.com/wp-content/uploads/2017/11/Ctrl-S.png" alt="Ctrl S" width="297" height="72" />

<img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" width="16" height="16" alt="Loading..." title="Loading..." />

Loading...

3. Quel raccourci-clavier permet de compléter le nom d'une formule ?

touche entree 1

<img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" width="16" height="16" alt="Loading..." title="Loading..." />

Loading...

4. Quel raccourci-clavier permet d'afficher les formules dans les cellules ?

Formule dans les cellules

Ctrl exclamation

Ctrl underscore

<img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" width="16" height="16" alt="Loading..." title="Loading..." />

Loading...

5. Quel raccourci-clavier insère la fonction SOMME ?

Ajouter une Somme

<img class="size-full wp-image-26529 alignleft" src="https://www.excel-exercice.com/wp-content/uploads/2017/11/Ctrl-S.png" alt="Ctrl S" width="297" height="72" />

<img class="size-full wp-image-26541 alignleft" src="https://www.excel-exercice.com/wp-content/uploads/2017/11/Ctrl-espace.png" alt="Ctrl espace" width="368" height="70" />

<img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" width="16" height="16" alt="Loading..." title="Loading..." />

Loading...

6. Comment ajouter une colonne par raccourci-clavier (il faut qu'une colonne soit déjà sélectionnée) ?

Ajouter une nouvelle colonne

Ctrl fleche droite

<img class="size-full wp-image-26545 alignleft" src="https://www.excel-exercice.com/wp-content/uploads/2017/11/Ctrl-pageup.png" alt="Ctrl pageup" width="297" height="72" />

<img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" width="16" height="16" alt="Loading..." title="Loading..." />

Loading...

7. Quel raccourci permet d'analyser une partie d'une formule ?

Analyse une formule avec F9

<img class="size-full wp-image-26517 alignleft" src="https://www.excel-exercice.com/wp-content/uploads/2017/11/fonction_F6.png" alt="fonction F6" width="74" height="74" />

<img alt="fonction F8" width="74" height="74" data-src="https://www.excel-exercice.com/wp-content/uploads/2017/11/fonction_F8.png" class="size-full wp-image-26519 alignleft lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img class="size-full wp-image-26519 alignleft" src="https://www.excel-exercice.com/wp-content/uploads/2017/11/fonction_F8.png" alt="fonction F8" width="74" height="74" />

<img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" width="16" height="16" alt="Loading..." title="Loading..." />

Loading...

8. Quel raccourci-clavier vous permet de sélectionner toute la colonne où se trouve la cellule active ?

<img class="size-full wp-image-26545 alignleft" src="https://www.excel-exercice.com/wp-content/uploads/2017/11/Ctrl-pageup.png" alt="Ctrl pageup" width="297" height="72" />

<img class="size-full wp-image-26541 alignleft" src="https://www.excel-exercice.com/wp-content/uploads/2017/11/Ctrl-espace.png" alt="Ctrl espace" width="368" height="70" />

<img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" width="16" height="16" alt="Loading..." title="Loading..." />

Loading...

9. Comment ajouter rapidement les dollars dans une formule ?

<img alt="fonction F8" width="74" height="74" data-src="https://www.excel-exercice.com/wp-content/uploads/2017/11/fonction_F8.png" class="size-full wp-image-26519 alignleft lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img class="size-full wp-image-26519 alignleft" src="https://www.excel-exercice.com/wp-content/uploads/2017/11/fonction_F8.png" alt="fonction F8" width="74" height="74" />

<img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" width="16" height="16" alt="Loading..." title="Loading..." />

Loading...

10. Quel raccourci-clavier permet d'éditer (modifier) une cellule

<img class="size-full wp-image-26523 alignleft" src="https://www.excel-exercice.com/wp-content/uploads/2017/11/fonction_F12.png" alt="fonction F12" width="74" height="74" />

<img class="size-full wp-image-26517 alignleft" src="https://www.excel-exercice.com/wp-content/uploads/2017/11/fonction_F6.png" alt="fonction F6" width="74" height="74" />

<img alt="fonction F8" width="74" height="74" data-src="https://www.excel-exercice.com/wp-content/uploads/2017/11/fonction_F8.png" class="size-full wp-image-26519 alignleft lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img class="size-full wp-image-26519 alignleft" src="https://www.excel-exercice.com/wp-content/uploads/2017/11/fonction_F8.png" alt="fonction F8" width="74" height="74" />

<img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" width="16" height="16" alt="Loading..." title="Loading..." />

Loading...

Votre adresse mail :

Votre prénom :

En cochant cette case, j’accepte la politique de confidentialité de ce site.

<img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img width="16" height="16" alt="Loading..." title="Loading..." data-src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" class="lazyload" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" /><noscript><img src="https://www.excel-exercice.com/wp-content/plugins/watupro/img/loading.gif" width="16" height="16" alt="Loading..." title="Loading..." />

Loading...

jooble full logotype recadre

Plus d'articles

Back to top

@2022 - www.excel-exercice.com. All Right Reserved.

Le majordome du net prend soin d'Excel exercice !

Back to top