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;
19 Cards in this Set
- Front
- Back
Dorothy designed a column chart and
would like to add an element that will help lead the eye and improve readability of the chart. Which chart feature should she include? |
Gridlines
|
|
In an Microsoft Excel worksheet, how do
you change the width of a column so that the widest entry will fit? |
AutoFit
|
|
What is the process of bringing data
containing text fields separated by commas into Excel called? |
Importing data
|
|
What is the process of viewing a PivotTable
report for a subset that meets the criterion only? |
Filtering
|
|
Which is the name of an interactive
graphical representation of data that allows a user to change the groupings? |
PivotChart
|
|
Which area, on the left side of the formula
bar, can you look at to determine the cell address of a selected cell? |
Name box
|
|
Joan has a table that includes demographic
information about her employees. What does all the information about one employee represent? |
Row
|
|
Which group on the Formulas Ribbon
contains a command that allows a user to create names for cells to use in a formula? |
Defined Names
|
|
Which command on the Page Layout
Ribbon enables a user to flip objects on a worksheet? |
Rotate
|
|
Which Chart Tools Ribbon tab enables a
user to apply a style to the selected chart? |
Format
|
|
How do you quickly modify a table style to
meet user preferences? |
Right-click on a style and choose
Duplicate |
|
John would like to display the count of
employees last name on the Y-axis. What area would he drag this information to in order to display correctly? |
Values
|
|
What command do you use to apply a
background color to cells in a worksheet? |
Fill Color
|
|
Larkeysha has created a spreadsheet
containing student grades. Which function would she use to return the current date in cell A1? |
TODAY
|
|
Jennifer is calculating her GPA. If she uses
"=(A1+A2+A3+A4)/4", this is an example of which type of entry? |
formulas
|
|
When copying values in Microsoft Excel,
which feature automatically adjusts cell references for the new copy location? |
Relative reference
|
|
Which group on the View Ribbon enables a
user to show or hide the ruler, gridlines, Formula Bar, or headings? |
Show
|
|
Which ribbon contains the command to
apply a theme to a worksheet in Microsoft Excel? |
Page Layout
|
|
David only wants to view the employees in
the Marketing department who earn a salary of more than $25,000. What command should he use to complete this task? |
Filter
|