D100 Introduction to Spreadsheets - Set 1 - 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 is the path to the 'Protect Sheet' button in Excel?

REVIEW tab

HOME tab

INSERT tab

VIEW tab

Question 42: How do you hide a worksheet in Excel?

Click Hide in the shortcut menu

Use the Insert menu

Click Remove Worksheet in the tab options

Delete the worksheet

Question 43: What is a reference to a cell or range of cells in another workbook called?

External reference

Named range

Data link

External cell

Question 44: Which function is used when a table is organized horizontally in Excel?

VLOOKUP

HLOOKUP

INDEX

MATCH

Question 45: Which function is most commonly used in vertical tables?

HLOOKUP

INDEX

MATCH

VLOOKUP

Question 46: What type of formatting allows you to apply rules based on cell values?

Table formatting

Conditional formatting

Data validation

Rule formatting

Question 47: What do you call the left column values in a table array used for VLOOKUP?

Table headers

Table fields

Table arguments

Lookup values

Question 48: What is the path to the 'Total Row' check box for tables?

TABLE TOOLS DESIGN tab

HOME tab

INSERT tab

PAGE LAYOUT tab

Question 49: How is data arranged when it is in ascending sequence?

Highest to lowest

A-Z

Z-A

By size

Question 50: What is the path to the Format Painter button in Excel?

HOME tab

INSERT tab

DATA tab

VIEW tab

Struggling With Exams?

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

Get Exam Support