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
ExAc ReviewQuiz-3
| Question | Answer |
|---|---|
| What feature was created for users who prefer to use the keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with the ALT key? | Key Tips |
| Which area on the left side of the formula bar indicates the cell address of a selected cell? | Name box |
| Sharon’s spreadsheet contains information about the number of music downloads in F25. In this address, ‘25’ identifies the: | Row |
| 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 |
| Which term describes the blank portions of a page that fall outside the main body of the printed document? | Margins |
| 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 |
| Dorothy designed a column chart and would like to add an element that will help lead the eye and improve readability of the chart. Which chart feature should she include? | Gridlines |
| What can you use to easily filter pivot tables and cube functions interactively in a worksheet? | Slicer |
| 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 |
| 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 |
| Sam completed a query on the UNC School system and wants to narrow his search to find which schools have a maximum tuition of $15,000 for in-state students. Which operator would he use? | <> |
| 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 |
| 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 |
| 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 relevant | Save as Database Template |
Created by:
1642804