Study your flashcards anywhere!
Download the official Cram app for free >
 Shuffle
Toggle OnToggle Off
 Alphabetize
Toggle OnToggle Off
 Front First
Toggle OnToggle Off
 Both Sides
Toggle OnToggle Off
 Read
Toggle OnToggle Off
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
58 Cards in this Set
 Front
 Back
What are the three different ways to remove split panes from your Excel window?

1.Window (pulldown 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 pulldown 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 pulldown 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 pulldown 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?

ControlA


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 cofounders of Apple?

Steve Jobs and Steve Wozniak


In Excel, what is the intersection of a row and a column called?

Cell


Who are the cofounders 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 pulldown 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 pulldown 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 pulldown 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
