picture or graphic element can be placed in a header or a footer in an Excel worksheet.
True
False
5
When working with the financial functions, the Pmt argument (the payment) is _______ if you are paying out the money.
protected
hidden
positive
negative
6
Use the check boxes in the _______ group to customize the table formatting by adding or removing banding for rows or columns.
Table Styles Design
Table Style Options
Table Formatting
Design Options
7
If Excel data are formatted as a table, filtering is enabled automatically.
True
False
8
When a filter has been applied to a column, the column header will display an arrow.
True
False
9
To create a PivotTable, click the Recommended PivotTables button on the _______ tab of the Ribbon.
Home
Insert
Formulas
Data
10
One way to subtotal data without formulas and without including details in an outline format is to use Consolidate.
True
False
11
To view page breaks in a worksheet more clearly, use the _______ view.
Page Layout
Normal
Page Break Preview
Web
12
_______ prints only the selected cells in the active worksheet.
Print Selection
Print Entire Workbook
Print Selected Table
13
You can unmerge a merged cell back into its original cells, but you cannot split a single cell into two new columns or two new rows.
True
False
14
You can move a chart to a new position on the sheet by selecting it and then dragging it anywhere on the worksheet.
True
False
15
To switch your current chart to a different chart type, click the Reset Chart button in the Chart Tools Layout tab.
True
False
16
When you insert new cells, the cells will use the same formatting as the cells either above, if you shifted down, or to the left, if you shifted right.
True
False
17
The Clear button on the Sparkline Tools Design tab will remove Sparklines from the selected cells.
True
False
18
You can sort or filter data on all except which of the following?
cell color
shapes
font color
icons
19
When you insert a picture into an Excel worksheet, the images are embedded objects, meaning they become part of the workbook.
True
False
20
_______ charts are like column charts turned on their side.
Line
Pie
Clustered column
Bar
21
To use Consolidate, the data need to be sorted in a particular order.
True
False
22
To return your worksheet to normal after freezing panes, click the Freeze Panes button and select _______.
Unfreeze Rows
Unfreeze Columns
Unfreeze Panes
Unfreeze Worksheet
23
The NOW function inserts the system date and time.
True
False
24
The Lookup & Reference function category includes MATCH and INDEX.
True
False
25
Which of the following is not a type of Sparkline?
Pie
Win/Loss
Column
Line
26
To concatenate means to _______ items such as when you combine the text values of cells in Excel.
split
link
merge
duplicate
27
When filtering is enabled, you can clear the filter and disable filtering from the _______ tab.
Home
Data
Design
Format
28
To maintain the _______ ratio of a picture, be sure to use one of the resize handles at the four corners of the picture.
resize
size
aspect
square
29
You can use the _______ keyboard shortcut to open the Find and Replace dialog with the Find tab on top.
Ctrl+H
Ctrl+O
Ctrl+F
Ctrl+C
30
You can manually enter values for the size of a picture or you can drag a(n) _______ handle on the image to make it larger or smaller.
resize
rotate
select
alignment
31
When calculating an average, Excel includes all empty cells.
True
False
32
In a PivotTable, Excel will place fields with numeric data in the Values section and text or date fields in the _______ section.
Text
Header Row
Range
Rows
33
When entering a numerical expression such as “<10” as the Criteria argument, you must enclose the expression in quotation marks.
True
False
34
Names assigned to cells act as a list of _______ to the cell locations.
shortcuts
links
pointers
ranges
35
Typically, when you sort data by a single column, you use the Sort A to Z or _______ commands available.
Chronological sort
Sequential sort
Sort Z to A
Numerical sort
36
To choose a custom color, click _______ from the bottom of the font color palette.
More Colors…
Advanced Colors…
Created Colors…
Single Colors
37
The text functions RIGHT, LEFT, and MID _______ a specific number of characters from a text string.
insert
extract
format
copy
38
To sum data that meet multiple criteria, use _______.
COUNTIF
SUM
SUMIF
SUMIFS
39
When you insert a row or column, a _______ will appear, allowing you to choose formatting options for the new row or column.
green triangle
Mini Toolbar
Smart Tag
dialog box
40
_______ data in a worksheet allows you to see only the rows that meet criteria you specify.
Sorting
Filtering
Deleting
Moving
41
To rename a worksheet in a workbook, right-click the worksheet tab, and select _______.
Name
Rename
Sheet
Heading
42
One method of changing a chart type is to _______ in the chart area and select Change Chart Type….
click
double-click
right-click
press
43
The absolute value of a negative number is the same as the number.
True
False
44
In the IF function, the Logical_test argument always includes a _______ operator.
combination
comparison
function
formula
45
To sort or filter the category data in the PivotChart, click the button in the lower right corner of the PivotChart with the name of the field you want to sort or filter.
True
False
46
The keyboard shortcut for the Paste command is _______.
Ctrl+X
Ctrl+C
Ctrl+P
Ctrl+V
47
To unhide a row or column, you must double-click the boundary where the hidden row or column would normally be located.
True
False
48
The _______ paste option pastes only the values, not the underlying formula or cell formatting.
Values
Formulas
Transpose
No Borders
49
Pie charts do not contain _______.
pie slices
data points
point explosions
gridlines
50
The Count function counts the number of cells that contain numbers within a specified range of cells.
True
False
0 comments