Reading...
Play button
Play button
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;
73 Cards in this Set
- Front
- Back
|
What box displays the active cell reference?
|
Name box
|
|
|
Excel opens a new workbook with how many worksheet?
|
Three worksheets
|
|
|
What is the basic unit of an Excel worksheet in which you enter data?
|
Cell
|
|
|
How does Excel automatically align text by default?
|
Left-aligned
|
|
|
Holding down the ________ key while you drag a chart edge snaps the edge of the chart area to the worksheet gridlines.
|
Alt key
|
|
|
What Excel function allows you to add all of the numbers in a range of cells?
|
"Sum" function
|
|
|
A cell is referred to by its unique address called a ________, which is the intersection of a column and a row
|
Cell Reference
|
|
|
In Excel, any set of characters containing a letter, hyphen, or space is considered __________.
|
Text
|
|
|
What is the keyboard shortcut to save an Excel workbook?
|
CTRL + S
|
|
|
What do you call a series of 2 or more adjacent cells in a column or row?
|
Range
|
|
|
How many columns does each Excel worksheet have?
|
16,384
|
|
|
What do you call a chart that is drawn on the same worksheet as the data that it is drawn from?
|
Embedded Chart
|
|
|
What do you call the vertical axis of a chart?
|
Value Axis
|
|
|
What symbol do all Excel formulas begin with?
|
Equal sign =
|
|
|
In Excel, the "Order of Operations" determines ____________?
|
The order in which calculations are performed
|
|
|
Which dialog box do you open to change the page orientation, scale to fit a worksheet onto one page, and center a worksheet horizontally and vertically when printing a page?
|
"Page Set-Up" dialog box
|
|
|
How many rows does an Excel worksheet have?
|
Over 1 million rows (1,048,576 rows to be exact)
|
|
|
This bar at the top of the Excel worksheet allows you to enter or edit data in a cell.
|
Formula bar
|
|
|
What tab do you click on to "Freeze panes" on a worksheet?
|
View Tab
|
|
|
What tab do you click on to add a header/footer to a worksheet?
|
Insert Tab
|
|
|
What tab do you click on to add a chart to a worksheet?
|
Insert Tab
|
|
|
Where can you change the formatting of a worksheet such as font size, color, shading,and text alignment?
|
Home tab
|
|
|
What tab do you click on to perform "Conditional Formatting?
|
Home Tab
|
|
|
What function is used to determine the lowest number in a given range?
|
Min
|
|
|
The "Undo button" allows you to reverse up to how many actions at one time?
|
You can reverse up to 100 previous actions at one time
|
|
|
Which keys do you press when you want to display the formulas in an Excel worksheet?
|
CTRL + ` (the accent key)
|
|
|
The AutoSum button and other functions such as "Average" "Max" and "Min" can be found in the editing group of what tab?
|
Home Tab
|
|
|
What tab do you click on to change the "color theme" of a worksheet?
|
Page Layout Tab
|
|
|
What tab do you click when you want to "Sort" data?
|
Home Tab
|
|
|
What is the "Order of Operations" for performing calculations in formulas that contain more than one arithemtic operator such as (+,-,?,*)
|
1. Operations in parenthesis are performed first
2.Exponents are calculated next 3. Multiplication and Division from left to right are performed next 4. Addition and Subtraction from left to right are performed last |
|
|
What Excel feature allows you to copy a formula from one cell to another or to continue a series of numbers, days of the week, or months of the year?
|
Auto Fill feature
|
|
|
A ____________ is a prewritten formula that is written into Excel.
|
Function
|
|
|
What Excel feature do you use when you want to verify that a formula contains the cell references that you intended it to have?
|
Range Finder
|
|
|
What type of cell reference changes when it is copied?
|
Relative Cell Reference
|
|
|
What type of cell reference does not change but rather remains constant when it is copied?
|
Absolute Cell Reference
|
|
|
What does the pointer change to when you are copying a formula using the "fill handle" in the lower right hand corner of a cell?
|
A black crosshair +
|
|
|
What type of reference is $C$5
|
Absolute cell reference
|
|
|
What key do you press to convert a relative cell refernce to an absolute cell reference?
|
F4
|
|
|
What Excel feature is used to automatically adjust the width of a column or the height of a row to fit its widest or tallest entry?
|
AutoFit
|
|
|
What do you click to enter text on more than one line in a cell?
|
Click "Alt + Enter" at the end of each intended line
|
|
|
To create a "custom header/footer", what key do you press?
|
Print/Print Preview
|
|
|
What do you call a pie chart that has one or more of the sections separated from the main portion of the pie?
|
Exploding Pie Chart
|
|
|
What do you click to use the AutoFit feature to adjust the width of a cell to fit the widest entry?
|
Double click the right border of the column
|
|
|
When you highlight a column and click "Insert" from the shortcut menu, where does Excel automatically insert a new column?
|
To the left of the highlighted column
|
|
|
When you highlight a row and click "Insert" from the shortcut menu, where does Excel automatically insert a row?
|
Above the highlighted row
|
|
|
Which border do you drag when you want to adjust the height of a row?
|
The bottom border of the row
|
|
|
Which border do you drag when you want to adjust the width of a column?
|
The right border of the column
|
|
|
Where is the "Merge and Center" button located?
|
On the "Home tab" and "the Mini Toolbar"
|
|
|
What button do you click when you want to add background color to a cell?
|
Shading button (paint bucket)
|
|
|
How do rename a worksheet?
|
1.Double-click the worksheet name in the lower left hand corner and type in the new name
2. Right-click on the sheet name in the lower left hand corner and click "Rename" from the shortcut menu |
|
|
What button and tab do you click on to activate the "wrap text" feature?
|
Format cells button
Alignment tab |
|
|
How are columns identified?
|
Capital letters
|
|
|
How are rows identified?
|
Numbers
|
|
|
Any set of characters containing letters,hyphens, or spaces
|
Text
|
|
|
A series of two or more adjacent cells in a column or row
|
Range
|
|
|
Provides easy access to frequently used commands
|
Quick Access Toolbar
|
|
|
A format that displays a dollar sign to the left of the number and inserts a comma
|
Currency style format
|
|
|
Small rectangle in the lower right-hand corner of a cell that is used to copy formulas
|
Fill Handle
|
|
|
What type of cell reference is $G$5?
|
Absolute cell reference
|
|
|
What type of cell reference changes when it is copied?
|
Relative cell reference
|
|
|
By default, where does Excel align numbers within a cell?
|
Right-aligned
|
|
|
Where do you navigate to center a chart vertically and horizontally on a page?
|
Office button/Print Preview/Margins tab
|
|
|
What button do you click to fit an Excel worksheet on 1 page?
|
Fit to 1 page wide by 1 page tall
|
|
|
True/False
Does changing the orientation to lanescape automatically fit a worksheet onto 1 page? |
False
|
|
|
What does it mean when you see a dotted line on an Excel worksheet?
|
The spreadsheet will print on more than 1 page
|
|
|
If you want to print a document and you see a dotted line on the worksheet, what should you do?
|
Either put the document in landscape view or click "fit to 1 page wide by 1 page tall"
|
|
|
On what tab will you find the button to put a chart on a separate worksheet?
|
Design tab
|
|
|
On what tab will you find buttons to add a chart title, add axis titles, move a legend, or add data labels?
|
Layout tab
|
|
|
On what tab will you find the button to change the style of a chart?
|
Design tab
|
|
|
On what tab will you find the button to change the 3-D rotation of a chart?
|
Layout tab
|
|
|
On what tab will you find the button to change the height and width of a chart?
|
Format tab
|
|
|
On what tab will you find the button to "Sort" data on a chart?
|
Home tab
|
|
|
What key do you hold down when you want to highlight non-adjacent cells, rows, or columns?
|
CTRL key
|
