Exam 2: Formulas,Functions,and Formatting

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?

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

A ____ is a prewritten formula that is built into Excel.

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

All of the following are valid Excel arithmetic operators EXCEPT ____.

The most common error when entering a formula is to reference the wrong cell in the formula.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A prewritten formula built into Excel.

A ____ is text and graphics that print at the bottom of every page.

The range automatically selected by Excel is always correct.

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

The equal sign (=)precedes a formula.

The Percent Style button instructs Excel to display a value as a percentage,determined by multiplying the cell entry by 100,rounding the result to the nearest percent,and adding a percent sign.

When you click the Decrease Font Size button,Excel assigns the next highest font size in the Font Size gallery.

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

Which of the following actions are provided by the Paste Options button?

The Insert Options button lists formatting options.

To use ____________________ to verify that a formula contains the intended cell references,double-tap or double-click the cell with the formula you want to check.

The ____ function determines the lowest number in a range.

You should ____ a function name in the Formula AutoComplete list to select the function.