Excel Basics
Define spreadsheet
A spreadsheet or worksheet is a file made of rows and columns that help sort data, arrange data easily, and calculate numerical data.
Define workbook.
Workbook - A workbook is a file that contains one or more worksheets. You can create a new workbook from a blank workbook or a template.Create a new workbook
What is a cell?
Cell – formed at the intersection of column and row.
Define formatting.
Formatting allows you to edit your data by adding font styles, border styles, background colours, lines, margins, highlighting cells and changing the number style and cell alignment.
List 2 groups of people who use spreadsheets
Accountants, Teachers, Salespeople, Scientists, Engineers
What is the ribbon?
Ribbon – contains tabs that appear horizontally and gives you quick access to features, functions, and commands.
What is the difference between a row and column
Rows run horizontally on spreadsheets and are identified by a row number to left side of the sheet.
Columns run vertically on spreadsheets and are identified by column header at the top of the sheet. Column headers are typically the letters of the alphabet in Excel.
List two types of number formats.
General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special, Custom
3 Examples of Spreadsheet Programs
View Buttons allow you to switch between Excel's various sheet views. What are they?
Explain what Merge Cells is.
Merging cells in a spreadsheet allows you to join one or more adjacent cells (horizontally or vertically or both) into one larger cell that is then displayed across multiple columns or rows.
What is conditional formatting?
Conditional formatting provides visual cues to help you quickly make sense of your data. It can show you highs and lows, greater than and less than, icons, or other data trends based on criteria you provide.