Microsoft Excel Intermediate Quiz - ExecutrainExecutrain

Please enter your email:

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

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

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

4. Define a template

It is a pre-created spreadsheet where all the user needs to do is fill in the information

It is a pre-created 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

5. What is a Sparkline?

A basic chart that resides inside a cell

A brighter boarder surrounding information

A line highlighting important information

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

Yes

It can only be done in PowerPoint

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

8. How would you protect the content of cells whilst allowing the user to change specific areas?

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

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

A password must be applied to the entire workbook

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

Typically used to illustrate rates of change over a period of time

Typically used to display data changes over a period of time

Typically used to compare different data points in relation to a total

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

Trace Dependents

Follow Formula

Find Formula

Trace Precedents

Find Number

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

12. Which example of a named reference is correct?

1Name range

Name Range 1

Name_Range1

13. 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 from the shapes button in the illustrations group

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

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. Which option is used to add numbers onto a chart indicating the figure of a column?

Data Table

Trend Line

Axis Label

Data Label

Question 1 of 15