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;
30 Cards in this Set
- Front
- Back
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 Insert Ribbon
enables a user to insert a picture of a program window into a worksheet? |
Screenshot
|
|
Which group on the View Ribbon enables a
user to show or hide the ruler, gridlines, Formula Bar, or headings? |
Show
|
|
Kathryn needs the text in cell A1 to be
angled at 90 degrees. Which alignment option should she select? |
Orientation
|
|
What is the process of viewing a PivotTable
report for a subset that meets the criterion only? |
Filtering
|
|
How do you quickly modify a table style to
meet user preferences? |
Right-click on a style and choose
Duplicate |
|
Which is the name of an interactive
graphical representation of data that allows a user to change the groupings? |
PivotChart
|
|
Which command on the Page Layout
Ribbon enables a user to flip objects on a worksheet? |
Rotate
|
|
What is the name of the list of frequently
used Excel commands available when a user right-clicks an item in the worksheet? |
Shortcut Menu
|
|
What can you use to easily filter pivot tables
and cube functions interactively in a worksheet? |
Slicer
|
|
When copying values in Microsoft Excel,
which feature automatically adjusts cell references for the new copy location? |
Relative reference
|
|
What are graphical objects that contain
buttons a user can click to filter the data in PivotTables and PivotCharts? |
Slicers
|
|
What ribbon contains the commands used
to create a chart in Excel? |
Insert Ribbon
|
|
David wants to arrange the employee
salaries in Column A of his spreasheet from lowest to highest. What command should he use to complete this task? |
Sort
|
|
Which is a tiny chart that provides a visual
representation of data in a worksheet cell? |
Sparkline
|
|
What command do you use to increase or
decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility? |
Zoom to Selection
|
|
Which Chart Tools Ribbon tab enables a
user to apply a style to the selected chart? |
Format
|
|
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
|
|
Which is a way to qualify data by specifying
a matching condition or asking a question of the data? |
Query
|
|
Which of the following is the default method
for summarizing data in a PivotTable? |
Sum
|
|
Kenyon would like to apply the Title format
to the data in Row 1 of a spreadsheet. Which formatting style should he select? |
Cell Style
|
|
Joan has a table that includes demographic
information about her employees. What does all the information about one employee represent? |
Row
|
|
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
|
|
Which command on the Fill options dialog
box is the default option? |
Fill Series
|
|
Which command do you use to reduce the
margin between the border and the text in an indented cell? |
Decrease Indent
|
|
Which function do you use to insert today’s
date in a worksheet so that it automatically updates each time the worksheet is opened? |
Today
|
|
Sharon's spreadsheet contains information
about the number of music downloads in F25. "25" identifies the: |
Row
|
|
Which command on the Home Ribbon do
you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet? |
Format
|
|
Which command creates decorative text in
a worksheet? |
WordArt
|
|
Which quick-number style button formats
numbers to display as currency in the worksheet? |
Accounting
|