Identify the letter of the choice that best matches the phrase or definition: Moves the insertion point to the right one cell.

Identify the letter of the choice that best matches the phrase or definition: Moves the insertion point to the previous row.

Identify the letter of the choice that best matches the phrase or definition: Moves the insertion point to the left one cell.

Identify the letter of the choice that best matches the phrase or definition: Moves the insertion point to the beginning of the worksheet.

Identify the letter of the choice that best matches the phrase or definition: Moves the insertion point to the previous screen.

Indicate whether the statement is true or false: Scarlett can minimize the Ribbon by triple-clicking any of the Ribbon tabs.

Which of the following is NOT true about workbooks?

Indicate whether the statement is true or false. If it is false, change the identified word(s) to make the statement true. Rows in a worksheet appear vertically and are identified by letters.

Indicate the answer choice that best completes the statement or answers the question. Kiera tells Mya that ____ is an absolute cell reference.

Indicate the answer choice that best completes the statement or answers the question. Adam tells Ian that the * (asterisk) character is used to represent ____.

Indicate the answer choice that best completes the statement or answers the question. An example of a font size is 12 _____.

Indicate the answer choice that best completes the statement or answers the question. The ____ feature displays suggestions that are possible matches with the first few characters you enter in a cell.

Indicate the answer choice that best completes the statement or answers the question. Cate wants to print her workbook. By default, which of the following worksheet data will print?

Indicate the answer choice that best completes the statement or answers the question. Cate wants to share her workbook electronically, but she doesn’t want the recipients to be able to modify the data. One of her options is to save it as a(n) ____ file.

Indicate whether the statement is true or false. If it is false, change the identified word(s) to make the statement true. When you freeze columns and rows, the worksheet is divided into two panes.

Indicate whether the statement is true or false. If it is false, change the identified word(s) to make the statement true. The AutoComplete feature in Excel corrects misspellings as you enter data.

Which of the following is NOT an option for Santiago to apply for conditional formatting?

In Excel, a cell's width is automatically adjusted when the font size changes.

A(n) ____ cell reference does not change when the formula is copied or moved.

By default, Excel aligns numbers at the ____ of the cell.

Which of the following is NOT true about working with multiple worksheets?

John decides to show snapshots of the data for each row in his worksheet. He inserts ____.

Rajit knows that all of the following are true about charts EXCEPT: ____.

When you move the mouse pointer over the cells in the worksheet window, the mouse pointer changes to (a)n ____.

In a worksheet, a split can be removed by double-clicking the split bar.

Illustrates trends in data at equal intervals

Illustrates scientific data, specifically uneven intervals

Compares the sizes of portions as they relate to a whole unit

Effective for emphasizing trends

Useful for making comparisons among individual items

Using _____ is an easy method to apply formatting to data and convert the same data into a chart.

The accompanying figure shows ____ in column F.

When you move the mouse pointer over the formula bar, the mouse pointer changes to a(n) ____.

Indicate whether the statement is true or false. Tyree can use the Format Painter feature to copy attributes assigned to a cell.

Brandon is modifying the structure of his worksheet. Brandon knows that the default column width is 8.43 ___.

Indicate whether the statement is true or false. If it is false, change the identified word(s) to make the statement true. With the AutoComplete feature, the worksheet is scanned and a range of cells to sum is selected.

Excel refers to a spreadsheet as a ____.

Which of the following is NOT true about the AutoFill command?

By default, new blank workbooks include ____ worksheet(s).

The Enter and Cancel buttons appear in the formula bar even if you are not entering data.

Excel simplifies the organization and maintenance of your data.

Which of the following is NOT true about creating formulas?

Which of the following is NOT true about changing alignment?

Tanner learns that all of the following are true about using AutoFill to fill in a series EXCEPT: ____. To fill a series, a pattern must be established in the initial selection of cells.

Sawyer learns that when you point to the fill handle, the pointer changes to a ____.

A ____ contains column headings or field names in a data source.

3D references used in summary worksheets condense and total data from other worksheets.

____ view displays the column and row labels separated from the worksheet cells.

____ formulas perform calculations that describe large quantities of data.

A shortcut to entering cell references is to name a range of cells.

To select an entire row, click the row heading. Indicate whether the statement is true or false.

The Ribbon in Excel is similar to the Ribbon used in Word. Indicate whether the statement is true or false.

When you use the Cut and Copy commands, the data and formats are also moved or copied.

Two non-adjacent cells are distinguished in a function using a ____.

When you add a new column to your spreadsheet, the data shifts to the right.

Which of the following is NOT true about charts?

When you enter more numbers than can fit in a cell, ____.

Press the down arrow to move to the next screen in a spreadsheet.

When filtering data, you can control the screen data displayed by specifying certain criteria.

Formulas perform calculations that you could perform using a scientific calculator.

You can easily change the print settings using commands in the ____.

All cells in a range share all or part of their borders.

When you ____ columns and/or rows, you lock them so you can keep an area visible as you scroll through the worksheet.

The COUNT and SUM functions are interchangeable.

When creating formulas, there must be a closing parenthesis for every opening parenthesis.

The formula =SA1 contains an absolute reference.

To create a minus sign in a formula, use the hyphen key.

Which of the following is NOT true about copying and moving data?

Rearranges data in as many as three different columns

Divides the worksheet into two panes

Doing this enables you to focus on a particular range of data

Screens data to only display data that meets certain criteria

Locks columns and rows to keep them visible

Indicate whether the statement is true or false. Matt can change the sequence in which a formula is solved by using hyphens.

Indicate whether the statement is true or false. When you use the Insert Sheet button, the new sheet tab appears to the right of the active sheet tab.

Indicate whether the statement is true or false. 1A is an example of a cell reference.

Indicate whether the statement is true or false. Spreadsheets are often used for reporting finances and managing expenses.

Indicate whether the statement is true or false. To enter data in a cell, you must first make the cell active.

Indicate whether the statement is true or false. If the text does not fit on one line of a cell, you can wrap to new lines.

An error value appears if the cell is not wide enough to show the result.

Comments added to an Excel worksheet are automatically printed by default.