Question 1

(TCO 1) An Input Area (as it applies to Excel 2016) is defined as _____.

• a range of cells containing results based on the output area

• displaying the name of a worksheet within a workbook

• a range of cells containing values for variables used in formulas

• displaying the content of the active cell

Question 2

(TCO 1) In Excel 2016, a sheet tab _____.

• displays the content of the active cell

• conceals the applicable formulas for the workbook

• identifies the address of the current cell

• displays the name of a worksheet within a workbook

Question 3

(TCO 1) If you wanted to insert the current date into a header or footer element, what would the code look like?

• code &[Page]

• Ctrl + Alt + Delete

• The Ctrl + D key combination

• code &[Date]

Question 4

(TCO 1) In Excel a formula _____.

• is a number that represents a date and can be the basis of calculations

• is a combination of cell references, operators, values, and/or functions used to perform calculations

• is a number that represents a quantity and can be the basis of calculations

• should be used in each column of a workbook

Question 5

(TCO 1) The fill handle in Excel 2016 _____.

• is the fastest way to type A1 in the name box

• helps carry over the fill to the remaining slides

• is the same action as pressing enter

• is a small green square at the bottom-right corner of a cell that facilitates fill operations

Question 6

(TCO 1) Which of the following would allow you to adjust the column width and/or row height of many cells at once?

• Just type longer or taller formulas in some of them.

• Click and drag across the cells to select them and use any sizing method you choose.

• Drag the fill handle across the cells.

• Type A1 in the Go To dialog box.

Question 7

(TCO 1) If you had worksheets that contained the inventory of each room in your house with a separate sheet for each room, all of the sheets together would be a

• workbook.

• ledger.

• document.

• journal.

Question 8

(TCO 1) In Excel, a border _____.

• is data from another cell that is only temporarily residing in the active cell

• is a line that surrounds a cell or a range of cells

• never prints

• is preset and weight cannot be adjusted

Question 9

(TCO 2) A formula in Excel begins with a(n)

• *.

• $.

• =.

• /.

Question 10

(TCO 2) In Excel, a function can be defined as a _____.

• predefined formula that performs a calculation

• cell reference or a value

• list of values and defined names as you enter data into a spreadsheet

• set of rules that govern the structure and components for a formula

Question 11

(TCO 2) =$E2-G$4 contains examples of _____ cell references.

• absolute

• mixed

• relative

• constant

Question 12

(TCO 2) To display the current date on each page of an Excel worksheet, use the _____ function.

• PRESENT

• TODAY

• CURRENT

• SET

Question 13

(TCO 2) The _____ function returns a result based on a condition.

• MAX

• TODAY

• FIND

• IF

Question 14

(TCO 2) The MAX function identifies the _____.

• highest value in a range

• number of blank cells in a range

• lowest value in a range

• midpoint value in a range

Question 15

(TCO 2) In the arguments to an IF function, the condition that is evaluated to determine if it is true or false is also sometimes called a _____.

• logical test

• lookup value

• breakpoint

• table array action