An Excel workbook can be opened by clicking the Open button on the Quick Access toolbar, or by pressing this.
What is the Ctrl + O
100
Instead of typing dollar signs, which function key can you press repeatedly to change a cell reference to absolute, relative, or mixed?
What is F4?
100
A database is made up of a collection of ___.
What is objects?
100
The two general categories of database management systems are file management system and
What is relational database management system?"
100
Triple-clicking in a paragraph of text in a PowerPoint slide will
What is "select the whole paragraph?"
200
If you want to edit only a portion of the data in a cell, first __the cell to make the cell active and move the insertion point inside the cell.
What is double-click?
200
You can adjust a column width to fit the longest entry in the column by positioning the mouse pointer on the right column boundary and what?
What is "double-clicking the left mouse button?"
200
To open an Access database, you can click a file name in the Open Recent Database section of the Getting Started with Microsoft Access screen, or you can click __ and then click Open at the drop-down list.
What is the Office button?
200
A relational database management system eliminates the need for ___ redundancy.
What is data
200
Ctrl + ___ in a sentence will select the entire sentence.
What is "A"?
300
When writing your own formulas, you must begin each formula with.
What is an equal sign?
300
What will happen if you press Ctrl + `(grave accent)?
What is the worksheet will display formulas instead of results?
300
The area of the Access screen that is divided into groups of tabs and commands is called the __.
What is the ribbon?
300
The spell checker can be started by pressing what function key?
What is F7?
300
The Replace dialog box contain these two text boxes:
What is "Find what and Replace with?"
400
An absolute cell reference "does" or "does not" change when copied to another cell.
What is "does not"?
400
Font characteristics for data in a cell can be changed with the Font and Font size buttons in the what?
What is Home tab, Font group and Mini toolbar?
400
A database must contain at least one of these objects?
What is a table?
400
Clicking the Ignore button in the Spelling dialog box causes PowerPoint to __.
What is skip the occurrence of the word?
400
To cut, copy, or paste text in slides, you would use buttons found in this group in the Home tab.
What is the "Clipboard"?
500
An IF function has ___ parts.
What is 3?
500
In Print Preview mode a worksheet is displayed
What is "as it appear when printed?"
500
Which view do you use to define fields, data types, and descriptions?
What is the Design View?
500
How do you select an entire word in a PowerPoint slide?
What is double-click the word?
500
Ctrl + C is the keyboard shortcut for ___ selected text.