Deck 10: Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

Question 1

Banding refers to ________.

A) adding a total row to a table
B) alternating the background color of rows and/or columns
C) adding a chart to a table
D) taking a format from one table and copying it to another table

Answer 1

B

Question 2

Both cells and tables can have ________,which provide pre-built,reusable formatting.

A) banding
B) constants
C) variables
D) styles

Answer 2

D

Question 3

Which of the following statements about banding is FALSE?

A) If a row or column is deleted from a table, the banding will be automatically updated.
B) Banding can be done manually.
C) Banding can be done for rows, but not for columns.
D) Banding can be used in tracking information.

Answer 3

C

Question 4

If a state's sales tax is stored in cell B2 and referenced in formulas,this value is known as a(n)________.

A) variable
B) parameter
C) argument
D) constant

Question 5

Which of the following statements about cell alignment is FALSE?

A) Most number, date, and time formats align right.
B) Most text formatting aligns right.
C) Cells can be aligned on the horizontal axis.
D) Cells can be aligned on the vertical axis.

Question 6

The ________ tool could be used to take an existing cell's format and apply it to other cells.

A) Format Painter
B) Banding
C) Workbook Theme
D) Table Style

Question 7

A table with odd rows in one color and even rows in another color are said to have ________ rows.

A) tabular
B) banded
C) hard-coded
D) constant

Question 8

Which of the following does the Format Painter NOT copy?

A) alignment
B) font colors
C) cell contents
D) borders

Question 9

Which of the following is an example of a formula?

A) =MIN(P2:Q4)
B) M11
C) 57
D) COUNT

Question 10

Information presented in charts is said to be in ________ format.

A) oral
B) narrative
C) graphical
D) tabular

Question 11

In the formula =E5,the value contained in E5 is known as a(n)________.

A) constant
B) argument
C) parameter
D) variable

Question 12

If all cell content in a worksheet is lined up along the left side of a cell,it has a left cell ________.

A) constant
B) alignment
C) justification
D) argument

Question 13

In the formula =3+5,the 3 and 5 are both examples of ________.

A) constants
B) arguments
C) variables
D) parameters

Question 14

Which of the following is NOT closely associated with tables?

A) total rows
B) charts
C) banding
D) caps

Question 15

Which of the following is an example of a constant?

A) =SUM(B2:B3)
B) J7
C) SUM
D) 3

Question 16

The A1:A3 in the formula below is a(n)________.
=SUM(A1:A3)

A) parameter
B) constant
C) variable
D) argument

Question 17

Which of the following will get the smallest value from a range of cells?

A) SUM
B) MIN()
C) AVERAGE()
D) MAX()

Question 18

Information organized into rows and columns is said to be in ________ format.

A) narrative
B) tabular
C) oral
D) graphical

Question 19

Which of the following is an example of a mathematical operator?

A) $
B) ^
C) =
D) X

Question 20

A series of numbers laid out in a spreadsheet is most consistent with a(n)________ format.

A) tabular
B) oral
C) graphical
D) narrative

Question 21

What is the result of the following Excel formula?
=2(2+5)

A) 4
B) 9
C) 64
D) 14

Question 22

Which of the following has the highest priority per order of operations?

A) parentheses
B) exponentiation
C) division
D) addition

Question 23

In the formula =J3+4,the value stored in cell J3 is known as a variable.

Question 24

If a formula references cell A1 and is copied down one row and to the right one column,the new formula will reflect B2 if the cell reference is a(n)________ reference.

A) absolute
B) relative
C) mixed
D) constant

Question 25

A value in a cell that is referenced in a formula or function is known as a variable.

Question 26

The term fill color refers to the color of the border of a cell.

Question 27

A cell has exactly three alignments: left-aligned,centered,and right-aligned.

Question 28

A chart is an example of information presented in tabular format.

Question 29

Negative numbers can be displayed in different colors and different formats.

Question 30

A table is just another name for a worksheet.

Question 31

Rather than hard-code a value,it is considered good practice to use a(n)________ instead.

A) function
B) parameter
C) constant
D) argument

Question 32

Cell alignment refers solely to the horizontal alignment of a cell's content.

Question 33

Cell content can be rotated by changing the cell's orientation.

Question 34

The Format Painter will copy fonts,but not borders,fill colors,or alignment.

Question 35

A function is a small program that performs operations on data.

Question 36

One function can have multiple arguments.

Question 37

Excel facilitates taking tabular data and converting that data into graphical format.

Question 38

MAX is an example of a function.

Question 39

The following is a function:=B2*B5

Question 40

MIN is an example of an AutoSum function.

Question 41

Values should be hard-coded wherever possible.

Question 42

The COUNT()function will return the total number of cells in a range,regardless of value.

Question 43

Formulas can be copied to the Clipboard and then copied to other locations in a workbook.

Question 44

Order of operations specifies which mathematical operations happen first.

Question 45

The following is an example of a built-in function: =J4+J2

Question 46

Sales tax is one example of a value well-suited to being a parameter.

Question 47

A relative cell reference will not change when copied.

Question 48

Not all formulas start with the equal sign (=).

Question 49

Portable Document Format (PDF)is the default file format for Excel spreadsheets.

Question 50

The equal sign (=)is an example of a mathematical operator.

Question 51

Information presented in labeled rows and columns is said to be in ________ format.

Question 52

If you would like values between 25 and 50 in a range of cells to appear in yellow,use conditional formatting.

Question 53

The AVERAGE()function returns the average of a range of cells.

Question 54

Conditional formatting is when Excel automatically changes a formula within a cell based on parameters assigned to that cell.

Question 55

Pi is one example of a value well-suited to being a parameter.

Question 56

If a formula contains the relative cell reference J7 and the formula is copied to a cell two rows down and one row to the right,the reference will become K9.

Question 57

The correct order of operations is:
Exponentiation and Parentheses
Multiplication and Division
Addition and Subtraction

Question 58

The formula below contains a hard-coded value:
=J3*SUM(A1:A2)

Question 59

The formatting function pastes the formatting and the cell value from the Clipboard to a cell.

Question 60

Conditional formatting is when Excel changes the way information is displayed based on rules specific to the problem in the worksheet.

Question 61

If cell J6 contains 14 and cell J7 contains 6,the ________()function would return 10 if applied to that range.

Question 62

The largest value in a range can be found using the ________()function.

Question 63

The background color of a cell is also known as the ________ color.

Question 64

A table with alternating colored rows is said to have ________.

Question 65

The function that allows users to determine how many numerical values exist in a range is the ________()function.

Question 66

Predefined set of formatting properties that determine the appearance of a table are known as table ________.

Question 67

The theme that is automatically applied unless you specify otherwise is known as the ________ workbook theme.

Question 68

SUM(),COUNT(),AVERAGE(),MIN(),and MAX()are part of a special group of functions known as ________ functions.

Question 69

Variables or values inside a function's parentheses are known as ________.

Question 70

The ________ tool allows copying a source format from one cell or range to another cell or range of cells.

Question 71

A collection of built-in cell styles given a name is known as a workbook ________.

Question 72

The ________()function is essentially the same as dividing the sum of a range of cells by the count of those cells.

Question 73

A value in a cell referenced by a formula or function is a(n)________.

Question 74

A small program that performs calculations on data is known as a(n)________.

Question 75

An Excel cell that contains =SUM(A2:A5),SUM is an example of a(n)________.

Question 76

A chart is an example of information presented in ________ format.

Question 77

A cell with contents centered in that cell is said to have a centered cell ________ .

Question 78

The more than 400 functions that come as part of Excel are known as ________ functions.

Question 79

An Excel cell that contains =SUM(11,12,25),11,12,25 is an example of a(n)________.

Question 80

C5 is an example of a cell ________.