BUS 1305 – Exam 1, 2026 – Study guide and practice material
Define what a spreadsheet application is. - correct answer ✔✔ A collection of data that is
organized in a row and column format.
What do you call the intersection of a row and columns? - correct answer ✔✔ Cell
What do formulas and functions need to begin with? - correct answer ✔✔ =
What is the file extension for Microsoft Excel 2016 workbooks? - correct answer ✔✔ .xlsx
What are the elements of worksheet documentation? - correct answer ✔✔ Descriptive
file/worksheet names, worksheet titles, column and/or row titles, cell labels, cell comments, or
a dedicated documentation worksheet.
How does Excel align the data types - right, center, left? - correct answer ✔✔ Number = right
Date/Time = right
Text = left
What keys do you press, to insert a line break or hard return in a cell? - correct answer ✔✔
ALT+ENTER
What key do you press to select a noncontiguous range of cells? - correct answer ✔✔ Click cells
holding the CTRL key
Be able to identify a range of cells. - correct answer ✔✔ A1:B3
Letter indicates the column and the number indicates the row
, On what tab will you find AutoFit the width of a column? - correct answer ✔✔ Home, under the
Cells group
What characters will you see if a numerical value is too narrow to be displayed in a cell? -
correct answer ✔✔ #####
What steps do you need to perform to rename a worksheet? - correct answer ✔✔ 1) Right click
on the tab
2) Click "Rename"
The default, what is print range in Excel? - correct answer ✔✔ Print Active Sheets
What do you call the format that organizes information in labeled columns and numbered rows?
- correct answer ✔✔ Tabular
Excel uses the what type of presentation for information via charts and graphs? - correct answer
✔✔ Set to a vertical orientation (AKA Angle Counterclockwise)
What is the Comma Style? - correct answer ✔✔ Accounting Number Format without a
monetary symbol
What colors does a person who is color-blind, have trouble distinguishing between? - correct
answer ✔✔ Reds and greens
How many types of cell alignment are in Excel? - correct answer ✔✔ SIx: Left, center, right, top,
middle, and bottom.
Define what a spreadsheet application is. - correct answer ✔✔ A collection of data that is
organized in a row and column format.
What do you call the intersection of a row and columns? - correct answer ✔✔ Cell
What do formulas and functions need to begin with? - correct answer ✔✔ =
What is the file extension for Microsoft Excel 2016 workbooks? - correct answer ✔✔ .xlsx
What are the elements of worksheet documentation? - correct answer ✔✔ Descriptive
file/worksheet names, worksheet titles, column and/or row titles, cell labels, cell comments, or
a dedicated documentation worksheet.
How does Excel align the data types - right, center, left? - correct answer ✔✔ Number = right
Date/Time = right
Text = left
What keys do you press, to insert a line break or hard return in a cell? - correct answer ✔✔
ALT+ENTER
What key do you press to select a noncontiguous range of cells? - correct answer ✔✔ Click cells
holding the CTRL key
Be able to identify a range of cells. - correct answer ✔✔ A1:B3
Letter indicates the column and the number indicates the row
, On what tab will you find AutoFit the width of a column? - correct answer ✔✔ Home, under the
Cells group
What characters will you see if a numerical value is too narrow to be displayed in a cell? -
correct answer ✔✔ #####
What steps do you need to perform to rename a worksheet? - correct answer ✔✔ 1) Right click
on the tab
2) Click "Rename"
The default, what is print range in Excel? - correct answer ✔✔ Print Active Sheets
What do you call the format that organizes information in labeled columns and numbered rows?
- correct answer ✔✔ Tabular
Excel uses the what type of presentation for information via charts and graphs? - correct answer
✔✔ Set to a vertical orientation (AKA Angle Counterclockwise)
What is the Comma Style? - correct answer ✔✔ Accounting Number Format without a
monetary symbol
What colors does a person who is color-blind, have trouble distinguishing between? - correct
answer ✔✔ Reds and greens
How many types of cell alignment are in Excel? - correct answer ✔✔ SIx: Left, center, right, top,
middle, and bottom.
