Font size
WorksheetsEXCEL- Chapter 4- Working with Data
Total questions: 20
Worksheet time: 10mins
By ________________ in place, you'll be able to scroll through your content while continuing to view the Header Cells.
4.1
Holding Rows or Columns
Freezing Rows or Columns
Icing Rows or Columns
Scrolling Rows or Columns
You can quickly reorganize a worksheet by_____?
4.1
Organizing
Putting in Order
Sorting your data
Clicking Random Buttons
____________can be used to narrow down the data in your worksheet, allowing you to view only the information you need.
4.1
Sorting
Formatting
Filters
Edits
What command allows you to quickly summarize data?
4.1
Total Command
Subtotal Command
Ten Command
Summary Command
What allows you to illustrate your workbook data graphically?
4.1
Charts
Tables
Spreadsheets
Workbooks
Excel includes additional options to make your workbooks easier to view and compare. For example, you can choose to ________ or_______.
open a new window for your workbook
split a worksheet into separate panes
Sort Spreadsheet
AutoSum
View tab on the Ribbon
When sorting data, it's important to first decide if you want the sort to apply to the ______________ or just a _________.
4.3
entire worksheet
cell range
right answer
spreadsheet
Chart
In which tab on the Ribbon will you find the Sort button?
4.3
Sort
Data
View
Insert
File
In which tab on the Ribbon will you find the Filter button?
4.3
Filter
Data
View
Insert
File
T/F
Filters are cumulative, which means you can apply multiple filters.
4.3
True
False
What is this button in the Data Tab?
4.4
Total
Subtotal
Outline
Add
___________ can improve the look and feel of your workbook.
4.5
Tables
Cells
Pictures
Cookies
Fuzzy Socks
What tab would you click on to change the style of your table?
4.5
Design
Insert
View
Table
What type of Chart is this? 4.7
Column
Line
Pie
Bar
Area
What type of Chart is this? 4.7
Column
Line
Pie
Bar
Area
What type of Chart is this? 4.7
Column
Line
Pie
Bar
Area
What type of Chart is this? 4.7
Column
Line
Pie
Bar
Area
What type of Chart is this? 4.7
Column
Line
Pie
Bar
Area
What allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value.
4.8
Formatting
Sorting
Sort & Filter
Conditional Formatting
What is the name of this button, found on the Home tab?
4.8
Conditional Formatting
Highlight Cell
Format cell
Manage Rules
