D100 Introduction to Spreadsheets - Set 3 - 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: How can you force a formula to calculate the product of two ranges of numbers?

Use the MULTIPLY function

Use the PRODUCT function

Use the SUM function

Use the MULT function

Question 22: Which of the following tools allows you to track changes made by multiple users in a workbook?

Track Changes

Goal Seek

Data Validation

Protect Sheet

Question 23: What happens when you press Ctrl + Shift + L in Excel?

Applies a filter to the selected data

Locks the selected cells

Deletes the active worksheet

Toggles the gridlines

Question 24: Which of the following is the keyboard shortcut to insert a new row in Excel?

Ctrl + Shift + +

Alt + R

Ctrl + +

Ctrl + Shift + T

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

To truncate decimal values

To round numbers to a specified number of decimal places

To generate random numbers

To change the format of a cell

Question 26: Which of the following functions would you use to find the number of cells in a range that meet a certain condition?

COUNT

COUNTA

COUNTIF

COUNTBLANK

Question 27: Which of the following is NOT a function related to text manipulation in Excel?

LEFT

TEXT

PROPER

MEAN

Question 28: How can you enable editing in a cell without using the mouse?

Press F2

Press F4

Press Ctrl + E

Press Alt + E

Question 29: What is the result of the formula =SUM(3,5,8,-2)?

Question 30: Which of the following is NOT an Excel error message?

#VALUE!

#NAME?

#DIV/0!

#INVALID!

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

Use the Name Box next to the formula bar

Right-click and choose "Name Range"

Use the Format tab

Go to Data Validation

Question 32: Which of the following tools allows you to highlight cells that meet a specific condition?

Trace Precedents

Conditional Formatting

Data Validation

Goal Seek

Question 33: What does the HLOOKUP function do in Excel?

Searches for a value in the top row of a table

Searches for a value in the left column of a table

Looks for a specific value across multiple sheets

Compares two sets of data

Question 34: What happens if you press Ctrl + Home in Excel?

Moves the cursor to the last cell with data

Selects the first row

Moves the cursor to cell A1

Highlights the active cell

Question 35: Which of the following is a valid argument for the VLOOKUP function?

Table_Array

Row_Index_Number

Match_Type

Start_Value

Question 36: What is the purpose of the IFERROR function?

To return the number of errors in a range

To return a custom result if a formula generates an error

To fix errors in a formula

To display formulas with errors

Question 37: How can you quickly select an entire row in Excel?

Click the row number

Press Ctrl + A

Press Shift + R

Press Ctrl + Shift + R

Question 38: What function would you use to find the most frequently occurring value in a dataset?

MEDIAN

MODE

AVERAGE

MIN

Question 39: Which of the following is the shortcut to insert the current time in Excel?

Ctrl + Shift + ;

Ctrl + ;

Ctrl + T

Ctrl + Shift + T

Question 40: What is the purpose of the RANK function?

To sort a range of values in ascending order

To return the rank of a number within a list of numbers

To find the highest value in a range

To calculate the sum of a list of numbers

Don't Want to Study?

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

Get Exam Support