IntExcel Ch 1-2 Test Review

Functions tests a condition or statement and returns value if True and another value if False?

Which menu option is used to insert a new row above the selected cell in Excel?

How does Excel treat a street address?

What is the purpose of the "Freeze Panes" feature in Excel?

Which of the following is the constant in the formula =D5*85%?

Excel comes with many built-in formulas called:

How can you insert a new column between columns A and B in Excel?

How can you insert a new column between columns A and B in Excel?

How can you rename a worksheet in Excel?

Which of the following displays when you place the pointer on the border of a selected cell or range?

Calculates loan payment amounts for regular payments and constant interest rate:

Which of the following displays a label on multiple lines within a cell?

Which of the following statements about formulas is NOT true?

By default, how does Excel align labels in a cell?

This Excel feature allows you to view totals, averages, or other statistical information without creating a formula:

What is the purpose of the "Print Titles" feature in Excel?

How can you change the orientation of a worksheet from portrait to landscape for printing?

Which of the following is NOT true for inserting dates?

What does the "Page Break Preview" allow you to do in Excel?

How do you create a new workbook in Microsoft Excel

Which of the following characters always starts a formula?

Which option in Excel allows you to print a selected range on a single page?

In Excel, which of the following keys opens the Save As dialog box?

What is the keyboard shortcut to re-save a workbook with the same file name?

What is the shortcut to edit the contents of a selected cell in Excel?

How many items can the Office Clipboard hold?

How do you open an existing workbook in Excel?

By default, how does Excel align values in a cell?

Which of the following formulas correctly adds the values in cells E4 and E5?

What is the keyboard shortcut to save a workbook in Excel?

By default, what file name extension is given to Excel workbook files?

When a formula has syntax error like incorrect function spelling it returns:

Which of the following functions inserts the current date?

In the Excel window, which of the following displays buttons for switching worksheet views?

Command enlarges or shrinks printed data to fit a number of pages or a particular paper size?

Function evaluates a condition or statement and returns one value if true and another value if it is false.

It is important to remember that Excel calculates these operations before any others are performed.

Which of the following cell addresses will change when it is copied?

Which of the following formats would you use to display a numeric value as currency in Excel?

The acronym “Please Excuse My Dear Aunt Sally” helps the user remember:

What does the "Merge & Center" option do in Excel?

When you copy a formula with a relative cell reference, the copied cell reference is:

This type of cell reference does not change when copied and remains in a fixed position during operations.

To reference cells in another worksheet, but in the same workbook in which the current formula resides, use a:

What is the purpose of the AutoFill feature in Excel?

Which of the following is NOT true when inserting and deleting columns?

Formula Auditing tools which steps through formula and displays an outcome to isolate error?

How can you set the print area for a specific range in Excel?

Which of the following is a valid 3D cell reference?

Which of the following functions uses a lookup table that is organized in columns?

Which of the following is an absolute cell reference?

Which of the following provides an example of a mixed reference and a relative reference?

Which of the following is a relative cell reference?

What key do you press to select non-adjacent cells?

Which of the following is a mixed cell reference?

What is the purpose of the "Wrap Text" feature in Excel?

Keyboard shortcut turns formula into an absolute cell reference ($) is:

How do you enter a number as a label in a cell?

What does the "Hide" option do in Excel when applied to a selected column?

Set of formatting elements including font style, size, color, alignment, borders, and fill, and number formats?