To help organize and identify Microsoft Excel files by provided details about the files, which of the following would you use?
What is Document Properties
100
Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?
What is Design
100
What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
What is Copy using the Fill Handle
100
Which view displays the area used to create a table or to modify the structure of the table?
What is Design
100
Which ribbon in layout view contains the commands to insert or delete new rows and columns in a report?
What is Report Layout Tools Arrange
200
Carl notices that he data in cell E3 reads #######. What command could Carl choose to correct his problem?
What is AutoFit
200
What can you use to easily filter PivotTables and cube functions interactively in a worksheet?
What is Slicer
200
When copying values in Microsoft Excel, which feature automatically adjust cell references for the new copy location?
What is Relative Reference
200
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?
What is Form View
200
After a query is created, which action must take place to display the results of the query?
What is Run
300
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
What is Sheet Options
300
Which command on the Insert Ribbons enables a user to insert a picture of a program window into a worksheet?
What is Screenshot
300
Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
What is Calcuation
300
What is the purpose of the primary key in a database?
What is Unique Identifier
300
Dean needs to add the FBLA logo at the top of his membership form. Which type of control should he use?
What is Unbound
400
What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
What is String
400
Ken has inserted a picture into his spreadsheet and would like it to standout which a frame or 3D effect. Which tool would he use to achieve this?
What is Picture Styles
400
IF, AND, OR, and NOT are all part of which category of functions?
What is Logical
400
Susie has a relational database for her catering business. She wants to create a form which shows the customer information at the top and any orders for that customer at the bottom. The orders section of the form is a:
What is Subform
400
Which type of operations performs mathematical functions, such as MAX, MIN, or COUNT on a group of records?
What is Aggregate
500
What is the process of bringing data containing text fields separated by commons into Excel called?
What is Importing Data
500
Ken has inserted a picture into his spreadsheet that was taken with a low-quality camera. Which tool would allow him to sharpen the image?
What is Corrections
500
Jessica needs to capitalize the first letter in each word. Which functions would she use?
What is Proper
500
Which type of field enables a user to select from a list of values when updating the contents of a field?
What is Lookup
500
What type of query enables a user to add the results of a query to an existing table in a database?