D100 Introduction to Spreadsheets - Set 5 - Part 2

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

Question 21: What is the purpose of the HLOOKUP function in Excel?

Looks up values in columns

Looks up values in rows

Filters data by criteria

Replaces text in a cell

Question 22: Which of the following is a valid Excel formula?

=SUM(A1, B2, C3)

=SUM(A1; B2; C3)

SUM(A1 + B2 + C3)

SUM = (A1, B2, C3)

Question 23: Which of the following tools helps visualize data in Excel?

PivotTable

PivotChart

Goal Seek

Freeze Panes

Question 24: How do you group rows or columns in Excel?

Use the Data tab and select "Group"

Use the View tab and select "Group Rows"

Right-click and select "Group Columns"

Press Ctrl + G

Question 25: What is the purpose of the TEXT function in Excel?

Converts numbers to text in a specific format

Converts text to numbers

Removes spaces from text

Splits text into different columns

Question 26: Which of the following is the shortcut to insert the current date in Excel?

Ctrl + D

Ctrl + Shift + ; (semicolon)

Ctrl + ; (semicolon)

Alt + D

Question 27: What is the purpose of the FIND function in Excel?

Searches for a text string within another text string

Returns the first numeric value in a range

Calculates the sum of all numbers

Filters rows based on criteria

Question 28: How do you remove gridlines from a worksheet in Excel?

Use the View tab and uncheck the "Gridlines" box

Use the Home tab and uncheck "Show Gridlines"

Press Ctrl + Shift + G

Use the Insert tab and select "Remove Gridlines"

Question 29: What does the MATCH function do in Excel?

Finds the relative position of a value in a range

Returns the sum of a range

Joins multiple text values

Divides a range by a number

Question 30: How do you create a named range in Excel?

Use the Formula tab and select "Define Name"

Right-click and select "Name Range"

Use the Data tab and select "Create Range"

Use the Home tab and select "Format Range"

Question 31: What is the shortcut for switching between worksheets in Excel?

Ctrl + Tab

Alt + Tab

Ctrl + Page Up/Page Down

Shift + F11

Question 32: What does the LEFT function do in Excel?

Trims spaces from text

Extracts a substring from the beginning of a text string

Finds text in a cell

Joins text from two cells

Question 33: What is the purpose of the OFFSET function in Excel?

Returns a reference to a range offset from a given reference

Counts cells with numbers

Sums a range of cells

Filters data based on a condition

Question 34: How do you create a drop-down list in Excel?

Use Data Validation and select List

Use the Home tab and select Create List

Use the Insert tab and select Drop-down

Press Ctrl + Shift + D

Question 35: What is the purpose of the SUBSTITUTE function in Excel?

Replaces text in a string with another text

Joins text strings together

Converts text to uppercase

Sorts text in alphabetical order

Question 36: What does the MID function do in Excel?

Extracts a substring from the middle of a text string

Returns the midpoint of a range

Finds a text string in a cell

Divides a text string into two parts

Question 37: What is the correct formula to calculate the square root of a number in Excel?

=SQRT(number)

=SQR(number)

=ROOT(number)

=POWER(number, 0.5)

Question 38: How do you remove all formulas from a worksheet while keeping the results?

Copy and paste values only

Use the "Clear All" feature

Use the Data tab and select "Remove Formulas"

Press Alt + F11

Question 39: Which of the following is the correct function to return the remainder of a division in Excel?

MOD

DIV

QUOTIENT

REMAINDER

Question 40: What is the purpose of the INDIRECT function in Excel?

Returns the reference specified by a text string

Directs to a specific cell reference

Joins text from two different cells

Filters data based on criteria

Don't Want to Study?

Save Time on Studies, Spend More with Family & Friends! Pay-After-you-Pass!

Get Exam Support