Basic Excel Skills Test. -

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

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

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

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

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

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.

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.

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

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

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

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

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.

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

Basic Excel Skills Test.