A circular reference in Excel is
Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous
Correct answer is C
A circular reference occurs when a formula directly or indirectly refers to its own cell. This causes the formula to use its result in the calculation, which can create errors.
You can convert existing excel worksheet data and charts to a HTML document by using
FTP wizard
Internet assistant wizard
Intranet wizard
Import wizard
Correct answer is B
The Internet Assistant for Excel is an add-in wizard that allows you to create and distribute Excel documents online for viewing with any popular browser. The Internet Assistant helps you convert your spreadsheet data to HTML format. It is designed for the 1997 and earlier versions of Excel.
You can use the formula palette in Excel to
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
Correct answer is B
No explanation has been provided for this answer.
When you link data maintained in an excel workbook to a word document
The word document cannot be edited
The word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data
Correct answer is B
No explanation has been provided for this answer.
In an Excel worksheet, you can select
The entire worksheet
Rows
Columns
All of the above
Correct answer is D
No explanation has been provided for this answer.
Aptitude Tests
Latest Jobs
Indorama Eleme Fertilizer & Chemicals Limited (IEFCL) Graduate Engineer Internship Program 2024
Diploma Engineer Internship Program at Indorama Eleme Fertilizer & Chemicals Limited (IEFCL)
Admin Officer - Airline Industry at Ascentech Services Limited
Area Sales Manager at Airtel Nigeria
State Business Manager at Airtel Nigeria
Inventory Manager at a Reputable Agricultural Company
Supply Chain Officer at Kellogg's Tolaram Nigeria Limited (KTNL)
Warehouse Manager at Shulifang Biotechnology FZE
Capability Development & Execution Excellence Manager (Rivers) at Airtel Nigeria
Regional Security Manager - Northeast Region at Airtel Nigeria
