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

Question 1

The calculations and their results are inputs.

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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 6

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

Question 7

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

Question 8

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

Question 9

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 10

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

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

The COUNT function ignores blank cells and cells with text.

Question 19

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

Question 20

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 21

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 22

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 23

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

Question 24

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

Question 25

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

Question 26

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

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

Question 27

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

Question 28

The COUNT function recognizes both text and number cells. _________________________

Question 29

Excel stores times as decimal fractions. _________________________

Question 30

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

Question 31

MAX determines the number of values in a list. _________________________

Question 32

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 33

The function inputs are referred to as arguments. _________________________

Question 34

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

Question 35

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

Question 36

The word Component entered into a cell represents a ____.

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

Question 37

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

Question 38

Functions are predefined formulas that perform calculations. _________________________

Question 39

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

Question 40

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

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 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 43

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 44

The ____ button formats numbers in the Accounting Number Format.

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

Question 45

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

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

Question 46

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 47

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 48

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 49

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

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

Question 50

Calculations and their results are called ____.

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

Question 51

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

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

Question 52

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 53

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 54

The result of a formula can be a ____.

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

Question 55

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 56

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 57

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 58

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 59

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 60

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 61

The Excel operator for subtraction is ____.

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

Question 62

The Excel operator for multiplication is ____.

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

Question 63

____ 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

Question 64

The Excel operator for addition 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

____ are predefined formulas that perform calculations.

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

Question 67

____ 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 68

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 69

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 70

____ 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 71

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

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

Question 72

____ 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 73

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 74

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

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

Question 75

Excel stores times as ____.

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

Question 76

The Excel operator for exponent is ____.

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

Question 77

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 78

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

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

Question 79

The Excel operator for division is ____.

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

Question 80

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

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