Font size
S
M
L
XL
WorksheetsExcel Test Review Chapters 5, 6, and 8
Total questions: 85
Worksheet time: 43mins
Name
Class
Date
1.
If a function contains more than one argument, semicolons separate the arguments.
a)
True
b)
False
2.
Because Excel includes so many functions, the best way to select a function is from the Excel Help.
a)
True
b)
False
3.
You can use the SUM function to total the values stored in up to 255 non-adjacent cells or ranges.
a)
True
b)
False
4.
Some mathematical operations, such as addition, subtraction, multiplication, and division, do not require functions.
a)
True
b)
False
5.
An example of a square root function written correctly is ____.
a)
SQRT(C4)
b)
SQROOT(C4)
c)
=SQRT(C4)
d)
=SQROOT(C4)
6.
Logical functions can determine the average, standard deviation, or variance of a range of data.
a)
True
b)
False
7.
When you sort data contained in columns of a worksheet, Excel includes the column headings
a)
True
b)
False
8.
Filtering data removes errors.
a)
True
b)
False
9.
Hiding permanently removes a row or column from view.
a)
True
b)
False
10.
A picture is anything that appears on the screen that you can select and work with as a whole, such as a shape, picture, or chart
a)
True
b)
False
11.
SmartArt graphics are often used for organizational charts, flowcharts, and decision trees.
a)
True
b)
False
12.
The worksheet cell is the hyperlink, not the contents entered in that cell.
a)
True
b)
False
13.
When you select the data source for a chart, you should also include the text you want to use as labels in the chart.
a)
True
b)
False
14.
Embedded charts are useful when you want to print a chart next to the data the chart illustrates
a)
True
b)
False
15.
A chart sheet does not have worksheet cells and cannot contain data or formulas.
a)
True
b)
False
16.
When you select the chart style, click a 3-D chart subtype to create a 3-D chart.
a)
True
b)
False
17.
Pie charts can be harder to design because you must designate which data should be used on each axis.
a)
True
b)
False
18.
If you know the function you want to enter, you can click the appropriate category button in the ____ group on the Formulas tab of the Ribbon.
a)
Function Library
b)
Formula
c)
Data
d)
Calculations
19.
You can use the Insert Function dialog box to find a specific function. In the ____ box, type a brief description of what you want to do. Then, click Go.
a)
Directory
b)
Find What
c)
Search for a Function
d)
Go To
20.
____ helps you enter a formula with a valid function name and arguments. As you begin to type the function name, a list of function names appears below the active cell.
a)
Formula Complete
b)
Formula Now
c)
Formula Selector
d)
Formula AutoComplete
21.
An example of the function that returns the number of cells in a range of cells that contain data is ____.
a)
=NUMBER(B4)
b)
=COUNT(B4)
c)
=NUMBER(B4:B15)
d)
=COUNT(B4:B15)
22.
You can enter a formula with the AVERAGE, COUNT, MAX, or MIN function in a selected cell by clicking the Sum button arrow in the ____ group on the Home tab, clicking the function name, selecting the appropriate range, and then pressing the Enter key.
a)
Editing
b)
Formula
c)
Cells
d)
Worksheet
23.
The present value of a loan based on equal payments is written as ____.
a)
PV(rate,nper,pmt,fv,type)
b)
PVAL(rate,nper,pmt,fv,type)
c)
PV(rate,nper,pmt,term)
d)
PVAL(rate,nper,pmt,term)
24.
In a PMT function, the argument indicated by fv refers to ____.
a)
Future value
b)
Past value
c)
Favorite value
d)
Fixed value
25.
In the IF function, the second argument determines the value that appears in the cell if the logical test is ____.
a)
False
b)
True
c)
An error
d)
None of the above
26.
In the IF function, the third argument determines the value that appears in the cell if the logical test is ____.
a)
False
b)
True
c)
An error
d)
None of the above
27.
Date and time functions can be used to convert serial numbers to a ____.
a)
Month
b)
Day
c)
Year
d)
All of the above
28.
The ____ function returns the current date and time based on the computer’s date and time settings.
a)
Now()
b)
When()
c)
Current()
d)
Date()
29.
The ____ function repeats the text in the specified cell a specified number of times.
a)
MIRROR
b)
REPT
c)
AGAIN
d)
OVER
30.
Sam is using the functions within Excel to complete questions in a school homework assignment.
Sam needs to find the average of a range of numbers. What would be an example of a formula written correctly?
Sam needs to find the average of a range of numbers. What would be an example of a formula written correctly?
a)
=AVG(E4,E9)
b)
=AVERAGE(E4:E9)
c)
=AVG(E4:E9)
d)
+AVERAGE(E4:E9)
31.
Sam needs to round some figures in a worksheet. The Round function is considered to be a _____ function.
a)
date and time
b)
financial
c)
mathematical
d)
statistical
32.
Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet.
What should Cheryl do to access Formula AutoComplete to help her write her formulas?
What should Cheryl do to access Formula AutoComplete to help her write her formulas?
a)
Type the first letters in a cell
b)
Click Formula AutoComplete on the
Ribbon
c)
Open the
AutoComplete Wizard by right-clicking on the active cell
d)
None of the above
33.
Cheryl has found the formula she wants to use by using Formula AutoComplete. How can she access a Screen Tip to guide her in entering the necessary arguments?
a)
Double-click the name of the function
b)
Double-click anywhere inside the
worksheet
c)
Double-click anywhere outside the
worksheet
d)
None of the above
34.
To sort data, you first click a cell in the column by which you want to sort a range of data. Click the Data tab on the Ribbon. In the ____ group, click ascending or descending sort.
a)
Filter
b)
Sort
c)
Sort & Filter
d)
Data
35.
When you want to see all the data in a worksheet again, you can restore all the rows by clearing the filter. Click the filter arrow, and then click the ____ command.
a)
Clear Filter From
b)
Clear Filter To
c)
Remove Filter From
d)
Remove Filter To
36.
To add conditional formatting, select the range you want to analyze. In the ____ group on the Home tab, and click the Conditional Formatting button.
a)
Formulas
b)
Format
c)
Edit
d)
Styles
37.
To hide more than one row, select how many rows you want to hide, and then ____ the selection to show the short-cut menu.
a)
right-click
b)
left-click
c)
highlight
d)
double-click
38.
To open the Shapes gallery, click the Insert tab on the Ribbon, and then, in the ____ group, click the Shapes button.
a)
Shapes
b)
Clip Art
c)
Illustrations
d)
Pictures
39.
To open the Shapes gallery, click the Insert tab on the Ribbon, and then, in the ____ group, click the Shapes button.
a)
Shapes
b)
Clip Art
c)
Illustrations
d)
Pictures
40.
When the shape is selected, the ____ appear on the Ribbon and contain the Format contextual tab.
a)
Drawing Tools
b)
Shape Tools
c)
Graphic Tools
d)
Editing Tools
41.
When you no longer need a shape or any other object in a worksheet, you can delete it. First, click the object to select it. Then press the ____ key.
a)
Recycle
b)
Remove
c)
Erase
d)
Delete
42.
____ graphics enhance worksheets by providing a visual representation of information and ideas.
a)
SmartClips
b)
SmartPictures
c)
SmartPhotos
d)
SmartArt
43.
To insert a SmartArt graphic, click the SmartArt button in the ____ group on the Insert tab. The Choose a SmartArt Graphic dialog box appears.
a)
Illustrations
b)
Shapes
c)
Data
d)
Formulas
44.
When the SmartArt graphic is selected, SmartArt Tools appear on the ____ and contain the Design and Format contextual tabs.
a)
Drawing tab
b)
Status bar
c)
Side bar
d)
Ribbon
45.
A(n) ____ is a digital photograph or other image file.
a)
Attachment
b)
Fax
c)
Picture
d)
Shape
46.
To insert a picture from a file, click the ____ button in the Illustrations group on the Insert tab of the Ribbon.
a)
Format
b)
Shape
c)
Data
d)
Picture
47.
The ____ tab contains tools to edit and format the picture.
a)
Edit
b)
Format
c)
Delete
d)
Graphics
48.
____ are predesigned workbook files that you can use as the basis or model for new workbooks.
a)
Forms
b)
Templates
c)
Formats
d)
Images
49.
A ____ is a reference in a worksheet that opens another file or page when you click it.
a)
hyperlink
b)
button
c)
transporter
d)
pop-up cell
50.
You can create hyperlinks to ____.
a)
another Web page
b)
a specific location in the current
workbook
c)
an e-mail address
d)
all of the above
51.
The chart types are available on the ____ tab in the Charts group.
a)
Data
b)
Edit
c)
Worksheet
d)
Insert
52.
You open the Insert Chart dialog box by clicking the Dialog Box Launcher in the ____ group on the Insert tab.
a)
Charts
b)
Cells
c)
Worksheet
d)
Edit
53.
You can rename a chart sheet like any other worksheet. Right-click its sheet tab, and then click ____ on the shortcut menu.
a)
Text box
b)
Rename
c)
File name
d)
Chart name
54.
A selected chart element is surrounded by a ____.
a)
fill box
b)
selection box
c)
text box
d)
border
55.
A chart, whether embedded in a worksheet or on a chart sheet, is considered part of a ____.
a)
workbook
b)
database
c)
data file
d)
report
56.
You switch between a chart sheet and a worksheet by clicking the appropriate ____.
a)
sheet tabs
b)
file name
c)
icon
d)
data marker
57.
A ____ chart shows the relationship of a part to a whole.
a)
pie
b)
column
c)
line
d)
scatter
58.
Each part of a pie chart is shown as a ____ of the pie.
a)
bowl
b)
slice
c)
serving
d)
dish
59.
Businesses often use all of the following EXCEPT ____ charts to illustrate growth over several periods.
a)
column
b)
bar
c)
line
d)
pie
60.
Paco wants to change some of the elements in his chart, including the fill and border color.
What type of dialog box does Paco need to access to make these changes?
What type of dialog box does Paco need to access to make these changes?
a)
Format dialog box
b)
Chart dialog box
c)
Style dialog box
d)
Layout dialog box
61.
On a separate chart that he is working on, Paco needs to access the Format dialog box for the chart legend. First, he selects the chart he wants to edit. Then, on the ____ tab under Chart Tools on the Ribbon, in the Current Selection group, he clicks the Format Selection button.
a)
layout
b)
page layout
c)
data
d)
format
62.
The ____________________ is the value the function uses to perform a calculation, including a number, text, or a cell reference that acts as an operand.
a)
function
b)
argument
c)
data
d)
number
63.
As an example of a financial function, =____________________(.1,5,–500) displays the current value of five payments of $500 at a 10% interest rate.
a)
PMT
b)
FV
c)
CV
d)
PV
64.
The monthly interest rate is determined by dividing the annual interest rate by 12 ____________________.
a)
days
b)
years
c)
percent
d)
months
65.
A(n) ____________________ sort arranges data with letters from Z to A, data with numbers from highest to lowest, and data with dates from oldest to newest.
a)
filter
b)
ascending
c)
descending
d)
data
66.
All of the comments tools are located on the ____________________ tab of the Ribbon in the Comments group.
a)
comments
b)
edit
c)
review
d)
format
67.
A(n) ____________________ chart uses bars of varying heights to illustrate values in a worksheet.
a)
bar
b)
pie
c)
column
d)
line
68.
A(n) ____________________ is a group of related information in a column or row of a worksheet that is plotted on the chart.
a)
data series
b)
argument
c)
legend
d)
workbook
69.
You can pull one or more slices away from the pie to distinguish them, creating what is called a(n) ____________________ pie chart.
a)
unstructured
b)
3-D
c)
exploded
d)
disconnected
70.
You can show a variety of data markers on sparklines, including the high and low points, negative point, first and last points, and all data points. These options are available in the ____________________ group.
a)
format
b)
data
c)
sort
d)
show
71.
Functions used to describe large quantities of data.
a)
mathematical
b)
text
c)
financial
d)
statistical
72.
Functions that are used to insert dates and times in a worksheet.
a)
text
b)
mathematical
c)
date and time
d)
financial
73.
Functions used to analyze loans and investments.
a)
statistical
b)
financial
c)
mathematical
d)
text
74.
Functions that are used to format and work with cell contents.
a)
text
b)
financial
c)
mathematical
d)
statistical
75.
Functions, such as the square root functions, that manipulate quantitative data in a worksheet.
a)
statistical
b)
text
c)
mathematical
d)
financial
76.
Displays a subset of the data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria.
a)
Sort
b)
Object
c)
Conditional Formatting
d)
Filtering
77.
Rearranging the data in a more meaningful order.
a)
Sort
b)
Object
c)
Conditional Formatting
d)
Filtering
78.
A note attached to a cell that is usually used to explain or identify information contained in the cell.
a)
Sort
b)
Comment
c)
Filtering
d)
Conditional Formatting
79.
Highlights worksheet data by changing the look of cells that meet a specified condition.
a)
Filtering
b)
Conditional Formatting
c)
Sort
d)
Object
80.
Anything that appears on the screen that you can select and work with as a whole.
a)
Sort
b)
Filtering
c)
Object
d)
Comment
81.
The entire chart and all other chart elements.
a)
Chart layout
b)
chart
c)
chart style
d)
chart area
82.
Specifies which elements are included in a chart and where they are placed.
a)
Chart layout
b)
Chart
c)
chart style
d)
chart
83.
A separate sheet in the workbook that stores a chart.
a)
chart
b)
chart layout
c)
chart sheet
d)
chart area
84.
Formats the chart based on the colors, fonts, and effects associated with the workbook’s theme.
a)
chart
b)
chart layout
c)
chart style
d)
chart area
85.
A graphical representation of data.
a)
chart sheet
b)
chart
c)
chart layout
d)
chart area
Reset
