Multiple Choice
Top Bottom Rules
A) is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.
B) moves the data from the top of the workbook to the bottom for analysis.
C) highlight cells meeting specified criteria with a specified color, font, or border.
D) format cells based upon their value in relation to the value of other cells such as the top 10%.
Correct Answer:
Verified
Correct Answer:
Verified
Q5: You can sort data by one or
Q6: The Table Style Options Group<br>A) enables you
Q7: To create a table from an existing
Q8: Filtering<br>A) helps to clean the data before
Q9: Previewing the worksheet in Backstage view<br>A) autoprints<br>B)
Q11: Freezing keeps rows and / or columns
Q12: The Table Style _ group contains check
Q13: A _ area defines the range of
Q14: Plan the fields for a table carefully
Q15: When you no longer need conditional formatting,