Microsoft Excel - Intermediate

Please enter your email:

1. 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

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. 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

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

Data Table

Trend Line

Axis Label

Data Label

5. 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

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

Trace Dependents

Follow Number

Find Number

Trace Precedents

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

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. Using Formula auditing, which button will show where a formula got its numbers from?

Trace Dependents

Follow Formula

Find Formula

Trace Precedents

Find Number

10. 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

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

Yes

It can only be done in PowerPoint

12. Which example of a named reference is correct?

1Name range

Name Range 1

Name_Range1

13. 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

14. What is a Sparkline?

A basic chart that resides inside a cell

A brighter boarder surrounding information

A line highlighting important information

15. 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

Question 1 of 15

GET IN TOUCH