Baylor Bus 1350 Erica Ancira FINAL EXAM | Baylor University | UPDATED Questions with 100% Verified Answers

Baylor Bus 1350 Erica Ancira FINAL EXAM | Baylor
University | UPDATED Questions with 100% Verified
Answers
Q1: What is a spreadsheet?
A: A collection of data that is organized in a row and column format


Q2: What is a worksheet?
A: A single spreadsheet where there are a grid of columns and rows


Q3: What is a cell?
A: The intersection of columns and rows in which data is entered


Q4: What is a row?
A: A horizontal set of cells that encompasses all the columns in a worksheet


Q5: What is a column?
A: A vertical set of cells that encompasses all the rows in a worksheet


Q6: What is a formula?
A: A mathematical equation that produces a result and may contain numbers, operators,
text, and/or functions


Q7: What is a function?
A: A built-in program that performs a task such as calculating a sum or average


Q8: What is the What-if analysis tool?
A: Allows one to examine the outcome of the changes to values in a worksheet


Q9: What is a record?
A: All of the categories of data that pertain to one person, place, thing, event, or idea and
are formatted as a row in a worksheet.


Q10: What is a field?
A: An item of information in a worksheet column that is associated with something of
interest


Q11: What is a workbook?
A: A file that contains one or more worksheets

,Q12: How many cells are in an Excel worksheet?
A: 17,179,869,184


Q13: What is a cell reference?
A: A cell or range of cells within a formula or function instead of a value


Q14: What is the keyboard shortcut for moving the active cell down
one row?
A: "Enter"


Q15: What is the keyboard shortcut for moving the active cell up
one row?
A: "Shift" + "Enter"


Q16: What is the keyboard shortcut for moving the active cell to
column A of the current row?
A: "Home"


Q17: What is the keyboard shortcut for moving the active cell to the
last cell of the row that contains data?
A: "End"


Q18: What is the keyboard shortcut for moving the active cell to A1?
A: "Ctrl" + "Home"


Q19: What is the keyboard shortcut for moving to the last cell,
highest # row and far right column that contains information?
A: "Ctrl" + "End"


Q20: What is the keyboard shortcut for moving up one screen?
A: "PgUp"


Q21: What is the keyboard shortcut for moving down one screen?
A: "PgDn"


Q22: What is the keyboard shortcut for moving left one screen?
A: "Alt" + "PgUp"


Q23: What is the keyboard shortcut for moving right one screen?
A: "Alt" + "PgDn"

, Q24: What is the keyboard shortcut for moving one worksheet left?
A: "Ctrl" + "PgUp"


Q25: What is the keyboard shortcut for moving one worksheet
right?
A: "Ctrl" + "PgDn"


Q26: What is the keyboard shortcut for moving one column right?
A: "Tab"


Q27: What is the keyboard shortcut for moving one column left?
A: "Shift" + "Tab"


Q28: When is the "Go To" button useful?
A: When navigating within large worksheets


Q29: What is the keyboard shortcut for bolding a cell?
A: "Ctrl" + "B"


Q30: What is a cell note?
A: A text box, like a sticky note that is attached to a cell in a worksheet


Q31: What does a cell comment do?
A: Allows for threaded discussions withing a workbook cell


Q32: What is the keyboard shortcut for placing the insertion point
into cell contents? (being able to type in the cell)
A: "F2"


Q33: What is text data?
A: Consists of any combination of printable characters


Q34: What is the default alignment for text data?
A: Left


Q35: What is numeric data?
A: Consists of numbers (0-9) in any form not combined with letters and special characters
such as the period and/or hyphen.


Q36: What is data data?