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
