Exam 10: Excel: Formulas, Functions, and Formatting

Modified Multiple Choice Which of the following is a method of entering functions?

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

Which of the following Option buttons gives options for filling cells following a fill operation?

Critical Thinking Questions Case 2-2 Anna is a competitive runner.She wants to improve her performance and decides to keep track of data for six months to determine if the time of day or year she runs affects her performance.Her worksheet contains the following data: start and end time, total time, and distance.Now Anna wants to know the longest total time she has run.By looking at the total time values, she finds the longest total time to be 54 minutes.Instead of manually entering that value in a cell below the total time data, Anna decides to use the MAX function to determine the longest total time.Why did Anna prefer to use the MAX function?

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

____________________ view shows the worksheet divided into pages.

Modified Multiple Choice Which of the following are valid formulas?

A(n) ____________________ is a dot on the screen that contains a color.

Cooler colors tend to pull away from the reader.

A formula in a cell that contains a reference back to itself is called a(n) ____________________.

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

You can click the ____ button to undo an automatic correction.

The function, or ____________________, of a worksheet is to provide a user with direct ways to accomplish tasks.

When Excel recognizes that you entered a date in mm/dd/yy format, it automatically formats the date as ____________________.

The default font for the Basis theme is different than the default font for the Office theme.

Briefly discuss displaying the formulas version of a worksheet.

The adjusted cell references in a copied and pasted formula are called ____ cell references.