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