Testmoz
Home
Features
Pricing
FAQs
Build a Test
Login/Sign Up

Excel Complete Unit D & E

Is this your test? Login to manage it. If not, you can create an assessment just like it.

This is a non-interactive preview of the quiz content.

1.
1 point
Which text function converts text to uppercase?
2.
1 point
Use this function to check for errors and display a message you specify if there is an error in a formula.
3.
1 point
Dragging a chart object to a new location on the worksheet will change the data in the worksheet.
4.
1 point
Which two charts compare trends over time intervals?
a. c. b. d.
5.
1 point
Cell names cannot contain ____.
6.
1 point
A formula that makes calculations based on stated conditions is called a ____.
7.
1 point
A pie chart ____.
8.
1 point
The x-axis and y-axis are, respectively, the ____.
9.
1 point
Which function returns the number of entries in a range based on given criteria?
10.
1 point
Symbols, such as less than (<), greater than (>), and equal to (=), are all examples of comparison operators.
11.
1 point
Names of cells and ranges can use ____.
12.
1 point
A(n) ____ identifies each data series in a chart, generally with a different color.
13.
1 point
In a pie chart, slices that are pulled away are said to be ____.
14.
1 point
You can assign names to cells and ranges, but you cannot use these names in formulas.
15.
1 point
Which of the following is not a valid named range?
16.
1 point
A delimiter is a data separator.
17.
1 point
Which of the following is NOT a comparison operator you can use in Excel?
18.
1 point
A common example of a text delimiter is ____.
19.
1 point
You can create multiple charts based on the same worksheet data.
20.
1 point
The parts of an IF function are separated by parentheses.
21.
1 point
A(n) ____ chart compares distinct object levels using vertical bars; is the Excel default.
22.
1 point
The scatter chart is the Excel default,and compares sizes of pieces as part of a whole.
23.
1 point
Which text function converts text to lowercase?
24.
1 point
Which text function capitalizes the first letter in a string of text?
25.
1 point
Which of these is NOT one of the three parts of an IF function?
26.
1 point
Text annotations are ____ that you can add to further describe the data in your chart.
27.
1 point
Any data changed in the worksheet is automatically updated in the chart.
28.
1 point
A collection of related data points is called a ____.
a. c. b. d.
29.
1 point
Which Excel feature is used to break a data field into separate columns?
30.
1 point
You must type underscores instead of spaces between words when you assign a name to a cell or range.
31.
1 point
The AND function returns a value of TRUE if every logical test in the formula is true.
32.
1 point
Determine the calculated result of the formula =PROPER(“john smith”).
33.
1 point
Named cells can be used as a navigational tool by selecting the name in the ____.
34.
1 point
A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.
35.
1 point
You can build a logical formula using an IF function.
Home Features Pricing FAQs Legal Sample Tests Build a Test Login/Sign Up