D100 Introduction to Spreadsheets - Set 4 - 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 TRIM function in Excel?

To cut the contents of a cell

To remove all spaces from text

To remove extra spaces from text except for single spaces between words

To format text to uppercase

Question 22: How can you quickly duplicate a worksheet in Excel?

Right-click the sheet tab and select Duplicate

Press Ctrl + C and then Ctrl + V

Press Alt + D

Hold Ctrl and drag the sheet tab

Question 23: Which of the following formulas returns the current date and time?

NOW()

TODAY()

DATE()

TIME()

Question 24: How do you open the Find and Replace feature in Excel?

Ctrl + F

Ctrl + H

Ctrl + Shift + F

Alt + F

Question 25: What is the shortcut for hiding a row in Excel?

Ctrl + Shift + 9

Ctrl + 9

Alt + 9

Ctrl + Shift + H

Question 26: Which of the following functions would you use to find the smallest number in a range?

MIN

MAX

SMALL

RANK

Question 27: What does the LEN function do in Excel?

Returns the length of text in characters

Counts the number of words in a cell

Measures the size of a worksheet

Calculates a sum based on text

Question 28: What is the shortcut to open a new workbook in Excel?

Ctrl + O

Ctrl + W

Ctrl + N

Alt + N

Question 29: Which of the following Excel features allows you to perform what-if analysis?

Data Validation

Conditional Formatting

Scenario Manager

Data Filter

Question 30: What is the default number of sheets in a new Excel workbook?

Question 31: How do you insert a new row in Excel?

Ctrl + Shift + + (Plus)

Ctrl + R

Alt + R

Shift + F10

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

Multiplies two numbers

Adds up a range of numbers

Returns one value if a condition is true and another if false

Divides two numbers

Question 33: How do you clear all the formatting in a cell?

Use the Clear All option

Use the Format Painter

Right-click and select Remove Formatting

Press Alt + R

Question 34: What is the purpose of the CONCATENATE function in Excel?

To add two cells together

To combine text from multiple cells into one

To apply conditional formatting to text

To count characters in a cell

Question 35: What does Ctrl + D do in Excel?

Deletes the selected cell

Duplicates the worksheet

Fills the cell below with the content of the current cell

Opens the Developer tab

Question 36: Which of the following functions returns the highest value in a range?

SUM

MAX

MIN

COUNT

Question 37: What does the ISBLANK function do in Excel?

Checks if a cell is empty

Checks if a cell contains a number

Checks if a cell contains text

Checks if a cell contains an error

Question 38: How do you copy the contents of a cell to the clipboard in Excel?

Press Ctrl + C

Press Ctrl + V

Press Ctrl + Shift + C

Press Alt + C

Question 39: Which of the following features enables you to view two parts of a worksheet at once?

Freeze Panes

Split

Merge

Group

Question 40: What is the shortcut for opening the Print dialog in Excel?

Ctrl + P

Ctrl + O

Ctrl + Shift + P

Alt + P

Don't Want to Study?

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

Get Exam Support