SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Microsoft Office Excel
Start Test
Study First
Subject
:
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Box at the far left end of the formula bar that you can use to create and navigate to named ranges
Name box
Live preview
Explode
Plot area
2. Setting that determines whether the worksheet will be printed with the paper in portrait or landscape
Intranet
Orientation
Chart
SUM function
3. Feature used to complete and entry based on previous entries made in the column containing the active cell
Expression
Scaling
Chart sheet
Autocomplete
4. Predefined formula performs a specific calculation using the inputs you specify
Function
Print titles
What if analysis
Volatile
5. graphic that compares and contrasts worksheet data in visual format
Chart
Icon sets
Default
Smart Art graphic
6. To move a pie slice away from the pie chart - for emphasis
Volatile
Explode
Relative reference
What if analysis
7. Block of adjacent cells in a worksheet
Contiguous range
Drag and drop
Filter
Auto fill
8. Set of related data points to be charted
Noncontiguous range
Data Series
Clear
Smart Art graphic
9. value - some text - or and expression that defines the type of contend you want to see
Argument
Criterion
Autocomplete
Orientation
10. Format that controls how numerical data is displayed including the use of commas - dollar signs - and decimal places
Number format
Fill handle
Criterion
Accounting format
11. Each column of a charted worksheet contains a category
Categories
Link
Copy
Keyboard shortcuts
12. Selected worksheet
Active sheet tab
Font
Spelling checker
Preview
13. Any element on a worksheet or chart that can be manipulated independently
Expression
Object
Fill handle
Data bars
14. Symbols used in mathematical operations
Collapse box button
Arithmetic operators
Object
Workbook
15. Located above the worksheet data appears here
Formula bar
Embed
Wrap text
Undo
16. Measurement of the typeface in points
Link
Contiguous range
Format
Font size
17. Using a function as an argument within another function
Nesting
What if analysis
Intranet
Wrap text
18. List of sequential numbers - dates - times - or text
Chart
Series
Comma format
Clear
19. To change the angle of the contents on a cell
Accounting format
Merge and center
Rotate
Range name
20. Command used to place data from the clipboard to a location on the worksheet
Vertical axis
Structured references
Paste
Clear
21. Style that displays decimal numbers as a percentage
Percent format
Cell
Range name
Formula
22. Command used to place a copy of data from the selected cell or range on the clipboard
Merge and center
Organization chart
Clipboard
Copy
23. Windows feature that holds data or graphics that you cut or copy prior to pasting into another location
Clipboard
Fill
Key tips
Scroll
24. Cell entry that consists of a number and numeric formatting only
Preview
Auto fill
Value
Theme
25. Displays the relationships within an organization such as managers in an office - the people they manage and who they report to
Data Series
Organization chart
Cell address
Sheet tabs
26. Cells in a worksheet that act as a block - but are not necessarily adjacent to each other
Noncontiguous range
Text box
Nesting
Word Art
27. hide nonmatching rows in a table or list of data according to the criterion or criteria you specify
Filter
Default
Header
Footer
28. Process of saving data to internet
Preview
Redo
Publish
Font size
29. vertical scale of a chart on which the values from each category is plotted
Volatile
Spelling checker
Explode
Vertical axis
30. Tool used to assist you in finding and correcting typographical or spelling errors
Data points
Format
Formula
Spelling checker
31. Type of conditional formatting that includes one of a set of icons reflecting the relative value stored in each of the formatted cells
Intranet
Sort
Icon sets
Nest
32. Cell address in a formula that will not change when you copy the formula to another location - dollar signs in the cell reference indicate when it is absolute
Accounting format
Absolute reference
Organization chart
Panes
33. Feature that enables excel to create a series automatically
Auto fill
SUM function
Intranet
Chart layout
34. Style that vertically aligns with dollar signs and decimal points
Accounting format
Worksheet
Top/bottom rules
Percent format
35. Using formulas and other tools in Excel to examine the results of particular data
Chart
What if analysis
Clipboard
Active sheet tab
36. A free floating box added to a sheet or chart that contains any text you specify and can be formatted separately
Text box
Default
Data marker
Pick from list
37. Color that fills a cell appearing behind the data
Scroll
Data points
Fill
Color scales
38. An identifying label assigned to a group of cells
Percent format
Legend
Numeric label
Range name
39. Function that updates and displays a new result each time you open the workbook
Data bars
Volatile
Workbook
Keyboard shortcuts
40. Name given to on of excels predefined formulas
Argument
Label
Function name
Merge and center
41. Default number of characters that display in a column based on the default font
Active cell
Default column width
Blank workbook
Clipboard
42. Text entered to identify the type of data contained in a row or column
Keyboard shortcuts
Percent format
Label
Wrap text
43. Feature that speeds up the manual entry of functions
Formula auto calculate
Grouping
Undo
Copy
44. Alphanumeric entry in a worksheet that is not a cell or range address
Percent format
Chart Sheet
Text
Contiguous range
45. Tool that enables you to copy formatting from a cell and apply it to another cell or range
Name box
Format painter
Footer
Active sheet tab
46. To use a function as an argument within another function
Chart area
Nest
Smart Art graphic
Default
47. Type of conditional formatting that creates filled background bars reflecting the relative value stored in each of the formatted cells
Scaling
Vertical axis
Formula auto calculate
Data bars
48. Using the table name or a table column header in a formula to refer to data in the entire table or specified column
Auto fill
Value
Structured references
Name box
49. To insert and object in a destination document so that it can still be edited by the source application - the original object remains unchanged
Workbook
Key tips
Embed
Object
50. Private network of computes within a business or organization
SUM function
Object
Merge and center
Intranet