Trap Gang
Quack
Space Jam
Nose
Coke Boy
100
Which view enables a user to create or modify a worksheet while seeing how it will look in printed format? A. Page Layout B. Print C. Normal D. Web
What is A.Page Layout
100
283. Wendy wants to be able to see what her database report will look like without producing a hard copy. Which option would she choose? NCCTE.9_12.BE.BM20.2.06 RBT: A. Print preview B. Quick print C. Print D. Selected records
What is A.Print Preview
100
280. Which ribbon in layout view contains the commands to insert or delete new rows and columns in a report? NCCTE.9_12.BE.BM20.2.06 RBT: A. Report Layout Tools Design B. Report Layout Tools Arrange C. Report Layout Tools Format D. Report Layout Tools Page Setup
What is B.Report Layout Tools Arrange
100
327. Mrs. Wilson needs to create a report that lists students by their homeroom teacher. Each teacher needs a separate list for attendance. Which option would allow Mrs. Wilson to put students together by homeroom on separate sections of the report? NCCTE.9_12.BE.BM20.2.11 RBT: A. Sort B. Filter C. Conditional formatting D. Grouping
What is D.Grouping
100
302. Dean needs to add the FBLA logo to the top of his membership form. Which type of control should he use? NCCTE.9_12.BE.BM20.2.08 RBT: A. Bound B. Unbound C. Button D. Calculated
What is B.Unbound
200
274. You are employed as an assistant at Doggie Daycare. Your boss has asked you to update the new pet patient information. If you opened the form in Design View, which view should you switch to in order to enter patient information? NCCTE.9_12.BE.BM20.2.05 RBT: A. Layout View B. Form View C. Design View D. Report View
What is B.Form View
200
Joan has a table that includes demographic information about her employees. What does all the information about one employee represent? NCCTE.9_12.BE.BM20.1.01 RBT: A. Entry B. Workbook C. Row D. Column
What is C.Row
200
63. Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula? NCCTE.9_12.BE.BM20.1.05 RBT: A. Function Library B. Defined Names C. Formula Auditing D. Calculation
What is C.Formula Auditing
200
277. The report Jamie created has a dark background and the page number is not displaying correctly. Which formatting option would he apply to the page number to add contrast between the background and the page number? NCCTE.9_12.BE.BM20.2.06 RBT: A. Fill Color B. Font Size C. Font Color D. Format Painter
What is C.Font Color
200
229. What are three valid methods for saving a database in Microsoft Access? NCCTE.9_12.BE.BM20.2.02 RBT: A. Alt + S, File tab Save command, Quick Access Toolbar Save command B. Alt + S, Home Ribbon Save command, Quick Access Save command C. Alt + S, File tab Save command, Shortcut Save command D. Ctrl + S, File tab Save command, Quick Access Save command
What is D.Ctrl + S, File tab Save command, Quick Access Save command
300
227. Johnny has planned his baseball card database and determined a logical arrangement. What is his next step? NCCTE.9_12.BE.BM20.2.02 RBT: A. Determine what information to include B. Discuss the database with users C. Gather the information D. Input data
What is C.Gather Information
300
336. What action would Donna perform to create a new table named Customer Appreciation from the exisiting Customer Information table and Order History table? NCCTE.9_12.BE.BM20.2.12 RBT: A. delete query B. update query C. append query D. make table query
What is D.make table query
300
207. Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet? NCCTE.9_12.BE.BM20.1.13 RBT: A. Shapes B. Picture Cropping C. Screen Clipping D. Screenshot
What is C.Screen Clipping
300
. What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility? NCCTE.9_12.BE.BM20.1.01 RBT: A. Magnify Area B. Enlarge Selected Area C. Amplify Range D. Zoom to Selection
What is D.Zoom to Selection
300
310. Terry's form needs to display the FBLA member's exact age based on today's date and their birth date. Which type of control would allow Terry to display information that would change every day? NCCTE.9_12.BE.BM20.2.08 RBT: A. Bound B. Unbound C. Button D. Calculated
What is D.Calculated
400
313. Carol has created a table from her database to see all information about FBLA chapters in her region. She needs to know the mean number of active members in the region. Which aggregate function should she use? NCCTE.9_12.BE.BM20.2.09 RBT: A. Count B. Max C. Min D. Average
What is D.Average
400
17. Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell? NCCTE.9_12.BE.BM20.1.01 RBT: A. Cell box B. Address box C. Name box D. Formula box
What is C.Name Box
400
98. Curt wants to search his CD collection database for the names of the albums from his favorite artist that were released after 2010. What object should Curt create and save to obtain this information most efficiently? NCCTE.9_12.BE.BM20.2.07 RBT: A. Filter B. Table C. Query D. Report
What is C.Query
400
335. John wants to create a query that will display the total number of hamburger patties in stock at two different locations. The results should display the sum of the values from each location. Which solution should John use for his query? NCCTE.9_12.BE.BM20.2.12 RBT: A. Crosstab Query B. Expression Builder C. Simple Query D. Totals
What is B.Expression Builder
400
105. Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel? NCCTE.9_12.BE.BM20.1.07 RBT: A. Home B. Page Layout C. Data D. View
What is B.Page Layout
500
326. Which type of operation performs mathematical functions, such as MAX, MIN, or COUNT, on a group of records? NCCTE.9_12.BE.BM20.2.11 RBT: A. Statistical B. Geometric C. Aggregate D. Algebraic
What is C.Aggregate
500
319. 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? NCCTE.9_12.BE.BM20.2.10 RBT: A. Form View B. Layout View C. Design View D. Navigation Form
What is D.Navigation Form
500
316. Carol has created a table from her database to see all information about FBLA chapters in her region. She needs to know which chapter has the most active members in the region. Which aggregate function should she use? NCCTE.9_12.BE.BM20.2.09 RBT: A. Count B. Max C. Min D. Average
What is B.Max
500
333. What type of query enables a user to add the results of a query to an existing table in a database? NCCTE.9_12.BE.BM20.2.12 RBT: A. Update B. Append C. Action D. Make table
What is B.Append
500
309. Which group on the Form Design Tools Arrange Ribbon allows the user to align to grid? NCCTE.9_12.BE.BM20.2.08 RBT: A. Merge/Split B. Move C. Position D. Sizing & Ordering
What is D.Sizing and Ordering
M
e
n
u