D100 Introduction to Spreadsheets - Set 5 - Part 3

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

Question 41: How do you insert a new worksheet in Excel?

Press Shift + F11

Press Ctrl + N

Press Alt + W

Press Ctrl + Shift + N

Question 42: What does pressing Ctrl + A do in Excel?

Selects the entire worksheet

Opens the "Save As" dialog box

Copies the current cell

Highlights the active row

Question 43: What does the COUNTA function do in Excel?

Counts non-empty cells

Counts cells with numbers only

Adds up all numbers in a range

Subtracts values in a range

Question 44: How do you apply borders to a selected range of cells in Excel?

Use the Home tab and select Borders

Use the Insert tab and select Borders

Right-click and select Apply Borders

Press Ctrl + B

Question 45: Which of the following tools is used to track changes made to a workbook?

Track Changes

Version History

Watch Window

PivotTable

Question 46: What is the shortcut for selecting the entire column in Excel?

Ctrl + Space

Shift + Space

Ctrl + Shift + C

Alt + Space

Question 47: Which of the following is the purpose of the CHOOSE function in Excel?

Selects a value from a list based on an index number

Sorts data in a specific order

Finds and replaces text

Selects multiple cells at once

Question 48: What does the CLEAN function do in Excel?

Removes all non-printable characters from text

Cleans up formatting in a cell

Removes duplicates from a range

Clears cell contents

Question 49: How do you delete multiple worksheets at once in Excel?

Hold down Ctrl, select the sheets, right-click, and choose Delete

Press Shift + Del

Press Ctrl + D

Use the View tab and select "Delete Sheets"

Question 50: What does the LARGE function do in Excel?

Returns the k-th largest value in a data set

Returns the maximum value in a range

Calculates the sum of all numbers in a range

Multiplies the largest values in a range

Congratulations! You have completed all 5 question sets. Good job!

Go Back to Home

Struggling With Exams?

Less Time Studying, More Time Living – Finish Your Degree Faster! Pay-After-you-Pass!

Get Exam Support