Excel Questions and Answers (2022/2023) Rated A+

Document Content and Description Below

Excel Questions and Answers (2022/2023) Rated A+ Active cell ✔✔The selected cell in the worksheet; indicated with a dark border. Active sheet ✔✔The worksheet currently displayed in the work ... book window. Active workbook ✔✔The workbook you are currently using. Adjacent range ✔✔A single rectangular block that includes a group of contiguous cells. Arithmetic operator ✔✔A symbol, such as +, - , *, or /, used in a formula to perform arithmetic calculations. AutoComplete ✔✔The feature that helps make entering repetitive text easier. As you enter text in a worksheet, text that begins with the same letters as a previous entry in the same column is displayed. Autofit ✔✔To eliminate empty space by matching the column width to the longest cell entry or the row height to the tallest cell entry. AutoSum ✔✔A button that quickly inserts Excel functions that summarize all the values in a column or row using a single statistic - SUM, AVERAGE, COUNT, MIN or MAX Cell ✔✔The intersection of a column or row in a worksheet. Cell range ✔✔A group of worksheet cells, which can be adjacent or nonadjacent. (Example - A2:G19) Cell reference ✔✔The address of a cell indicating its column and row location. Column heading ✔✔In Excel, the part of the worksheet that identifies each column by a different letter. Cut ✔✔To remove data from a cell and place it on the Office Clipboard. Date data ✔✔A value in a recognized date format. Delete ✔✔To remove a cell or cells from a worksheet, shifting the remaining worksheet cells into the space previously occupied by the deleted cell or cells; also to remove a worksheet entirely from a workbook. Drag and drop ✔✔To move an item (either text or a graphic) by selecting it and dragging it with the mouse. Editing mode ✔✔A mode in which you can edit part of an entry rather than the entire contents of a cell. Find ✔✔The command to locate specific letters and numbers in a workbook. Formula ✔✔A mathematical expression that calculates a value; all Excel formulas always begin with an equal sign (=) followed by an expression that describes the calculation to be done. Formula bar ✔✔The bar located above the workbook window in which the contents of a cell are displayed. Formula view ✔✔Excel view in which cell formulas are displayed rather than the values returned by the formulas. Function ✔✔A predefined formula that performs calculations using specific values called arguments. Landscape orientation ✔✔A type of page orientation in which the page is wider than it is tall, so that text spans the widest part of the page. Microsoft Excel 2007 ✔✔A spreadsheet prog [Show More]

Last updated: 2 years ago

Preview 1 out of 27 pages

Buy Now

Instant download

We Accept: