Excel Level 2 Questions

Front 1

List the 2 methods for inserting worksheets in a workbook.

Back 1

1. Open Insert menu & select the worksheet command
2. Position the mouse pointer on the worksheet tab that you want the new worksheet to appear before and click the secondary mouse button.
3. Select the Insert command. From the Insert dialog box, select the icon that represents the type of worksheet that you want to create. Click ok.

Front 2

When panes are frozen, what effect does it have on scrolling?

Back 2

When you scroll vertically, the rows that are frozen always appear on the screen.
When you scroll horizontally, the columns that are frozen always appear on the screen. when you press cntrl + home you return to the cell where you set the frozen panes, not cell A1

Front 3

What Zoom setting would you use to expand or contract a selected range of cells to fit within the window?

Back 3

Selection

Front 4

What is always the first step when setting a custom view?

Back 4

Set your screen with the view and/or options that you want to save in the custom view.

Front 5

Is it possible to paste values only and create a link at the same time?

Back 5

No. When you paste values only, the Paste Link button is unavailable.

Front 6

Once you consolidate data by category, can you edit the consolidated area to add more source areas?

Back 6

No. Once you have consolidated data by categories, you cannot add more source areas.

Front 7

Does double-clicking on a toobar when it is docked move the toolbar to its last floating location?

Back 7

No. The double-click trick works only when you click on a blank area of the toolbar, not a button or the front of the toolbar.

Front 8

What happens when you hold down the Cntrl and Shift keys while drawing an object?

Back 8

The object will be centered on the point where you start drawing. It will also be proportional.

Front 9

If you want to use a particular button on one of the palettes in the AutoShapes menu, what are 2 things you can do to save time?

Back 9

1. Tear off the palette on which the button is located to create temporary toolbar 2. Double-click the button. You can then draw several of the same shape.

Front 10

Is it always possible to add a 3D effect to a object?

Back 10

No. You cannot apply 3D effects to some shapes.

Front 11

How do you open the Borders toolbar?

Back 11

Open the Toolbars from the View menu and toggle Borders on or click on the Borders button drop-down arrow and select Draw Border.

Front 12

What does the Borders toolbar allow you to do?

Back 12

Create your own custom borders within a worksheet.

Front 13

What are the diffences between using the Chart Wizard and using the F11 function key?

Back 13

Chart Wizard leads you through 4 steps in which you select the type of chart the data source, chart options and chart location. When you are finished with the wizard, the chart is embedded on a worksheet.
When you press F11 the chart is placed on its chart worksheet. The chart uses the default chart type. You must make any modifications yourself, without any assistance.

Front 14

When you have a 3demensional column chart, what is the value axis referred to as?

Back 14

It is referred to as the Z-axis in a 3demensional column chart.

Front 15

Does double-clicking on a toolbar when it is docked move the toolbar to its last floating location?

Back 15

No. The double-click trick works only when you click on a blank area of the toolbar, not a button or the front of the toolbar.

Front 16

What happens when you hold down the Shift + Cntrl keys while drawing an object?

Back 16

The object will be centered on the point where you start drawing. It will also be proportional.

Front 17

How do you copy styles from one workbook to another?

Back 17

Open the Workbook that contians the styles that you want to copy. Then open the workbook that you want to copy the styles into. Open the Style dialog box and click the Merge button. Select the workbook that contains the styles and click ok.

Front 18

Can you create conditional formatting before you enter data into the cells?

Back 18

Yes. You can create conditional formatting either before or after you enter data into the cells.

Front 19

What is a template?

Back 19

Workbook that contains text, formulas, formatting styles and other information that you want to use repeatedly.

Front 20

If you want to use Excel's Auto Online feature what conditions must be met?

Back 20

As long as your data is set up in a consistant manner, you can use Excel's Auto Outline feature to create an online for your worksheet. For the Auto online feature to work, rows containing formulas must summerize data that is either all above the summary cannot be mixed. Also, columns containing formulas must summerize data that is either all to the left or all to the right of the summary column. The direction of summary can not be mixed.

Front 21

Is it possible to hide non-consectutive rows and columns?

Back 21

Yes

Front 22

In the Function Arguements box, what does it mean when an arguement is in bold?

Back 22

An arguement that appears in bold is a required arguement.

Front 23

Why does using the ROUND function increase accuracy in your worksheet?

Back 23

If you do not use ROUND, Excel uses all decimal points when calculating formulas. If you ROUND the value it ensures that only that number of decimal places is used.

Front 24

Can you nest functions other than IF statements?

Back 24

You can nest all functions (as long as they work together)

Front 25

What is the difference between the Error Checking and the Trace Error buttons?

Back 25

Error checking: starts the error check of the whole worksheet, states the error and offers a solution.
Trace checking: Merely highlights errors.

Front 26

When you are tracking precendents, what does it mean when you see an arrow with a spreadsheet icon?

Back 26

It means that a cell related to the selected cell is on another worksheet.

Front 27

If you leave tracer arrows on the screen, do they print?

Back 27

Yes. If you do not want them to print, you must erase them first.

Front 28

What 2 things are wrong with the range name 2000 Data?

Back 28

1. A range name cannot start with a number
2. A range name cannot have a space in it.

Front 29

Which commands do you use when you want to create several range names once?

Back 29

Open the Insert menu and select name command. Select create names from the submenu.

Front 30

If you are using a range name in a formula, but decide to delete the range name, what should you do?

Back 30

Change the formula back to using the cell references (ie remove the range name from the formula) and then delete the range name.

Front 31

When you are going to paste a list of range names on a worksheet, what should you be careful to do?

Back 31

Select a cell away from any data on the worksheet. Otherwise when you use Paste List, the list will replace any data.

Front 32

How do you select non-adjacent worksheet tabs?

Back 32

1. click the first worksheet
2. hold down the Cntrl
3. click another worksheet tab
4. release the cntrl key when finished.

Front 33

What do you do if you realize that you do not want certain cells to use Data Validation rules anymore?

Back 33

1. select the cells.
2. open the Data Validation dialog box
3. click the clear all
4. click ok