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. Method used to move or copy the contents of a range of cells by dragging the border of a selection from one location and dropping it in another
Comma format
Drag and drop
Percent format
Autocomplete
2. Box at the far left end of the formula bar that you can use to create and navigate to named ranges
Name box
Chart sheet
Arithmetic operators
Print titles
3. To apply attributes to cell data to change the appearance of the worksheet
Nesting
Autocorrect
Data points
Format
4. Command that enables you to display the formulas in a worksheet so that you can check them
Key tips
Intranet
Show formulas
Data marker
5. Reducing or enlarging worksheet information to fit on a specified number of pages
Text box
Wrap text
Scaling
Theme
6. Predrawn graphic used to illustrate a specific data relationship such as a list or other relationship
Tick marks
Nest
Smart Art graphic
Autocomplete
7. Alphanumeric entry in a worksheet that is not a cell or range address
Text
Pick from list
Worksheet
Highlight cells rules
8. Measurement of the typeface in points
Link
Column specifier
Blank workbook
Font size
9. Instruction Excel uses to calculate a result
Publish
Header
Total row
Formula
10. Key that identifies each of the data series in a chart
Data Series
Legend
Auto calculate
Pick from list
11. Chart that occupies its own worksheet
Redo
Chart sheet
Arithmetic operators
Wrap text
12. Excel file with one or more worksheets
Workbook
Absolute reference
Chart sheet
Fill
13. The order in which excel performs the mathematical operations specified in a formula - based on the types of mathematical operators used
Column specifier
Pick from list
Order of precedence
Comma format
14. Number entered in the worksheet as a label - not value - like the year 2012
Formula
Theme
Numeric label
Noncontiguous range
15. Free floating text object added to a sheet or a chart - to which you can apply special formatting effects
Organization chart
Word Art
Theme
Conditional formatting
16. Shape - bar - column representing each data point of a chart
Clipboard
Data marker
Intranet
Organization chart
17. value - some text - or and expression that defines the type of contend you want to see
Default
Number format
Date
Criterion
18. Cell address that can change in a copied formula - so the new address is expressed in relation to the cell containing the copied formula
Relative reference
Object
Structured references
What if analysis
19. Collection of coordinated fonts - colors - and effects for graphic elements such as charts and images that can be quickly applied to all sheets
Rotate
Scaling
Active cell
Theme
20. 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
Explode
Autocomplete
Text box
Absolute reference
21. Predefined formula performs a specific calculation using the inputs you specify
Function
Sort
Footer
Filter
22. Cells in a worksheet that act as a block - but are not necessarily adjacent to each other
Noncontiguous range
Text box
Comma format
Blank workbook
23. Descriptive text appearing at the top of each printout page
Header
Chart layout
Formula bar
Formula
24. Default number of characters that display in a column based on the default font
Column specifier
Default column width
Smart Art graphic
Structured references
25. Work area for entering and calculating data made up of columns and rows separated by gridlines aka spreadsheet
Font size
Worksheet
Structured references
Word Art
26. Process of saving data to internet
Orientation
Publish
Data bars
Print titles
27. Conditional formatting rules that format the highest or lowest values in the formatted range - or those that are above or below average
Filter
Color scales
SUM function
Top/bottom rules
28. Default chart type that displays each data point as a vertical column
Drag and drop
Column chart
Comma format
Data points
29. Private network of computes within a business or organization
Intranet
Name box
Plot area
Auto calculate
30. Feature used to automate the correction of common typing errors
Organization chart
Autocorrect
Embed
Excel table
31. Standard settings excel uses in its software - such as column width or number of worksheets in a workbook
Top/bottom rules
Accounting format
Volatile
Default
32. Combination of font - text color - cell color - and other attributes applied to a single cell
Order of precedence
Cell style
Date
Default column width
33. Each column of a charted worksheet contains a category
Blank workbook
Preview
Categories
Footer
34. Located above the worksheet data appears here
Sort
Auto fill
Wrap text
Formula bar
35. Command used to redo an action you have undone
Embed
Nest
Redo
Scroll
36. Command used to remove data from a cell or range of cells and place it on a clipboard
Cut
Auto fill
Clear
Fill
37. Area that holds the data points on a chart
Chart
Contiguous range
Cell style
Plot area
38. Cell entry that indicates a date or time and is stored as a date code
Header
Date
Theme
Text box
39. Built in calculation used to add range of values together
Filter
Chart
Active sheet tab
SUM function
40. Feature that enables you to automatically combine cells and center the contents
Chart
Color scales
Conditional formatting
Merge and center
41. To insert and object in a destination document so that it can still be edited by the source application - the original object remains unchanged
Embed
Data Series
Freeze
Footer
42. hide nonmatching rows in a table or list of data according to the criterion or criteria you specify
Total row
Filter
Print titles
Nest
43. Using a function as an argument within another function
Vertical axis
Legend
Object
Nesting
44. Block of adjacent cells in a worksheet
Tab scrolling buttons
Chart area
Filter
Contiguous range
45. Block of cells in an excel worksheet
Chart area
Scaling
Range
Criterion
46. Cell entry that consists of a number and numeric formatting only
Grouping
Date
Value
Excel table
47. Feature used to complete and entry based on previous entries made in the column containing the active cell
Formula auto calculate
Function
Autocomplete
Criterion
48. Tool that enables you to copy formatting from a cell and apply it to another cell or range
Active sheet tab
Format
Format painter
Fill handle
49. An identifying label assigned to a group of cells
Chart layout
Cell
Absolute reference
Range name
50. Sections or areas in a window that enable you to see different parts of the worksheet at the same time
Panes
Autocomplete
Font size
Default