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;
23 Cards in this Set
- Front
- Back
Quick Access Toolbar
|
toolbar in the upper-left of Excel that provides you with buttons for the Excel commands most frequently used
|
|
Mini Toolbar
|
pops up when you right-click on a cell in an Excel worksheet and contains the command buttons for several commonly used formatting commands to reduce mouse movement.
|
|
Shortcut Menu
|
pops up when you right-click on a cell in an Excel worksheet and displays a list of several other commonly used commands that aren’t shown in the Mini Toolbar
|
|
Wrap Text
|
Excel alignment feature that displays the text on multiple lines within a cell so that all of the text in that cell is visible on a worksheet
|
|
Clear Formats
|
removes all formatting previously done in the selected cell(s), but does not remove the data/contents of the cell(s)
|
|
Clear Contents
|
removes the data/contents, but not the formatting, in selected cell(s)
|
|
Clear All
|
Removes all data/contents and formatting within chosen cell(s)
|
|
Comment Box - Not Name Box or Address Box!
|
a text box linked to a cell that can be used to provide information pertaining to that cell
|
|
Order of Operations
|
indicates which part of a formula to calculate first, second, third, etc.
|
|
Insert Function Dialogue Box
|
assists users with setting up a function
|
|
Arguments
|
provide Excel with the information necessary to compute a function. Arguments are entered in parentheses after the function name.
|
|
TODAY, NOW, DAY, MONTH, YEAR, DATE FUNCTIONS
|
Displays current date, current date and time, displays number between 1-31, displays month of given cell, displays year of given cell
|
|
RAND Function
RANDBETWEEN Function |
generates a random number between 0 and 1.
generates a random number between two numbers specified by the user. |
|
CONCATENATE Function
|
joins multiple text strings together to be joined in one cell.
|
|
Shortcut keys
|
allow a user to quickly activate an Excel command using a combination of keys on the keyboard
|
|
COUNT Function
|
function used to provide a count of the number of cells containing numerical values within the selected range of cells. Disregarding text
|
|
AVERAGEA Function
|
a function used to calculate the average value of a range of cells. Excel assigns a numerical value to any text values contained in the selected range of cells and includes that numerical value in the calculation.
|
|
Column Chart
|
a chart that uses vertical columns to represent numerical data and allows the user to compare values across different categories
|
|
Bar Chart
|
a chart type that uses horizontal bars to represent numerical data and allows the user to compare values across different categories.
|
|
Line Chart
|
a chart type that uses lines to display trends in numerical data over a period of time
|
|
Area Chart
|
a chart type that illustrates multiple sets of numerical data over a period of time
|
|
Doughnut Chart
|
a chart type that uses pieces of the doughnut to show what portion of the total value is contributed by each category and allows the user to display multiple data series with each different data series displayed as a different layer of the doughnut
|
|
Chart Legend
|
shows the user what category of data each color of the chart represents
|