excel 6 review make a review sheet by numbering as shown below. the test is timed. you can practice...
DESCRIPTION
Question 02 _______________sorts from low to high—1 to 1000 or A to Z AscendingDescendingTRANSCRIPT
![Page 1: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/1.jpg)
Excel 6 Review
•Make a review sheet by numbering as shown below. •The test is timed. •You can practice again if needed.•Click the mouse when you are ready to begin.
1. 2.3.4.5.6.Down to15.
![Page 2: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/2.jpg)
Question 01
_________________ sorts from high to low--1000 to 1 or from Z to A.
Ascending Descending
![Page 3: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/3.jpg)
Question 02
_______________sorts from low to high—1 to 1000 or A to Z
Ascending Descending
![Page 4: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/4.jpg)
Question 03
_________________ highlights worksheet data by changing the look of cells that meet a specified condition; such as making cells less 80 appear in red and bold
Sorting Highlighting
Conditional Formatting
Filtering
![Page 5: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/5.jpg)
Question 04
_______________—temporarily removes a row or column from view.
Sorting Hiding Shading
![Page 6: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/6.jpg)
Question 06
_____________ —organizes data in an order that is more meaningful.
Filtering Freezing
Filling Sorting
![Page 7: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/7.jpg)
Question 06
Use this feature to display a subset of the data that meets certain criteria. It temporarily hides the rows that don’t meet the specified criteria. What is this? _______________.
Sort Filter
Shading Conditional Formatting
![Page 8: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/8.jpg)
Question 07
_____________ --a shape used to display a message.
Chart Callout
Sheet tab
Example
![Page 9: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/9.jpg)
Question 08
The shape below is showing a __________shape.
2-D 3-D
Flattened
![Page 10: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/10.jpg)
Question 9
The shape below is showing a ____________ effect.
shading blurconditional
![Page 11: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/11.jpg)
Question 10
All of the following are examples of a Smart Graphic EXCEPT:
Venn Diagram Organizational Chart
Text Box Pyramid Chart
![Page 12: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/12.jpg)
Question 11
To make the background color of a picture so that is see through, use Set ___________ Color.
Relative TransparentUnderline Background
![Page 13: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/13.jpg)
Question 12
____________ are predesigned workbook files that you can use as the basis or model for new workbooks.
Themes Smart GraphicsTemplates
![Page 14: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/14.jpg)
Question 13
A _________________is a collection of worksheets.
.
sheetbook Graphing book
workbook
![Page 15: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/15.jpg)
Question 14
The arrow below is pointing at the Sheet1 __________. These can be renamed, colored, etc.
placeholder Sheet tab
Work tab
![Page 16: Excel 6 Review Make a review sheet by numbering as shown below. The test is timed. You can practice again if needed. Click the mouse when you are ready](https://reader036.vdocuments.us/reader036/viewer/2022062401/5a4d1b2b7f8b9ab0599990be/html5/thumbnails/16.jpg)
Question 15
Trimming off the edges of a picture leaving a inner section is called ___________.
scaling cutting
Cropping slicing