 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:
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:
a. numbers.
b. letters.
c. Roman numerals.
d. colors.
• Question 3
30 seconds
Report an issue
Q. Spreadsheet columns are easily identified by:
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?
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?
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?
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?
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:

=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:

=sum(C2:C11)

=average(C2,C11)

=average(C2:C11)

=average(B2:B11)

• Question 10
45 seconds
Report an issue
Q.

When you sort data...

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...

=

()

;

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
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?
Filter
Sort
• Question 14
180 seconds
Report an issue Q. What value would you get if you put in the formula: =A1*B1
2
3
4
Error
• Question 15
30 seconds
Report an issue
Q. What would be a correct formula for SUM in excel?
=SUM(B3:B9)
=SUMB3+B9
SUM(B3:B9)
• Question 16
30 seconds
Report an issue
Q. Which formula gets the biggest value of a range of cells?
MAX
MIN
LARGE
SUM
• Question 17
30 seconds
Report an issue
Q. Which formula gets the smallest value of a range of cells?
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.

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.

format cell

conditional formatting

fill color

magic cell

• Question 20
30 seconds
Report an issue
Q. _____ are vertical.
Rows
Columns
• Question 21
30 seconds
Report an issue
Q. ________ are horizontal
Rows
Columns
• Question 22
30 seconds
Report an issue
Q. What allow quickly apply the content for one cell to another cell?
Active cell
Autocell
Auto sum
Auto Fill
• Question 23
30 seconds
Report an issue
Q. How do you select an entire column?
Select Edit > Select > Column from the menu
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?

\$

=

#

/

-

• Question 25
30 seconds
Report an issue
Q. This function can be written to carry out an action and is a conditional operator.
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
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
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
Count
CountA
CountIf
List
• Question 29
20 seconds
Report an issue
Q. Where rows and columns meet are referred to as
Blocks
Cells
Boxes
• Question 30
20 seconds
Report an issue
Q. If you see a series of "######" in a cell, that means the following: