D100 Introduction to Spreadsheets - Set 4 - 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: What does the RANK function do in Excel?

Sorts values in ascending order

Calculates the position of a number in a list

Returns the median of a range

Adds all numbers in a list

Question 42: How do you toggle between displaying formulas and values in Excel?

Press Ctrl + ` (grave accent)

Press Ctrl + Shift + F

Press Alt + F9

Press Ctrl + Alt + F

Question 43: What is the purpose of Data Validation in Excel?

To filter data based on criteria

To restrict the type of data that can be entered in a cell

To format data based on conditions

To hide rows that do not meet certain criteria

Question 44: Which Excel function would you use to count cells that meet a specific condition?

COUNT

COUNTIF

COUNTA

SUM

Question 45: What is the purpose of conditional formatting in Excel?

To apply consistent formatting across all cells

To highlight cells that meet specific criteria

To automatically adjust column widths

To convert data into a chart

Question 46: How do you remove duplicates in a dataset in Excel?

Use the Remove Duplicates feature in the Data tab

Press Ctrl + Shift + D

Use the Filter feature in the Data tab

Right-click and select Delete Duplicates

Question 47: How do you insert a column chart in Excel?

Use the Insert tab and select Column Chart

Press Ctrl + Shift + C

Use the Home tab and select Insert Chart

Right-click the worksheet and choose Insert Column Chart

Question 48: What is the shortcut for selecting an entire row in Excel?

Shift + Space

Ctrl + Space

Alt + Space

Ctrl + Shift + Space

Question 49: Which of the following is a use of the SUMIF function?

To sum numbers based on a condition

To count cells that contain a specific value

To multiply values based on a condition

To return the largest value in a range

Question 50: What is the default alignment for text in Excel?

Center

Right

Left

Justified

Struggling With Exams?

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

Get Exam Support