There are a lot of people who cannot pass a Microsoft excel basic skills test. This is because Excel is seen as the most complex package that Microsoft has to offer. Do you know how to use every feature on excel to get the fastest and perfect data sheets? The question trivia quiz below is perfectly designed for those who need help with the application basics. Do give it a shot and see what you might learn.
Conditional Formatting
Sum
@Choose
Paste as values
1) Imps Contracted: Largest to Smallest 2) Imps Delivered: Smallest to Largest
1) Imps Contracted: Largest to Smallest 2) Imps Delivered: Largest to Smallest
1) Imps Delivered: Largest to smallest 2) Imps Contracted: Largest to smallest
1) Imps Delivered: Largest to smallest 2) Imps Contracted: Smallest to Largest
Right Click on the line Line/Column and select insert
On the home tab, click "insert" and select insert row/column
With your mouse, highlight the row/column and type Control+I
=SUM(A2:A6)
=A2+A3+A4+A5+A6
=1+2+3+4+5
=SUM($A$2:$A$6)
11
12
6
10
Wrap Text
Format as table
Merge cells
Shrink-to-fit
Formulas
Values
Formats
Comments
Validation
1
2
3
4
5
10
21
20
12
1
2
3
Highlighting A1 and pressing "Control+1"
Right clicking on A1