.png){kind=logo}
PDF Download
FREE COMPUTERS AND STUDY GAMES ABOUT EXCEL
EXAM QUESTIONS
Actual Qs and Ans Expert-Verified Explanation
This Exam contains:
-Guarantee passing score -77 Questions and Answers -format set of multiple-choice -Expert-Verified Explanation
Question 1: Percent Style
Answer:
A number format that displays values as if they were multiplied by 100 and with the % symbol.
Question 2: Cell
Answer:
The intersection of a column and row in a worksheet.Question 3: Assume that the data on a worksheet consume a whole printed page and a couple of columns on a second page. what can't you do to force the data to print all on one page?
Answer:
Increase the left and right margins.
Question 4: Normal view
Answer:
The default view of a worksheet that shows worksheet data but not margins, headers, footers, or page breaks.
Question 5: A spreadsheet that contains formulas, functions, values, text, and visual aids.
Answer:
Worksheet Question 6: You selected and copied worksheet data containing formulas. However, you wanted the pasted copy to contain the current formula results rather than formulas. What do you do?
Answer:
Click the Paste arrow in the Clipboard group and select Values&Source Formatting.Question 7: What characteristic is not applicable to the accounting number format?
Answer:
Dollar sign immediately on the left side of the value.
Question 8: Wrap text
Answer:
An excel feature that makes data appear on multiple lines within a cell.Question 9: A combination of cell references, operators, values, and/or functions used to perform a calculation.
Answer:
Formula
Question 10: Sheet tab navigation
Answer:
Visual elements that help you navigate to the first, previous, next, or last sheet within a workbook.
Question 11: Auto Fill
Answer:
A feature that enables you to copy the contents of a cell or a range of cells to continue a sequence by dragging the fill handle over an adjacent cell or range of cells.
Question 12: Input area
Answer:
A range of cells in a worksheet used to store and change the variables used in calculations.
Question 13: Formatting that enables a label to appear on multiple lines within the current cell.
Answer:
Wrap text
Question 14: Spreadsheet
Answer:
An electronic file that contains a grid of columns and rows used to organize related data and to display results of calculations, enabling interpretation of quantitative data for decision making.
Question 15: Status bar
Answer:
The row at the bottom of the Excel window that displays instructions and other details about the status of a worksheet.
Question 16: Name Box
Answer:
An identifier that displays the address or the range name of the current cell in an Excel worksheet.
Question 17: A rectangular group of cells.
Answer:
Range
Question 18: Text
Answer:
Any combination of letters, numbers, symbols, and spaces not used in Excel calculations.
Question 19: Alignment
Answer:
Placement of data within cell boundaries.
Question 20: Horizontal alignment
Answer:
The placement of cell data between the left and right cell margins in a worksheet.
Question 21: Vertical alignment
Answer:
The position of data between the top and bottom cell margins.
Question 22: Column heading
Answer:
The alphabetical letters above the columns in a worksheet.Question 23: What Excel interface item displays the address of the current cell?
Answer:
Name box
Question 24: View controls
Answer:
Icons on the right side of the status bar that enable to change to Normal, Page Layout, or Page Break view to display the worksheet.
Question 25: Pointing
Answer:
The process of using the mouse pointer to select cells while building a formula. Also known as semi-selection.
Question 26: AutoComplete
Answer:
A feature that searches for and automatically displays any other label in that colums that matches the letters you typed.
Question 27: Semi-selection
Answer:
The process of using the mouse pointer to select cells while building a formula. Also known as pointing.
Question 28: Active cell
Answer:
The current cell in a worksheet. It is indicated by a dark green border onscreen.
.png)