MGMT 2303: Review of Excel Fundamentals

Which of the following are characteristics of a label in an Excel spreadsheet?

A number, when used as a label, will have an apostrophe in front of it. A label is typically used to identify data in the spreadsheet. A label does not interact with other cells—cannot be used in a calculation.

When entering data into a cell in Excel, to add a line break within a cell, type ____

ALT + Enter

Methods of moving the contents of one cell in Excel to another cell?

Click on the cell to make it active, then on the Home tab, in the Clipboard group, select Cut. Then click on the destination cell and click Paste. Right-click on the cell to open the context menu. Then select Cut. Right-click on the destination cell and select Paste.

The shortcut to Save an Excel file is ____

Ctrl + S

Match the following pointers with their functions in Excel.

Cursor or Large cross----selects menu items or activates cells Fill-handle cross--------Autofills adjacent cells Row heading cross-------Resizes the row to the left

In the formula =IF(C1>5,"Yes","No"), what does it mean in plain language?

If the number in cell C1 is greater than 5, then type "Yes," if not type "No."

True statements regarding an active cell?

It will be identified by the Name Box. It can be identified by the heavy border around the cell. It is the cell where the user can input data.

Which of the following items are used to identify a cell in the cell's address?

Letter—Cell's column Number—Cell's row

Which of the following statements are correct regarding Excel's Save As option?

Save As allows you to choose where the file will be saved. Save As allows you to change the name of the file.

Which of the following are methods of selecting a range of adjoining cells in Excel?

Select the first cell in the range and drag down to the last cell. Select the first cell in the range then hold down the Shift key and select the last cell in the range.

To remove trailing blank spaces from imported data sets, one quick method is to use the ___ function.

TRIM

If you wish to view or manipulate your Excel spreadsheet when you are offline, you will need to load it onto your computer. Taking a file from the Internet and saving onto your computer's hard drive is called ________

downloading

If you wish to drag a value or label across your spreadsheet, use the ___ pointer.

large cross

Cell references can be relative, absolute, or mixed. Imagine that you have a cell with a date in it. If when you copy the cell using the fill handle, the date changes, then you know that the cell is a(n) ______ reference

relative

If you enter a formula and Excel returns an error value of #DIV!, this means that ____

the formula is dividing a value by zero and therefore cannot enter a result

If you receive an error value of #VALUE! after entering a formula in Excel, then this means that ______.

the operation or function is not possible

If you enter a formula in a cell and Excel returns a series of hashmark symbols (####), this means that _____

this is not an error value; it simply indicates that the cell's visible width cannot display the result

To save an iCloud Numbers file as an Excel file, you will need to click the View Numbers Tools icon at the top right of the screen. This icon is a circle with ______

three dots

By default, when you enter a number into a cell in Excel it jumps to the right of the cell. This tells you that Excel recognizes the entry as a(n) ___.

value