Brainscape's Knowledge GenomeTM

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


See full index

CIT 105 > Excel > Flashcards

Excel Flashcards

0
Q

True or False. The use of a fill color in a cell or range of cells sets off the cell or range from other portions of the worksheet and provides visual impact to draw the user’s eye toward the cell or range.

A

True

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

Which of the following keys toggles between Insert mode and Overtype mode?

A

INSERT

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

True or False. A character with a point size of 10 is about 10/72 of one inch in height.

A

True

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

Which of the following is the path to the Sum button?

A

(Home tab | Editing group)

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

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

A

cell

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

When you decrease the row height to ________, the row is hidden.

A

0

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

True or False. You can snap an embedded chart to the worksheet grid lines by holding down the ALT key while you drag the chart to a new position.

A

True

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

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

A

RIGHT ARROW

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

Which of the following is the path to the Comma Style button?

A

(Home tab | Number group)

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

Which of the following Option buttons gives options for filling cells following a fill operation?

A

Auto Fill Options

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

True or False. The opposite of merging cells is splitting a merged cell.

A

True

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

The _______ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to the nearest cent.

A

Accounting number format

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

True or False. Clicking the Insert Function box opens the Function Arguments dialog box, as shown in the accompanying figure.

A

True

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

Which of the following keys is an alternative to double-clicking the cell edit it 1 point?

A

F2

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

True or False. An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation

A

False

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

The ___________ Options button lists error-checking options following the assignment of an invalid formula to a cell.

A

Trace Error

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

True or False. The Accounting number format assigns a floating dollar sign.

A

False

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

True or False. If each cell in a selected range is next to the to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked.

A

True

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

True or False. When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.

A

False

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

True or False. The values that you use with a function are called arguments.

A

True

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

Which of the following calculations multiplies 23 by 0.01?

A

=23%

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

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

A

operations

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

The _________ is the small black square located in the lower-right corner of the heavy border around the active cell.

A

fill handle

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

True or False. If a major error is made when typing data into a cell, click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then renter the data from the beginning.

A

True

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

A(n) _______ chart is drawn on the same worksheet as the date.

A

embedded

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

True or False. Point mode allows you to select cells for use in a formula by using the keyboard.

A

False

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

Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.

A

True

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

True or False. The Insert Options button lists formatting options.

A

True

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

True or False. When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery

A

False

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

Which of the following is the path to the Copy a d Paste buttons?

A

(Home tab | Clipboard group)

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

What effect does the Comma Style format have on the selected cells?

A

Displays cell contents with two decimal places and commas as thousands separators

31
Q

How many chart types does Excel offer?

A

11

32
Q

True or False. Excel uses the default Oriel Theme for all new workbooks.

A

False.

33
Q

The ________ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

A

Auto Fill Options

34
Q

True or False. To clear the entire worksheet, click the Clear All button on the worksheet.

A

False

35
Q

True or False. A single point is about 1/32 of one inch in height.

A

False

36
Q

Excel remembers the last _________ action you have completed.

A

100

37
Q

The most popular background color is __________.

A

blue

38
Q

The ___________ Options button lists formatting options following an insertion of cells, rows, or columns.

A

Insert

39
Q

You can use the ________ to check which cells are referenced in the formula assigned to the active cell.

A

Range Finder

40
Q

You can enter the correct range in a function by typing the beginning and ending cell references separated by a _______.

A

colon (:)

41
Q

You can open the Format Cells dialog box by pressing the ______ keys.

A

CTRL + 1

42
Q

To enter a number as text, precede it with a(n) ________.

A

Apostrophe (‘)

43
Q

True or False. In a worksheet, columns typically contain information that is similar to a list.

A

False

44
Q

Pressing the _____ keyboard shortcut key(s) selects cell A1.

A

CTRL + HOME

45
Q

When selecting worksheet titles and subtitles, follow the more is less guideline.

A

False

46
Q

You should _______ a function name in the Formula AutoComplete list to select the function.

A

double-click

47
Q

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

A

theme

48
Q

True or False. You can turn off the Bold formatting for selected text by clicking the Bold Off button (Home tab | Font group).

A

False

49
Q

True or False. The Sum button menu allows you to enter one of five often-used functions easily into a cell.

A

True

50
Q

True or False. Best fit means that the width of the column will be increased or decreased by a percentage you specify.

A

False

51
Q

True or False. You can use the arrow keys to complete an entry in Point mode.

A

False

52
Q

To paste copied cell contents, you can press the _______ keys.

A

CTRL + V

53
Q

______ view allows you to create or modify a worksheet while viewing how it will look in printed format.

A

Page Layout

54
Q

In Excel, a number can contain the characters __________.

A

all of the above

55
Q

True or False. Excel can display characters in only three font colors: black, red, and blue.

A

False

56
Q

To remove an embedded chart, you should _________ it and press the DELETE key.

A

click

57
Q

True or False. When you click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column.

A

False

58
Q

The _______ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

A

AVERAGE

59
Q

True or False. To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

A

False

60
Q

What effect does the Accounting Number Format have on the selected cells?

A

Displays cell contents with two decimal places that align vertically

61
Q

True or False. The equal sign (=) precedes a formula.

A

True

62
Q

Clicking the ________ opens the Insert Function dialog box shown in the accompanying figure.

A

Insert Function box on the formula bar

63
Q

True or False. To use Range Finder to verify that a formula contains the intended cell references, click the cell with the formula you want to check.

A

False

64
Q

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

A

understand what is required

65
Q

To print a range of cells in the active worksheet, click _______ in the Setting area in the Print gallery, as shown in the accompanying figure.

A

Print Selection

66
Q

True or False. Moving from left to right, the first calculation in the order of operations is negative (-).

A

True

67
Q

The AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

A

Formula

68
Q

A _____ is a series of two or more adjacent cells in a column or row or rectangular group of cells, as shown in the accompanying figure.

A

range

69
Q

You _______ a worksheet to emphasize certain entries and make the worksheet easier to understand.

A

format

70
Q

True or False. Using Point mode to enter formulas often is faster and more accurate that using the keyboard to type the entire formula.

A

True

71
Q

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

A

26

72
Q

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

A

ESC

73
Q

True or False. As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

A

False

74
Q

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

A

CTRL + C

75
Q

In the accompanying figure, the ranges E4:14 and F13:I13 are formatted with a ____ dollar sign.

A

Fixed

CIT 105 (3 decks)

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