D100 Introduction to Spreadsheets - Set 4 - Part 1

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

Question 1: What does the CONCAT function do in Excel?

Combines text from multiple cells into one

Adds numbers from multiple cells

Multiplies the values in two cells

Replaces text within a cell

Question 2: What is the shortcut for saving a workbook in Excel?

Ctrl + S

Ctrl + P

Ctrl + T

Ctrl + C

Question 3: Which of the following functions returns the current date in Excel?

TODAY()

DATE()

NOW()

TIME()

Question 4: How do you quickly switch to the next worksheet in Excel?

Press Ctrl + Tab

Press Ctrl + Page Down

Press Shift + Tab

Press Alt + N

Question 5: Which chart type is best for showing parts of a whole?

Line Chart

Bar Chart

Pie Chart

Scatter Chart

Question 6: What does the MAX function do in Excel?

Returns the highest value in a range

Returns the average value in a range

Returns the lowest value in a range

Returns the sum of values in a range

Question 7: What is the purpose of the Fill Handle in Excel?

It copies the content and formatting of a cell

It formats a range of cells automatically

It extends a series or copies content to adjacent cells

It deletes a selected range

Question 8: Which of the following functions can you use to return the current day of the week in Excel?

WEEKDAY()

TODAY()

DAY()

DATE()

Question 9: What is the default file extension for Excel workbooks?

.xls

.xlsx

.csv

.txt

Question 10: How do you create a comment in an Excel cell?

Right-click the cell and choose “Insert Comment”

Use the “Insert” tab and select “Add Comment”

Use the Review tab and select “New Comment”

Press Ctrl + Shift + C

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

Counts all the blank cells in a range

Counts all the non-blank cells in a range

Adds up the numerical values in a range

Counts the number of rows in a range

Question 12: What is a Sparkline in Excel?

A mini chart displayed inside a single cell

A feature to highlight data trends

A type of formula to calculate totals

A tool for drawing a line graph

Question 13: Which of the following functions calculates the number of years between two dates in Excel?

YEARFRAC()

DATEDIF()

DAYS()

YEAR()

Question 14: How do you merge two or more cells in Excel?

Use the Format Painter

Use the Merge & Center option on the Home tab

Press Ctrl + M

Right-click and select "Merge"

Question 15: What is the shortcut to insert a new worksheet in Excel?

Ctrl + N

Shift + F11

Ctrl + W

Ctrl + Shift + N

Question 16: What does the ROUND function do in Excel?

Returns the largest integer less than or equal to a number

Returns the nearest integer

Rounds a number to a specified number of digits

Multiplies a value by 10

Question 17: Which of the following error messages indicates a divide-by-zero error?

#DIV/0!

#VALUE!

#NAME?

#REF!

Question 18: How can you convert text to columns in Excel?

Use the “Text to Columns” feature in the Data tab

Use the Merge & Center tool

Use the Format Painter

Use the Review tab

Question 19: What is the result of the formula =AVERAGE(10, 20, 30)?

Question 20: What is the purpose of Freeze Panes in Excel?

To save a workbook

To lock certain rows or columns in place

To protect a worksheet from edits

To filter a dataset

Need Guaranteed Results?

Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support