Excel 2019 for Beginners Week 2

Podcast Beta

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What types of data can a single Excel cell hold?

Numeric, graph, formula, and text

Text, formula, image, and numeric

Numeric, text, formula, and error (correct)

Numeric, text, table, and formula

What should you enter in a cell to ensure the number 12 can be used in calculations?

'12 Employees'

12 in one cell and 'Employees' in the next (correct)

12 with an asterisk to indicate it's numeric

12 Employees in a single cell

Which function of formulas is essential for a spreadsheet?

They allow for dynamic calculations based on cell values. (correct)

They restrict data entry to numeric values only.

They convert text entries into numeric formats.

They provide formatting options for cells.

What does text in an Excel worksheet provide?

Clarification about numeric values in the worksheet. Signup and view all the answers

If you enter a value that starts with a number, how does Excel treat it?

As a text entry. Signup and view all the answers

Which of the following best describes numeric values in Excel?

They include dates and times as valid entries. Signup and view all the answers

What layer do charts and pictures reside on in an Excel worksheet?

The drawing layer Signup and view all the answers

What occurs when you position the mouse pointer on a window's border?

The mouse pointer changes to a double arrow. Signup and view all the answers

To simultaneously resize a window both horizontally and vertically, you should click and drag:

Any of the corners of the window. Signup and view all the answers

What is the purpose of entering a formula into a cell in Excel?

To perform calculations and return results dynamically. Signup and view all the answers

Which command would you use to arrange all visible workbook windows in Excel?

View ➪ Window ➪ Arrange All. Signup and view all the answers

What happens to minimized windows when executing the Arrange All command?

They are excluded from the arrangement. Signup and view all the answers

How can you make a different workbook window active if your current window is maximized?

Select it from the taskbar. Signup and view all the answers

Which of the following methods does NOT allow you to switch among workbook windows?

Clicking a window if it's hidden behind the current window. Signup and view all the answers

Why might someone prefer to work with maximized workbook windows?

To avoid distractions from other windows. Signup and view all the answers

What is one advantage of displaying two workbook windows side by side?

To facilitate comparison of information. Signup and view all the answers

What happens when you press Shift+F11 while working in Excel?

A new sheet is added before the active sheet. Signup and view all the answers

What is the effect of double-clicking the bottom border of a row in Excel?

It sets the row height to the tallest entry in the row. Signup and view all the answers

What should you choose to automatically adjust the row height in Excel?

Home ➪ Cells ➪ Format ➪ AutoFit Row Height Signup and view all the answers

Which command allows you to delete a worksheet in Excel?

Home ➪ Cells ➪ Delete ➪ Delete Sheet Signup and view all the answers

How can you change the name of a worksheet in Excel?

Double-click the sheet tab Signup and view all the answers

If a row is hidden in Excel, what is true about its height?

The height is set to zero. Signup and view all the answers

What is the maximum number of characters allowed in a worksheet name in Excel?

31 characters Signup and view all the answers

How can you select a hidden column to unhide it in Excel?

By pressing F5 and selecting a cell within the hidden column. Signup and view all the answers

Which of the following characters cannot be used in a worksheet name in Excel?

/ Signup and view all the answers

What happens when you hide a column in Excel?

The column's width is set to zero. Signup and view all the answers

Which method will NOT change the name of a worksheet?

Drag the sheet tab to another location Signup and view all the answers

Which method allows you to hide rows in Excel?

Select the row header, then click on Hide from the shortcut menu. Signup and view all the answers

When using navigation keys in Excel, what is true about hidden rows or columns?

The active cell skips over cells in hidden rows or columns. Signup and view all the answers

How can you color-code worksheet tabs in Excel?

Right-click the sheet tab and select Tab Color Signup and view all the answers

What effect does using longer worksheet names have in Excel?

Reduces the number of sheets visible without scrolling Signup and view all the answers

What should you do to make a hidden row visible again?

Right-click the row header and choose Unhide. Signup and view all the answers

What happens when you press Enter after entering data in a cell by default?

It moves the selection to the next cell down. Signup and view all the answers

How can you change the default direction in which the selection moves after pressing Enter?

Modify settings in the Advanced Options menu. Signup and view all the answers

If a range of cells is selected, what happens when you press Enter?

It moves to the next cell in the selection. Signup and view all the answers

What shortcut allows you to enter the same data into multiple cells at once?

Ctrl+Enter Signup and view all the answers

How can you navigate backward through a selection of cells?

Press Shift+Enter. Signup and view all the answers

What key do you press to switch from Enter mode to Edit mode?

F2 Signup and view all the answers

What is the function of the Tab key when entering data in Excel?

It moves the selection to the next cell in the row. Signup and view all the answers

What occurs if you want to edit text in Enter mode when you realize there's a mistake?

You can switch to Edit mode by pressing F2. Signup and view all the answers

Entering a numeric value in Excel requires selecting a cell, typing the value, and pressing the Enter key.

True Signup and view all the answers

Excel allows a single cell to hold a maximum of about 20,000 characters.

False Signup and view all the answers

If a cell contains text that exceeds its column width and adjacent cells are not blank, the full text will be displayed.

False Signup and view all the answers

To make text in a cell wrap to multiple lines in Excel, you need to select Home ➪ Alignment ➪ Wrap Text.

True Signup and view all the answers

When entering a negative number in Excel, you can only use a minus sign before the number.

False Signup and view all the answers

If a long text string is entered into a cell adjacent to another nonblank cell, Excel will display all characters regardless of the column's width.

False Signup and view all the answers

To increase the width of a column in Excel, you can drag the border in the column letter display area.

True Signup and view all the answers

You cannot include currency symbols when entering values into an Excel cell.

False Signup and view all the answers

The Accounting format in Excel always displays negative numbers with a minus sign.

False Signup and view all the answers

The Custom format in Excel allows users to define number formats that exist in other categories.

False Signup and view all the answers

When the series of hash marks (#########) appears in a cell, making the column wider typically resolves the issue.

True Signup and view all the answers

The Currency format can only display negative values with a minus sign.

False Signup and view all the answers

The Percentage format in Excel allows you to choose the number of decimal places to display.

True Signup and view all the answers

The Scientific format in Excel displays numbers always in decimal notation without any exponent.

False Signup and view all the answers

Excel allows users to specify a currency symbol only in the General format.

False Signup and view all the answers

The Special format in Excel provides additional formats like Social Security Number and Phone Number in the U.S. version.

True Signup and view all the answers

Pressing Shift+F11 adds a new sheet after the active sheet.

False Signup and view all the answers

You can delete a worksheet by activating it and choosing Home ➪ Cells ➪ Delete ➪ Delete Sheet.

True Signup and view all the answers

To change a sheet's name, you can only double-click the sheet tab.

False Signup and view all the answers

A worksheet name in Excel can be a maximum of 31 characters long.

True Signup and view all the answers

Excel allows slashes (/) to be used in worksheet names.

False Signup and view all the answers

You can right-click a sheet tab, choose Insert to add a new worksheet before the active sheet.

True Signup and view all the answers

Longer worksheet names cause the tabs to appear narrower on the screen.

False Signup and view all the answers

You can use the colon (:) character in a worksheet name in Excel.

False Signup and view all the answers

Excel's AutoComplete feature works only within a non-contiguous column of cells.

False Signup and view all the answers

When you enter the word 'canister' below another cell containing 'can', Excel attempts to AutoComplete the entry to 'canister'.

True Signup and view all the answers

Pressing Alt+Enter forces Excel to display text in multiple lines within the same cell.

True Signup and view all the answers

AutoComplete changes the case of letters in your entries to ensure consistency.

True Signup and view all the answers

Turning off the AutoComplete feature can be done from the Formatting tab in Excel Options.

False Signup and view all the answers

If you type 'widgets' in a cell and then try to enter 'Widgets' in another, Excel will not change the case automatically.

False Signup and view all the answers

Using the Delete key after typing part of the AutoComplete suggestion can override the suggestion.

True Signup and view all the answers

Excel does not provide any way to control line breaks when wrapping text automatically.

False Signup and view all the answers

To insert multiple rows, you must click the column letters in the worksheet border.

False Signup and view all the answers

Excel allows you to shift existing cells when inserting new cells.

True Signup and view all the answers

To delete a row in Excel, you can right-click the selected row number and choose Delete.

True Signup and view all the answers

You can only undo a row deletion in Excel by selecting Undo from the menu.

False Signup and view all the answers

To insert a new column, you can choose Home ➪ Cells ➪ Add ➪ Insert Sheet Columns.

False Signup and view all the answers

Selecting multiple cells in a row leads Excel to insert columns corresponding to the selected cells.

False Signup and view all the answers

Excel displays a dialog box when inserting cells to let you choose the direction to shift.

True Signup and view all the answers

Partial rows or columns cannot be inserted in Excel using the Insert dialog box.

False Signup and view all the answers

Study Notes

Excel Data Types

Excel worksheets can contain over 17 billion cells, each capable of holding one of four data types: numeric values, text, formulas, or errors.
Objects such as charts, diagrams, and pictures exist on a worksheet’s drawing layer, not in cells.

Numeric Values

Numeric values represent quantities like sales, employee count, dates (e.g., Feb 26, 2019), or times (e.g., 3:24 AM).

Text Entries

Text can serve various purposes: as data (e.g., employee names), labels, column headings, or instructions.
Text that begins with a number is treated as text and cannot be used in calculations (e.g., "12 Employees" is text, not a numeric value).

Formulas

Formulas are fundamental in Excel for calculations, automatically updating results if referenced cells change.
They can be simple mathematical expressions or utilize built-in functions.

Data Entry Techniques

Enter Key Behavior: Default setting moves selection to the next cell down after pressing Enter, configurable via File ➪ Options ➪ Advanced.
Selecting Cell Ranges: Selecting multiple cells allows pressing Enter to cycle through the selection.
Ctrl+Enter: This shortcut places the same data in multiple selected cells.
F2 Key: Switches between Enter mode (to input data) and Edit mode (to modify existing content).

Window Management

Active workbook windows accept input; click or use Ctrl+Tab to switch between open windows.
Arranging Windows: Utilize View ➪ Window ➪ Arrange All for organized visibility.

Adding and Deleting Worksheets

New worksheets can be created quickly using the New Sheet control, Shift+F11, or right-clicking on tabs.
Delete unwanted worksheets by right-clicking the sheet tab or using Home ➪ Cells ➪ Delete ➪ Delete Sheet.

Renaming Worksheets

Rename sheets through Home ➪ Cells ➪ Format ➪ Rename Sheet, double-clicking the tab, or right-clicking and selecting Rename.
Sheet names can be up to 31 characters and must avoid specific characters (e.g., /, , :, *, ?).

Changing Sheet Tab Colors

Customize worksheet tabs by changing their background color for easier identification.

Row and Column Management

AutoFit Row Height: Adjust row height automatically to fit the tallest entry using double-click on row border or Home ➪ Cells ➪ Format ➪ AutoFit Row Height.
Hiding Rows and Columns: Useful for concealing information; select and right-click to choose Hide, or use Home ➪ Cells ➪ Format ➪ Hide & Unhide.
Unhiding: Can be done by adjusting the width of hidden columns or height of hidden rows, or selecting a cell within them and using unhide options.

Miscellaneous Tips

When deleting a sheet that contains data, Excel prompts for confirmation.
Descriptive sheet names and color coding can enhance workbook organization and navigability.

Excel Worksheet Basics

An Excel worksheet can contain text, values, and formulas for data manipulation.
Values in the worksheet, especially for loan calculations, can be found in specified cells; text is typically in column A and numerical values/formulas in column B.

Entering Data into Cells

Data entry is intuitive; click the cell, type the value or text, and press Enter, Tab, or navigate with arrow keys.
Numeric values can include decimals, currency symbols, signs, and commas; negative numbers are indicated with a minus sign or parentheses.

Text Entry and Formatting

Cells can hold approximately 32,000 characters but may not display all due to width constraints; use adjustments to view full text.
Options for displaying long text:
- Edit to shorten content.
- Adjust column width manually by dragging the border.
- Opt for a smaller font size.
- Activate text wrapping using Home ➪ Alignment ➪ Wrap Text.

AutoComplete Feature

AutoComplete streamlines text entry by suggesting completions for recurring terms, ensuring accuracy and consistency.
It recognizes previous entries; e.g., typing "Widgets" will prompt AutoComplete for subsequent entries.
AutoComplete works only in contiguous cells and may be disabled in Excel options if distracting.

Manual Line Breaks

To insert a new line within a single cell, press Alt+Enter, which allows for manual breaks and activates text wrapping.

Number Formatting Options

Excel offers more than just general formatting; users can choose specific categories such as Currency, Accounting, Date, Time, Percentage, and others.
Each format allows for customization, including decimal places and display of negative numbers.

Adding and Deleting Worksheets

New worksheets can be added using various methods:
- Click the New Sheet control (plus icon) next to sheet tabs.
- Use keyboard shortcut Shift+F11.
- Insert via the Ribbon or context menu.
To delete a worksheet:
- Right-click the sheet tab and select Delete.
- Use the Home Ribbon to delete selected sheets.

Renaming Worksheets

Default worksheet names can be changed for better organization through:
- Ribbon options for renaming.
- Double-clicking the sheet tab.
- Right-clicking the sheet tab for rename options.
Names can contain up to 31 characters, including spaces, but certain symbols are prohibited.

Color-Coding Worksheets

Users can change tab colors for easier identification of worksheet purposes.

Inserting and Deleting Rows/Columns

Inserting rows:
- Select the row or rows, right-click, and choose Insert.
- Use the Ribbon for inserting rows relative to the active cell.
Inserting columns follows similar procedures.

Deleting Rows/Columns

To delete, select the row or column, right-click, and choose Delete.
Multiple selections will delete all rows/columns in the selection.
Use Ctrl+Z to undo accidental deletions.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

In Week 2 of Excel 2019 for Beginners, you will explore various types of data, how to enter text, values, dates, and times into your worksheets. Additionally, you'll learn to modify and edit information, use number formats, and gain a foundational understanding of Excel worksheet basics. This session is designed to enhance your skill set and improve your efficiency with Excel.