Formatting Data & Graphics in Microsoft Office Excel 2016
Help!
|
|
||||
|---|---|---|---|---|---|
| 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
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
mtooner
Popular Computers sets