Font size
WorksheetsBA 250 Midterm Review
Total questions: 15
Worksheet time: 13mins
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
What is the feature that allows you to add a finishing touch to the bottom of your workbook or worksheets by including your name, the sheet name, & file name code?
(a)
Which excel feature is used to organize data in a specific order within an excel spreadsheet?
(a)
Which excel feature is used to hide the data you don't want to see within an excel spreadsheet?
(a)
Columns are identified by letters and rows are identified by (a) .
Page (a) are a feature that can be used to "start" a new page between certain sets of data within a spreadsheet.
