Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Kierra's Final Exams > Computer Applications Final > Flashcards

Computer Applications Final Flashcards

1
Q

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

A

Theme

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

A______ is a prewritten formula that is built into Excel.

A

Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Parenthesis

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Point mode allows you to _____________.

A

Select cells using the mouse pointer.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

The __________ function determines the lowest number in a range.

A

minimum

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

The _________ fuction displays the highest value in a range.

A

max

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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.

A

average

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

relative

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

The __________ preceded a formula.

A

equal sign

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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.

A

style button

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

control plucs c

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

26

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

increase

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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.

A

operations

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What formula would multiply 23 by 0.01?

A

23%

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is the path to the Conditional Formatting button?

A

Home tab 4/style group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

enter

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Cell reference in a formula are called _________.

A

assumptions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

if

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

Constant

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

=$b$4

22
Q

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

A

Access

23
Q

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

A

data sheet view

24
Q

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

A

data sheet

25
Q

In a database, “Denver” is an example of a(n) ______.

A
26
Q

After you save a table, the new table name appears ____________________.

A

on the tab for the table and end the navigation pane

27
Q

The first step in creating a database is to ____________.

A

determine a storage location for the database

28
Q

You need to save a new record after entering it. Access does not save new records________.

A

automatically

29
Q

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

A

filter

30
Q

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

A

one, some or all

31
Q

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.

A

sort and filter

32
Q

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

A

design grid

33
Q

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

A

query

34
Q

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.

A

simple query

35
Q

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

A

database tools

36
Q

When you opne a query object, you ____the query.

A

run

37
Q

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

A

remain

38
Q

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

A

results

39
Q

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.

A

coloumnar

40
Q

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

A

records source

41
Q

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.

A

page navigaiton

42
Q

_______appear horizontally and are identified by numbers on thelet side of the worksheet window.

A

Rows

43
Q

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

A

Columns

44
Q

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

A

wide

45
Q

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

A

spread sheet

46
Q

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

A

####

47
Q

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

A
48
Q

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

A

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

49
Q

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

A

F2

50
Q

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

A

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

Kierra's Final Exams (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions