WorksheetsSPREADSHEET
Total questions: 6
Worksheet time: 3mins
Name
Class
Date
1.
Which of the following is the correct statement for Macro?
a)
A Macros are created and written using C language.
b)
B Macros are templates for various kinds of worksheet
c)
C You can record a macro in Excel to perform calculations.
d)
D Once you click recording macro, the macro will record all your movements orvoices.
2.
Microsoft Excel has a protection feature that allows users to protect the worksheet from
a)
A viruses
b)
B changes
c)
illegal copies
d)
being corrupts
3.
The spreadsheet feature that blocks users from modifying or erasing information in aworksheet is called
a)
A lock.
b)
B shield
c)
C blocker
d)
D protection
4.
What is the function of Macro?
a)
A Returning a value from the same table.
b)
B Solving tasks that contain lengthy lists.
c)
C Making use of shortcut keys.
d)
D Automating complex tasks and reducing the number of steps required tocomplete tasks that are performed frequently
5.
Which of the following answer is the correct statement about Pivot Table?
a)
A It allows the user to summarize lengthy lists using complex criteria.
b)
B It allows you to take any value entered into a designated table and return avalue from that same table
c)
C It allows information protected from being lost.
d)
D It allows you to store series of commands and use a single command.
6.
A complex criterion in pivot table is best referring to
a)
A each piece of information contained in a row.
b)
B each piece of information contained in a column
c)
C each piece of data that summarizes multiple information
d)
D each column or field in source data that summarizes multiple rows ofinformation
100 %
