Random Question
How do you merge cells?
What is Merge and Center Button.
How do you put the workbook in design mode
What is Developer tab and design mode button
How do yousave workbook
What is file tab save as group, downloads.
What does SUM do
What is adds all cells and returns the sum.
How do you make a PivotChart
What is Insert tab, PivotChart button.
How do you make a Pivot Table
What is Insert tab then PivotTable button
What are the two controls that can be inserted
What is Form controls and ActiveX controls.
How do you open a new workbook
What is File tab, New worksheet.
What does the IF function do
What is Checks if a condition is met
How do you insert a slicer
How do you check for errors in a formula
What is error checking/Formula auditing
How do you record a macro
What is record macro button and record steps
How do you check compatibility of a worksheet
What is File tab, Check for issues button, check compatibility.
How do you add or take away Field Headers
What is click PivotTable then Analyze Tab and then Field headers button.
What is Review Tab protect workbook and set password.
How do you assign a button a macro
What is design mode, click button, macros button and then assign macro
How do you mark workbook as final
What is file tab, protect workbook, mark as final
What does the MATCH function do
What is returns the relative position of the item in the array
How do you get information under the PivotTable
What is Drilling down/up
How do you get the solver Add-in
What is File tab, options group, add-ins button, Go button, Solver Add-in
List 2 Groups from the developer tab
What is Code or Add-ins or Controls or XML
How do you fit sheet on one page
What is file tab, print group, scaling button, fit sheet on one page.
How do you return the Serial Number
What is TODAY function.
What are the steps to making a relationship between field categories.
What is selecting the categories to make a relationship with, then inputting the type of relationship.