Order
Group Course
- Group Order
Excel Test
FAQ
- Certifications
- Course Outline
Excel Experts
- Excel Primers
- Open University
About Us
Login

3 Day Group Trial.
aicheat
button test
Certifications
Contact us:
Course Outline
Essential Excel
Essential Excel Course outline
Excel Courses Directory
Excel Course Categories
Excel Courses World Wide
FAQ
front
Group Excel Training
Group Order
Knowledge Base
- Excel Primers
neworder
One Day Excel Course Trial
Online Excel Course for Employees : Free Trial
Online Excel Course: | Live Support | Also Group Courses
Order:
Pivot table Course
Preview Page
Privacy & Cookies Policy
Terms and Conditions
Thanks for joining Essential Excel Free course
Top 10 Excel Help Sites
uk
Unique Free Excel Testing Workbook
Workplace Course Outline
WorkPlace Excel: Course Outline v1

Basic Excel Skills Test.

By admin / April 29, 2015

Time limit: 0

Quiz Summary

0 of 13 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 13 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%
Control your worksheet 0%
Formatting 0%
Formulas 0%
Functions 0%
Functions 0%
linking 0%

1
2
3
4
5
6
7
8
9
10
11
12
13

Current
Review
Answered
Correct
Incorrect

Question 1 of 13

1. Question
When I type a number into a cell, it’s coming up as a date.What should I do?
- Hit the Delete Button Twice
- In the Home Ribbon, Go to Clear>Clear Formats
- Delete the Row
Correct

Incorrect
Question 2 of 13

2. Question
What is wrong with this Formula:
A5+B7\C8-E400
- The formula is correct
- There needs to be an equal sign at the beginning
- Division symbol is / not \
- There needs to be an equal sign at the beginning and use the / symbol
Correct

Incorrect
Question 3 of 13

3. Question
How will Excel evaluate this Formula:

=B1+C2 * D3
- The formula will add B1 to C2 and multiply by D3
- The Formula will multiply C2 by D3 and then add it to B1
- The formula will generate an error message
- The Formula will multiply B1 by D3 and then add it to C2
Correct

Incorrect
Question 4 of 13

4. Question
How can you configure the worksheet to show the formulas instead of the results.
- Look in the Formula bar
- Only possible in print preview mode
- Go to the Formula Ribbon and click on 'Show Formulas"
- Go to the Formula Ribbon and click show dependents
Correct

Incorrect
Question 5 of 13

5. Question
I want to find the average sales for Monday based on the data below. Which formula or function is correct ?
- =AVERAGE(B3:B6)
- =AVERAGE(B2:B6)
- B8/6
- =AVERAGE(B2:B7) or =B8/7
Correct

Incorrect
Question 6 of 13

6. Question
What is the fill handle and how do you use it?
- It is mainly used to create a list like weekdays and months.
- It is used to copy Functions and you need to get the cross hair cursor shape before you use it.
- It will copy Functions and Formulas. You need to get the cross hair cursor shape before you use it.
- It copy formats and you need to get the cross hair cursor shape before you use it.
Correct

Incorrect
Question 7 of 13

7. Question
Why has Excel put a Green mark in our Function cell?
- There is an error which must be corrected before you can proceed.
- Excel is reminding you to format the cell properly
- Excel is saying there is a possible error , so you need to double check your formula.
Correct

Incorrect
Question 8 of 13

8. Question
I want to find the largest number in a range of numbers. Which Function should I Use?
- MIN Function.
- The SUM and AVERAGE Function together.
- MAX Function
- COUNTA Function
Correct

Incorrect
Question 9 of 13

9. Question
I have come across this Function =INT(A2) and I don’t understand what it does.What is the quickest way to find out?
- Google it
- Search Excel's help system
- Click Function key F1
- Click the Fx Symbol to the left of the Formula Bar
Correct

Incorrect
Question 10 of 13

10. Question
I have a value in cell A1 in Sheet1 worksheet and I have a value in cell A1 in sheet2 worksheet.

I want to create a formula in worksheet Sheet3 which will add them together.Which is the correct formula.
- =sheet1A1+sheet2A2
- sheet1!A1+sheet2A1
- =sheet1!A1+sheet2!A1
- =sheet3!A1+sheet2!A1+sheet2!a1
Correct

Incorrect
Question 11 of 13

11. Question
I want to freeze row 3 of my worksheet.How will I do it?
- Click into cell A4 .Go to the View Ribbon >Freeze Panes>Freeze panes
- Go to the View Ribbon >Freeze Panes>Freeze First Row
- Press Control+F +P
Correct

Incorrect
Question 12 of 13

12. Question
I want to filter the data below to see a list of orders where the revenue figure was greater than $15000.
What should I do?
- Click on list.Go to Data>Filter. Then click the filter beside revenue and look for 15000 to select.
- Click on list. Go to Data>Filter. Then click the filter beside revenue .Select Number filters>Greater than and type in 15000
- First sort the revenue figures highest to lowest, then apply filters. Click the filter beside revenue and look for 15000 to select.
Correct

Incorrect
Question 13 of 13

13. Question
As per spreadsheet image, we want to create a formula in cell J4 which will work out the commission due to Lorraine. The Commission rate is in Cell F1. We will want to copy down these formulas. From the list below which is the most effective formula.
- =I4 /100*10
- =I4 * 10%
- =I4 & F$1
- =I4* $F1
Correct

Incorrect