D100 Introduction to Spreadsheets - Set 3 - 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 key combination will you use to open the Find dialog box in Excel?

Ctrl + H

Ctrl + F

Ctrl + A

Ctrl + R

Question 2: What function will you use to calculate the future value of an investment based on periodic payments and a constant interest rate?

NPV

PMT

Question 3: What does the Excel function COUNTA do?

Counts only blank cells in a range

Counts non-empty cells in a range

Counts numbers in a range

Counts only text in a range

Question 4: Which Excel tool allows you to filter data based on specific criteria?

Sort

Data Validation

Filter

Goal Seek

Question 5: What is the function of the AutoFill feature in Excel?

Automatically adjusts column widths

Automatically fills a range with data based on patterns

Automatically applies conditional formatting

Automatically creates charts based on data

Question 6: How can you freeze the first row of a worksheet so it stays visible while scrolling?

Click on the View tab and select "Freeze Top Row"

Right-click the row and choose "Freeze"

Use the Data tab and select "Freeze Panes"

Use the Home tab to freeze the row

Question 7: Which of the following Excel functions calculates the largest value in a range?

MAX

MIN

SUM

AVERAGE

Question 8: Which function in Excel allows you to join the contents of two or more cells?

CONCAT

CONCATENATE

JOIN

MERGE

Question 9: What will be the result of the formula =A1+A2 if A1 contains 5 and A2 contains "3"?

Error

Question 10: What is the purpose of a PivotChart in Excel?

To display large amounts of data

To display visual representations of PivotTable data

To create interactive charts

To summarize complex formulas

Question 11: How do you apply a data validation rule to restrict the value in a cell to whole numbers only?

Use the Formula Auditing tool

Apply Conditional Formatting

Use Data Validation and select Whole Number

Use Goal Seek

Question 12: What is the default alignment of numbers in Excel?

Left

Right

Center

Justify

Question 13: How can you quickly delete all data in a worksheet without deleting the actual worksheet?

Right-click the worksheet and select Delete

Press Ctrl + A, then Delete

Click on Clear All under the Home tab

Use Data Validation

Question 14: Which function can be used to count the number of blank cells in a range?

COUNTBLANK

COUNTA

COUNT

BLANKCOUNT

Question 15: What is the purpose of the Goal Seek tool in Excel?

To perform complex data analysis

To find the required input value for a desired output

To perform calculations automatically

To create visual data representations

Question 16: How can you display all formulas in a worksheet at once?

Press Ctrl + `

Click on the Formula Auditing tool

Use the Trace Precedents feature

Use Conditional Formatting

Question 17: What is the function of the "TODAY" function in Excel?

It returns the current time

It returns the current date

It calculates the difference between two dates

It formats the date

Question 18: Which of the following Excel features allows you to check for inconsistencies in formulas?

Evaluate Formula

Trace Precedents

Conditional Formatting

Formula Auditing

Question 19: What type of chart would you use to compare the proportions of different categories in a dataset?

Line Chart

Pie Chart

Scatterplot

Bar Chart

Question 20: Which Excel function can be used to calculate the median of a range of numbers?

MEDIAN

AVERAGE

MODE

SUM

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