Computing pretest
In Excel, a number can contain the characters __________.
123456789 +-[ ],/ .$Ee
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.
26
Which view allows you to create or modify a worksheet while viewing how it will look in printed format.
>
_____ are types of changes that occur when text has been omitted from a document and must be inserted later.
Additisions
Using slide layouts eliminates the need to resize objects and adjust the font size, because PowerPoint ____________________.
Automatically sizes the objects and text to fit the placeholders
A ____ is an erasable optical disc you can write on multiple times.
CD-RW (compact disc-rewriteable)
To toggle between the values version and the formulas version of a worksheet, hold down the ____ key.
CTRL key while pressing the ACCENT MARK (`)
To change the name of a field, right-click the column heading for the field, click ____ on the shortcut menu, and then type the desired field name.
Change field
_____ formatting is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.
Character
Less than (<), greater than (>), and NOT (not equal to) are examples of _____.
Comparison operators
When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.
Constant
One way to create a table, is to click ____ on the Ribbon and then click the Table button.
Create
To move to the end of the document, press the _____ key(s).
Ctrl+End
To delete a record, click the Record selector for the record, and then press the ____ key(s).
Delete
If you want text indented on a line to create a lower-level paragraph, _____ the text.
Demote
To change the design of a query, right-click the query and then click ____ on the shortcut menu.
Design View
To open a table in Design view, right-click the table in the Navigation pane and then click ____ on the shortcut menu
Design View
Each time the _____ key is pressed, the paragraph formatting in the previous paragraph is carried forward to the next paragraph.
Enter
You can check formulas for errors by clicking the ____ button on the Formulas tab on the Ribbon.
Error Checking
To check the spelling of an entire document using the keyboard, press the ________ key(s).
F7
A saved database is referred to as a ____.
File
To change the print orientation from portrait to landscape, click the ____ button on the Print Preview tab.
Landscape
To preview and then print a table, select the table, click the Office Button, point to the Print command arrow to display the Print submenu, and then click ____ on the Print submenu.
Print Preview
A(n) _____ is a set of computer instructions that carries out a task on the computer.
Program
____________ consists of electronic components that temporarily store instructions waiting to be executed by the processor, data needed by those instructions, and results of processed data (information).
RAM or random access memory
Every time you enter a value into a cell in the worksheet, Excel automatically ____ formulas.
Recalculates all
When Word flags a possible spelling or grammar error, it also changes the Spelling and Grammar Check icon to a _____.
Red X
A formula using the ____ cell reference B20 instructs Excel to adjust the cell reference as it copies it to the destination area.
Relative
To delete a field in a table, right-click the column heading for the field, and then click ____ on the shortcut menu.
Remove Field
To insert a field as the last field in a table, right-click the Add New Field column heading, click ____ on the shortcut menu, type the desired field name, click the down arrow, and then ensure the correct data type is already selected.
Rename New Field
When copying files, the folder containing the files to be copied is called the _____ folder.
Source
A ____ is a small metal or plastic device that looks like a ballpoint pen, but uses pressure instead of ink to write, draw, or make selections.
Stylus
To find all individuals whose name is Tom or Tim, enter ____ in the Criteria row of the appropriate column.
T?m
A file name can have a maximum of 255 characters, including spaces. The only characters not allowed are the __________.
less than symbol (<), greater than symbol (>), and vertical bar (|) asterisk (*), question mark (?), quotation mark (") backslash (\ ), slash (/), colon (:)
To switch between insert mode and overtype mode, _____.
press the INSERT key on the keyboard
To delete a character in a document, click next to the character and then press the ____ key to erase to the left of the insertion point.
Backspace
A ____ is a duplicate of a file, program, or disk that you can use in case the original is lost, damaged, or destroyed.
Backup
The ____ function is useful when you want to assign a value to a cell based on a logical test.
If
Saving the workbook frequently is important for the following reason:
If you lose power, the worksheet could be lost
How are themes arranged in the Themes gallery?
In alphabetical order running from left to right
____ conveys meaning and is useful to one or more people.
Information
To add a record to a table, click the ____ record button.
New (blank)
The rule is to press the SPACEBAR ____ time(s) after periods, colons, and other punctuation marks
One
To view the results of a query, open it by right-clicking the query in the Navigation pane and clicking ____ on the shortcut menu.
Open
A(n) ____ is system software.
Operating system
Slide layouts have ____________________ arranged in various configurations for containing text or visual content.
Placeholders
To save an existing document with a different file name, use _____.
Save as on the office button menu
Which of the following layouts includes placeholders for text and content?
Title Only
When a file is deleted from a removable media, _____.
the file is stored in the Recycle Bin where you can recover it until you empty the Recycle Bin
