Deck 1: Applying Fundamental Excel Skills and Tools in Problem Solving

Question 1

Typing a value into a cell instead of entering the formula that produced the value is a good practice when building a spreadsheet.

Answer 1

False

Question 2

Excel provides a variety of tools for designing a spreadsheet, which is referred to as a worksheet in the Excel application.

Answer 2

True

Question 3

The COUNT function ignores blank cells and cells with text.

Answer 3

True

Question 4

To use a "general" formula over and over again but with a different set of numbers, use a feature called Rotating Values.

Question 5

In the Format Cells dialog box, the Category box lists the available number formats.

Question 6

A formula is an equation that performs calculations, the result of which can be either a value or a label.

Question 7

When Excel rounds the display, it does so by rounding any number half or lower down to the next value.

Question 8

The Comma Style button formats numbers with commas and no decimal places.

Question 9

The pound sign (#) is the syntax used by Excel to indicate that a cell reference is absolute.

Question 10

The calculations and their results are inputs.

Question 11

Some of the most common formatting options available in the Format Cells dialog box are also available on the HOME tab and on the Mini toolbar.

Question 12

When working with multiple worksheets in a workbook, it's a good idea to rename each worksheet tab based on the default labels (Sheet1, Sheet2, and so on).

Question 13

Sheet names are only needed in formulas when the cell being referenced is on another worksheet.

Question 14

The labels and values upon which Excel calculations are based are outputs.

Question 15

The rules programmed into a function are referred to as the function's algorithm.

Question 16

Range names, like text labels, are enclosed in quotation marks when used in formulas.

Question 17

The ### signs indicate that the column width is insufficient to display the complete value in the cell.

Question 18

If there is insufficient room to display a label in a cell, the text may be displayed in a truncated format.

Question 19

The fill handle is a small square in the lower-right corner of a selected cell that you use to delete the contents of the selected cell.

Question 20

When entering a value in a cell, you should enter the value with commas.

Question 21

The COUNT function recognizes both text and number cells. _________________________

Question 22

If a column shows the numbers 1, 2, and 3 as well as the SUM equaling 6, the number 6 is a ____.

A) calculated value
B) numeric value
C) text label
D) submenu

Question 23

The Accounting Number Style displays values with commas and two decimal places, but no dollar signs. _________________________

Question 24

The word Component entered into a cell represents a ____.

A) calculated value
B) subhead
C) numeric value
D) text label

Question 25

A paper spreadsheet is simply a sheet organized into columns and headings. _________________________

Question 26

The dollar sign syntax is used by Excel to indicate that a cell reference is absolute. _________________________

Question 27

In a spreadsheet, a number such as 12 entered into a cell represents a ____.

A) calculated value
B) submenu
C) numeric value
D) text label

Question 28

Excel provides a variety of tools for designing and working with a spreadsheet, which is referred to as a ____ in the Excel application.

A) chart
B) spreadsheet
C) table
D) worksheet

Question 29

The No Break button automatically wraps text within the cell, and the cell height adjusts accordingly. _________________________

Question 30

To use a "general" formula over and over again but with a different set of numbers, use a feature called absolute cell referencing. _________________________

Question 31

Excel stores times as decimal fractions. _________________________

Question 32

The function inputs are referred to as arguments. _________________________

Question 33

The labels and values upon which the calculations are based are called ____.

A) inputs
B) outputs
C) calculated values
D) numeric values

Question 34

SUM calculates the minimum value in a list of values. _________________________

Question 35

A function is always structured beginning with the function address and an opening parenthesis mark. _________________________

Question 36

Functions are predefined formulas that perform calculations. _________________________

Question 37

A(n) value is an equation that performs calculations. _________________________

Question 38

MAX determines the number of values in a list. _________________________

Question 39

Each function has its own output, which specifies the function name and order of the arguments. _________________________

Question 40

A cell formatted with the Proportion Style displays the % symbol following the value. _________________________

Question 41

The error message #NUM! means that there is ____.

A) insufficient width in the cell to display data
B) an invalid cell reference
C) an invalid numeric value in a formula or function
D) no answer

Question 42

To toggle between the display of formulas and the display of values, press and hold the Ctrl key while pressing ____.

A) ` (grave accent)
B) % (percent)
C) ? (question mark)
D) + (plus)

Question 43

The result of a formula can be a ____.

A) value
B) label
C) either a or b
D) neither a nor b

Question 44

The Accounting Number Format displays ____.

A) the dollar sign at the left edge of the cell
B) commas
C) two decimal places for the numeric value, with a column of values aligned on the decimal point
D) all of the above

Question 45

The ____ Style button formats numbers with commas, two decimal places, and values aligned on the decimal point.

A) Currency
B) Comma
C) Percent
D) all of the above

Question 46

Excel formulas can contain ____.

A) constants
B) cell references to previously entered values
C) cell references to other calculated values
D) all of the above

Question 47

The Excel error message for "no answer" is ____.

A) #N/A
B) #NA
C) !NA
D) ###

Question 48

The error message #DIV/0! means that there is ____.

A) division by zero
B) an invalid cell reference
C) an invalid numeric value in a formula or function
D) a wrong argument type or operand

Question 49

When the formulas are displayed, the worksheet column widths and formats ____.

A) do not change
B) are modified to accommodate the display
C) default to a standard format
D) all of the above

Question 50

One way to determine where an error might exist in a formula is to print the worksheet in a format that shows ____.

A) values
B) formulas
C) both a and b
D) neither a nor b

Question 51

The error message ###### means that there is ____.

A) insufficient width in the cell to display data, or negative date/time
B) an invalid cell reference
C) an invalid numeric value in a formula or function
D) no answer

Question 52

The ____ Style button formats numbers as percentages, displayed to the nearest percent, with no decimal places.

A) Currency
B) Comma
C) Percent
D) all of the above

Question 53

To correct the problem of the error message ######, ____.

A) double-click the column dividing line to make the column as wide as the longest entry in the column
B) drag the column dividing line to the desired width
C) choose the Column option on the Format menu and then specify column width
D) any of the above

Question 54

The ____ button formats numbers in the Accounting Number Format.

A) $
B) ,
C) %
D) all of the above

Question 55

The error message #REF! means that there is ____.

A) insufficient width in the cell to display data, or negative date/time
B) an invalid cell reference
C) an invalid numeric value in a formula or function
D) no answer

Question 56

Changing the cell background, bolding the text, and applying a border can be accomplished using the buttons in the ____ group on the HOME tab.

A) Cells
B) Text
C) Font
D) Color

Question 57

A formula in Excel always begins with a(n) ____.

A) question mark (?)
B) equal sign (=)
C) pound sign (#)
D) asterisk (*)

Question 58

To display formulas in a worksheet, click the FORMULAS tab on the ribbon and then click Show Formulas in the ____.

A) Formula Editing group
B) Formula Show/Hide group
C) Formula Auditing group
D) Formula Now group

Question 59

The Excel error type for "wrong argument type or operand" is ____.

A) #VALUE
B) #NAME
C) #VALUE!
D) #NAME?

Question 60

Calculations and their results are called ____.

A) inputs
B) outputs
C) calculated values
D) numeric values

Question 61

When Excel rounds the display, it does so by rounding any number ____ down to the next value.

A) greater than half
B) less than half
C) equal to or less than half
D) equal to or greater than half

Question 62

If a formula reads =1/10/2014+10, Excel will treat the 1/10/2014 as a(n) ____.

A) calculation
B) date
C) error
D) none of the above

Question 63

____ is/are last in the order of precedence rules.

A) Addition and subtraction from left to right
B) Exponentiation
C) Multiplication and division from left to right
D) Operations in parentheses

Question 64

The Excel operator for exponent is ____.

A) *
B) /
C) ^
D) &

Question 65

If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is ____.

A) 0
B) 1
C) 11/10
D) 4

Question 66

If A1=2, then the resulting value of =A1*(3+5) is ____.

A) 10
B) 11
C) 16
D) 30

Question 67

Excel stores dates as sequential numbers starting with January 1st of the year ____.

A) 1000
B) 1900
C) 2000
D) 2007

Question 68

The Excel operator for addition is ____.

A) +
B) *
C) /
D) =

Question 69

____ is/are first in the order of precedence rules.

A) Addition and subtraction from left to right
B) Exponentiation
C) Multiplication and division from left to right
D) Operations in parentheses

Question 70

If 5% is displayed in a cell, the actual value that is stored is ____.

A) .005
B) .05
C) .5
D) 5

Question 71

When working with multiple worksheets in a workbook, it's a good idea to ____ each worksheet tab.

A) rename
B) delete
C) reorder
D) make a duplicate of

Question 72

When Excel rounds the display, it does so by rounding any number ____ up to the next value.

A) greater than half
B) less than half
C) equal to or less than half
D) equal to or greater than half

Question 73

The Excel operator for subtraction is ____.

A) +
B) *
C) -
D) =

Question 74

____ are predefined formulas that perform calculations.

A) Functions
B) Arguments
C) Rules
D) Codes

Question 75

The Excel operator for division is ____.

A) /
B) *
C) ^
D) =

Question 76

Excel stores times as ____.

A) decimal fractions
B) whole numbers
C) mini clocks
D) all of the above

Question 77

____ is/are third in the order of precedence rules.

A) Addition and subtraction from left to right
B) Exponentiation
C) Multiplication and division from left to right
D) Operations in parentheses

Question 78

The Excel operator for multiplication is ____.

A) +
B) -
C) *
D) =

Question 79

If A1=2, the resulting value of =3*A1^3 is ____.

A) 9
B) 12
C) 18
D) 24

Question 80

____ is/are second in the order of precedence rules.

A) Addition and subtraction from left to right
B) Exponentiation
C) Multiplication and division from left to right
D) Operations in parentheses