D100 Introduction to Spreadsheets - Set 5 - 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 of the following is the shortcut to open the "Format Cells" dialog box?

Ctrl + 1

Ctrl + 2

Alt + F

Shift + F11

Question 2: What does the VLOOKUP function do in Excel?

Looks up values in rows

Looks up values in columns

Calculates averages

Filters data

Question 3: What does the SUBTOTAL function in Excel do?

Sums the total of a range

Performs calculations like sum, average, count, etc., on visible cells

Multiplies values in a range

Returns the median of a range

Question 4: How do you protect a worksheet in Excel?

Use the Format Cells option

Use the Review tab and select "Protect Sheet"

Use the Data tab and select "Data Protection"

Use the Home tab and select "Protect"

Question 5: Which Excel function is used to count only cells that contain numbers?

COUNTA

COUNT

COUNTIF

COUNTBLANK

Question 6: What happens when you double-click the fill handle in Excel?

It fills the series down to the end of the data range

It clears the contents of the cell

It formats the selected range

It opens the Format Cells dialog box

Question 7: What is the main purpose of the PivotTable feature in Excel?

To filter data

To summarize and analyze large datasets

To create visual charts

To sort data alphabetically

Question 8: Which of the following error codes represents an invalid cell reference?

#NAME?

#REF!

#VALUE!

#NUM!

Question 9: How can you insert multiple rows at once in Excel?

Press Alt + R multiple times

Right-click and choose "Insert" after selecting multiple rows

Press Ctrl + I

Use the Fill Handle and drag down

Question 10: Which of the following is the correct syntax for the IF function?

IF(condition, value_if_true, value_if_false)

IF(condition, value_if_false, value_if_true)

IF(value_if_true, condition, value_if_false)

IF(condition, value_if_false)

Question 11: How do you apply a filter to a data range in Excel?

Use the "Data" tab and select "Filter"

Use the "Home" tab and select "Sort & Filter"

Right-click and select "Apply Filter"

Use the "View" tab and select "Data Filter"

Question 12: Which of the following features allows you to apply specific formatting based on cell values?

Conditional Formatting

Data Validation

Filter

Table Styles

Question 13: What is the main purpose of the “Goal Seek” feature in Excel?

To find an input value needed to reach a desired result

To filter large datasets

To calculate averages

To highlight data

Question 14: Which of the following is the shortcut for creating a new chart?

F11

Ctrl + Shift + C

Alt + C

Ctrl + Alt + F11

Question 15: How do you lock a specific cell to prevent it from changing when copying a formula?

Use relative cell references

Use absolute cell references with $

Use dynamic cell references

Press Ctrl + L

Question 16: What does the CONCATENATE function do in Excel?

Adds numbers

Joins text from multiple cells into one

Counts cells with text

Replaces text

Question 17: Which of the following is the correct formula to calculate the average of a range of cells A1?

=AVERAGE(A1)

=SUM(A1)

=MEDIAN(A1)

=AVG(A1)

Question 18: What does pressing Ctrl + Z do in Excel?

Redoes the last action

Undoes the last action

Copies the selected cell

Deletes the current row

Question 19: Which of the following functions is used to return the current date and time in Excel?

NOW()

TODAY()

TIME()

DATE()

Question 20: What does the term “cell range” refer to in Excel?

A single cell in a worksheet

A collection of adjacent cells

A chart in a worksheet

A filtered set of data

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