Liz Riggs
Quiz by , created more than 1 year ago

The quiz will check your overall understanding of Excel.

134
1
0
hemingwaywil
Created by hemingwaywil over 8 years ago
Liz Riggs
Copied by Liz Riggs over 8 years ago
Liz Riggs
Copied by Liz Riggs over 8 years ago
Close

Checking your Excel knowledge.

Question 1 of 23

1

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?

Select one of the following:

  • -

  • <

Explanation

Question 2 of 23

1

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

Select one of the following:

  • True
  • False

Explanation

Question 3 of 23

1

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

Select one of the following:

  • True
  • False

Explanation

Question 4 of 23

1

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

Select one of the following:

  • 6+5

  • =6+5

  • 6+5=

Explanation

Question 5 of 23

1

What symbol would you use to divide?

Select one of the following:

  • ~

  • /

  • ^

  • \

Explanation

Question 6 of 23

1

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

Select one or more of the following:

  • 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

Explanation

Question 7 of 23

1

What is a cell reference?

Select one of the following:

  • The column letter and row number

  • What is inside it

Explanation

Question 8 of 23

1

What symbol would you use to multiply?

Select one of the following:

  • x

  • *

  • ~

  • #

Explanation

Question 9 of 23

1

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

Select one of the following:

  • =SUM(A1:A15)/15

  • =AVERAGE(A1:A15)

  • =AVERAGE(A1+A15)

  • =SUM(AVERAGE(A1-A15)

Explanation

Question 10 of 23

1

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

Select one of the following:

  • =SUM(A1:B1)

  • =A1+B1

  • =SUM(A1+B1)

Explanation

Question 11 of 23

1

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.

Select one of the following:

  • True
  • False

Explanation

Question 12 of 23

1

How can you improve the look of your spreadsheet?

Select one of the following:

  • Add colour

  • Add shading

  • Add borders

  • Merge and Centre your heading

  • Format cells to currency where appropriate

  • All of the above

Explanation

Question 13 of 23

1

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

Select one of the following:

  • True
  • False

Explanation

Question 14 of 23

1

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

Select one of the following:

  • Merge and Centre

  • Wrap Text

Explanation

Question 15 of 23

1

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

Select one or more of the following:

  • 50 then format it to %

  • 50%

  • .5 then format it to 50%

Explanation

Question 16 of 23

1

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

Select one of the following:

  • True
  • False

Explanation

Question 17 of 23

1

Ascending is -

Select one or more of the following:

  • Largest to Smallest
    Z to A

  • Smallest to Largest
    A to Z

Explanation

Question 18 of 23

1

Descending is -

Select one or more of the following:

  • Largest to Smallest
    Z to A

  • Smallest to Largest
    A to Z

Explanation

Question 19 of 23

1

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

Select one of the following:

  • Filter

  • Find and Replace

Explanation

Question 20 of 23

1

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

Select one of the following:

  • True
  • False

Explanation

Question 21 of 23

1

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

Select one of the following:

  • True
  • False

Explanation

Question 22 of 23

1

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

Select one of the following:

  • True
  • False

Explanation

Question 23 of 23

1

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

Select one of the following:

  • Worksheet

  • Cell

  • Chart

  • Sum

Explanation