Computer Applications Final

Question 1

A ______ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.

Answer 1

Theme

Question 2

A______ is a prewritten formula that is built into Excel.

Answer 2

Function

Question 3

As in algebra, you can use _________ to override formula that is built into Excel.

Answer 3

Parenthesis

Question 4

Point mode allows you to _____________.

Answer 4

Select cells using the mouse pointer.

Question 5

The __________ function determines the lowest number in a range.

Answer 5

minimum

Question 6

The _________ fuction displays the highest value in a range.

Answer 6

max

Question 7

The __________function sums the numbers in the specified range and then divides the sum by the number of cells with numeric calues in the range.

Answer 7

average

Question 8

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

Answer 8

relative

Question 9

The __________ preceded a formula.

Answer 9

equal sign

Question 10

The percent __________ instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, round the result to the nearest percent, and adding a percent sign.

Answer 10

style button

Question 11

To copy cell contents, you can select the cell and then press the __________ keys.

Answer 11

control plucs c

Question 12

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

Answer 12

26

Question 13

When you click the __________ Font size button, Excel assigns the next highest font size in the Font Size gallery.

Answer 13

increase

Question 14

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

Answer 14

operations

Question 15

What formula would multiply 23 by 0.01?

Answer 15

23%

Question 16

What is the path to the Conditional Formatting button?

Answer 16

Home tab 4/style group

Question 17

An alternative to clicking the Paste button is to press the ______key.

Answer 17

enter

Question 18

Cell reference in a formula are called _________.

Answer 18

assumptions

Question 19

The ______ function is useful when you want to assign a value to a cell based on a logical test.

Answer 19

if

Question 20

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

Answer 20

Constant

Question 21

What symbol(s) make a call absolute cell reference?

Answer 21

=$b$4

Question 22

_____ is a program known as a database management system (DBMS).

Answer 22

Access

Question 23

In ________ you can rearrange the order of the fields in a datasheet by dragging them to a new location.

Answer 23

data sheet view

Question 24

In Datasheet view, the table displays its data in rows and columns in a _______.

Answer 24

data sheet

Question 25

In a database, "Denver" is an example of a(n) \_\_\_\_\_\_.

Question 26

After you save a table, the new table name appears \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.

Answer 26

on the tab for the table and end the navigation pane

Question 27

The first step in creating a database is to \_\_\_\_\_\_\_\_\_\_\_\_.

Answer 27

determine a storage location for the database

Question 28

You need to save a new record after entering it. Access does not save new records\_\_\_\_\_\_\_\_.

Answer 28

automatically

Question 29

A ______ temporarily displays records in a datasheet based on the condition that you specify.

Answer 29

filter

Question 30

A query can contain __________ of the fields in the table.

Answer 30

one, some or all

Question 31

An easy method to change th way data is sorted is to click any field value in the field you want to sort, and then click the Ascending or Descending buttons in the _______ group on the Home tab.

Answer 31

sort and filter

Question 32

When viewing a table in Design view, the field names and data types appear in the _________ in the top half of the Table window.

Answer 32

design grid

Question 33

A ___ is a database object that lets you ask the database about the data it contains.

Answer 33

query

Question 34

An easy way to create a query is to use the \_\_\_\_\_\_\_which asks you what data you want to see by letting you select options in dialog boxes.

Answer 34

simple query

Question 35

To create a relationship between tables, click the ___________ tab on the Ribbon. In the Relationships group, click the Relationships button.

Answer 35

database tools

Question 36

When you opne a query object, you \_\_\_\_the query.

Answer 36

run

Question 37

When you run a query, the data in the table on which the query is based ________ in the table.

Answer 37

remain

Question 38

You can run the query by clicking the Run button in the _____ group on the Query Tools Design tab.

Answer 38

results

Question 39

The Form Wizard provides four form layouts from which to choose. The \_\_\_\_\_\_\_layout displays fields in a stacked column format, with labels to the left of their controls.

Answer 39

coloumnar

Question 40

Just as with forms, the tables or queries that contain the data used in a report are called the \_\_\_\_\_\_\_\_\_\_\_\_.

Answer 40

records source

Question 41

When a report contains more than one page, you can click the buttons on the ________ bar at the bottom of the Print Preview window to view additional pages in the report.

Answer 41

page navigaiton

Question 42

\_\_\_\_\_\_\_appear horizontally and are identified by numbers on thelet side of the worksheet window.

Answer 42

Rows

Question 43

\_\_\_\_\_\_\_\_\_\_ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.

Answer 43

Columns

Question 44

If a cell is not ______ enough to display all the cell's content, extra text entends into the next cells if there is room.

Answer 44

wide

Question 45

Microsoft Office Excel 2010 is the ________ program in Microsoft Office 2010.

Answer 45

spread sheet

Question 46

Numbers that extend beyound a cell's width appear as _____________ in the cell.

Answer 46

####

Question 47

The \_\_\_\_\_\_\_\_, or cell reference area located below the Ribbon, displays the cell reference of the active cell.

Question 48

The easiest way to change the active cell in a worksheet is to \_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_.

Answer 48

click the cell on the ribbon and type in the cells location

Question 49

To edit the data directly in a cell, make the cell active and then press the \_\_\_\_\_\_\_\_\_\_key or double-click the cell.

Answer 49

F2

Question 50

To replace cell contents you can select the cell, type the new data, and then enter the date by \_\_\_\_\_\_\_\_\_\_\_.

Answer 50

press in the enter key, pressing the tab key clicking the enter button on the formula bar