Worksheets2016 Excel - Lesson 3 & Lesson 4 Study Guide
Total questions: 21
Worksheet time: 11mins
John's workbooks includes 3 worksheets. Which option should he choose to print them?
Print Selection
Print Active Sheet
Print Entire Workbook
Fit to on page
Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?
Values
Formulas
Labels
Functions
Tyler created a monthly sales workbook that contains the formula = (January!B3). "January" is an example of a (n):
named range
external reference
names manager
scope
How is a cell reference in a formula and its corresponding location in a worksheet identified?
Arrows pointing from the formula to the location
Cell reference and cell locations are circled
Cell reference and cell locations are outlined in matching colors
Lines connect from the formula to the location
What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
Copy method from the Shortcut Menu
Copy using the Fill Handle
Copy from the Home Ribbon
Copy using the Quick Access Toolbar
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
Form
Boilerplate
Smart Sheet
Template
Steve would like to print only the worksheet he is currently working on. What print option should he choose?
Print Area
Active Sheets
Entire Workbook
Quick Print
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
=$B$1+25
=B1+25
=1$B$+25
=B1:B3
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
Absolute reference
Certain reference
Variable reference
Relative reference
What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
Calling the Sheet
Name reference
Sheet Name
Worksheet Reference
What area contains the command used to customize the print options in Microsoft Excel?
Home Ribbon
Page Layout Ribbon
File Tab
Quick Access Toolbar
Jim would like to print only the cell range A1:F20. What page setup option should he change?
Orientation
Page Break
Print Area
Print Titles
Which command enables a user to save an existing worksheet with a new name or save the worksheet with a new name or save the worksheet in a new location?
Close
Save
Save As
Exit
Joshua created a budget workbook that contains the formula =(Summary!B3). "Summary" is an example of a(n):
named range
external reference
names manager
scope
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n):
named range
external reference
names manager
scope
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
=B4+C4
=B4*C4
=B4/C4
=B4-C4
Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
=B4+C4
=B4*C4
=B4xC4
=B4-C4
What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?
Relative
Mixed
Absolute
Unconditional
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
Function Library
Defined Names
Formula Auditing
Calculation
Which group on the Formula Ribbon contains the command that checks for common errors found in formula?
Function Library
Defined Names
Formula Auditing
Calculation
Which group on the Formula tab enables a user to specify when a formula is computed
Function Library
Defined Names
Formula Auditing
Calculation
