Excel Basics Quiz

Excel Spreadsheet Software

• Microsoft Excel is a spreadsheet program in the Microsoft Office suite.
• It is used for numeric calculations and data analysis.
• Spreadsheet files are called workbooks, containing worksheets.
• Workbook file extension is .xlsx.

Excel Capabilities

• Data entry: Quick and accurate data input.
• Data recalculation: Easy recalculation of data.
• What-if analysis: Performing analysis under different scenarios.
• Data presentation: Changing presentation of information
• Chart creation: Generating charts from data.
• Information sharing: Sharing data with others.
• Building on previous work: Continuing work from previous sessions.
• Quick analysis tools: Visually-appealing data representation.
• Templates: Using predefined, formatted files for new worksheets.

Excel Window Components

• Name box: Displays active cell address.
• Formula bar: Entering and editing worksheet data.
• Worksheet window: Grid of columns and rows, labeled alphabetically (columns) numerically(rows).
• Worksheet size: 1,048,576 rows and 16,384 columns.
• Cell: Intersection of a column and row.
• Active cell: Cell outlined by a dark rectangle.
• Other elements: Sheet tabs (for switching between sheets), scroll bars, status bar, mode indicator, new sheet button, etc.

Formulas in Excel

• Formulas are equations in a worksheet.
• Begin with the '=' symbol.
• Use cell references, not values.
• Important for calculation accuracy and reference use.
• Operators in formulas: +, -, *, /, %, ^(caret).
• Functions: Predefined calculations.
• Function arguments: Info used in functions to derive answers.

Entering and Editing Formulas

• Formulas in Excel worksheet begin with the '=' sign.
• Calculation operators determine the type of calculation.
• Operations Include: Arithmetic, Comparison, Text Concatenation, and Reference operators.

Worksheet Views

• Normal view: Displays in default format.
• Page Layout view: Represents how worksheets appear when printed.
• Page Break View: Shows pages as they would print with page break indicators.
• Printing features are also available.
• Sheet tabs and scrolling buttons: Navigating between sheets within the current workbook.

Relative and Absolute Cell References

• Relative cell references: Change when copied or moved.
• Absolute cell references: Don't change when copied or moved, '$' symbol before column letter and row number.
• Copying formulas using F4 to change/add/replace $ signs

Functions in Excel

• Predefined formulas to perform calculations.
• Organized by category (e.g., financial, date/time, statistical).
• Begin with the '=' symbol.
• Autocomplete helps with function input.
• Arguments: Information function needs to calculate.

Copying and Moving Data

• Cut, copy, and paste buttons: Copy and move data.
• Fill handle: Auto-fill data in range of cells.
• Drag-and-drop function: Copy or move data and cells.

Rounding Numbers

• Rounding function used to specify decimal places.
• Zero denotes removing decimal places.

Formatting in Excel

• Formatting affects data appearance, not actual data values.
• Changes font, font sizes.
• Adjusting column widths: Adjusting column to accommodate largest text entry.
• Using auto-fit button to adjust column widths.
• Conditional formatting: Modifying data's presentation based on its values/rules.

Rename/Move Worksheets

• Renaming and color-coding worksheets.
• Deleting worksheets.

Charts in Excel

• Chart sheets: Sheets containing charts linked to workbook data.
• Embedded/separate charts.
• Using Quick Analysis or Insert to create charts.
• Changing chart design/elements such as titles, legends, grid lines, and other settings.

Chart Types

• Combo: Displays different chart types together.
• Pie: Compares proportions.
• Area: Compares trends over time.
• Column: Compares using columns.
• Line: Comparing trends over time.