NEW
Font size
WorksheetsBBA(BPM) 2 sessional
Total questions: 20
Worksheet time: 9mins
Identify the formula for
VLOOKUP
=VLOOKUP(table_array, lookup_value, col_index_num, [range_lookup])
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
=VLOOKUP(table_array, col_index_num, lookup_value,[range_lookup])
=VLOOKUP(lookup_value, table_array, [range_lookup], col_index_num)
Identify the formula for
INDEX
=INDEX(array, row_num, [column_num])
=INDEX(row_num, array, [column_num])
=INDEX( [column_num], row_num, array)
=INDEX(array, [column_num], row_num)
Which feature enables you to create custom tabs and groups?
A. ribbon
B. Quick Access Toolbar
C. view
D. Tab
_________ function displays the current date.
=DATE( )
=DAY( )
=TODAY( )
=TODATE( )
$A5 is a/an ________ reference.
Relative
Absolute
Mixed
All of the above
Every cell has a name called its ______
address
range
value
function
To see all the rows again after applying Filter, click ____________command.
delete
clear
back
None of these
What can't you do with google forms?
Create a pop quiz
Manage event registrations
Create a presentation
Collect email addresses for a newsletter
To select as many options as they like, what question type should be used?
Multiple choice
Checkboxes
Dropdown
Linear Scale
What is the type of this question?
Multiple choice grid
Checkboxes
Linear scale
Multiple choice
We can add video to a form
True
False
______________ contains the text that is to be sent to the recipients.
Main Document
Data Source
Merge field
What is/are main step(s) involved in mail merge process?
Creating Main Document
Creating Data Source
Merging main document and Data source
All the above
None of these
Default document type used to create formal letters
Letters
Directory
E-mail messages
Which icon represents Power Point?
Google Docs is a
Word Processor
Spreadsheet Application
Presentation Tool
