Formatting Data & Graphics in Microsoft Office Excel 2016
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| show | Yes
🗑
|
||||
| Where are the commands for adding graphics located? | show 🗑
|
||||
| show | No
Because images are by default freely moving objects.
🗑
|
||||
| show | 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? | show 🗑
|
||||
| To change the size of an image...... | show 🗑
|
||||
| To move the image | show 🗑
|
||||
| The Picture Tools Format tab is added when? | show 🗑
|
||||
| Do what to change a picture's styles, borders, and effects? | show 🗑
|
||||
| Can numeric formats be applied after data are entered? | show 🗑
|
||||
| Formatting empty cells before typing the data... | show 🗑
|
||||
| show | 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? | show 🗑
|
||||
| show | Increase Decimal and Decrease Decimal
for easily changing the decimal places for a value
🗑
|
||||
| show | How a value is displayed.
🗑
|
||||
| show | NO
🗑
|
||||
| show | Select the cell and look at the Formula bar.
🗑
|
||||
| What is a conditional format? | show 🗑
|
||||
| show | 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? | show 🗑
|
||||
| show | A dialog box
🗑
|
||||
| show | changes relative to the cell it is copied to.
🗑
|
||||
| show | The result is 12 because the order of operations states that multiplication be performed first and then addition and subtraction.
🗑
|
||||
| A function | show 🗑
|
||||
| Which is an example of an absolute cell reference? | show 🗑
|
||||
| Data in chronological order is sorted | show 🗑
|
||||
| The IF function is used to | show 🗑
|
||||
| show | displays data as a percentage of a whole.
A pie chart uses slices that are sized as a percentage of a whole.
🗑
|
||||
| show | 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.
🗑
|
||||
| show | perform an advanced search with multiple criteria.
🗑
|
||||
| show | PivotTable.
A PivotTable automatically analyzes and summarizes data.
🗑
|
||||
| show | 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