Excel Projects 1-5 Review

3 years ago

techalvarez16

Save

Edit

Host a game

Live GameLive

Homework

Solo Practice

Practice

30 QuestionsShow answers

- Question 130 secondsReport an issueQ. A spreadsheet program is used to store data in:answer choices
- Question 230 secondsReport an issueQ. Spreadsheet rows are easily identified by:answer choices
- Question 330 secondsReport an issueQ. Spreadsheet columns are easily identified by:answer choices
- Question 430 secondsReport an issueQ. Which of the following is an example of a cell reference?answer choices
- Question 530 secondsReport an issueQ. Which of these are not an example of how MS Excel can be used?answer choices
- Question 630 secondsReport an issueQ. What is the purpose of spreadsheets?answer choices
- Question 730 secondsReport an issueQ. What does this symbol represent in MS Excel?answer choices
- Question 830 secondsReport an issueQ.
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 - Question 930 secondsReport an issueQ.
If I wanted to know the average annual salary earned by the employees I would write the following formula in cell C12:

answer choices - Question 1045 secondsReport an issueQ.
When you sort data...

answer choices - Question 1130 secondsReport an issueQ.
Every formula needs to begin with...

answer choices - Question 1230 secondsReport an issueQ. One way to make sure the header row always displays when scrolling the worksheet is toanswer choices
- Question 1330 secondsReport an issueQ. What can be used to narrow down the data in your worksheet?answer choices
- Question 14180 secondsReport an issueQ. What value would you get if you put in the formula: =A1*B1answer choices
- Question 1530 secondsReport an issueQ. What would be a correct formula for SUM in excel?answer choices
- Question 1630 secondsReport an issueQ. Which formula gets the biggest value of a range of cells?answer choices
- Question 1730 secondsReport an issueQ. Which formula gets the smallest value of a range of cells?answer choices
- Question 1830 secondsReport an issueQ.
Which formula would you use to calculate how many sales are over $20 from a series.

answer choices - Question 1930 secondsReport an issueQ.
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 - Question 2030 secondsReport an issueQ. _____ are vertical.answer choices
- Question 2130 secondsReport an issueQ. ________ are horizontalanswer choices
- Question 2230 secondsReport an issueQ. What allow quickly apply the content for one cell to another cell?answer choices
- Question 2330 secondsReport an issueQ. How do you select an entire column?answer choices
- Question 2430 secondsReport an issueQ.
Which symbol do you use to create an absolute cell reference?

answer choices - Question 2530 secondsReport an issueQ. This function can be written to carry out an action and is a conditional operator.answer choices
- Question 2630 secondsReport an issueQ. Returns the number of cells in a range that contains numbersanswer choices
- Question 2730 secondsReport an issueQ. Returns the number of cells in a range that contain any value/labelanswer choices
- Question 2830 secondsReport an issueQ. Returns the number of cells that meet a condition set forth in a formulaanswer choices
- Question 2920 secondsReport an issueQ. Where rows and columns meet are referred to asanswer choices
- Question 3020 secondsReport an issueQ. If you see a series of "######" in a cell, that means the following:answer choices

Report an issue

Why show ads?