Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Corrections
| Question | Answer |
|---|---|
| Alicia needs to move the data in cell B5 to cell E5. Which command would she select? | Cut |
| What term is used when referencing cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address? | Worksheet Reference |
| Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D? | Text |
| How is an exact copy of a worksheet created within the same workbook? | Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu |
| Joan has created a spreadsheet that displays sales of her employees. She would like to view only those employees with sales above $25,000 who are from Region 3. What option will allow her to do that? | Custom Filter |
| What is the process of bringing data containing text fields separated by commas into Excel called? | Importing data |
| 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 she use? | COUNTIF |
| What can you use to easily filter pivot tables and cube functions interactively in a worksheet? | Slicer |
| In order to directly report the data, what must a PivotChart always be associated with? | PivotTable |
| Leigh Ann designed a bar chart and would like to add an element above the chart to make the data more meaningful. Which chart feature would she need to include? | Chart Title |
| John would like to add a banner at the top of his spreadsheet. Which object should he insert? | Shapes |
| Individual entries in the FBLA address book would be entered into a: | cell. |
| When saving a Microsoft Access database as another file type, which ribbon contains an area of centralized tasks that are related to file management known as the backstage? | File tab |
| Matt needs to add his contacts to the Driver Education database. To do this quickly, what predefined object can he create? | Application Parts |
| Dennis needs to format the numbers in his database to three decimal places. Which number format would he use? | Fixed |
| Ashton needs to add a footer to the data entry form in his gaming database. Which view will allow Ashton to add a footer? | Design View |
| Tanya created a report to show people signed up for a 5K race. She needs to increase the size of the report header so she can add the race logo control. Which view will allow her to resize the header? | Design View |
| Tyler is using Microsoft Access for a class assignment. Which database object would she use to organize and display data pulled from tables and queries? | Report |
| Preston's form needs to display the tax on an order. Which type of control would allow Preston to display information that would change every day? | Calculated |
| Dean needs to add the FBLA logo to the top of his membership form. Which type of control should he use? | Unbound |
| Sally is the National Technical Honor Society president. She is creating a database to manage her membership information. What form tool could she use to quickly create a set of tabs a user could click to access forms and reports in the database? | Navigation Form |
| Margaret wants to send an address change to all the customers in her current database. She wants to create address labels to accomplish this. Which would she use? | Report |
| The manager of Doggie Donuts needs to group inventory by types of dog food in stock. He needs a subtotal for each group. Which query action will display this information? | Crosstab query |
| Juan is creating a chart that graphs attendance at FBLA State Leadership conferences from the past five years, which he has in a database. He wants to remove the y-axis value. Which tab in Chart Options would he select? | Axes |
| Rachel has spent a lot of time creating a membership database for her FBLA chapter, which she has been asked to share with other chapters in her region as an example. What would be the best method of sharing the structure of a database, including | Save as Database Template |
Created by:
5782256494