Questions:
1. You can use the Name Manager dialog
box to view and manage named ranges,
including the _____, which indicates
where the named range is recognized.
a. scope
2. You can create a _____ to define what
data values are allowed in a cell.
a. validation rule
3. Which type of conditional formatting
rule would you create to add a
horizontal bar to a cell background,
where the length of the bar reflects the
value in the cell?
a. Data Bar
4. What is the default layout for a newly
created Pivot table?
a. Compact Form
5. What will you click on the Reports list
box in Solver Results dialog box to
produce an Answer Report?
a. Answer
12. Which box will you check after clicking
on a table and then selecting Table
Tools > Design, to add a total row to a
table?
a. Total Row
13. Where does Excel list the fields
available for a PivotTable?
a. in the PivotTable Fields pane
14. When you save a workbook as a
template, which of the following file
name extensions does Excel apply?
a. XLTX
15. When you freeze the top row of a
worksheet, what part of the worksheet
can you scroll?
a. all rows below the top row
16. What must you add to the Excel ribbon
before you can insert a form control or
create a macro?
a. Developer tab
