Font size
WorksheetsLinking Spreadsheet Data
Total questions: 17
Worksheet time: 14mins
What menu option is used to invoke the Insert Sheet dialog?
Insert menu
View menu
Edit menu
File menu
How is cell G5 of a sheet named My Sheet referenced?
$G5 in My Sheet
$My Sheet.G5
$G5!My Sheet
$My Sheet:G5
How many forward slashes are typically in a file path?
four
three
two
1
What feature allows you to jump to a different spreadsheet in LibreOffice Calc?
Macro
Connect
Hyperlink
Sheet tabs
A relative hyperlink stores the location with respect to the (a) location.
While inserting tables from a webpage (a) selects the entire HTML document.
What is the file extension for LibreOffice Calc?
(a)
What are used to enclose sheet names as there might be a space within sheet names?
(a)
The From file option of the (a) dialog box allows to insert sheet from another file.
A sheet can only be added before the current sheet.
True
False
If ‘sales’ sheet has a reference to ‘cost’ sheet then any changes made to ‘cost’ sheet will be reflected in the sales sheet as well.
True
False
It is not possible to link a sheet as a reference in another sheet.
False
True
We can insert data from a table created on a web page into a spreadsheet.
True
False
A hyperlink once created on a sheet cannot be deleted.
True
False
Name the two ways to link the sheets in a LibreOffice Calc.
By cell references
e.g. 'Sheet2'.A1 or 'My Sheet'.G5.
By hyperlinks or by using the “Link to external data”
I dont know
the two ways to link the sheets in a LibreOffice Calc are by:
(a)
Differentiate between Relative and Absolute Hyperlink.
no full path
URL without protocol
URL with protocol
full file path
