Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/33

Click to flip

33 Cards in this Set

  • Front
  • Back
List the 2 methods for inserting worksheets in a workbook.
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.
When panes are frozen, what effect does it have on scrolling?
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
What Zoom setting would you use to expand or contract a selected range of cells to fit within the window?
Selection
What is always the first step when setting a custom view?
Set your screen with the view and/or options that you want to save in the custom view.
Is it possible to paste values only and create a link at the same time?
No. When you paste values only, the Paste Link button is unavailable.
Once you consolidate data by category, can you edit the consolidated area to add more source areas?
No. Once you have consolidated data by categories, you cannot add more source areas.
Does double-clicking on a toobar when it is docked move the toolbar to its last floating location?
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.
What happens when you hold down the Cntrl and Shift keys while drawing an object?
The object will be centered on the point where you start drawing. It will also be proportional.
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?
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.
Is it always possible to add a 3D effect to a object?
No. You cannot apply 3D effects to some shapes.
How do you open the Borders toolbar?
Open the Toolbars from the View menu and toggle Borders on or click on the Borders button drop-down arrow and select Draw Border.
What does the Borders toolbar allow you to do?
Create your own custom borders within a worksheet.
What are the diffences between using the Chart Wizard and using the F11 function key?
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.
When you have a 3demensional column chart, what is the value axis referred to as?
It is referred to as the Z-axis in a 3demensional column chart.
Does double-clicking on a toolbar when it is docked move the toolbar to its last floating location?
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.
What happens when you hold down the Shift + Cntrl keys while drawing an object?
The object will be centered on the point where you start drawing. It will also be proportional.
How do you copy styles from one workbook to another?
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.
Can you create conditional formatting before you enter data into the cells?
Yes. You can create conditional formatting either before or after you enter data into the cells.
What is a template?
Workbook that contains text, formulas, formatting styles and other information that you want to use repeatedly.
If you want to use Excel's Auto Online feature what conditions must be met?
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.
Is it possible to hide non-consectutive rows and columns?
Yes
In the Function Arguements box, what does it mean when an arguement is in bold?
An arguement that appears in bold is a required arguement.
Why does using the ROUND function increase accuracy in your worksheet?
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.
Can you nest functions other than IF statements?
You can nest all functions (as long as they work together)
What is the difference between the Error Checking and the Trace Error buttons?
Error checking: starts the error check of the whole worksheet, states the error and offers a solution.
Trace checking: Merely highlights errors.
When you are tracking precendents, what does it mean when you see an arrow with a spreadsheet icon?
It means that a cell related to the selected cell is on another worksheet.
If you leave tracer arrows on the screen, do they print?
Yes. If you do not want them to print, you must erase them first.
What 2 things are wrong with the range name 2000 Data?
1. A range name cannot start with a number
2. A range name cannot have a space in it.
Which commands do you use when you want to create several range names once?
Open the Insert menu and select name command. Select create names from the submenu.
If you are using a range name in a formula, but decide to delete the range name, what should you do?
Change the formula back to using the cell references (ie remove the range name from the formula) and then delete the range name.
When you are going to paste a list of range names on a worksheet, what should you be careful to do?
Select a cell away from any data on the worksheet. Otherwise when you use Paste List, the list will replace any data.
How do you select non-adjacent worksheet tabs?
1. click the first worksheet
2. hold down the Cntrl
3. click another worksheet tab
4. release the cntrl key when finished.
What do you do if you realize that you do not want certain cells to use Data Validation rules anymore?
1. select the cells.
2. open the Data Validation dialog box
3. click the clear all
4. click ok