How much can you remember about Excel? Level 1.

Question 1 of 30

Medal-premium 1

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

Select one of the following:

  • 6+5

  • =6+5

  • 6+5=

Question 2 of 30

Medal-premium 1

When creating a chart, it is best to use as much data as possible from your spreadsheet.

Select one of the following:

  • True
  • False

Question 3 of 30

Medal-premium 1

What symbol would you use to divide?

Select one of the following:

  • ~

  • /

  • ^

  • \

Question 4 of 30

Medal-premium 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

Question 5 of 30

Medal-premium 1

What is a cell reference?

Select one of the following:

  • The column letter and row number

  • What is inside it

Question 6 of 30

Medal-premium 1

What symbol would you use to multiply?

Select one of the following:

  • x

  • *

  • ~

  • #

Question 7 of 30

Medal-premium 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)

Question 8 of 30

Medal-premium 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)

Question 9 of 30

Medal-premium 1

Choose the best chart to use when comparing two sets of numbers.

Select one of the following:

  • Pie

  • Bar

  • Scatter

  • Column

  • All of the above, it doesn't make that much difference as long as you label it

Question 10 of 30

Medal-premium 1

Pie charts are best to use when you are trying to compare parts of a whole.

Select one of the following:

  • True
  • False

Question 11 of 30

Medal-premium 1

You should always include a Legend on every chart you create.

Select one of the following:

  • True
  • False

Question 12 of 30

Medal-premium 1

A good chart should include which of the following?

Select one or more of the following:

  • Title

  • X Axis Label

  • Y Axis Label

  • Legend (if more than one series is being displayed)

  • All of the above

Question 13 of 30

Medal-premium 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

Question 14 of 30

Medal-premium 1

You can display the formulas you have used in your spreadsheet by chosing Show Formulas from the Formulas menu.

Select one of the following:

  • True
  • False

Question 15 of 30

Medal-premium 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

Question 16 of 30

Medal-premium 1

How can you improve the look of your column, bar or scatter chart?

Select one of the following:

  • Add shading

  • Change colours of the series

  • Add a chart title

  • Add X & Y axis titles

  • All of the above

Question 17 of 30

Medal-premium 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

Question 18 of 30

Medal-premium 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

Question 19 of 30

Medal-premium 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%

Question 20 of 30

Medal-premium 1

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

Select one of the following:

  • True
  • False

Question 21 of 30

Medal-premium 1

You can create a chart quickly by pressing which function key?

Select one of the following:

  • F11

  • F4

Question 22 of 30

Medal-premium 1

Absolute Cell References are used when you need to refer back to a single cell when dragging down a formula.

Select one of the following:

  • True
  • False

Question 23 of 30

Medal-premium 1

Ascending is -

Select one or more of the following:

  • Largest to Smallest
    Z to A

  • Smallest to Largest
    A to Z

Question 24 of 30

Medal-premium 1

Descending is -

Select one or more of the following:

  • Largest to Smallest
    Z to A

  • Smallest to Largest
    A to Z

Question 25 of 30

Medal-premium 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

Question 26 of 30

Medal-premium 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

Question 27 of 30

Medal-premium 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

Question 28 of 30

Medal-premium 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:

  • -

  • <

Question 29 of 30

Medal-premium 1

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

Select one of the following:

  • True
  • False

Question 30 of 30

Medal-premium 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
Icon_fullscreen

How much can you remember about Excel? Level 1.

Liz Riggs
Quiz by , created over 1 year ago

The quiz will check your overall understanding of Excel. This does not contain Level 2 elements.

Eye 59
Pin 0
Balloon-left 0
Tags No tags specified
hemingwaywil
Created by hemingwaywil over 1 year ago
Liz Riggs
Copied by Liz Riggs over 1 year ago
Liz Riggs
Copied by Liz Riggs over 1 year ago
Close