Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

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?

32
Q

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

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.

35
Q

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

36
Q

Excel remembers the last _________ action you have completed.

37
Q

The most popular background color is __________.

38
Q

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

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 _______.

41
Q

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

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.

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.

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.

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).

49
Q

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

50
Q

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

51
Q

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

52
Q

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

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.

56
Q

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

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.

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.

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.

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.

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.

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 (-).

67
Q

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

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.

69
Q

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

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.

71
Q

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

72
Q

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

73
Q

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

74
Q

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

75
Q

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

CIT 105 (3 decks)

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