Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
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
|