Microsoft Excel lessons 9-11 Pre-Test

1. All of the FBLA officers have access to the spreadsheet of member contact information. Which feature in Excel allows others to view which officer made changes to the spreadsheet, when the change was made and what changes were made?

  1. Track Changes
  2. Change History
  3. History
  4. Names Manager

2. SUMIF and SUMIFS are in which category of functions?

  1. Math & Trig
  2. Text
  3. Logical
  4. Lookup & Reference

3. Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that range that are greater than 1,000. What function should she use?

  1. SUMIF
  2. AVERAGEIF
  3. TOTALIF
  4. COUNTIF

4. Dorothy designed a column chart and would like to change the background color to yellow. Which

chart feature should she modify?

  1. Axis Title
  2. Chart Title
  3. Gridlines
  4. Plot Area

5. James wants his spreadsheet to return true when the logical value is false. What function should he use?

  1. IF
  2. AND
  3. OR
  4. NOT

6. Lilly is creating a spreadsheet for FBLA and would like all of the advisors at her school to be able to make changes to the spreadsheet at the same time. What command allows her to do this?

  1. Share Workbook
  2. Protect Workbook
  3. Tracking Changes
  4. Export

7. Which is a tiny chart that provides a visual representation of data in a worksheet cell?

  1. Trendline
  2. Sparkline
  3. Dataline
  4. Flashpoint

8.What graphically represents trends in plotted data and predicts future values?

  1. Sparkline
  2. Trendline
  3. Chartline
  4. Error bar

9. Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should he use?

  1. SUMIF
  2. AVERAGEIF
  3. TOTALIF
  4. COUNTIF

10.Which Chart Tools Ribbon tab allows a user to insert various labels on the chart?

  1. Style
  2. Design
  3. Layout
  4. Format

11.What term refers to an Excel Chart with offset pieces?

  1. Exploded
  2. Shattered
  3. Separated
  4. Detached

12. Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type should he create?

  1. Bar
  2. Column
  3. Line
  4. Pie

13. John wants to create a chart that shows trends of sales for 4 quarters. What type of chart should he create?

  1. PivotChart
  2. Line chart
  3. Embedded chart
  4. Linked chart

14. John wants to be able to view his monthly sales chart as well as his data on the same worksheet. What type of chart should he create?

  1. PivotChart
  2. Line chart
  3. Embedded chart
  4. Linked chart

15.Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?

  1. Style
  2. Design
  3. Layout
  4. Format

16. John wants to identify the exact value that each column in his chart represents. Which option should he choose?

  1. Gridlines
  2. Arrows
  3. Pictures
  4. Labels

17. Which of the following functions would you use to convert text from uppercase to title case?

  1. UPPER
  2. PROPER
  3. LOWER
  4. SUBSTITUTE

18. Which function automatically counts cells that meet multiple conditions?

  1. COUNTIF
  2. COUNT
  3. COUNTIFS
  4. SUMIFS

19. Which function automatically counts cells that meet a specific condition?

  1. COUNTIF
  2. COUNT
  3. COUNTIFS
  4. SUMIFS

20. In the formula =SUMIFS (C5:C16, F5:F16, "<=60", B5:B16, ">200000"), what is the range of cells to be added?

  1. = C5:C16
  2. = F5:F16
  3. = B5:B16
  4. = C5:F16

21. In the formula =SUMIFS(C5:C16, F5:F16,"<=60", B5:B16, ">200000"), what does <=60 means?

  1. If the value in C5:C16 is greater than or equal to 60, the value in C5:C16 will be included in the total.
  2. If the value in F5:F16 is greater than or equal to 60, the value in C5:C16 will be included in the total.
  3. If the value in B5:BF16 is less than or equal to 60, the value in C5:C16 will be included in the total.
  4. If the value in F5:F16 is less than or equal to 60, the value in C5:C16 will be included in the total.

22. What does criteria range in a formula refer to?

  1. The worksheet data to be included in the formula’s results
  2. The range containing a condition that must be met in order for data to be included in the result
  3. The type of formula being used for the calculation
  4. The type of data contained in the cells to be included in the formula

23. Which function returns one value if a condition is true and a different value when the condition is not true?

  1. AND
  2. OR
  3. IF
  4. IFERROR

24. Adding, deleting, moving, and viewing comments are performed from the commands on which ribbon tab?

  1. COMMENTS
  2. REVIEW
  3. FILE
  4. VIEW

25. The Protect and Share Workbook button is on which ribbon tab?

  1. COMMENTS
  2. REVIEW
  3. FILE
  4. VIEW

26. Which is NOT an option in the Comments group?

  1. New Comment
  2. Delete
  3. Show Ink
  4. Edit Comment

27. You can turn on track changes with all of the following EXCEPT:

  1. Track Changes button
  2. Share Workbook button
  3. Protect Sheet button
  4. Protect and Share Workbook button

28. All of the following are on the REVIEW tab EXCEPT:

  1. Track Changes button
  2. Share Workbook button
  3. Protect Cells button
  4. Protect and Share Workbook button

29. Which of the following would be the strongest password?

  1. 02Feb2011 (Your dog's birthdate)
  2. DenVer (The city in which you were born, with odd capitalization)
  3. 679KrDj! (The last three digits of your social security and first names of each of your siblings with an exclamation point)
  4. BruinsO6 (Your high school mascot and year you graduated using the letter O for a zero)

30. Within Excel, you can require a password for all of the following EXCEPT:

  1. Opening a file
  2. Formatting cells, columns, and rows on a worksheet
  3. Adding a new worksheet, deleting a worksheet
  4. Deleting a file

31. You can send a workbook to someone by all of the following methods EXCEPT:

  1. Use the FILE, Insert, Email command from Backstage view
  2. Open a third party email program and attach the Excel file
  3. Save the workbook on SkyDrive and send a link to the file for viewing only
  4. Through a Send to Mail Recipient button you've added to the Quick Access Toolbar

32. Which of the following functions allows you to have Excel put any number in by chance from 10000 to 99999?

  1. RAND()
  2. RANDBETWEEN(10000,99999)
  3. BYCHANCE(10000,99999)
  4. RANDOM(10000,99999)

33. You can do all of the following with comments except?

  1. Format the text using a different color
  2. Change the background comment box color
  3. Not include the user name who made the comment
  4. Hide the comment