BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
grouping
-selecting 2 or more worksheets so you can perform the dame action at the same time,
the worksheets will have identical structure and formatting
-can group and ungroup
What does grouping worksheets improve?
-productivity, can perform data entry, structural changes (add,deleting,widening
rows/columns), formatting page layouts, and printing
-You can copy worksheets from one workbook to another
Worksheet refrences
Allows you to reference cells in other worksheets in the same workbook, requires you to
use the name of the worksheet before the cell range
Worksheet Reference
-Allows you to reference cells in other worksheets in the same workbook -Exclamation
points separate worksheets and cell references
-Ex. Atlanta!B3 + Boston!B4
-Is absolute
-Pointer to a cell in another worksheet
When referencing a worksheet..
...you can click tab for the worksheet
-if sheet name contains spaces when referencing, enclose name in single quotes=>
'year end sum'!B3
Managing Worksheets
You can :
-Control worksheet visibility (hiding, displaying)
-Open and arrange windows (can view 2 ws at once)
-Split a window
-Save an excel worksheet
-to see content of 2 worksheets at the same time use "new window" and 'arrange all"
Synchronized scrolling
Allows you to scroll in one pane while the other pane(s) move similarly
Hyperlink
An electronic Marker that connects to a(n)
-specific cell in the same workbook
-specific cell in a different workbook
-existing file
-web page
-email address
3D Formula
Formula that refers to the same cell or cell range in multiple worksheets
Linking
Connecting cells between workbooks
3D Workbook
, Tabs at bottom display worksheet names, scrolling buttons allow easy movement along
worksheets
3D reference
includes worksheet name, column letter, and row #
-a formula with a 3D reference is useful to obtain the value from a cell range in another
worksheet. The formula would contain worksheet name, exclamation point, and cell
reference Ex. 'octobersales'!E5
-A function w/ a 3D reference may contain data from 2 or more worksheets EX.
SUM('Qtr1:Qrt4'!E3) where cell E3 in all sheets from Qtr1 to Qtr4 is included in range
Spreadsheet Errors
Syntax- occurs when a formula or function violates correct construction (misspelled
function name or illegal use of operator)
Logic- incorrect construction produces inaccurate results
Auditing Formulas
The formula auditing group on the formula tab enables you to:
-display or trace relationships
-show formulas
-check for errors
-evaluate formulas
Formula Auditing tools help to detect errors (syntax and logical
Precedent cells (auditing)
cells referenced in a formula
Dependent cells (auditing)
contain formulas that refer to other cells
Tracer arrows (auditing)
helps you identify cells that cause errors
blue arrows- cells w/ no errors
red arrows- cells w/ errors
Error Checking command
lets you check for errors that have occurred in formulas anywhere in a worksheet
trace precedents and trace dependents
Can display arrows that depict the relationships between precedent and dependent cells
so you can identify cells used in formulas
Error checking dialogue box
opens when an errors identified , click "ignore error" to move on or "edit" in formula bar
to correct it
Checking for errors
error checking button or IFERROR function
Watch Window
formulas in cells that are not visible can be "watched", small window to view the formula
calculation
destination file
the file that an object is embedded in or linked to
Data Validation
enables you to control the data that can be entered into a cell (warns and prevents
people from entering "wrong" data in a cell, useful in shared workbooks
GRADED
grouping
-selecting 2 or more worksheets so you can perform the dame action at the same time,
the worksheets will have identical structure and formatting
-can group and ungroup
What does grouping worksheets improve?
-productivity, can perform data entry, structural changes (add,deleting,widening
rows/columns), formatting page layouts, and printing
-You can copy worksheets from one workbook to another
Worksheet refrences
Allows you to reference cells in other worksheets in the same workbook, requires you to
use the name of the worksheet before the cell range
Worksheet Reference
-Allows you to reference cells in other worksheets in the same workbook -Exclamation
points separate worksheets and cell references
-Ex. Atlanta!B3 + Boston!B4
-Is absolute
-Pointer to a cell in another worksheet
When referencing a worksheet..
...you can click tab for the worksheet
-if sheet name contains spaces when referencing, enclose name in single quotes=>
'year end sum'!B3
Managing Worksheets
You can :
-Control worksheet visibility (hiding, displaying)
-Open and arrange windows (can view 2 ws at once)
-Split a window
-Save an excel worksheet
-to see content of 2 worksheets at the same time use "new window" and 'arrange all"
Synchronized scrolling
Allows you to scroll in one pane while the other pane(s) move similarly
Hyperlink
An electronic Marker that connects to a(n)
-specific cell in the same workbook
-specific cell in a different workbook
-existing file
-web page
-email address
3D Formula
Formula that refers to the same cell or cell range in multiple worksheets
Linking
Connecting cells between workbooks
3D Workbook
, Tabs at bottom display worksheet names, scrolling buttons allow easy movement along
worksheets
3D reference
includes worksheet name, column letter, and row #
-a formula with a 3D reference is useful to obtain the value from a cell range in another
worksheet. The formula would contain worksheet name, exclamation point, and cell
reference Ex. 'octobersales'!E5
-A function w/ a 3D reference may contain data from 2 or more worksheets EX.
SUM('Qtr1:Qrt4'!E3) where cell E3 in all sheets from Qtr1 to Qtr4 is included in range
Spreadsheet Errors
Syntax- occurs when a formula or function violates correct construction (misspelled
function name or illegal use of operator)
Logic- incorrect construction produces inaccurate results
Auditing Formulas
The formula auditing group on the formula tab enables you to:
-display or trace relationships
-show formulas
-check for errors
-evaluate formulas
Formula Auditing tools help to detect errors (syntax and logical
Precedent cells (auditing)
cells referenced in a formula
Dependent cells (auditing)
contain formulas that refer to other cells
Tracer arrows (auditing)
helps you identify cells that cause errors
blue arrows- cells w/ no errors
red arrows- cells w/ errors
Error Checking command
lets you check for errors that have occurred in formulas anywhere in a worksheet
trace precedents and trace dependents
Can display arrows that depict the relationships between precedent and dependent cells
so you can identify cells used in formulas
Error checking dialogue box
opens when an errors identified , click "ignore error" to move on or "edit" in formula bar
to correct it
Checking for errors
error checking button or IFERROR function
Watch Window
formulas in cells that are not visible can be "watched", small window to view the formula
calculation
destination file
the file that an object is embedded in or linked to
Data Validation
enables you to control the data that can be entered into a cell (warns and prevents
people from entering "wrong" data in a cell, useful in shared workbooks
