Microsoft Excel - Intermediate

Please enter your email:

1. What is the general use of a line graph?

Most used graph that shows a comparison of information

Shows the performance over a period of time

Used to show the portions of which the data makes up

2. How would you protect the content of cells whilst allowing the user to change specific area’s?

You cannot do so

Select cells that are allowed to be changed > format cells > protection > untick lock > ok

You have to unlock the area to be used by the user and then protect the sheet

A password must be applied to the entire workbook.

3. Which option is used to add number onto a chart indicating the figure of a column?

Data Table

Trend Line

Axis Label

Data Label

4. Using Formula auditing, which button will show where a formula got its numbers from?

Trace Dependents

Follow Formula

Find Formula

Trace Precedents

Find Number

5. Which button will allow you to add the figures onto a chart:

6. What is a Sparkline?

A basic chart that resides inside a cell

A brighter boarder surrounding information

A line highlighting important information

7. What is a name reference not used for?

Used to indicate a specific reference

Another method of locking a cell (absolute reference)

Used to name cell ranges to be incorporated into other formulas

A quicker way of saving a workbook

8. Define a template

It is a precreated spreadsheet where all the user needs to do is fill in the information.

It is a precreated spreadsheet where all the user needs to do is fill in the information, but cannot be accidentally overwritten

Is a word document

Is a PowerPoint presentation

9. Which example of a named reference is correct?

1Name range

Name Range 1

Name_Range1

10. How do you enable the circled feature?

You copy and paste the arrows from another program

You draw the shapes in by clicking the insert tab and choose the shape

You use conditional formatting

11. How would you format cells based on certain conditions that must be met?

Manually format the information to suit your needs

use conditional formatting

use a IF statement formula to do so for you

12. What does Sheet3! Indicate in a formula?

The formula is referring to a named reference

The answer will appear on sheet 3

A cell reference from sheet 3 will be used in the formula

13. What does a hyperlink not do?

Quickly link formulas of cells together

Takes you to a specific cell in the current book

Takes you to a specific cell in a different workbook

Takes you to a specific website

14. Using Formula auditing, which button will show if a number is needed by other cells?

Trace Dependents

Follow Number

Find Number

Trace Precedents

15. Can you change the background of the plot area of a chart?

Yes

It can only be done in PowerPoint

Question 1 of 15