Checking your Excel knowledge.

Question 1

Question

What symbol do you use for "less" if you had to create a formula to calculate Profit and were told this is Income less Running Costs?

Answer

Question 2

Question

You should select the whole column you want to sort before pressing the Sort button.

Answer

True
False

Question 3

Question

You can sort more than one column at a time by choosing Custom Sort from the Sort menu.

Answer

True
False

Question 4

Question

What would you type in a cell to add 6 and 5?

Answer

6+5
=6+5
6+5=

Question 5

Question

What symbol would you use to divide?

Answer

Question 6

Question

What can you use the AutoFill handle for? (the black box at the bottom right of a cell)

Answer

To copy formulas down or across your spreadsheet
To automatically enter series like days of the week or months of the year
To create your own numbered list
It can only be used to copy formulas

Question 7

Question

What is a cell reference?

Answer

The column letter and row number
What is inside it

Question 8

Question

What symbol would you use to multiply?

Answer

Question 9

Question

Choose the correct formula to work out the mean (average) of the cells in the range A1 to A15.

Answer

=SUM(A1:A15)/15
=AVERAGE(A1:A15)
=AVERAGE(A1+A15)
=SUM(AVERAGE(A1-A15)

Question 10

Question

What is the best way to add the cells in A1 and B1 together?

Answer

=SUM(A1:B1)
=A1+B1
=SUM(A1+B1)

Question 11

Question

Sometimes printing an Excel spreadsheet can be tricky because if it is too big it will go onto a second page and there's nothing you can do about that.

Answer

True
False

Question 12

Question

How can you improve the look of your spreadsheet?

Answer

Add colour
Add shading
Add borders
Merge and Centre your heading
Format cells to currency where appropriate
All of the above

Question 13

Question

Using Merge and Centre is a really good option for the Title line of your spreadsheet as it will make it stand out.

Answer

True
False

Question 14

Question

If a column heading is really wide compared to the data inside it, what is the best way to format this?

Answer

Merge and Centre
Wrap Text

Question 15

Question

What would you type in your cell to display 50%?

Answer

50 then format it to %
50%
.5 then format it to 50%

Question 16

Question

Excel can round your decimal places up or down for you.

Answer

True
False

Question 17

Question

Ascending is -

Answer

Largest to Smallest Z to A
Smallest to Largest A to Z

Question 18

Question

Descending is -

Answer

Largest to Smallest Z to A
Smallest to Largest A to Z

Question 19

Question

If you want to display just some of the data from your spreadsheet which feature can you use?

Answer

Filter
Find and Replace

Question 20

Question

Freeze Panes is a handy tool when working with a large spreadsheet as it keeps your headings at the top of your screen.

Answer

True
False

Question 21

Question

You need to be careful when using Find/Replace as sometimes it can replace text you didn't want it to.

Answer

True
False

Question 22

Question

When using the SUM function your answer has to be next to the figures you are adding up.

Answer

True
False

Question 23

Question

What is the intersection of a row and a column is called?

Answer

Worksheet
Cell
Chart
Sum

Next up

Checking your Excel knowledge.

Description

Resource summary

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Similar

	Created by hemingwaywil over 8 years ago

	Copied by Liz Riggs over 8 years ago

	Copied by Liz Riggs over 8 years ago