SPREADSHEET APPLICATIONS B
Sign in to Google to save your progress. Learn more
Email *
What is your name? *
What is the password? This password is time sensitive. Your FBLA Adviser will be able to provide it to you. *
51)  When might it make sense to omit a legend for a chart?
1 point
Clear selection
52)  You can use a Gantt Chart for:
1 point
Clear selection
53)  A chart that is part of a worksheet is called:
1 point
Clear selection
54)  To move one slice of a pie chart away from the pie creates which one of the following types of charts?
1 point
Clear selection
55)  When more than one data series exists in a chart, a/an ____ helps to identify which data markers represent each data series.
1 point
Clear selection
56)  Because of the visual distortion that can result with 3D charts, you should:
1 point
Clear selection
57)  Microsoft Excel is an electronic spreadsheet program that allows the user to manipulate:
1 point
Clear selection
58)  Which does NOT describe a spreadsheet application?
1 point
Clear selection
59)  If another user needs to view or print a worksheet and does not have Microsoft Excel on his or her computer, what file format will you need to save the worksheet in to allow them to view the worksheet?
1 point
Clear selection
60)  What is the cell reference for the cell range of E2 to J24?
1 point
Clear selection
61)  Justin wants to survey the students at his school about which college or university they will be attending. What is the best spreadsheet feature to use for this task?
1 point
Clear selection
62)  Which one would best describe the use of a spreadsheet that tracks income and expenses?
1 point
Clear selection
63)  When used in a formula, what operator allows the formula to find a cell reference that is not equal?
1 point
Clear selection
64)  A spreadsheet displays numbers and text in a table layout, making the relationships between ____ easy to understand.
1 point
Clear selection
65)  Text used as an argument in an IF function must be:
1 point
Clear selection
67)  Which of the following is true about a pivot table?
1 point
Clear selection
68)  When creating a pivot table, which statement is not true?
1 point
Clear selection
69)  The ____ button on the PivotTable toolbar updates the contents of a PivotTable based on changes made to the source data.
1 point
Clear selection
70)  When using pivot tables, if a column contains any text entries, which of the following would be the only way to summarize that data?
1 point
Clear selection
71)  Which one of the following can cause round off errors in computations?
1 point
Clear selection
72)  Microsoft Excel's interactive PivotTable feature lets users interact with the data in ____.
1 point
Clear selection
73)  Where do Microsoft Excel's installed templates reside?
1 point
Clear selection
74)  Which of the following cannot be used to run a macro?
1 point
Clear selection
75)  When you assign a macro to start from a place on a graphic object, what is that place called?
1 point
Clear selection
76)  Which of the following is not a valid method to create a macro?
1 point
Clear selection
77)  When developing a template, you can modify the default color scheme by clicking which tab?
1 point
Clear selection
78)  To create a new file from an existing workbook template, which section in the File tab must you search?
1 point
Clear selection
79)  To create the Personal Macro Workbook:
1 point
Clear selection
80)  Sierra has a Microsoft Access database table that she needs to import into Microsoft Excel, what menu does she need to start with to import the data?
1 point
Clear selection
81)  A feature used to divide data into subsets (i.e., all employees who worked over 40 hours; students with May birthdays) is a:
1 point
Clear selection
82)  By using filtering options, one can hide ___ that do not match a certain criteria.
1 point
Clear selection
83)  Which feature will temporarily hide data in a column?
1 point
Clear selection
84)  In order to sort or filter data correctly, a table must be formatted according to specific criteria. Which if the following is not necessary?
1 point
Clear selection
85)  What is the main difference between Advanced Filter and AutoFilter?
1 point
Clear selection
86)  ____allows you to display only those rows that meet certain specifications that you choose.
1 point
Clear selection
87)  Dave has a large spreadsheet of plants that thrive well in the part of the state where he lives. He wants to narrow down the list to the following characteristics of the plants: they have red flowers, need lots of sunshine, need little water, grow 10” high. He also has an area in his yard where he would like to plant purple flowers that work well as bedding plants. Which query could work to find what he wants?
1 point
Clear selection
88)  Jennie is looking for a customer record in her Excel workbook, she is not sure if they spell their last name as Radley or Bradley. What wildcard would you suggest she use for her filter?
1 point
Clear selection
89)  If a products spreadsheet has the headings: Description, Product code, Supplier, Cost, and Location, which would be chosed to filter to determine those products from Sanford and Son that cost more than $5,000?
1 point
Clear selection
90)  To check for invalid data entered as the result of a formula or automated tools such as Goal Seek, use the:
1 point
Clear selection
91)  To print gridlines this option must be checked.
1 point
Clear selection
92)  Which of the following alignment options is used to automatically position labels in a cell?
1 point
Clear selection
93)  What happens when cell J4 is active and the fill color icon is clicked?
1 point
Clear selection
94)  Which feature in a spreadsheet allows for quick copying of formulas?
1 point
Clear selection
95)  Mrs. Rodriguez wants to enter the same formula in cells B10, C10, D10, G10, H10, and L10. Which command will allow her to quickly enter the same formula in each of these cells?
1 point
Clear selection
96)  As worksheet names become longer, what may happen to the sheet tabs?
1 point
Clear selection
97)  By default each worksheet has a name, what option is not valid when trying to manage multiple worksheets?
1 point
Clear selection
98)  Which cell format will display the number 344567890 as a social security number that looks like this: 344-56-7890?
1 point
Clear selection
99)  What feature should be used to automatically shade cells with a value greater than 100 to display with a yellow background?
1 point
Clear selection
100)  Which type of text box will allow users to enter their own data or select data from a predefine list?
1 point
Clear selection
Submit
Clear form
Never submit passwords through Google Forms.
reCAPTCHA
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy