Excel Exam 2

11 September 2022
4.7 (114 reviews)
49 test answers

Unlock all answers in this set

Unlock answers (45)
question
By default, how does Excel align numeric entries in a cell? A. top left corner of a cell B. top right corner of a cell C. bottom left corner of a cell D. bottom right corner of a cell
answer
D: Bottom right corner of a cell
question
Which of the following commands lets you display a label on multiple lines within a cell? A. Split B. Merge & Center C. Wrap Text D. Format Painter
answer
C: Wrap Text
question
Which of the following Page Setup options lets you set margins for headers and footers? A. Page B. Margins C. Header/Footer D. Sheet
answer
B: Margins
question
Once you have saved a workbook for the first time, which of the following keyboard shortcuts can you use to save it again? A. Ctrl+F B. Ctrl+K C. Ctrl+R D. Ctrl+S
answer
D: Ctrl + S
question
What is selected when you click the Select All button located above the row 1 heading and to the left of the column A heading? A. the entire column B. the entire row C. the entire worksheet D. the 20 cells adjacent to the top of the column
answer
C: The entire worksheet
question
What is selected when you point to and click a column heading? A. the entire column B. the entire row C. the entire worksheet D. the 20 cells adjacent to the top of the column
answer
A: The entire column
question
Which of the following Spelling dialog box options skips all occurrences of the same spelling of a word in the worksheet? A. Ignore Once B. Ignore All C. Change D. Change All
answer
B: Ignore all
question
Which of the following describes the section of the worksheet that prints? A. gridline area B. zoom area C. fill area D. print area
answer
D: Print area
question
Which of the following displays in a cell when you click AutoSum? A. =SUM () B. =AUTOSUM C. =ADD D. =AUTOADD
answer
A: =SUM ()
question
Which of the following increases the distance between the cell contents and the left boundary of a cell? A. column width B. row height C. gridline D. indent
answer
D: Indent
question
Which of the following is included in calculations? A. labels B. values C. columns D. rows
answer
B: Values
question
Which of the following is the name used to describe a rectangular group of cells? A. columns B. rows C. range D. none of the above
answer
C: Range
question
Which of the following Page Setup options lets you set the Print area by selecting a specified range of cells? A. Page B. Margins C. Header/Footer D. Sheet
answer
D: Sheet
question
Which of the following keyboard shortcuts cuts cells or a cell range? A. Ctrl+C B. Ctrl+S C. Ctrl+V D. Ctrl+X
answer
D: Ctrl+X
question
Which of the following statements is False about hiding rows? A. Hiding a row deletes the data from the row. B. Hiding a row does not delete the data from the column. C. Hiding a row does not affect the results of calculations. D. After hiding a row, you can unhide it.
answer
A: Hiding a row deletes the data from the row
question
Which of the following statements is True? A. Workbooks can hold a maximum of 29 sheets. B. Workbooks can hold a maximum of 16,000 sheets. C. The number of sheets you can insert in a workbook is limited only by the amount of memory available on your computer. D. By default, a workbook contains five sheets.
answer
C: The number of sheets you can insert in a workbook is limited only by the amount of memory available on your computer
question
You can print an entire workbook, a single worksheet, or a section of a worksheet. T or F?
answer
True
question
You can use the Split command to show different parts of the same spreadsheet in separate panes. T or F?
answer
True
question
The Wrap Text command enables you to display the contents of a cell on multiple lines. T or F?
answer
True
question
A cell displays the result of the formula and the Formula bar displays the formula. T or F?
answer
True
question
A print area consists of any range of cells you have identified or the entire worksheet. T or F?
answer
True
question
By default, text and values are oriented horizontally from left to right, but you can change text orientation to display text vertically or at an angle. T or F?
answer
True
question
Cell Styles are a set of predefined formatting elements that you can apply to titles, subtitles, column headings, row totals, and other areas of your worksheet. T or F?
answer
True
question
Excel 2016 has over 16,000 columns and over 1 million rows. T or F?
answer
True
question
Hiding a column or row does not delete the information in the worksheet nor does it affect the results of calculations. T or F?
answer
True
question
In Excel, a rectangular group of cells is called a range. T or F?
answer
True
question
Which of the following is true about the TODAY and NOW functions? A. They have no arguments. B. You can enter up to two arguments. C. You can enter up to three arguments. D. You can enter up to four arguments.
answer
A: They have no arguments
question
In the function =SUM(B2:B6), which part of the function is the argument? A. SUM B. B2 C. B6 D. B2:B6
answer
D: B2:B26
question
Which of the following is a mixed cell address? A. B2 B. $B$2 C. B$2 D. Sheet2!B2
answer
C: B$2
question
Which of the following characters must always start a function? A. = B. ( C. $ D. none of the above
answer
A: =
question
Which of the following is an absolute cell address? A. B2 B. $B$2 C. B$2 D. Sheet2!B2
answer
B: $B$2
question
Which of the following is a relative cell address? A. B2 B. $B$2 C. B$2 D. Sheet2!B2
answer
A: B2
question
Which of the following contains one relative reference (either the row number or column letter) and one absolute reference (the remaining row number or column letter)? A. absolute reference B. mixed reference C. 3D cell reference D. relative reference
answer
B: Mixed reference
question
Which of the following formulas correctly adds the values in cells E4 and E5? A. * E4 + E5 B. = E4 + E5 C. # E4 + E5 D. E4 + E5
answer
B. = E4 + E5
question
Which of the following functions calculates payments for a loan if regular payments are made and the interest rate is constant? A. PMT B. IF C. LOOKUP D. VLOOKUP
answer
A: PMT
question
Which of the following functions combines the SUM function with the logical criteria component of the IF function? A. SUMIF B. SUMPRODUCT C. ROUND D. none of the above
answer
A: SUMIF
question
Which of the following functions tallies the number of cells in a range that contain numbers? A. AVERAGE B. COUNT C. MAX D. MIN
answer
B: COUNT
question
Which of the following functions evaluates a specified condition and returns one value if the condition is True and another value if the condition is False? A. PMT B. IF C. LOOKUP D. VLOOKUP
answer
B: IF
question
Which of the following features displays numerical results such as SUM, AVERAGE, and COUNT on the Status bar for selected cells? A. Formula Auditor B. Range Finder C. Formula AutoComplete D. AutoCalculate
answer
D: Auto Calculate
question
Which of the following is the constant in the formula =D5*85%?? A. = B. D5 C. * D. 85%
answer
D: 85%
question
The SMALLEST function finds the smallest value in a cell range. T or F?
answer
False
question
If your formula includes a syntax error, Excel displays an error message that starts with a number sign (#) and ends with an exclamation point (!). T or F?
answer
True
question
The AVERAGE function calculates an average by adding cell values together and dividing the total of the values by 4. T or F?
answer
False
question
The IF function calculates loan payment amounts. T or F?
answer
False
question
The ROUND function adjusts a value to a specified number of decimal places. T or F?
answer
True
question
The Range Finder highlights and color codes each cell as you type its address. T or F?
answer
True
question
The formula to add the values in cells D3 and D4 is @D3 + D4. T or F?
answer
False
question
Formula auditing is the process of displaying suggestions for completing a formula. T or F?
answer
True
question
VLOOKUP and HLOOKUP are examples of LOOKUP functions T or F?
answer
True