BAYLOR BUSINESS 1350 EXAM 1 QUESTIONS &
DETAILED COMPLETE SOLUTIONS
1. Excel a spreadsheet program that can be used to
manage, analyze, and share information. With the
help of Excel, you can reveal underlying trends,
calculate values, make predictions and
recommendations, and display or share
information with large or small amounts of data.
2. Spreadsheet a collection of data that is organized in a row
and col- umn format. It is used for recording text &
numbers for analysis purposes.
3. cell intersection of each row and column
4. row a horizontal set of cells that encompasses all the
columns in a worksheet
5. column a vertical set of cells that encompasses all the rows
in a worksheet.
6. Formula Bar displays data or formula in cell
7. Backstage View the File tab of the ribbon, contains various screens
with commands that allow you to manage files
and options for the Excel.
8. Template a preformatted workbook that contains the
document design and some content already
entered into the doc- ument.
9. Keyboard Shortcuts a keyboard equivalent for a software command that
al-
lows you to keep your hands on the keyboard
instead of reaching for the mouse to make
ribbon selections
1/
19
,BAYLOR BUSINESS 1350 EXAM 1 QUESTIONS &
DETAILED COMPLETE SOLUTIONS
10. ScreenTip
2/
19
,BAYLOR BUSINESS 1350 EXAM 1 QUESTIONS &
DETAILED COMPLETE SOLUTIONS
a label that appears next to an object, providing infor- mation about that object or giving a link to
associated help topics.
11. KeyTips labels that appear over each tab and command
on the ribbon when ALT is pressed.
12. WorkBook a file that contains one or more worksheets
13. SheetTab the worksheet that is visible in the Excel
application window and is denoted by a white
tab (unless a tab color has been applied) with
bold letters and a thick bottom border
14. Chart Sheet a sheet that contains only a chart that is linked to
data within the workbook
15. F: best practice to not use spaces T/F:
when naming a worksheet, it is best practice to use spaces
16. cell reference refers to a particular cell or range of cells within
a for- mula or function instead of a value and is
combination of its column letter and row
number.
17. Active Cell the recipient of an action, such as a click,
calculation, or paste.
18. range reference refers to the cells in the worksheet that have been
select- ed and can reference a single cell,
several contiguous cells, or noncontiguous cells.
19. contiguous cell range [a/k/a This consists of multiple selected cells, all directly
adja- cent cells] adja- cent to one another.
3/
19
DETAILED COMPLETE SOLUTIONS
1. Excel a spreadsheet program that can be used to
manage, analyze, and share information. With the
help of Excel, you can reveal underlying trends,
calculate values, make predictions and
recommendations, and display or share
information with large or small amounts of data.
2. Spreadsheet a collection of data that is organized in a row
and col- umn format. It is used for recording text &
numbers for analysis purposes.
3. cell intersection of each row and column
4. row a horizontal set of cells that encompasses all the
columns in a worksheet
5. column a vertical set of cells that encompasses all the rows
in a worksheet.
6. Formula Bar displays data or formula in cell
7. Backstage View the File tab of the ribbon, contains various screens
with commands that allow you to manage files
and options for the Excel.
8. Template a preformatted workbook that contains the
document design and some content already
entered into the doc- ument.
9. Keyboard Shortcuts a keyboard equivalent for a software command that
al-
lows you to keep your hands on the keyboard
instead of reaching for the mouse to make
ribbon selections
1/
19
,BAYLOR BUSINESS 1350 EXAM 1 QUESTIONS &
DETAILED COMPLETE SOLUTIONS
10. ScreenTip
2/
19
,BAYLOR BUSINESS 1350 EXAM 1 QUESTIONS &
DETAILED COMPLETE SOLUTIONS
a label that appears next to an object, providing infor- mation about that object or giving a link to
associated help topics.
11. KeyTips labels that appear over each tab and command
on the ribbon when ALT is pressed.
12. WorkBook a file that contains one or more worksheets
13. SheetTab the worksheet that is visible in the Excel
application window and is denoted by a white
tab (unless a tab color has been applied) with
bold letters and a thick bottom border
14. Chart Sheet a sheet that contains only a chart that is linked to
data within the workbook
15. F: best practice to not use spaces T/F:
when naming a worksheet, it is best practice to use spaces
16. cell reference refers to a particular cell or range of cells within
a for- mula or function instead of a value and is
combination of its column letter and row
number.
17. Active Cell the recipient of an action, such as a click,
calculation, or paste.
18. range reference refers to the cells in the worksheet that have been
select- ed and can reference a single cell,
several contiguous cells, or noncontiguous cells.
19. contiguous cell range [a/k/a This consists of multiple selected cells, all directly
adja- cent cells] adja- cent to one another.
3/
19
