Spreadsheet-Excel
Terms
undefined, object
copy deck
- 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