D100 Introduction to Spreadsheets - Set 3 - 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 can you quickly adjust the width of a column to fit its content?

Double-click the right edge of the column header

Right-click and select "Fit to Content"

Press Ctrl + W

Use the Format Painter

Question 42: Which of the following functions can be used to calculate monthly loan payments in Excel?

PMT

SUM

Question 43: What is the purpose of the LEN function in Excel?

To count the number of cells in a range

To calculate the length of a string of text

To calculate the length of a range of values

To remove extra spaces from text

Question 44: Which of the following will you use to restrict user input in a cell to only predefined values?

Data Validation

Conditional Formatting

Trace Dependents

Protect Sheet

Question 45: Which function allows you to retrieve data from multiple worksheets at once?

INDIRECT

VLOOKUP

SUMIF

MULTIREF

Question 46: How do you switch between different open workbooks in Excel?

Press Alt + Tab

Press Ctrl + Tab

Press Shift + Tab

Press Ctrl + Shift + Tab

Question 47: What is the result of the formula =ROUND(15.75, 0)?

15.8

Question 48: Which function calculates the internal rate of return for a series of cash flows in Excel?

IRR

RATE

Question 49: How can you quickly copy the formatting of a cell to another cell in Excel?

Use the Format Painter tool

Press Ctrl + Shift + C

Use Data Validation

Press Alt + C

Question 50: Which of the following will you use to create a summary of a dataset with totals and averages?

PivotTable

Data Validation

Conditional Formatting

Filter

Struggling With Exams?

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

Get Exam Support