Microsoft Excel Basics 4

To reference only one specific cell, do you only have to use the absolute reference symbol on the column (letter)? Or the row (number)? Or both?

BOTH

What does the COUNT Function count?

Cells with numbers.

True or false: An Excel function is a built-in or pre-defined formula that runs specific calculations. For the Excel function to work, you need to follow the correct syntax by providing it with values in the order it understands.

True. A function follows a specific rule or syntax. Then I can provide data the function understands.

In Excel, what is a cell?

A cell is described by the intersection of COLUMNS (indicated with letters), and ROWS (indicated with numbers). An active cell has a border.

What is a workbook?

A workbook is a file that can contain up to 255 worksheets, also known as spreadsheets, to help organize data. Worksheets are made up of cells that are organized into rows and columns, where users can enter and calculate data. Businesses often use workbooks instead of individual spreadsheets to organize data.

What is a worksheet?

A worksheet, also known as a spreadsheet, is a collection of cells in Excel that are organized into rows and columns. It's the working surface where you can enter and calculate data, sort and analyze raw data, and organize information. Each worksheet has 1,048,576 rows and 16,384 columns, starting with row 1 and column A.

What are different ways to enter data (text and numbers)?

After you type text into a cell, you hit the Enter key so Excel accepts your data entry. You can also use the tab key (to move right) or the arrow keys (to move up/down/left/right) and Excel will accept your entry. 1. Enter key 2. Tab key 3. Arrow key

What does every formula have to start with?

An equals sign: =

What does the COUNTBLANK function count?

Cells that are blank.

What does the COUNTA function count?

Cells with text or numbers.

What are two options to add a header or footer?

Click the "Page Layout" view on the Status Bar on the bottom right of the page (middle icon) Or Navigate to: Page Layout (Tab) > Sheet Options (Group) > click on the dialog box icon in the bottom right corner of the group > Page Setup dialog box pops up > Header/Footer (tab) > Custom Header or Custom Footer.

True or FALSE: An Excel workbook can contain only one worksheet?

False. A workbook can contain one or more worksheets.

What are two formulas you could use to sum the numbers 1 and 2?

First formula: = 1+2 (operation with a + sign) Second formula =sum(1,2) (operation with the sum function)

What is the path to the function library?

Formulas (Tab)>Function Library (group)

What is Goal Seek? It is also called, What-If Analysis.

It is a function that begins with the end in mind. If we know the price of an item, with goal seek we can find out how many items we need to sell to reach a dollar amount goal.

How do we print a large worksheet with repeating rows or repeating columns?

Navigate to Page Layout (Tab) > Page Setup (Group) > click on the dialog box icon in the bottom right corner of the group > Page Setup dialog box > Sheet (Tab) > select the "Rows to repeat at top:" and "Columns to repeat at left:"

True or false: To change data in a cell, you have to delete all the data and start over.

No. False. Just start typing in a cell and the previous data is deleted while the new data is accepted.

An absolute cell reference means that no matter where other formulas may be, they will always reference only one specific cell wherever that cell may be in your Excel file. What symbol do you use to make an absolute reference?

THE DOLLAR SIGN: $

What is the path to format cells by using a 3-color scale? Hint: Conditional Formatting

The path on the Ribbon: Home (Tab) > Styles (Group) > click the drop-down arrow next to Conditional Formatting > click Color Scales > click More Rules > under Edit the Rule Description, select 3-color scale.

What is the path on the ribbon to create a chart?

To insert a chart, navigate: INSERT (Tab) > CHARTS (Group)

True or False - When you start with an "=" equal sign in a cell, it means that Excel will do a mathematical operation of some type, or reference other cells or locations.

True.

True or false: After selecting your data range, using the shortcut key ALT-F1 inserts a column chart. The default chart is a column chart.

True.

True or false: You can insert a chart on a separate worksheet called the "Chart Sheet".

True. Note: keeping your chart in the same worksheet as your data until you're finished with the chart, then moving the chart to another worksheet is a best practice

True or false: The "Print Preview & Print" icon is in the Quick Access Toolbar.

True. We can also use the shortcut Ctrl + P to also access the Print Preview and Print.

Can Excel worksheets reference each other in formulas?

YES.