CSCI 211 Midterm

Which of the following is the Ribbon path to the Cell Styles button?

(HOME tab | Styles group)

Using the Excel spell checker, you can ____.

-check the spelling of words in a selected range -add words to the dictionary

Which of the following are formatting symbols?

-comma , -percent sign % -dollar sign $

When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____.

26

Which of the following patterns extends the fill series to 525, 475, 425?​

625, 575

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters.

8.43

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

Accounting number format

Which of the following Option buttons gives options for filling cells following a fill operation?

Auto Fill Options

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

AutoCalculate

Pressing the ____ keyboard shortcut key(s) selects cell A1.

CTRL+HOME

Pressing the ____ key while a dialog box is displayed opens a Help window.

F1

Which of the following keys moves the insertion point to the beginning of data in a cell?

HOME

In Office, ____ is presented in a window that has browser-style navigation buttons.

Help

Which of the following keys toggles between Insert mode and Overtype mode?

INSERT

When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics?

Identification of how to format various elements of the worksheet

If you want to learn more about a command, point to its button and wait for the ____ to appear.

ScreenTip

A ____ is a unique combination of letters or numbers that identifies a specific user to Windows

a user name

The date you change a file is an example of a(n) ____ property.

automatically updated

To enter data in a cell, you must first select the ____.

cell

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

colon :

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

constant

When you increase the screen resolution, Windows displays more information on the screen, but the information ____.

decreases in size

The range of cells receiving the content of copied cells is called the ____.

destination area

What effect does the Accounting Number Format have on the selected cells?

displays cell contents with two decimal places that align vertically

A thin red border indicates the active cell.

false

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

false

As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

false

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

false

Excel can display characters in only three font colors: black, red, and blue.

false

Exploding worksheet columns and rows is a useful technique for viewing large worksheets that extend beyond the window.

false

If you delete a file from removable media, it is stored in the Recycle Bin where you can recover it until you empty the Recycle Bin.

false

If you do not use the mini toolbar, it remains on the screen.

false

If you do not use the mini toolbar, it remains on the screen. _______________

false

The arithmetic operator, ^, directs Excel to perform the division operation.

false

The range automatically selected by Excel is always correct.

false

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

false

When you exit an Office app, if you have made changes to a file since the last time the file was saved, the app displays a dialog box asking if you want to save the changes you made to the file before it closes the app window.

false

When you hold down the CTRL key while rolling the mouse wheel, text on the screen becomes smaller regardless of the direction in which you roll the wheel.

false

When you move a file, it still appears in the original folder.

false

While holding down the ALT key, you can select nonadjacent ranges and cells.

false

With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

false

You can move any open window that is maximized to another location on the desktop by dragging the title bar of the window.

false

You can use the arrow keys to complete an entry in Point mode.

false

You cannot format an entire column at once.

false

Most users rely on ____ for finding, viewing, and managing information on their computers.

folder windows

A ____ is text and graphics that print at the bottom of every page.

footer

The ____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

formula

A ____ is a prewritten formula that is built into Excel.

function

When you delete a file from a ____, the deleted file is stored in the Recycle Bin.

hard drive

The ____ Option button lists formatting options following an insertion of cells, rows, or columns.

insert

A ____ consists of one or more keys that you press to perform tasks using the keyboard.

keyboard shortcut

If your computer is connected to the Internet, the contents of the Help page reflect both the ____ installed on the computer and material from Microsoft's website.

local help files

Combining two or more selected cells into one cell is called ____ cells.

merging

A(n) ____ window is an open window hidden from view but that can be displayed quickly by clicking the window's app button on the taskbar.

minimized

The default view in Excel is called ____ view.

normal

The range of cells receiving copied content is called the ____ area.

paste

A ____ reference is an adjusted cell reference in a copied and pasted formula.

relative

The Maximize button changes to the ____ button after you tap or click it.

restore down

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

right parenthesis

To use an app, you must instruct the operating system to ____ the app.

run

A ____ is a horizontal or vertical bar that appears when the contents of an area may not be visible completely on the screen.

scroll bar

Which of the following is not a valid format symbol?

semi-colon ;

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.

sparkline

____ organize and store data within worksheets.

tables

____ is/are used to place worksheet, column, and row titles on a worksheet.

text

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance.

theme

A character with a point size of 10 is about 10/72 of one inch in height.

true

A gesture is a motion you make on a touch screen with the tip of one or more fingers or your hand.

true

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.

true

A scroll bar contains scroll arrows and a scroll box.

true

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

true

Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.

true

File Explorer provides a means to create a blank Office document without running an Office app.

true

Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.

true

Once an Office app's Help window is open, you can search for help using the Table of Contents, clicking the links in the Help window, or entering search text in the 'Search online help' text box.

true

Organizing files in folders is part of a process known as file management.

true

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

true

The AVERAGE function requires that the argument be included within parentheses following the function name.

true

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

true

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

true

The equal sign (=) precedes a formula.

true

The opposite of merging cells is splitting a merged cell. _________________________

true

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

true

Windows is used to run apps.

true

Windows users who do not have touch screen capabilities typically work with a mouse that usually has at least two buttons.

true

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

true

You can press the CTRL+ACCENT MARK(`) keys to display the formulas in a worksheet.

true

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

true

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.

two

The ____ button allows you to erase recent cell entries.

undo

A ____ is like a notebook.

workbook

Clicking the ____ box completes an entry.

Enter

You should use a ____ chart to compare values side by side, broken down by category.

Clustered Column

To open the Format Cells dialog box with the Alignment sheet active, click the Alignment Settings _____.​

Dialog Box Launcher

Which of the following keys moves the insertion point to the end of data in a cell?

END

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

ESC

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.

Print Selection

The ____ provides convenient, one-tap or one-click access to frequently used commands.

Quick Access Toolbar

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

RIGHT ARROW