Upgrade to remove ads
BUSI 520 Chapter 1: Applying Fundamental Excel Skills and Tools in Problem Solving
Terms in this set (50)
True or false: A quick way to apply the currency format is to press Ctrl+Shift+$.
Pressing Ctrl+Shift+# applies the number format.
The COUNTA function ignores cells with text
_____ is(are) first in the order of precedence rules
Operations in parentheses
In Excel, what keystroke combination quickly applies the number format to two decimal places?
Ctrl+Shift+! (Ctrl, Shift and exclamation mark)
The error message ###### means that there is(are)
insufficient width in cell to display data, or negative date/time.
Error Message: Unrecognized text in a formula?
Error Message: No answer?
Error Message: Invalid cell reference?
Error Message: Wrong argument type or operand?
Error Message: Invalid numeric values in a formula or function?
Error Message: Division by zero?
The Accounting Format inserts a dollar sign directly in front of (and flush against) the leftmost number in the cell, like this: $1.00
Using cell references is preferable to directly inputting values into a formula.
When using Excel to open a file that is in .csv format, formulas and formatting entered in the sheet can be safely saved in either .csv, .xls or .xlsx format.
COUNT(number1, number 2, ...) determines the sum of a list of values.
In order to maintain consistency within your workbooks, it is important to format cells with formulas (outputs) using the same colors as cells containing assumptions and/or values (inputs).
B1 is an example of a(n) _____ cell reference.
The error message #NAME? means that there is(are)
unrecognized text in a formula.
_____ is(are) last in the order of precedence rules.
Addition and subtraction from left to right
If A1=2, then the resulting value of =3+5*A1 is
If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is
#REF! means invalid numerical values in a formula or function.
$B1 is an example of a(n) _____ reference.
In Excel, what keystroke combination quickly removes a border from the selected cell or range?
Ctrl+Shift+_ (Ctrl, Shift and underscore)
If A1=2, the resulting value of =3*A1^3 is
In Excel, what keystroke combination moves (the active cell) right, to the end of the current row of contiguous (adjacent) cells with values?
In Excel, what keystroke combination closes the current workbook?
Ctrl+F4 and Ctrl+w
If the formula =$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the resulting formula?
In Excel, what keystroke combination shows the format cells dialog window?
Ctrl+1 (Ctrl and 1)
In Excel, what keystroke combination switches (the active worksheet) to the next worksheet (to the right)?
In Excel, what keystroke combination selects right, to the end of the current row of contiguous (adjacent) cells?
In Excel, what keystroke combination selects the current row?
In Excel, what keystroke combination quickly inserts the current time?
Ctrl+Shift+: (Ctrl, Shift and colon)
In Excel, what keystroke combination moves one screen to the right within the current worksheet?
In Excel, what keystroke combination quickly applies a border around the selected cell or range?
Ctrl+Shift+& (Ctrl, Shift and ampersand)
If multiple cells are selected/highlighted, what keystroke combination copies the formula(s)/value(s) in the topmost cell(s) of the selected range down to the other cell(s) in the range of selected cells?
In Excel, what keystroke combination quickly inserts the current date?
Ctrl+; (Ctrl and semi-colon)
In Excel, after having copied something, what keystroke combination quickly performs a Paste Special operation?
What keystroke combination switches between currently open workbooks?
In Excel, what keystroke combination selects the current column?
In Excel, what keystroke combination changes the cell reference type (to absolute, mixed, mixed, relative) while entering/editing a formula?
A quick way to apply the percent format is to press Ctrl+Shift+%.
In Excel, what keystroke combination quickly applies the General format?
Ctrl+Shift+~ (Ctrl, Shift and tilde)
If multiple horizontal cells are selected/highlighted, what keystroke combination copies the formula(s)/value(s) in the leftmost cell(s) of the selected range to the right, to the other cells in the range of selected cells?
In Excel, what keystroke combination inserts cells?
You should always adjust column widths first, before attempting to Wrap Text for the column headings.
The wrong argument type or operand is shown by
In Excel, what keystroke combination toggles between displaying formulas and displaying values?
Ctrl+` (Ctrl and left quote(grave accent))
In Excel, after selecting a range of cells, what keystroke combination deletes those cells? (not just deletes the contents of cells, but deletes the actual cells, so that other cells adjust to replace the deleted cells)
THIS SET IS OFTEN IN FOLDERS WITH...
BUSI 520 Final
busi 520 final
BUSI 520 Chapter 1
BUSI 520 Ch 2
YOU MIGHT ALSO LIKE...
BUSI 520 Chapter 1
Excel Ch 1 Key Terms
Chapter 1 Keyboard Shortcuts
Excel Chapter 1
OTHER SETS BY THIS CREATOR
BUSI 405 Final Exam
BUSI 404 Final 2
BUSI 404 final 1
Busi 404 Final