NEW
Font size
WorksheetsExcel Workshop with Mr Elen
Total questions: 10
Worksheet time: 5mins
Which is used to perform what if analysis?
Solver
Goal Seek
Scenario Manger
All of the above
You can insert hyperlink (Ctrl + K) on
Text
Pictures
Shapes
All of the above
Which area in Microsoft Excel window allow the values and formulas to be entered?
Title Bar
Quick Access Toolbar
Formula Bar
_____ appear at bottom of the Excel window.
Title Bar
Formula Bar
Work sheet tabs
Name box
What is the use of Ctrl + K ?
To copy and paste
To move to a different file
To sort data
To filter data
What is the use of Ctrl + Shift + L ?
To sort data
To filter data
A and B
None of the above
How to create drop down list?
Data > Data Validation
View > Freeze Pane
Insert > Pivot Table
None of the above
What is the use of Pivot Table?
To summarise data
To filter data
In Excel, Columns are labelled as ____.
A, B, C, etc
1, 2, 3, etc
A1, A2, A3, etc
$A$1, $A$2, etc
In Excel, Rows are labelled as _____.
A, B, C, etc
1, 2, 3, etc
A1, A2, A3, etc
$A$1, $A$2, etc
