Lesson 3 & 4 Flashcards
1
Q
Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location? A. Close B. Save C. Save As D. Exit
A
C. Save As
2
Q
John's workbooks includes 3 worksheets. Which option should he choose to print them? A. Print Selection B. Print Active Sheet C. Print Entire Workbook D. Fit to One Page
A
C. Print Entire Workbook
3
Q
Jim would like to print only the cell range A1:F20. What page setup option should he change? A. Orientation B. Page Break C. Print Area D. Print Titles
A
C. Print Area
4
Q
What area contains the command used to customize the print options in Microsoft Excel? A. Home Ribbon B. Page Layout Ribbon C. File Tab D. Quick Access Toolbar
A
C. File Tab
5
Q
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets? A. Form B. Boilerplate C. Smart Sheet D. Template
A
D. Template
6
Q
Steve would like to print only the worksheet he is currently working on. What print option should he choose? A. Print Area B. Active Sheets C. Entire Workbook D. Quick Print
A
B. Active Sheets
7
Q
Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry? A. values B. formulas C. labels D. functions
A
B. formulas
8
Q
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create? A. =$B$1+25 B. =B1+25 C. =1$B$+25 D. =B1:B3
A
A. =$B$1+25
9
Q
What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously? A. Copy method from Shortcut Menu B. Copy using the Fill Handle C. Copy from the Home Ribbon D. Copy using the Quick Access Toolbar
A
B. Copy using the Fill Handle
10
Q
How is a cell reference in a formula and its corresponding location in a worksheet identified?
A. Arrows pointing from the formula to the location
B. Cell reference and cell location are circled
C. Cell reference and cell location are outlined in matching colors
D. Lines connect from the formula to the location
A
C. Cell reference and cell location are outlined in matching colors
11
Q
Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use? A. =B4+C4 B. =B4*C4 C. =B4 x C4 D. =B4-C4
A
B. =B4*C4
12
Q
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use? A. =B4+C4 B. =B4*C4 C. =B4/C4 D. =B4-C4
A
D. =B4-C4
13
Q
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n): A. named range. B. external reference. C. names manager. D. scope.
A
A. named range.
14
Q
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? A. Relative B. Mixed C. Absolute D. Unconditional
A
C. Absolute
15
Q
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location? A. Absolute reference B. Certain reference C. Variable reference D. Relative reference
A
D. Relative reference
