Pass Any OA Exam Now & Pay After You Pass. Contact Us!

D100 Introduction to Spreadsheets - Set 1 - Part 1

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 1: Which tab contains the Zoom button in Excel?

Question 2: Where can you find the Goal Seek button in Excel?

Question 3: What is an interactive view of worksheet data in Excel called?

Question 4: What type of report is a visual representation of PivotTables?

Question 5: What describes how a value changes over time or the relationship between two variables?

Question 6: Which chart cannot have a trendline added to it?

Question 7: What is the value that measures the strength of a trend and ranges from 0 to 1?

Question 8: Where can you find the Move Chart button in Excel?

Question 9: In a PivotTable, what do data fields correspond to?

Question 10: Which tab contains the PivotTable button in Excel?

Question 11: What does the Report Layout button allow you to modify?

Question 12: What summary function estimates the standard deviation of all data in a PivotTable?

Question 13: Which summary function finds the smallest data value in a PivotTable?

Question 14: Where can you find the Field List button in a PivotTable?

Question 15: What are visual filters that make PivotCharts and PivotTables easier to interpret called?

Question 16: How do you connect Slicers to multiple PivotTables?

Question 17: Which tab allows you to change the height of a Slicer?

Question 18: What type of PivotTable is constantly updated as data changes?

Question 19: Which function allows you to examine which cells are referenced by formulas?

Question 20: What Excel tool allows you to specify up to 200 cells to adjust to solve a problem?


Complete the Captcha to view next question set.

Need Guaranteed Results?

Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support