Brainscape's Knowledge GenomeTM

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


See full index

Excel Unit Test > Excel 1-3 Flashcards > Flashcards

Excel 1-3 Flashcards

1
Q

T/F Excel Automatically left aligns the text in a cell.

A

True

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

What is a predefined font, font size, and color that can be applied to a cell?

A

Cell style

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

T/F the ARROW button selects cells in the direction of the key.

A

True

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

T/F The PAGE DOWN button selects the cell at the beginning of the row that contains the active cell.

A

False

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

How many chart types does excel have?

A

15

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

T/F You should use the enter key to clear a cell

A

False

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

What type of orientation will position pages with the short edge at the top?

A

Portrait

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

T/F In-cell editing is when you edit directly in the cell

A

True

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

What button/key toggles between Insert Mode and Overtype Mode?

A

Insert

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

What area on the status bar will display the Average, Count, and Sum of a selected range?

A

AutoCalculate

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

What keyboard command is used to select and entire worksheet?

A

ALT+A

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

What is applied to enhance the appearance of the entire chart?

A

Chart style

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

T/F a pie chart is used to show changes over time.

A

False

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

What properties are assigned to a workbook?

A

Document, Standard, and Automatic

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

T/F Excel has less than 400 functions that will perform nearly every type of calculation.

A

False

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

What type of dollar sign will display using the Currency style format?

A

Floating

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

T/F The default workbook theme is Office.

A

True

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

T/F You can press the F8 key and arrow keys to select a range when using the keyboard.

A

True

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

A company may standardize with a specific ____ so all of their documents will have a similar appearance.

A

Theme

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

T/F Arrows can be used to complete an entry in Point Mode.

A

False

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

What option provides options for how to fill cells?

A

AutoFill

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

T/F The MAX function will find the highest value in a range.

A

True

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

What type of dollar sign is displayed using the Accounting Number format?

A

Fixed

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

What kind of text can be in a worksheet?

A

Spaces, hyphens, and letters

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

T/F A worksheet is identified by columns and rows.

A

True

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

What button completes an entry?

A

Enter

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

T/F Overflow text will display in the adjacent cells as long as there is text in the cells adjacent.

A

False

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

What is a predefined formula?

A

Function

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

What separates the first cell and last cell in a range?

A

Colon

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

T/F A plus sign must start at the beginning of all formulas and functions.

A

False

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

What works behind the scenes to fix common mistakes?

A

AutoCorrect

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

What is a visual representation of data?

A

Chart

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

T/F Common font styles are bold, underline, and italic.

A

True

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

What is used to measure the height of a character?

A

Point Size

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

T/F The comma style formats numbers with two decimal places and commas as thousands separator.

A

True

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

What kind of cells will separate cells that have been combined together?

A

Splitting Cells

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

What kind of format displays numbers with two decimal places and a currency number?

A

Accounting Number

38
Q

T/F Bold text has a darker appearance than normal text.

A

True

39
Q

What is located to the left of the formula bar that is used to select a cell?

A

Name Box

40
Q

The ESC key will stop the operations of what when reviewing the accuracy of formulas?

A

Range Finder

41
Q

A(n) ___ reference occurs when a formula refers to another cell(s) that include a formula that refers back to the original cell.

A

Indirect circular

42
Q

T/F Flashy or confusing visual elements should be avoided in a worksheet.

A

True

43
Q

A formula consists of what?

A

Cell references, numbers, and arithmetic operators

44
Q

T/F Negation is first in the order of operations when working in Excel.

A

True

45
Q

What is a way to enter formulas that is faster and more accurate than using the keyboard?

A

Point Mode

46
Q

The adjusted cell reference that is copied and pasted in a formula is called a(n) ___ cell reference.

A

Relative

47
Q

T/F Exponentiation is an arithmetic operation.

A

True

48
Q

What feature will enter data automatically based on a pattern?

A

Flash Fill

49
Q

T/F ALT+ENTER will wrap text.

A

True

50
Q

T/F An equal sign should precede (come before) a formula or function.

A

True

51
Q

If formulas located in other cells referenced in a deleted column or row, Excel will not adjust these cells and instead display the ___ error message.

A

REF!

52
Q

T/F When a number is entered with its format symbol, Excel will display and format the number with the assigned format.

A

True

53
Q

What type of referencing does Excel use to keep a row or column from adjusting in a formula when it’s copied?

A

Absolute

54
Q

T/F A logic test is a decision making process.

A

False

55
Q

A date stamp can be created using which function?

A

NOW

56
Q

A ___ chart will display trends and variations in data in a single cell.

A

Sparkline

57
Q

T/F negative numbers are shown with parentheses rather than a negative sign preceding the number in accounting.

A

True

58
Q

The ___ is based on a logic test.

A

IF Function

59
Q

T/F All error messages begin with a number sign.

A

True

60
Q

T/F A hard coded fixed date should be used if you are wanting to record when a worksheet is created.

A

True

61
Q

Cell references in a formula are called ___ .

A

Assumptions

62
Q

T/F The decrease indent button will indent two spaces to the right each time it is pressed.

A

False

63
Q

What key will remove the marquee from the source area and disable the past button?

A

ESC

64
Q

T/F When you copy a cell, the data in the original location is cleared and the format of the cell is rest to the default.

A

False

65
Q

What is a temporary storage area that allows you to collect text and graphics?

A

Office Cilpboard

66
Q

___ text allows for more text to fit into a smaller column width.

A

Rotated

67
Q

T/F Move and drop is using the mouse to move or copy cells.

A

False

68
Q

Which button will remove cells from the worksheet and copy them?

A

Cut

69
Q

T/F Keep Source Formatting will copy the contents, format, and styles of a source area.

A

True

70
Q

T/F Column boundaries can be used to adjust the column width.

A

True

71
Q

A column width of ___ is classified as a hidden column.

A

0

72
Q

T/F To check the spelling of worksheets in a workbook, right click any sheet tab, select all sheets, then check the spelling.

A

True

73
Q

What text/graphic prints at the bottom of every page?

A

Footer

74
Q

T/F The Between relational operator will display cell values between two numbers.

A

True

75
Q

___ are the portions of a printed page outside the main body of the document and are always blank.

A

Margins

76
Q

The ___ version shows the results of formulas entered.

A

Formula

77
Q

T/F The conditional formatting feature will change a cell’s appearance based on a rule.

A

True

78
Q

A(n) ___ is a picture element and is a measurement of height and width.

A

Pixel

79
Q

T/F Normal layout view shows the worksheet divided into pages.

A

False

80
Q

T/F ALT + ` is used to display formulas entered in a worksheet.

A

False

81
Q

What key allows you to select multiple worksheet tabs at one time?

A

CTRL

82
Q

T/F Axis titles provide clarity for understanding the chart data.

A

False

83
Q

The __ feature will divide the worksheet window into multiple panes.

A

Freeze

84
Q

T/F When you magnify the worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.

A

False

85
Q

What is known as a sensitivity analysis that will recalculate all formulas when new data is entered

A

What-IF Analysis

86
Q

What refers to the practice of removing barriers?

A

Accessibility

87
Q

T/F The CTRL key will allow one to select multiple sheet tabs at one time.

A

False

88
Q

A(n) __ chart is one that will display in the worksheet.

A

Embedded

89
Q

T/F The chart elements button will allow one to modify the axis titles and data labels.

A

True

90
Q

T/F The major identifier for charts is the data series.

A

False

Excel Unit Test (1 decks)

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