Excel Exam
As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations. True False
False
The / arithmetic operator indicates multiplication. True False
False
All of the following are valid Excel arithmetic operators EXCEPT ____. > ^ * %
>
The range automatically selected by Excel is always correct. True False
False
Worksheet titles and subtitles should be as wordy as possible. True False
False
You can replace a formula with its function so it remains constant. True False
False
You can select nonadjacent ranges using the SHIFT key. True False
False
You cannot format an entire column at once. True False
False
The ____ function displays the highest value in a range. MAX MIN SUM AVERAGE
MAX
____ is/are used to place worksheet, column, and row titles on a worksheet. Text Color Links Tabs
Text
A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function. True False
True
A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area. True False
True
A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet. True False
True
Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data. True False
True
Margins are those portions of a printed page outside the main body of the printed document and always are blank when printed. True False
True
Merging cells involves creating a single cell by combining two or more selected cells. True False
True
You can press the CTRL+ACCENT MARK(`) keys to display the formulas in a worksheet. True False
True
Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle? Quarter 1 Qtr1 Qtr2 Quarter4
correct answer is Quarter 1
The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n) range. True False
True
A thin red border indicates the active cell. True False
False
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation. True False
False
Best fit means that the width of the column will be increased or decreased by a percentage you specify. True False
False
Excel can display characters in only three font colors: black, red, and blue. True False
False
A company or department may standardize with a specific ____ so that all of their documents have a similar appearance. theme scheme style gallery
theme
A ____ is a prewritten formula that is built into Excel. function nested entry task rule
function
A ____ is text and graphics that print at the top of each page. header topper margin crown
header
When Excel follows the order of operations, the formula, 8 * 3 + 2, equals ____. 26 40 48 13
26
Which of the following formulas contains an absolute cell reference? =$B$4 =$B4 =B4 =B$4
=$B$4
_____ refers to cells not wide enough to display the entire entry. ##### &&&&& $$$$$ +++++
#####
The active cell reference appears in the Name box on the left side of the formula bar. True False
True
The equal sign (=) precedes a formula. True False
True
Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula. True False
True
When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data. True False
True
With Excel in Edit mode, you can edit cell contents directly in the cell. True False
True
To enter data in a cell, you must first select the ____. cell row column worksheet
cell
You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____. colon (:) semi-colon (;) period (.) none of the above
colon (:)
Using the mouse to move or copy cells is called ____. drag and drop drag drag and copy drag and paste
drag and drop
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. format save print clear
format
Combining two or more selected cells into one cell is called ____ cells. merging mixing combining spanning
merging
An Excel ____ allows data to be summarized and charted easily. worksheet workflow document presentation
worksheet
