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;
71 Cards in this Set
- Front
- Back
|
Excel is |
A powerful Spreadsheet Analysis Program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real time data from web sites. |
|
|
The Four Components of Excel are |
WorkBooks and Worksheets Charts Tables Web Support |
|
|
Workbooks are? |
Collection of Worksheets |
|
|
Worksheets are? |
Collection of data that can be analized |
|
|
Charts are? |
Visual representation of data |
|
|
Tables are? |
Organized, possibly numerical, view of data |
|
|
Web Support is? |
Published data on Web |
|
|
The Default Workbook Name is? |
Book1 |
|
|
The File Extension is? |
xlsx |
|
|
Why do are you suppost to save your workbook file? |
If you lose power to your computer, you can lose all your data. |
|
|
Worksheets or what? |
Rectangular grid sheet used to enter data, and is made up of rows and columns |
|
|
Rows are? |
Identified by numbers. they cant be changed. |
|
|
Coulumns are? |
Identified by letters. Cannot be changed |
|
|
Excel does what by default |
opens 3 worksheets in a workbook. |
|
|
A cell is? |
Basic unit of a worksheet into which you enter data. It also an intersection of row and column. |
|
|
An active cell is? |
A cell you enter data.It also had a Heavy Border, address displayed in the Name Box above column A, Row and Column heading are highlighted. |
|
|
Range is what? |
Series of two or more adjacent cells. |
|
|
Formula Bar is what? |
Enter text or mathematical expression. |
|
|
What is a Cell Reference? |
Coordinate of the intersection of the row and column. AKA Cell Name, Cell Address |
|
|
Example of a Cell Reference? |
=C5 |
|
|
Excel will accept what? |
Text Numbers Dates |
|
|
What is text? |
Combination of letters, numbers, or symbols ex QTR 1 This is has a auto Left- Aligned feature. |
|
|
What is Left- Aligned? |
Excel automatically positions text at the far left in the cell. |
|
|
What is Right- Aligned? |
Excel automatically positions numbers at the far right in the cell. |
|
|
How is dates displayed in Excel? |
4-1-13, 4/1/13 Displays with / by default. |
|
|
What does the auto fill feature do in excel? |
It copies an entry across a row It copies an entry down a column Creates a series of entries using th fill handle |
|
|
Where is th fill handle? |
Lower right corner of the Active Cell. |
|
|
What are the Insert and Delete Rows and Column features do? |
Can delete a full row or column from a worksheet Caution: If you delete a row or column with data, you will lose it all Rows- Insert above the active row Columns- Insert left of the active column |
|
|
Workbook opens with three ____ by default |
Worksheets |
|
|
Why do we need multiple sheets? All data can fit on one sheet. |
Organization- Sheets can group information that belongs together
Large sheets are hard to navigate |
|
|
How many Characters can be used in Naming worksheets? |
31 they cannot contain the following characters /,*,',: |
|
|
How are numbers displayed when there is not enough to display it entirely? |
Displays ########## |
|
|
Why is Excel so powerful? |
Performs Calculations Resistant to errors Save time |
|
|
What does performs calculations mean in Excel? |
Enter a formula into a cell then Excel will calculate the results for you.
|
|
|
What does it mean when you say excel is resistant to errors |
You can change the data and the formula will recalculate the results for you.
If you erroneously enter data, you can change it without recalculating the data manually |
|
|
What does it mean when someone says Excel saves time? |
It performs calculations that are time consuming |
|
|
The power of excel is that... |
it allows you to use a formula or function so you don't have to continually keep inputting data manually. |
|
|
Rules and examples of formulas |
Area of a square would be = Length * Width perimeter of a rectangle would be =2length + 2 Width Formulas follow the order of operations during their calculations Use Parentheses Exponents Multiplication or Division as they occur from left to right |
|
|
Why use a cell reference instead of the actual values? |
If you change a value in the cell, the formula will recalculate
If you use an actual number in the formula, it will not recalculate |
|
|
What is a function? |
Prewritten formula that is built into excel (Sum, Average, Max, Min)
takes a value or values and performs a calculation, then returns a result It simplifies the calculation in a formula by calculating all cell values in its range |
|
|
Example of a function or` |
=SUM(A1;A3) =AVERAGE (G2:G10) |
|
|
Function Library is what? |
It contains all the functions from multiple categories you can access it by clicking on fx on the formula bar |
|
|
THe process of using function library is ? |
on insert function box type function name It displays in select a function text area Then enter the arguments these are the cell ranges |
|
|
What is autosum? |
It provides a quick way to entewr commonly used functioned into a formula
It includes: SUM, AVERAGE, COUNT, MIN, AND MAX
|
|
|
what is relative cell reference? |
Adjust cell references as it copies from a source cell to a destination cell. |
|
|
What is Absolute Cell Reference? |
Does not adjust cell reference as it copies from a source cell to a destination cell. |
|
|
How to access the Copy and Paste commands without clicking them directly? |
By using the Fill handle |
|
|
What are the features of the Edit Cell Contents command? |
Allows recycling a complete worksheet for another time period. Can enter new edits directly in the cell or in the Formula Bar. EX. Creates a sheet with formulas, functions, and formatting for Monday, then delete Monday's data to recycle for Tuesday. Keeps all formulas, functions, and formatting but removes specific data to Monday. |
|
|
What is Data View? |
Allows user to see actual dta as it were entered. You dnt see formulas. You see what they calculate. |
|
|
What is formula view? |
Allows user to see formula in cells where they exist. Still see data where there is no formula |
|
|
How to switch between Formula View and Data View? |
use CTRL+ squigggly line above tab button. |
|
|
Whatare the features of Number Formats in Excel? |
Entries in cells automatically apply the General Format Dates format as dates Formats show purpose Accounting Number Format Currency Number Format Location : Right-click in cell, then format cells |
|
|
Examples of Date formats |
(13/Mar) becomes 13- Mar (03-15-13) becomes 03/15/13 |
|
|
Format shows purpose in two ways what or they |
$ and two decimals show currency negativ e numbers are showed in different ways like in red with a - sign or in in parenthesis |
|
|
How is accounting number format shown in excel? |
it displays with $ left aligned, comma after 3 digits, and .xx - two decimal places |
|
|
How is Currency Number Format shown in excel? |
It displays with $ floating, comma after 3 decimals, and .xx- two decimal places. |
|
|
What or the types of formatting in excel? |
Number accounting date time persentage and custom |
|
|
What is the CUstom formating pattern |
00#- sets two leading zeros if the number is smaller than 10, one leading zero if< 100 ex 001, 015, 100 |
|
|
What or some OTHER formatting tools? |
users can set font size, font color, font text can set background colors Cell Styles Themes |
|
|
What is cell styles? |
apply several format settings at once instead of individually.
|
|
|
Whagt is themes? |
Predefined set of colors, fonts, chart styles, cell styles, and fill effects that have common characteristics. office theme- default worksheet theme Lacation : Page Layout tab, theme group, themes command |
|
|
What happens when excel does not auto adjust cells to fit the data it holds? |
on empty adjacent cells - data displays in it fulladjacent cells- displays only the portion it can
With numbers it: If it has room displays as exponential format If it doesnt have room it will diplay ####### |
|
|
What or boarders used for? |
to group or emphasize data visually |
|
|
What is the merge cells feature used for? |
it can make a worksheet more readable used to span text or data across multiple cells used for title
|
|
|
What do charts do for your spreadsheet? |
Simplifies your understanding of data Its a visual representation of datas It also shows patterns and trends |
|
|
What is a Line chart? |
It illustrates trends overtime or geography |
|
|
What features or intersting about Modifying Chart Data? |
Formulas and functions recalculate values when the data changes in a cell
Charts once created will also re plot their graphs when data values change |
|
|
What is a column Charts? |
Compares the difference between values AKA Bar Charts they can be vertical or horizontal |
|
|
Steps to utilize the Lable feature. |
Click the boarder of the chart click the chart tools layout tab click the chart title button in the lables group click the above chart option type text then press enter |
|
|
What is a pie chart? |
Circular chart divided into parts. each part represents a piece of the whole pie bigger slices = bigger proportions of the pie |
|
|
What or some tools to modify pie charts? |
Exploded pie charts- a pie chart where one slice sits outside the circle of the pie chart used to show emphasis legend- Identifies each variable used in the chart. usually color coded |
