CSC Midterm study guide

About this deck

By: Jason VanDeWalle
Created: 2012-08-28
Size: 50 flashcards
Views: 20

About StudyBlue

STUDYBLUE makes things that make you better at school. Things like online flashcards with photos and audio. Things like personalized quizzes and friendly reminders about when (and what) to study next. Think of it as a digital backpack™: access to all of your study materials online and on your phone. STUDYBLUE exists to make studying efficient and effective for every student, for free. Join us.

“I have been getting MUCH better grades on all my tests for school. Flash cards, notes, and quizzes are great on here. Thanks!”
Kathy

Sign up (free) to study this.

Worksheet

An Excel _____ allows data easily to be summarized and charted.

requirements

The person or persons requesting the worksheet should supply their requirements in a _____ document.

Understand what is required

The first step in creating an effective worksheet is to make sure you _____.

cell

To enter data in a cell, you must first select or activate the _____.

Text

_____ is/are used to add worksheet, column, and row titles on a worksheet.

ESC

To cancel an entire entry before entering it into the cell, press the _____ key.

Enter

Clicking the _____ box completes an entry.

insertion point

The _____ is the blinking vertical line that indicates where the next typed character will appear.

AutoCorrect

The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

RIGHT ARROW

Pressing the _____ key to complete an entry activates the adjacent cell the right.

function

A _____ is a prewritten formula that is built into Excel.

ALT+ENTER

To start a new line in a cell, press the _____ keys.

20xx

When you enter a two-digit year that is less than 30, Excel changes the year to _____.

=23%

Which of the following calculations multiplies 23 by 0.01?

operations

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _____ that you use in algebra.

When Excel follows the order of operations, the formula, 8*3+2 equals _____.

Excel assigns the value in cell G15 to the active cell

Which of the following happens when you enter the formula =g15 into a cell?

select cells for use in a formula using the mouse pointer

Point mode allows you to _____, as shown in the accompanying figure.

relative

The adjusted cell references in a copied and pasted formula are called _____ references.

assumptions

Cell references in a formula are called _____.

constant

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than _____ values.

Range Finder

You can ensure correctness in your formulas by carefully checking them using _____.

determine the necessary functions and formulas needed

Which of the following is a suggested decision to make when you plan a workbook?

use Excel to create the worksheet

With a solid understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to _____.

Rotated

_____ text often provides a strong visual appeal.

Dialog Box Launcher

To open the Format Cells dialog box with the Alignment sheet active, click the Format Cells _____.

Fill Formatting Only

The _____ Auto Fill option that fills the destination area using the format of the source area; no content if filled.

Qtr2

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

data table

You use a _____ to automate data analyses.

amortization schedule

An _____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest over a period.

Cell protection

_____ ensures that users do not change values inadvertently that are critical to the worksheet.

The formula checker

_____ examines the formulas in a workbook in a manner similar to the way spell checker examines a workbook for misspelled words.

entry

The data _____ section of a worksheet includes data items entered by a user of a worksheet.

borders

Cell _____ help to set off sections of a worksheet.

name, name

To print individual sections of a worksheet, _____ these sections and then print them by _____.

unprotected

When considering which cells another worksheet user should be able to manipulate, leave the cells _____.

SHIFT

You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the _____ key and clicking the Sheet1 tab.

name

A cell _____ often is created from column or row titles.

table

A worksheet's row-and-column structure can be used to organize and store a _____.

field

Each row of an Excel worksheet used to create a table can store a record, and each column can store a _____.

column

In a table, a column that contains formulas or functions is called a calculated _____.

record

In a table, or database, the data related to each person or item is called a _____.

table

A _____ should be formatted so that the records are easily distinguished.

database

Even though Excel is not a true _____ management system like Access, it does give you many of the same basic capabilities.

(Home tab | Styles group)

Which of the following is the path to the Format as Table button?

Row banding

_____ causes adjacent rows in the table is distinguished from surrounding rows.

calculated

A _____ column is a column in a table in which each row uses a common formula that references other fields in the table.

Convert to Range

To change an active table back to a normal range of cells, right-click the table, point to Table on the shortcut menu, and then click _____ on the Table submenu.

About this deck

By: Jason VanDeWalle
Created: 2012-08-28
Size: 50 flashcards
Views: 20

About StudyBlue

“I have been getting MUCH better grades on all my tests for school. Flash cards, notes, and quizzes are great on here. Thanks!”
Kathy