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/58

Click to flip

58 Cards in this Set

  • Front
  • Back
What are the three different ways to remove split panes from your Excel window?
1.Window (pull-down menu) -- Click on Remove Split

2.Click and drag pane lines off window

3. Double click on pane lines
What is Microsoft Excel?
A spreadsheet program that allows you to organize data, complete calculations, make decisions, and graph data.
What are the steps for printing only part of an Excel worksheet?
Select the Area -- File -- Print -- Selection -- OK
Under what pull-down menu do you find the option to create a chart?
Insert
What does ^ mean in an Excel formula?
Exponent - To the Power of
The three major parts of Excel are...
worksheets
charts
databases
Under what pull-down menu do you find the spell check option?
Tools
How is text aligned in a cell?
Left
What does the function formula Minimum do?
Finds the smallest value in a cell range
What three things does AutoCorrect do?
1. Corrects two initial capital letters by changing the second letter to lowercase
2. Capitalizes the first letter in the names of days
3. Corrects common spelling mistaks
Under what pull down menu do you find the option to 'Goal Seek'?
Tools
Under what pull-down menu do you find the option to rotate a graph?
Chart
What does AutoFormat mean or do?
Produces Preformatted Table Setups
How many different types of charts are there?
14
Is the order of mathematical operations that are performed in a formula in a spreadsheet the same as the order of operation performed in an equation in algebra?
Yes
What toolbar must be on to set a shadow around a group of cells?
Drawing Toolbar
List 3 ways to change the height of a row
1. Change the border boundary

2. Format -- Row -- Height

3. Highlight Info. -- Format -- Row -- Autofit
List the steps to delete an entire sheet from an Excel workbook.
1. Click on Edit
2. Click Delete Sheet
3. Click OK
Where do you find the option to turn formulas on and/or off (not the keyboard shortcut)?
Tools -- Options -- View -- Formulas -- OK
What is the keyboard shortcut to select all the cells in a worksheet?
Control-A
List 2 ways of setting borders to a range of information
1. Shortcut Border button in the toolbar

2. Format -- Cells -- Border
Who are the co-founders of Apple?
Steve Jobs and Steve Wozniak
In Excel, what is the intersection of a row and a column called?
Cell
Who are the co-founders of Microsoft?
Bill Gates and Paul Allen
What does it mean to elevate a graph?
Tilts the chart
What are two examples of output devices?
Printer
Monitor
Speakers
Under what pull-down menu do you find AutoFormat?
Format
A chart that is on the same sheet as the table is called (what typed of chart)?
Embedded Chart
What is the smallest you can zoom out of an Excel worksheet?
10%
How do you change the name of an individual worksheet?
1. Double click on sheet tab
2. Type in new name
3. Press enter
What is the largest you can zoom into an Excel worksheet?
400%
How are numbers aligned in a cell?
Right
What does it mean when you see ########## in a cell and how do you correct it?
The column is too narrow to fit information, widen the column
What is the maximum number of sheets in an Excel workbook?
255
What does the function formula Maximum do?
Finds the largest value in a cell range
How many total columns are in a single Excel worksheet?
256
How many docks are there to anchor a toolbar on in an Excel window?
4
Write a function formula to find the minimum value in cells B9 through B20
=Min(B9:B20)
Which symbol in the formula bar, when clicked, is the same as pressing the enter key?
Green Checkmark
Write a function formula to average cells B9 through B20
=Average(B9:B20)
List 4 different types of charts you can set
You may choose any four of the following:

Column -- Bar -- Line -- Pie -- XY Scatter -- Area -- Doughnut -- Radar -- Surface -- Bubble -- Stock -- Cylinder -- Cone -- Pyramid
Under what pull-down menu do you find the option to set headers and footers?
View
Where do you find the option to set your page to landscape orientation?
File -- Page Setup -- Page -- Landscape
Write a function formula to find the maximum value in cells B9 through B20
=Max(B9:B20)
What is the key word when defining an absolute cell reference?
Constant
What does the ':'mean in a formula?
Through
What does the function formula "Count" do?
Adds together the number of nonblank cells
What two things does a floating toolbar have that an anchored tool bar does not?
Title Bar and Close Button
What does the function formula Average do?
Adds together the numbers in a cell range, and then divides by the number of cells used
What is the very first thing you always do when typing a formula?
= Equals Sign
How many dollar signs are in cell reference that is relative?
0
Under what pull-down menu do you find the option to freeze panes?
Window
What is a mixed cell reference?
Part relative, part absolute
How many dollar signs are in a cell reference that is absolute?
2
In the formula =IF(B4>=$B$17, 100, 200), the B4>=$B$17 is the _________________ part of the formula.
Logical
How many dollar signs are in a cell reference that is mixed?
1
What does 'Goal Seek' allow you to do as a spreadsheet user?
Allows you to determine what changes need to be made to reach a specific goal
What is the key word when defining a relative cell reference?
Adjust