Excel Projects 1-5 Review
3 years ago
techalvarez
Save
Edit
Host a game
Live GameLive
Homework
Solo Practice
Practice
30 QuestionsShow answers
  • Question 1
    30 seconds
    Report an issue
    Q.  A spreadsheet program is used to store data in: 
    answer choices
    a. a database.
    b. a text document.
    c. rows and columns.
    d. letters and numbers.
  • Question 2
    30 seconds
    Report an issue
    Q. Spreadsheet rows are easily identified by:
    answer choices
    a. numbers.
    b. letters.
    c. Roman numerals.
    d. colors.
  • Question 3
    30 seconds
    Report an issue
    Q. Spreadsheet columns are easily identified by:
    answer choices
    a. Roman numerals.
    b. numbers.
    c. letters.
    d. colors.
  • Question 4
    30 seconds
    Report an issue
    Q. Which of the following is an example of a cell reference?
    answer choices
    a. Column C
    b. =SUM
    c. Row 1
    d. A5
  • Question 5
    30 seconds
    Report an issue
    Q. Which of these are not an example of how MS Excel can be used?
    answer choices
    a. Budget
    b. Research Paper
    c. Track sales
    d. Track Inventory
  • Question 6
    30 seconds
    Report an issue
    Q. What is the purpose of spreadsheets?
    answer choices
    a. To present information on different engaging slides
    b. To deliver a speech to a crowd
    c. To perform basic and complex math computations in an organized way
    d. To excel your research papers and citations
  • Question 7
    30 seconds
    Report an issue
    Q. What does this symbol represent in MS Excel?
    answer choices
    a. Subtract
    b. AutoSum
    c. Formula
    d.    Average
  • Question 8
    30 seconds
    Report an issue
    Q.

    If I wanted to know the total amount of bonuses given to the employees I would write the following formula in cell D12:

    answer choices

    =sum(C2:C11)

    =sum(D2,D3,D4,D5,D7,D8,D9,D10,D11)

    =sum(D2:D11)

    $13,442.90

  • Question 9
    30 seconds
    Report an issue
    Q.

    If I wanted to know the average annual salary earned by the employees I would write the following formula in cell C12:

    answer choices

    =sum(C2:C11)

    =average(C2,C11)

    =average(C2:C11)

    =average(B2:B11)

  • Question 10
    45 seconds
    Report an issue
    Q.

    When you sort data...

    answer choices

    You change the values of the cells.

    You choose how the data will be displayed.

    You remove values that don't fit in your data set.

  • Question 11
    30 seconds
    Report an issue
    Q.

    Every formula needs to begin with...

    answer choices

    =

    ()

    ;

    FORMULA

  • Question 12
    30 seconds
    Report an issue
    Q. One way to make sure the header row always displays when scrolling the worksheet is to
    answer choices
    Freeze the Row
    Split the worksheet
  • Question 13
    30 seconds
    Report an issue
    Q. What can be used to narrow down the data in your worksheet?
    answer choices
    Filter
    Sort
  • Question 14
    180 seconds
    Report an issue
    Q. What value would you get if you put in the formula: =A1*B1
    answer choices
    2
    3
    4
    Error
  • Question 15
    30 seconds
    Report an issue
    Q. What would be a correct formula for SUM in excel?
    answer choices
    =SUM(B3:B9)
    =SUMB3+B9
    SUM(B3:B9)
    =ADD(B3:B9)
  • Question 16
    30 seconds
    Report an issue
    Q. Which formula gets the biggest value of a range of cells?
    answer choices
    MAX
    MIN
    LARGE
    SUM
  • Question 17
    30 seconds
    Report an issue
    Q. Which formula gets the smallest value of a range of cells?
    answer choices
    MAX
    MIN
    SMALL
    SUM
  • Question 18
    30 seconds
    Report an issue
    Q.

    Which formula would you use to calculate how many sales are over $20 from a series.

    answer choices

    sum

    sumif

    count

    countif

  • Question 19
    30 seconds
    Report an issue
    Q.

    Which tool is used to add a graphic representation of data based on a condition within a cell? For example, adding green data bars to a column of data.

    answer choices

    format cell

    conditional formatting

    fill color

    magic cell

  • Question 20
    30 seconds
    Report an issue
    Q. _____ are vertical. 
    answer choices
    Rows
    Columns
  • Question 21
    30 seconds
    Report an issue
    Q. ________ are horizontal
    answer choices
    Rows
    Columns
  • Question 22
    30 seconds
    Report an issue
    Q. What allow quickly apply the content for one cell to another cell?
    answer choices
    Active cell
    Autocell
    Auto sum
    Auto Fill
  • Question 23
    30 seconds
    Report an issue
    Q. How do you select an entire column?
    answer choices
    Select Edit > Select > Column from the menu
    Click the column heading letter
    Hold down the shift key as you click anywhere in the column.
    Hold down the Ctrl key as you click anywhere in the column
  • Question 24
    30 seconds
    Report an issue
    Q.

    Which symbol do you use to create an absolute cell reference?

    answer choices

    $

    =

    #

    /

    -

  • Question 25
    30 seconds
    Report an issue
    Q. This function can be written to carry out an action and is a conditional operator. 
    answer choices
    If Statements
    List Functions
    Count Functions
    Lookup Functions
  • Question 26
    30 seconds
    Report an issue
    Q. Returns the number of cells in a range that contains numbers
    answer choices
    Count
    CountA
    CountIf
    List
  • Question 27
    30 seconds
    Report an issue
    Q. Returns the number of cells in a range that contain any value/label
    answer choices
    Count
    CountA
    CountIf
    List
  • Question 28
    30 seconds
    Report an issue
    Q. Returns the number of cells that meet a condition set forth in a formula
    answer choices
    Count 
    CountA
    CountIf
    List
  • Question 29
    20 seconds
    Report an issue
    Q. Where rows and columns meet are referred to as
    answer choices
    Blocks
    Cells
    Boxes
  • Question 30
    20 seconds
    Report an issue
    Q. If you see a series of "######" in a cell, that means the following:
    answer choices
    You keyed in an incorrect number
    The row height is too high
    The text is incorrectly spelled
    The column width is not wide enough
Report an issue
Why show ads?
Report Ad
Join a game