Computer Science Semester 2 True of False
When you sort data contained in columns of a worksheet, Excel includes the column headings.
F
You must add fields in a certain order to the design grid.
F
You would use a bar chart to show the relationship of parts to a whole.
F
After you delete a record, you can use the Undo command to restore it
F
An embedded chart is on a separate sheet than the data it represents.
F
By default, Excel is set to print pages in landscape orientation.
F
Deleting does not permanently remove a worksheet and all its contents from the workbook.
F
Design view is helpful when you prepare a worksheet for printing.
F
Each formula begins with a quotation mark (").
F
Each workbook opens with five worksheets.
F
Hiding permanently removes a row or column from view.
F
In a complex formula, subtraction will be performed before multiplication.
F
Inserted cells do not affect the position of existing cells.
F
Numbers that do not fit in the cell are shown as a series of question marks (??????).
F
The =SMALL function displays the smallest number contained in the range identified in the argument.
F
The Description property in the design grid is a required field property that you use to describe what to enter in the field.
F
The Form Footer section displays information at the top of each form.
F
The ROUND function is used to sum the values in a selected range.
F
The cell in the worksheet in which you can type data is called the open cell.
F
The color of the text in a cell may not be changed.
F
The drag-and-drop method is the slowest way to copy or move data short distances in a worksheet.
F
The plus sign (+) is an example of an operand in a worksheet formula.
F
The primary purpose of a spreadsheet program like Excel is to solve problems that involve words.
F
To select a group of controls, click the first control, press and hold down the Tab key, click the other controls, and then release the Tab key.
F
To sort in descending order is to sort in alphabetic order and with numbers from lowest to highest.
F
When you create a blank database, Access creates the first table for you and gives it the name Database1
F
A database is a collection of objects
T
A field property describes a field's contents beyond the field's basic data type, such as indicating the number of characters the field can store or the allowable values that you can enter in the field.
T
A line chart is used to illustrate trends over time.
T
A query is a database object that lets you ask the database about the data it contains.
T
A text function can be used to convert text in a cell to all uppercase or lowercase letters.
T
Any changes that you make in Design view are automatically updated in Datasheet view when you save the table.
T
Excel contains a spell checking tool.
T
Forms have a Navigation bar that you can use to move between records.
T
Freezing rows and columns locks them in position on the screen.
T
If you change the data in a worksheet, the changes will automatically be reflected in any charts that are based on that data.
T
In Design view, you can add, delete, and make changes to the way that fields store data.
T
Scatter charts are sometimes referred to as XY charts because they place data points between an x- and y-axis.
T
Text that is too long to fit within a cell is displayed in the next cell, if it is empty.
T
The 3 sections of a form are the Form Header, Detail, and Form Footer.
T
The AutoSum feature may be used to add a long column of numbers.
T
The Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs
T
The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Office Button, the Ribbon, and the status bar.
T
The Formula Bar appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value.
T
The fill commands are available only if you plan to copy to cells adjacent to the original cell
T
To add a condition to a field, click in the field's Criteria box, and then type the condition.
T
To freeze panes, on the View tab of the Ribbon, in the Window group, click the Freeze Panes button, and then click Freeze Panes.
T
To paint a format, you must highlight the cell that you want to format.
T
To remove one or more rows or columns, right-click the selected rows or columns, and then click Delete on the shortcut menu.
T
To resize a column, place the pointer on the right edge of the column heading until the pointer changes to a doubleheaded arrow. Click and drag to the right until the column expands to the width you want.
T
When you open an existing database, the Navigation Pane opens on the left side of the screen
T
When you resize controls in a control layout in Layout view, reducing the width of one control reduces all the widths of all other controls in the control layout at the same time.
T
You can include cell references in a formula more quickly by using the point-and-click method to click each cell, rather than typing cell references.
T
You can make Column and Pie charts 3D (three dimensional).
T
You can move a field in the design grid by clicking the bar above the field, and then dragging the field to the new location.
T
You can use shortcut keys to quickly cut, copy, and paste cells.
T
You can use the Undo button on the Quick Access Toolbar to restore a deleted field value, but deleting a record permanently deletes it from the record source.
T
You may display formulas in the worksheet rather than displaying formula results.
T
You must enter an equal sign (=) as the first character in a function formula so that Excel will recognize it as a formula.
T