DIT Excel 2016 Review

What is a workbook?

• Excel file

• Excel spreadsheet page.

• A number, text, formula or function

What can a cell contain?

• A column

• A number, text, formula or function

• A row

• The cell address

Which keyboard shortcut bolds text in a cell?

• “Ctrl+B”

• “Ctrl+I”

• “Ctrl+U”

• “Ctrl+X”

Which keyboard shortcut would you press to cancel a command?

• “Backspace”

• “Tab”

• “Delete”

• “Escape”

Which of the following statements is TRUE?

• The content and format of a cell are independent.

• Changing the format of a cell also affects its content.

• The content and format of a cell are the same.

What are the pieces of information that describe the appearance of a cell's content?

• Active attributes

• Paste attributes

• Format attributes

• Edit attributes

Which of the following is NOT a way to change the column width in Excel?

• Right-click the column header and then click Column Width.

• Click and drag the column's boundary line to the desired width.

• Double-click the column header and then click Delete.

• All of the above

• Double-click the column's boundary line.

What are the three parts of a formula?

• Equal sign, Operand, Operator

• Formula Bar, Cell Reference, Color

• Complex, Simple, Order of Operations

Define Function.

• Must be the first character in the cell. It tells the spreadsheet a calculation is to be performed

• A predefined formula that performs a calculation based on values that are entered in the function.

• Indicates the operation to be performed, such as a sum

• Contains the information you want to use in the function’s calculation.

The following function calculates the average of the values in a range of cells by summing the cells and dividing by the number of cells used to find the sum.

• COUNT

• MAX

• AVERAGE

• MIN