NEW
Font size
WorksheetsAdvance Excel Table Fills Reference
Total questions: 10
Worksheet time: 5mins
What is the main advantage of converting a range into an Excel Table?
It allows the use of macros
It enables structured references and automatic formatting
It increases file size
It removes all filters
When you add a new row in an Excel Table, formulas in that table:
Must be copied manually
Automatically extend to the new rowc
Disappear
Need reformatting
What does the Flash Fill feature in Excel do?
Copies data using a formula
Automatically fills in a pattern based on user examples
Formats text in uppercase
Fills sequential numbers
Which of the following is an example of Custom Fill Series?
1, 2, 3, 4, 5
Mon, Tue, Wed, Thu
HR001, HR002, HR003
10, 20, 30, 40
In Excel, a calculated column in a table means:
A column with manually entered values
A column where one formula is automatically applied to all rows
A column used for pivot tables only
A hidden column
The formula =[@Score]/[@[Hours Attended]] in a table uses:
Cell references
Structured references
Relative references
Mixed references
In Excel, the $ symbol in a cell reference indicates:
The cell is locked
The cell contains text
The cell has a function
The cell is hidden
Which of the following is an Absolute Reference?
A1
$A1
A$1
$A$1
You have a PF rate stored in cell G1 and want it to stay constant while copying formulas. Which reference type should be used?
Relative
Absolute
Mixed
Structured
The Freeze Panes feature in Excel is used to:
Protect the worksheet from editing
Keep headers visible while scrolling
Split data into multiple sheets
Save a file in another format
