Font size
WorksheetsMicrosoft Excel 2016 Final Exam Review
Total questions: 134
Worksheet time: 2hrs 17mins
To select cells that are not adjacent (next to) each other, use which of the following keys while clicking on each cell?
Ctrl
Alt
Shift
Fn
Which feature enables you to preview headers and footers, page breaks, and other features that will print?
Print Layout
Page Layout
ScreenTips
Split Windows
Which of the following indicates a proper cell address?
3A
:A3
A3
@A3
Which of the following is the intersection of a row and column?
range
tab
bar chart
cell
Which of the following is the proper format for a range?
A1-D10
A1:D10
A1thruD10
A1&D10
Which of the following is the selection pointer?
Which of the following is the fill handle?
Which of the following is the move handle?
Which of the following describes a row?
Identified by letters; runs vertically
Identified by letters; runs horizontally
Identified by numbers; runs vertically
Identified by numbers; runs horizontally
Which of the following consists of details that describe or identify a file, including the author?
Paste
Document properties
Copy
Range
Which command is used to insert a cut or copied selection to a cell or range of cells?
Paste
Document Properties
Copy
Range
If you want to only fill the formatting of a selected cell and not the contents which fill option do you choose?
Copy Cells
Fill Formatting Only
Fill Without Formatting
Flash Fill
Which is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series?
Cell pointer
Column marker
Fill handle
Formula bar
Which of the following can you drag or double-click to change the width of a column?
Cell pointer
Column marker
Fill handle
Formula bar
You can quickly fill a column of data using an example that is based on existing data in adjacent columns using the Fill Series command.
TRUE
FALSE
You manually move the column marker to autofit a column.
TRUE
FALSE
The formula bar is found at the bottom of the Excel window.
TRUE
FALSE
Use the fill handle to create a natural series, such as the months of the year.
TRUE
FALSE
Content that has been cut or copied to the clipboard will have a solid green border around it.
TRUE
FALSE
Which of the following describes a column?
Identified by letters; runs vertically
Identified by letters; runs horizontally
Identified by numbers; runs vertically
Identified by numbers; runs horizontally
Which of the following is where you can save, select a template, change document properties, and close or exit Excel?
Backstage
Edit
Windows
Which of the following is where you can save, select a template, change document properties, and close or exit Excel?
Backstage
Edit
Windows
To change printer, layout, or margin settings, you click the File tab and use which of the following options?
Info
Options
Open
Which of the following options can be used to fit the worksheet to one page?
Collated
Orientation
Margins
Scaling
Which of the following options will print borders around each cell in your printed worksheet?
Gridlines
Draft Quality
Print Titles
Print Area
Which predesigned file already has a significant amount of formatting, text, and other features?
Blank workbook
Preset file
Text file
Template
To access an Excel template, you can click the File tab and then click New.
TRUE
FALSE
If you have too many columns on a page, the only option to see them all on a printed page is to decrease the column width.
TRUE
FALSE
You can access the Print command by pressing Ctrl+B.
TRUE
FALSE
Portrait orientation is the default orientation and it prints the page taller than it is wide.
TRUE
FALSE
The Print Active Sheets command will print every sheet in the workbook.
TRUE
FALSE
Which of the following is not an arithmetic operator?
+
-
*
]
Per the order of operations, what is the answer to this formula: =2*(2+2)?
6
8
4
2
Which of the following is an acceptable name for a named range?
C7
subtotal_west
subtotal west
subtotal/west
Which of the following is an example of an absolute cell reference?
A9
A$9
$A$9
A9:E9
Which of the following is an example of a relative cell reference?
A9
A$9
$A$9
A9:E9
To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).
TRUE
FALSE
It is always best to use the exact value instead of the cell reference when using formulas.
TRUE
FALSE
You can create a new range by selecting the cells and typing a name in the Name Box next to the formula bar.
TRUE
FALSE
The order of operations determines which parts of a formula are calculated before other parts of the formula.
TRUE
FALSE
The formula = 6 * 2 + 3 produces the same result as = 6 * (2 + 3).
TRUE
FALSE
Which function calculates the TOTAL (adds all the cells in the range together)?
SUM
AVERAGE
MAX
MIN
Which function calculates the MEAN of a range of cells (adds all the cells together and then divides by the number of cells)?
MIN
AVERAGE
COUNT
MAX
You want to calculate the number of nonblank cells in your worksheet. Which function should be used?
SUM
COUNTA
MIN
MAX
Which function returns the highest value in a range?
SUM
AVERAGE
MAX
MIN
Which function returns the lowest value in a range?
SUM
AVERAGE
MAX
MIN
Which function would you use instead of this formula: =B1+B2+B3+B4+B5+B6+B7?
=SUM(B1:B7)
=COUNT(B1:B7)
=AVERAGE(B1:B7)
=MAX(B1:B7)
Which function would you use instead of this formula: =(B1+B2+B3+B4)/4?
=SUM(B1:B4)/4
=COUNT(B1:B4)/4
=AVERAGE(B1:B4)/4
=MAX(B1:B4)/4
Which function was used in E1?
=COUNT(A1:A9)
=COUNTA(A1:A9)
=COUNTBLANK(A1:A9)
Which function was used in E3?
=COUNT(B1:B9)
=COUNTA(B1:B9)
=COUNTBLANK(B1:B9)
Which function was used in E4?
=SUM(B1:B9)
=COUNT(B1:B9)
=AVERAGE(B1:B9)
Which function was used in E5?
=SUM(B1:B9)
=COUNT(B1:B9)
=AVERAGE(B1:B9)
Which function was used in E6?
=SUM(B1:B9)
=MIN(B1:B9)
=MAX(B1:B9)
Which function was used in E7?
=SUM(B1:B9)
=MIN(B1:B9)
=MAX(B1:B9)
Comma format
A
B
C
D
E
Accounting format
A
B
C
D
E
Increase decimals
A
B
C
D
E
Decrease decimals
A
B
C
D
E
Percentage format
A
B
C
D
E
Allows you to rotate text within a cell
A
B
C
D
E
Text that is too wide for the column will be put on two lines within the same cell.
A
B
C
D
E
Decrease indent
A
B
C
D
E
Increase indent
A
B
C
D
E
Combines selected cells and applies center alignment
A
B
C
D
E
Middle Align
A
B
C
Top Align
A
B
C
Bottom Align
A
B
C
Which of the following is the fill color command?
Which of the following is the font color command?
Which of the following is the borders command?
When you delete cells in a worksheet, you remove one or more cells, forcing other cells to move down or to the right.
TRUE
FALSE
To apply a preformatted attributes such as fill color, font size, borders, etc. which are labeled Heading 1, Title, etc., choose the Format Painter command.
TRUE
FALSE
To just clear the contents of a cell without removing the actual cell, use the Delete Cells command.
TRUE
FALSE
After you select a color and apply it to a cell's background, the Fill Color button takes on that color.
TRUE
FALSE
Which of the following statements describes how to increase or decrease a column's width?
Right-click anywhere in the column and select Format Cells
Use the Page Setup dialog box
Drag the boundary next to the column heading
Select a Width setting in the Scale to Fit group on the Page Layout tab
Which of the following dialog boxes is used to transpose rows and columns?
Page Setup
Paste Special
Column Width
Row Height
In which of the following locations are check boxes that you can select to view or print gridlines?
In Print Preview
On the Home tab, in the Cells group
On the Page Layout tab, in the Sheet Options group
On the Page Layout tab, in the Page Setup group
The __________ is the line between rows or columns.
Border line
Boundary
Header
Move line
A(n) __________ is a line of text that appears at the top of each page of a printed worksheet.
Header
Footer
Headnote
Footnote
__________ is the top-to-bottom measurement of a row, measured in points.
Row height
Row size
Row dimension
Row margin
__________ refers to shrinking or stretching printed output to a percentage of its actual size.
Zoom out
Shrink page
Make fit
Scaling
A(n) __________ is a predefined set of colors, fonts, and effects that can be applied to an entire workbook
theme
styles
template
design
Which of the following statements describes how to unhide a hidden row or column?
Select a range of cells in the row or column, right-click, and select Unhide.
Use the Page Setup dialog box.
Remove all page breaks.
Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.
How many worksheets does Excel create by default in a new workbook?
1
2
3
5
Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook?
It's the easiest way to make a backup before making changes.
It lets you reuse formats and formulas in a new sheet.
It helps Excel learn where your data ranges are located.
You should keep one worksheet hidden in case of an error.
What should you do if there is a worksheet that needs to remain in the workbook but does not need to be viewed by everyone who has access to the workbook.
Delete the worksheet
Move the worksheet to the end of the workbook
Hide the worksheet
Click the undisplay command
Which of the following will return your worksheet to 100% with one click?
A
B
C
D
Which of the following statements describes how to change the color of a worksheet tab?
On the Page Layout tab, in the Themes group, select Colors.
Right-click the tab and select Tab Color.
Use the Fill Color tool on the Home tab.
You cannot change the color of a worksheet tab.
Which of the following steps is a method for hiding a single worksheet in a multi-sheet workbook?
On the View tab, in the Window group, click Hide.
Select the visible area of the worksheet.
Right-click the worksheet's tab and click Hide.
Enter the name of the worksheet in the Hide dialog box.
Which cell would you click to freeze Rows 1-5 and Column A?
A5
B5
A6
B6
When you create a copy of a worksheet named August, Excel gives that worksheet which of the following names?
September
August (2)
Sheet2
July
In order for you to freeze the first column of a worksheet into a frozen pane:
The entire contents of the column must be visible.
The first row of the column must be non-blank.
Duplicate worksheets must also be able to have their first columns frozen.
You can click Freeze First Column in the Freeze Panes menu.
When you click the New sheet (+) button on the tabs bar, where is a worksheet always inserted?
At the beginning of the tabs sequence
Before the active worksheet
After the active worksheet
At the end of the tabs sequence
Which Excel ribbon contains the command to Insert Data from Text?
Insert
Data
Home
Page Layout
To have Excel remove any duplicate records that have the same ID#, which value(s) should be checked?
ID# only
ID# and Last Name
ID # and Last Name and First Name
No values should contain a check mark
Which sort option would showing increasing values or alphabetical order?
Ascending
Descending
What is the name of the table used in this function =COUNT(Fbla[Schools])?
COUNT
Fbla
Schools
The table name is not shown
Referring to the table above, which sort order would be the FASTEST way to sort by Country in this order: United States, Canada
Ascending
Descending
Create a Custom Sort List
Referring to the table above, which sort box will sort by Country (with United States listed first), then by State in ascending order, then by Postal Code in ascending order?
Referring to the table above, what is the quickest method of filtering so that only Oklahoma (OK) is shown?
Uncheck every state or province except OK
Uncheck Select All and then check OK
Sort A to Z and then check OK
Sort Z to A and then check OK.
Referring to the table above, which Table Style Option should be enabled so that every other row is filled with a shading color as shown in the 2nd picture?
First Column
Last Column
Banded Columns
Banded Rows
How do you add a Total Row to a table?
Enable the Total Row table style option
Insert a blank row at the bottom of the table and then type "Total Row" as its heading
Enable the Total Row conditional formatting option
Use the Insert ribbon, then check Total Row
