Excel 1-3

Question 1

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

Answer 1

True

Question 2

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

Answer 2

Cell style

Question 3

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

Answer 3

True

Question 4

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

Answer 4

False

Question 5

How many chart types does excel have?

Answer 5

15

Question 6

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

Answer 6

False

Question 7

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

Answer 7

Portrait

Question 8

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

Answer 8

True

Question 9

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

Answer 9

Insert

Question 10

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

Answer 10

AutoCalculate

Question 11

What keyboard command is used to select and entire worksheet?

Answer 11

ALT+A

Question 12

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

Answer 12

Chart style

Question 13

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

Answer 13

False

Question 14

What properties are assigned to a workbook?

Answer 14

Document, Standard, and Automatic

Question 15

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

Answer 15

False

Question 16

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

Answer 16

Floating

Question 17

T/F The default workbook theme is Office.

Answer 17

True

Question 18

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

Answer 18

True

Question 19

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

Answer 19

Theme

Question 20

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

Answer 20

False

Question 21

What option provides options for how to fill cells?

Answer 21

AutoFill

Question 22

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

Answer 22

True

Question 23

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

Answer 23

Fixed

Question 24

What kind of text can be in a worksheet?

Answer 24

Spaces, hyphens, and letters

Question 25

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

Answer 25

True

Question 26

What button completes an entry?

Answer 26

Enter

Question 27

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

Answer 27

False

Question 28

What is a predefined formula?

Answer 28

Function

Question 29

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

Answer 29

Colon

Question 30

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

Answer 30

False

Question 31

What works behind the scenes to fix common mistakes?

Answer 31

AutoCorrect

Question 32

What is a visual representation of data?

Answer 32

Chart

Question 33

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

Answer 33

True

Question 34

What is used to measure the height of a character?

Answer 34

Point Size

Question 35

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

Answer 35

True

Question 36

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

Answer 36

Splitting Cells

Question 37

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

Answer 37

Accounting Number

Question 38

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

Answer 38

True

Question 39

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

Answer 39

Name Box

Question 40

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

Answer 40

Range Finder

Question 41

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

Answer 41

Indirect circular

Question 42

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

Answer 42

True

Question 43

A formula consists of what?

Answer 43

Cell references, numbers, and arithmetic operators

Question 44

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

Answer 44

True

Question 45

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

Answer 45

Point Mode

Question 46

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

Answer 46

Relative

Question 47

T/F Exponentiation is an arithmetic operation.

Answer 47

True

Question 48

What feature will enter data automatically based on a pattern?

Answer 48

Flash Fill

Question 49

T/F ALT+ENTER will wrap text.

Answer 49

True

Question 50

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

Answer 50

True

Question 51

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.

Answer 51

#REF!

Question 52

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

Answer 52

True

Question 53

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

Answer 53

Absolute

Question 54

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

Answer 54

False

Question 55

A date stamp can be created using which function?

Answer 55

NOW

Question 56

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

Answer 56

Sparkline

Question 57

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

Answer 57

True

Question 58

The ___ is based on a logic test.

Answer 58

IF Function

Question 59

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

Answer 59

True

Question 60

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

Answer 60

True

Question 61

Cell references in a formula are called ___ .

Answer 61

Assumptions

Question 62

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

Answer 62

False

Question 63

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

Answer 63

ESC

Question 64

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.

Answer 64

False

Question 65

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

Answer 65

Office Cilpboard

Question 66

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

Answer 66

Rotated

Question 67

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

Answer 67

False

Question 68

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

Answer 68

Cut

Question 69

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

Answer 69

True

Question 70

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

Answer 70

True

Question 71

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

Answer 71

0

Question 72

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

Answer 72

True

Question 73

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

Answer 73

Footer

Question 74

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

Answer 74

True

Question 75

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

Answer 75

Margins

Question 76

The ___ version shows the results of formulas entered.

Answer 76

Formula

Question 77

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

Answer 77

True

Question 78

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

Answer 78

Pixel

Question 79

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

Answer 79

False

Question 80

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

Answer 80

False

Question 81

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

Answer 81

CTRL

Question 82

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

Answer 82

False

Question 83

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

Answer 83

Freeze

Question 84

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

Answer 84

False

Question 85

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

Answer 85

What-IF Analysis

Question 86

What refers to the practice of removing barriers?

Answer 86

Accessibility

Question 87

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

Answer 87

False

Question 88

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

Answer 88

Embedded

Question 89

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

Answer 89

True

Question 90

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

Answer 90

False