Professional Formatting
Explore the Flashcards:
Adjusting a spreadsheet's appearance to make it clear and visually appealing.
![1. Pro Formatting.png](https://365datascience.com/resources/flashcards/6v7x83km75f-1-pro-formatting.png)
Select Entire Worksheet
The action of choosing all cells in a worksheet for formatting or data entry.
![2. Select sheet.png](https://365datascience.com/resources/flashcards/w9hus30xbqp-2-select-sheet.png)
Title Cell
A designated cell used for headings or titles in a spreadsheet.
![3. Worksheet Title.png](https://365datascience.com/resources/flashcards/2567kqgihpdj-3-worksheet-title.png)
Fast Scrolling
Being able to quickly navigate through large datasets using keyboard shortcuts.
![4. Fast Scrolling.png](https://365datascience.com/resources/flashcards/s60efofpvo-4-fast-scrolling.png)
Scroll Down Fast
Quickly moving down through rows in a spreadsheet using a keyboard shortcut, typically Control + Down Arrow.
![5. Scroll Down Fast.png](https://365datascience.com/resources/flashcards/k99lghk009k-5-scroll-down-fast.png)
Scroll Up Fast
Rapidly navigating upwards through spreadsheet rows with a shortcut, generally Control + Up Arrow.
![6. Scroll Up Fast.png](https://365datascience.com/resources/flashcards/pzl4y6vb39-6-scroll-up-fast.png)
Scroll Right Fast
Speedily moving to the right across columns in a spreadsheet using a keyboard command, often Control + Right Arrow.
![7. Scroll Right Fast.png](https://365datascience.com/resources/flashcards/mfdppqw6jdj-7-scroll-right-fast.png)
Scroll Left Fast
Swiftly scrolling left through columns in Excel, typically executed with Control + Left Arrow.
![8. Scroll Left Fast.png](https://365datascience.com/resources/flashcards/oggkp9wwlhl-8-scroll-left-fast.png)
Extend Selection Downward
Use Ctrl + Shift + Down Arrow to select cells down to the last non-blank cell in a column.
![9. Extend Selection Downward.png](https://365datascience.com/resources/flashcards/7g5rkypvatx-9-extend-selection-downward.png)
Extend Selection Upward
Apply Ctrl + Shift + Up Arrow to select cells up to the first non-blank cell in a column.
![10. Extend Selection Upward.png](https://365datascience.com/resources/flashcards/n4za1e0ovk-10-extend-selection-upward.png)
Extend Selection Rightward
Utilize Ctrl + Shift + Right Arrow to select cells to the rightmost non-blank cell in a row.
![11. Extend Selection Right.png](https://365datascience.com/resources/flashcards/w9c8nl289mh-11-extend-selection-right.png)
Extend Selection Leftward
Employ Ctrl + Shift + Left Arrow to select cells to the leftmost non-blank cell in a row.
![12. Extend Selection Left.png](https://365datascience.com/resources/flashcards/gtyr76d363e-12-extend-selection-left.png)
Fixed Reference
A cell reference in a formula that remains constant when copied to other cells.
![13. Fixed reference.png](https://365datascience.com/resources/flashcards/gozi21t6f8a-13-fixed-reference.png)
Dollar Sign ($)
Symbol used in Excel to fix a row or column reference in formulas.
![14. Dollar sign.png](https://365datascience.com/resources/flashcards/bc90m55aev6-14-dollar-sign.png)
Relative Reference
A cell reference in a formula that changes when the formula is copied to other cells.
![15. Relative reference.png](https://365datascience.com/resources/flashcards/zvo51hfo84-15-relative-reference.png)
Absolute Reference
A cell reference in a formula that does not change when the formula is copied.
![16. Absolute reference.png](https://365datascience.com/resources/flashcards/4m1v8g6al9h-16-absolute-reference.png)
Mixed Reference
A cell reference that combines relative and absolute references, using both $ and regular coordinates.
![17. Mixed reference.png](https://365datascience.com/resources/flashcards/8n50kted92w-17-mixed-reference.png)
Freeze Panes
A feature to keep specific rows or columns visible while scrolling through a spreadsheet.
![18. Freeze panes.png](https://365datascience.com/resources/flashcards/8k2jcairmi7-18-freeze-panes.png)
Unfreeze Panes
Reverting the freeze panes action to allow all parts of the sheet to scroll.
![19. Unfreeze panes.png](https://365datascience.com/resources/flashcards/i9j58e6gln-19-unfreeze-panes.png)
Text-to-Columns
A tool in Excel that separates text from a single cell into multiple columns based on a delimiter like commas or spaces, or fixed width. Used for organizing combined data.
![20. Text-to-columns.png](https://365datascience.com/resources/flashcards/m9fipa6e2lr-20-text-to-columns.png)
Alt + Enter
Keyboard shortcut to insert a line break within a cell, creating multi-line text.
![21. Alt Enter.png](https://365datascience.com/resources/flashcards/9oonjxsyu9b-21-alt-enter.png)
Wrap Text
A feature that adjusts row height to display all text within a cell.
![22. Wrap text.png](https://365datascience.com/resources/flashcards/7n4wyk72r8q-22-wrap-text.png)
Regular Sort
An Excel feature for organizing data in ascending or descending order based on one column, useful for quickly arranging lists or tables.
![23. Regular sort.png](https://365datascience.com/resources/flashcards/ogtowfp705-23-regular-sort.png)
Custom Sort
Organizing data based on specific criteria across multiple columns.
![24. Custom sort.png](https://365datascience.com/resources/flashcards/82jl0ujcvvf-24-custom-sort.png)
Data Validation
A tool to restrict data entry to certain types in specified cells.
![26. Data validation.png](https://365datascience.com/resources/flashcards/uwpxv4ynbh-26-data-validation.png)
Hyperlinks
Links in a cell that navigate to other documents or locations within the same document.
![27. Hyperlink.png](https://365datascience.com/resources/flashcards/6jxvlj5m4lc-27-hyperlink.png)
Naming Ranges
Assigning names to cell ranges for easy reference in formulas.
![28. Named ranges.png](https://365datascience.com/resources/flashcards/jok50qf1ik-28-named-ranges.png)
Conditional Formatting
Adjusting the display format of cell contents without changing the actual data.
![30. Conditional Formatting.png](https://365datascience.com/resources/flashcards/7flsohpb1iw-30-conditional-formatting.png)
Record Macros
Creating automated sequences of tasks to increase efficiency in repetitive tasks.
![31. Macros.png](https://365datascience.com/resources/flashcards/znmjyr5c4hh-31-macros.png)