Show:
Excel
Word
Excel
Access
PowerPoint
100
A much faster ways to select a dataset than using a mouse and dragging the cursor.
What is Ctrl+Shift and an arrow key
100
The paragraph mark (ΒΆ) is a formatting mark that indicates where this key is pressed.
What is the enter key?
100
The intersection of each column and row.
What is a cell?
100
This consists of a collection of tables, each of which contains information on a specific subject.
What is a database?
100
This view is the default view when a user opens PowerPoint.
What is normal view?
200
How to separate one cell into its components in adjoining cells.
What is Text to Columns
200
This highlights an entire sentence with one mouse click.
What is holding down the Ctrl key and clicking on any word in the sentence?
200
Combining two or more cells together.
What is merging?
200
This contains information about a given person, product, or event.
What is a record?
200
The basic unit of any PowerPoint presentation.
What is the slide?
300
Convert column data to rows or row data to columns
What is Paste Special to Transpose?
300
This allows you to see hidden characters in your document.
What is Ctrl+Shift+8?
300
Excel opens a new workbook with three __________.
What are worksheets?
300
You can find all clients whose names begin with Be, by entering _____ in the Criteria row of the Client Name field.
What is Be*?
300
A selected placeholder is outlined in this.
What is a dashed line?
400
Allows only limited data values in a cell
What is Validate Data?
400
This allows you to write anywhere on the page.
What is double clicking anywhere on the page?
400
A Pie chart with one or more slices offset.
What is an exploded Pie chart?
400
This field type allows the user to select from a list of values.
What is a lookup field?
400
Elements such as lines, arrows, callouts, and banners that can be added to a slide.
What are shapes?
500
Prevents the shifting of cell values when copying cell formulas.
What is a $?
500
This command auto-generates nonsense text as a placeholder.
What is =lorem(p,l) or =rand(p,l)?
500
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
What is 26?
500
To create a simple form, click Create on the Ribbon and then click this button on the Create tab.
What is the form button?
500
This indicates that a transition animation effect is applied to a slide when viewing it in the Slides tab.
What is a star?