click below
click below
Normal Size Small Size show me how
Graphics & Data
Formatting Data & Graphics in Microsoft Office Excel 2016
Term | Definition |
---|---|
Can graphics be used on a worksheet? | Yes |
Where are the commands for adding graphics located? | The Insert tab. |
Does it matter which cell(s) is/are selected when inserting a graphic? Why/Why not? | No Because images are by default freely moving objects. |
What are the steps to insert an image from a computer? | click Pictures on the Insert tab navigate to the image you want click Online Pictures on the Insert tab to search for a clip art image online |
Clip art from the Internet is protected by copyright through what means? | a Creative Commons license A link to this license is available in the Insert Pictures dialog box. |
To change the size of an image...... | Select it and change its size or rotate it by dragging a handle |
To move the image | Drag it to a new location |
The Picture Tools Format tab is added when? | A picture is selected. |
Do what to change a picture's styles, borders, and effects? | Click on the Picture Tools Format tab. |
Can numeric formats be applied after data are entered? | Yes |
Formatting empty cells before typing the data... | Can help improve accuracy. |
To apply a format... | Select a cell or range of cells go to Number Format list on the Home tab |
What can be seen by clicking the Number Format dialog box launcher? | All available number formats |
Number group also contains what function? | Increase Decimal and Decrease Decimal for easily changing the decimal places for a value |
What do formats applied to a cell determine? | How a value is displayed. |
Does formatting change the stored value of a cell? | NO |
To find the value stored in a cell do what? | Select the cell and look at the Formula bar. |
What is a conditional format? | When a cell displays a color format based on a value. It is based on rules that range from simple to complex. |
What are the steps to apply conditional formatting? | select the cell or cell range to format click Conditional Formatting on the Home tab to display a menu |
What do Highlight Cells Rules provide? | Simple and effective formatting. |
When one of the Highlight Cells Rules is clicked what displays? | A dialog box |
A relative cell reference | changes relative to the cell it is copied to. |
What is the result of the formula =5+2*3+1? | The result is 12 because the order of operations states that multiplication be performed first and then addition and subtraction. |
A function | performs a calculation and returns a single value. |
Which is an example of an absolute cell reference? | $B$2 An absolute cell reference requires dollar signs in front of both the column letter and row number. |
Data in chronological order is sorted | in order from lowest to highest. Data in chronological order is arranged from lowest to highest. |
The IF function is used to | return a value based on a comparison. The IF function makes a comparison and then returns a result based on that comparison. |
A pie chart | displays data as a percentage of a whole. A pie chart uses slices that are sized as a percentage of a whole. |
A chart legend | is based on the category labels in the first column of data. A chart legend corresponds to the category labels in the first column of data. |
A filter is used to | perform an advanced search with multiple criteria. |
A table that automatically analyzes and summarizes your data is called a/an | PivotTable. A PivotTable automatically analyzes and summarizes data. |
To sort data in a table, you must | click the arrow button in a column header and then click a Sort command. You click the arrow button in a table to display a menu with Sort commands |