Winston-Salem/Forsyth County Schools



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?Track ChangesChange HistoryHistoryNames Manager2. SUMIF and SUMIFS are in which category of functions?Math & TrigTextLogicalLookup & Reference3. 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?SUMIFAVERAGEIFTOTALIFCOUNTIF4. Dorothy designed a column chart and would like to change the background color to yellow. Whichchart feature should she modify?Axis TitleChart TitleGridlinesPlot Area5. James wants his spreadsheet to return true when the logical value is false. What function should he use?IFANDORNOT6. 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?Share WorkbookProtect WorkbookTracking ChangesExport7. Which is a tiny chart that provides a visual representation of data in a worksheet cell?TrendlineSparklineDatalineFlashpoint8.What graphically represents trends in plotted data and predicts future values?SparklineTrendlineChartlineError bar9. 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?SUMIFAVERAGEIFTOTALIFCOUNTIF10.Which Chart Tools Ribbon tab allows a user to insert various labels on the chart?StyleDesignLayoutFormat11.What term refers to an Excel Chart with offset pieces?ExplodedShatteredSeparatedDetached12. Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type should he create?BarColumnLinePie13. John wants to create a chart that shows trends of sales for 4 quarters. What type of chart should he create?PivotChartLine chartEmbedded chartLinked chart14. 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?PivotChartLine chartEmbedded chartLinked chart15.Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?StyleDesignLayoutFormat16. John wants to identify the exact value that each column in his chart represents. Which option should he choose?GridlinesArrowsPicturesLabels17. Which of the following functions would you use to convert text from uppercase to title case?UPPERPROPERLOWERSUBSTITUTE18. Which function automatically counts cells that meet multiple conditions?COUNTIFCOUNTCOUNTIFSSUMIFS19. Which function automatically counts cells that meet a specific condition?COUNTIFCOUNTCOUNTIFSSUMIFS20. In the formula =SUMIFS (C5:C16, F5:F16, "<=60", B5:B16, ">200000"), what is the range of cells to be added?= C5:C16= F5:F16= B5:B16= C5:F1621. In the formula =SUMIFS(C5:C16, F5:F16,"<=60", B5:B16, ">200000"), what does <=60 means?If the value in C5:C16 is greater than or equal to 60, the value in C5:C16 will be included in the total.If the value in F5:F16 is greater than or equal to 60, the value in C5:C16 will be included in the total.If the value in B5:BF16 is less than or equal to 60, the value in C5:C16 will be included in the total.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?The worksheet data to be included in the formula’s resultsThe range containing a condition that must be met in order for data to be included in the resultThe type of formula being used for the calculationThe type of data contained in the cells to be included in the formula23. Which function returns one value if a condition is true and a different value when the condition is not true? ANDORIFIFERROR24. Adding, deleting, moving, and viewing comments are performed from the commands on which ribbon tab?COMMENTS REVIEWFILEVIEW25. The Protect and Share Workbook button is on which ribbon tab?COMMENTS REVIEWFILEVIEW26. Which is NOT an option in the Comments group?New CommentDeleteShow InkEdit Comment 27. You can turn on track changes with all of the following EXCEPT:Track Changes buttonShare Workbook buttonProtect Sheet buttonProtect and Share Workbook button28. All of the following are on the REVIEW tab EXCEPT:Track Changes buttonShare Workbook buttonProtect Cells buttonProtect and Share Workbook button29. Which of the following would be the strongest password?02Feb2011 (Your dog's birthdate)DenVer (The city in which you were born, with odd capitalization)679KrDj! (The last three digits of your social security and first names of each of your siblings with an exclamation point)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:Opening a file Formatting cells, columns, and rows on a worksheetAdding a new worksheet, deleting a worksheetDeleting a file31. You can send a workbook to someone by all of the following methods EXCEPT:Use the FILE, Insert, Email command from Backstage viewOpen a third party email program and attach the Excel fileSave the workbook on SkyDrive and send a link to the file for viewing only 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?RAND()RANDBETWEEN(10000,99999)BYCHANCE(10000,99999)RANDOM(10000,99999)33. You can do all of the following with comments except?Format the text using a different colorChange the background comment box colorNot include the user name who made the commentHide the comment ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download