BA 250 Midterm Review

The (a)   is the term for a selected rectangular cell within an excel spreadsheet.

A (a)   cell reference is one that changes relatively with location of the formula.

A _______________ is an excel spreadsheet made up of more than one ____________________.

• worksheet; workbook

• workbook; worksheet

• spreadsheet; workbook

• file; spreadsheet

If the information in a cell represents a quantity, it is defined as a ______.

• category

• label

• value

• tab

A (a)   (aka formula) is an arithmetical expression used to calculate values in Excel.

What character must be included in a cell reference to make it "absolute" or in other terms "not changing"?

(a)  

Which is an example of a simple formula? (Select all that apply)

• =C4*E4

• =C4/E4

• =VLOOKUP(D4>=H4,(H4-D4)*C2,0)

• =C4+E4-F4

What term describes the process of allowing Excel to determine the column width based on the text or values in the column? Hint: it requires double-clicking

(a)  

What is the term used to identify the bar across the top of the spreadsheet screen that allows you to make edits to data, formatting and more?

• Editing Ribbon

• Task Bar

• Tab Panel

• None of these

What is the term used to identify the “edge” of the spreadsheet, specifically when preparing to print the workbook?

• Margin

• Page Break

• Orientation

• Themes