Busi 520 Quiz 1

B1 is an example of a ___ cell reference

relative

(T/F) The accounting format inserts a dollar sign directly infront of and flushed against the left most number in the cell. ——$1.00

False, this is currency

In Excel, what keystroke inserts the current time?

Ctrl+Shift+ : (colon)

If multiple horiz cells are selected, what keystroke copies the formulas of the leftmost cell in the range of selected cells?

Ctrl+R

In Excel, what keystroke combination quickly removes a border from the selected cell or range?

Ctrl+Shift+_

To quickly show/hide the Home Ribbon use what keystroke combination?

Shift+F1 (or Shift+Fn+F1)

Alt+F1 (or Alt+Fn+F1)

Ctrl+F1 (or Ctrl+Fn+F1)

F1 (or Fn+F1)

None of the answers listed

CTRL + F1

Cells formatted with the Number Format (Ctrl+Shift+!) can be aligned within a cell using the following formats:

Center aligned

Any/all of choices listed

Left aligned

Right aligned

Any/all of choices listed

In Excel, what keystroke combination quickly applies the number format to two decimal places, with comma separator for thousands?

Ctrl+Shift+# (Ctrl, Shift and number sign)

Ctrl+Shift+@ (Ctrl, Shift and "at" symbol)

Ctrl+Shift+~ (Ctrl, Shift and tilde)

None of the answers listed.

Ctrl+Shift+! (Ctrl, Shift and exclamation mark)

Ctrl+Shift+! (Ctrl, Shift and exclamation mark)

What keystroke combination switches between currently open workbooks?

Ctrl+tab

Ctrl+Pg dn

Ctrl+F4

Alt+Pg dn

None of the answers listed.

Ctrl + Tab

_____ is(are) first in the order of precedence rules.

Multiplication and division from left to right

Operations in parentheses

None of the answers listed.

Addition and subtraction from left to right

Exponentiation

Operations in parentheses

(T/F) The formula = COUNT(number1, number 2, ...) determines the sum of a list of values.

False

In Excel, what keystroke combination quickly inserts the current date?

Ctrl+Shift+# (Ctrl, Shift and number sign)

Ctrl+Shift+: (Ctrl, Shift and colon)

Ctrl+Shift+@ (Ctrl, Shift and "at" symbol)

Ctrl+; (Ctrl and semi-colon)

None of the answers listed.

Ctrl + ;

In Excel, what keystroke combination closes the current workbook?

Ctrl+F4

Two of the answers listed.

None of the answers listed.

Ctrl+w

F4

Ctrl + w and Ctrl F4

In Excel, what keystroke combination selects right, to the end of the current row of contiguous (adjacent) cells?

Ctrl+Shift+right arrow

None of the answers listed.

Shift+End

Shift+right arrow

Ctrl+Shift+end

ctrl + shift + right arrow

(T/F) The Accounting Format inserts a dollar sign directly in front of (and flush against) the leftmost number in the cell, like this:          $1.00

False

In Excel, what keystroke combination switches (the active worksheet) to the next worksheet (to the right)?

Ctrl+Pg dn (or Ctrl+Fn+Pg dn)

In Excel, what keystroke combination quickly applies a border around the selected cell or range?

ctrl + shift + & (ampersand)

In Excel, what keystroke combination quickly inserts the current time?

Ctrl+; (Ctrl and semi-colon)

Ctrl+Shift+: (Ctrl, Shift and colon)

Ctrl+Shift+# (Ctrl, Shift and number sign)

Ctrl+Shift+@ (Ctrl, Shift and "at" symbol)

None of the answers listed.

Ctrl+Shift+: (Ctrl, Shift and colon)

In Excel, what keystroke combination shows the format cells dialog window?

Ctrl+` (Ctrl and left quote (grave accent))

Ctrl+1 (Ctrl and 1)

None of the answers listed.

Ctrl+Shift+~ (Ctrl, Shift and tilde)

Ctrl+Shift+! (Ctrl, Shift and exclamation mark)

ctrl + 1

Cells formatted with Accounting format can be aligned within a cell using the following formats:

Left aligned

Right aligned

Center aligned

Any/all of choices listed

right aligned

In Excel, what keystroke combination selects the current row?

Shift + space

In Excel, after having copied something, what keystroke combination performs a normal Paste operation?

Ctrl+z

Ctrl+p

Ctrl+c

Ctrl+x

None of the answers listed.

ctrl + v

After summing cell to calculate total income, an error message of ########## is shown in one of your cells.  What does this indicate?

the cell width is too small to display the contents

none of the answers listed

an incorrect number

an incorrect position

an incorrect formula

the cell width is too small to display the contents

In the Windows version of Excel, the quickest way to left align data within the current cell is to use what keystroke combination?

Ctrl+Shift+L

Alt h, a, c

Alt h, a, l

None of the answers listed

Ctrl+Shift+C

Alt h, a, l

In Excel, what keystroke combination moves one screen to the right within the current worksheet?

Ctrl+Pg dn

Ctrl+tab

Alt+Pg dn

Shift+Pg dn

None of the answers listed.

Ctrl (+ fn) +pg down

(T/F) The COUNTA function ignores cells with text

True

False

False (COUNTA counts all non-empty cells, including cells containing text, numbers, dates, etc.)

(T/F) The best way to open a data file saved as a text file (*.txt) is to use the "Get & Transform Data" features in the Data ribbon.

True

False

False

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?

Ctrl+down arrow

None of the answers listed

Ctrl+Shift+down arrow

Ctrl+Shift+d

Ctrl+d

Ctrl+d

(T/F) Always adjust column widths first, before attempting to Wrap Text for the column headings.

True

False

False

(T/F) The best way to center titles is to use Merge & Center.

True

False

False. Center Across Selection is generally better than Merge & Center because merging cells can cause issues with sorting, filtering, and selecting ranges.

In Excel, what keystroke combination selects the current column?

None of the answers listed.

Ctrl+space

Alt+enter

Alt+space

Shift+space

ctrl+space

To quickly toggle Wrap Text use what keystroke combination?

Ctrl+w

Ctrl+Shift+W

Alt w

Alt h, w

alt, h, w

Cells formatted with the default Comma Style (Alt h, k) can be aligned within a cell using the following formats:

Right aligned

Center aligned

Left aligned

Any/all of choices listed

Right aligned

In Excel, what keystroke combination jumps (changes the active cell) to the right, to the end of the current row of contiguous (adjacent) cells with values?

Alt+right arrow

Alt+end

Ctrl+end

Ctrl+right arrow

None of the answers listed.

Ctrl+right arrow

The error message #NAME? means that there is(are)

invalid numerical values in a formula or function.

unrecognized text in a formula.

an invalid cell reference.

None of the answers listed.

a wrong argument type or operand.

unrecognized text in a formula.

To quickly insert a new function or open the Function Arguments window for a currently entered function, use what keystroke combination?

Shift+F3 (or Shift+Fn+F3)

Ctrl+F3 (or Ctrl+Fn+F3)

None of the answers listed

Alt+F3 (or Alt+Fn+F3)

F3 (or Fn+F3)

Shift+F3 (or Shift+Fn+F3)

_____ is(are) last in the order of precedence rules.

Exponentiation

Multiplication and division

Addition and subtraction

None of the answers listed.

Operations in parentheses

Addition and subtraction

It is okay to send your assignment file to someone else in order to help the person understand a particular topic.

True

False

False

In Excel, what keystroke combination quickly applies the General format?

Ctrl+Shift+~ (Ctrl, Shift and tilde)

Ctrl+Shift+@ (Ctrl, Shift and "at" symbol)

Ctrl+Shift+# (Ctrl, Shift and number sign)

None of the answers listed.

Ctrl+Shift+! (Ctrl, Shift and exclamation mark)

Ctrl+Shift+~ (Ctrl, Shift and tilde)

If the formula =$B$4-SUM(A1:A5) is copied from cell A9 to cell C10, what is the resulting formula?

None of the answers listed.

=$B$5-SUM(A2:A6)

=$B$4-SUM(C2:C6)

=$B$4-SUM(A2:A6)

=$B$4-SUM(C2:C5)

=$B$4-SUM(C2:C6)

In Excel, what keystroke combination performs an "undo" of the last action?

None of the answers listed.

Ctrl+u

Ctrl+v

Ctrl+z

Ctrl+x

Ctrl+z

In Excel, after having copied a cell, what keystroke combination opens the Paste Special dialog box?

Ctrl+v

Ctrl+Shift+p

Ctrl+Shift+v

None of the answers listed.

Ctrl+Alt+v

Ctrl+Alt+v

In Excel, what keystroke combination inserts cells?

Ctrl+Shift+insert

Ctrl+Shift+plus

Ctrl+i

None of the answers listed.

Ctrl+insert

Ctrl+Shift+plus

A quick way to apply the currency format is to press Ctrl+Shift+$.

True

False

True

If A1=2, the resulting value of =3*A1^3 is

None of the answers listed.

18

24

12

9

24

What Excel keystroke combination would you use to quickly format cells BELOW a top row cell formatted with the accounting format?

Ctrl+Shift+!

Ctrl+Shift+$

Alt 4 (or Alt+4 or Alt, 4)

Alt h, k

Alt h, k

Using cell references is preferable to directly inputting values into a formula.

True

False

True

In Excel, what keystroke combination shows the format cells dialog window?

Ctrl+Shift+~ (Ctrl, Shift and tilde)

Ctrl+` (Ctrl and left quote (grave accent))

None of the answers listed.

Ctrl+1 (Ctrl and 1)

Ctrl+Shift+! (Ctrl, Shift and exclamation mark)

Ctrl+1 (Ctrl and 1)

By changing the Error Checking Rules, you can specify that Excel will alert you about the following:  _____.

All of the answers listed.

Formulas which omit cells in a region

Unlocked cells containing formulas

Cells containing years represented as 2 digits

All of the answers listed

To display the formulas on the worksheet, press_____.

Alt + `  (Alt + Left quote)

Ctrl + End

Alt + ! (Alt + Exclamation)

Ctrl + `  (Ctrl + Left quote)

Ctrl + `  (Ctrl + Left quote)

To automate repetitive or difficult tasks, use a _____, which is a series of commands that you store and then run when you need to perform a task.

formula

comment

function

macro

macro

A(n) _____ cell contains a value that is used in a formula.

dependent

precedent

independent

active

precedent

In Excel, after having copied a cell, what keystroke combination opens the Paste Special dialog box?

Ctrl+Shift+v

None of the answers listed.

Ctrl+Alt+v

Ctrl+v

Ctrl+Shift+p

Ctrl+Alt+v

_____ prevents inserting, deleting, or renaming worksheets.

Workbook protection

File protection

Data validation

Worksheet protection

Workbook protection

The data validation tool restricts the _____.

neither data already stored in the worksheet nor data being entered

data already stored in the worksheet

both data already stored in the worksheet AND data being entered

data being entered

data being entered

Use the _____ button on the Formula Auditing toolbar to keep track of cell properties such as name, value, and formula, even if the cell is out of view.

Circle Invalid Data

Trace Error

Evaluate Formula

Watch Window

Watch Window

The data validation default "Allow" option is _____.

whole number

any value

list

custom

Any value

_____ prevents changing, moving, or deleting data.

File protection

Worksheet protection

Workbook protection

Data validation

Worksheet protection

Use the _____ button on the Formula Auditing toolbar to display tracer arrows that indicate which cells the formula references.

Trace Precedents

Error Checking

Trace Errors

Trace Dependents

Trace Precedents

When renaming a module, a module cannot use the same name as a macro.

True

False

True

The data validation tool restricts data being entered and the data already stored in the worksheet.

True

False

False

A validation rule can specify _____.

dates

All of the answers listed.

values, such as those between 1 and 100

decimal numbers

All of the answers listed

The name of a macro can contain letters, numbers, spaces, and the underscore symbol.

True

False

False

Macro viruses are viruses that are written and stored as macros attached to documents created in Office programs such as Excel, and run when you open the infected document.

True

False

True

A macro can be tested one step at a time by clicking the _____ button in the Macro dialog box.

Options

Test

Run

Step Into

Step into

A _____ specifies the type of data that is appropriate/allowed as content in a cell (...for example, whole numbers, decimal numbers, dates, time, or text).

scenario

formula

validation rule

macro

Validation rule

When a worksheet is protected, by default, all cells in the worksheet are unlocked.

True

False

False

To unlock cells in a protected workbook, click the Locked box to remove the check mark on the Protection tab of the __________.

Data Validation menu/window

Outline Settings menu/window

Record Macro menu/window

Format Cells menu/window

Format Cells menu/window

By choosing Protect Sheet, you can prevent a worksheet from being deleted from a workbook.

True

False

False

In Excel, what keystroke combination quickly inserts the current time?

Ctrl+Shift+# (Ctrl, Shift and number sign)

Ctrl+; (Ctrl and semi-colon)

Ctrl+Shift+@ (Ctrl, Shift and "at" symbol)

None of the answers listed.

Ctrl+Shift+: (Ctrl, Shift and colon)

Ctrl+Shift+:

The Circle Invalid Data button circles cells that _____.

All of the answers listed.

have errors

don't meet their data validation criteria

are in the wrong format

don't meet their data validation criteria

Locking cells or hiding formulas has no effect unless the worksheet is protected.

True

False

True

You can try to prevent an inexperienced Excel user from "messing up" a workbook by _____.

specifying which actions users can perform

All of the answers listed.

hiding cells so that users cannot see them

locking cells so that users cannot change their contents

All of the answers listed.

To display tracer arrows that indicate which formulas use the value in the active cell, use the _____ button on the Formula Auditing toolbar.

Trace Dependents

Trace Error

Trace Precedents

Error Checking

Trace Dependents

A quick way to apply the currency format is to press Ctrl+Shift+$.

True

False

True

A(n) _____ cell uses the value in the active cell in its formula.

dependent

active

independent

precedent

Dependent

In Excel, what keystroke combination jumps (changes the active cell) to the right, to the end of the current row of contiguous (adjacent) cells with values?

None of the answers listed.

Alt+right arrow

Ctrl+right arrow

Alt+end

Ctrl+end

Ctrl+right arrow

The new, Excel 365 threaded comments can contain formatted text and images.

True

False

False