Match the following descriptions to their corresponding feature names or shortcuts. - Enables the current cell's Edit mode - Button that shows all cells referenced in the active cell's formula - A built-in function that calculates the arithmetic mean of a range of cells - This button opens a list of commonly used statistical functions - A label assigned to a single cell or group of cells - Uses common arithmetic operations to perform calculations - Tallies the number of cells in a range - 3D cell reference - Button that starts a review of each part of a formula to determine errors. - An Excel function that controls how many decimal places to display for a value
Added by Amanda R.
Your feedback will help us improve your experience
Adi S and 51 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Which of the following Excel® functions can be used for finding a particular value based on a comparison? a. NPV b. VLOOKUP c. SUMPRODUCT d. IF The daily closing values of the Dow Jones Industrial Average over a period of 30 days are best described as time-series data. a. time-series b. cross-sectional c. nominal d. discrete Which of the following statements is false? a. The NPV function takes two arguments, the discount rate and a stream of cash flows. b. The SUMPRODUCT function takes two range arguments, which must be exactly the same size and shape, and it sums the products of the corresponding values in these two ranges. c. A two-way table allows you to see how a single output cell varies as you vary two input cells. d. The purpose of the Auditing Toolbar is to solve one equation with one unknown.
Adi S.
1. appear at the bottom of the Excel window. (A) Title bar (B) Formula bar (C) Work sheet tabs (D) Name box 2. What are the basic rectangular building blocks of a spreadsheet? (A) Cells (B) Zoom slider (C) Help button (D) All of these 3. Which of the following is not a term pertaining to spreadsheets? (A) Cell (B) Character (C) Browser (D) Formula 4. Which of the following identifies a cell in Excel? (A) Address (B) Formula (C) Name (D) Label 5. A formula in Excel always begins with an (A) Equal sign (B) Colon (C) Comma (D) Space
Madhur L.
Drag the letter from the list on the right to its matching term in the list on the left. When you are finished, click Done. [C] Save As [B] .csv [E] .html [D] Worksheet tab [G] Format Cells [H] SUM [J] Function [A] Destination cell [I] Home tab [F] AutoFit [A] Applies a border or shading to selected cells [B] Where cut or copied data is pasted [C] Saves workbook with a different name [D] The extension for a web page workbook [E] A built-in formula that adds the values in a selected range [F] Where the Clipboard group is found [G] A common file format that can be opened by many applications [H] Displays the name of the worksheet at the bottom left [I] Resizes column width or row height to accommodate the largest entry [J] A built-in formula
Akash M.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD