NEW
Font size
WorksheetsQUIZZ 2 week 2 (IT 11)
Total questions: 20
Worksheet time: 21mins
In which tab of the ribbon can you change Workbook Views to Page Break Preview?
Page Layout
Data
Review
View
what is the Annual Withholding Tax of an employee having a monthly salary of 12 thousand.
10,000
0
10
1,000
How much is your monthly contribution in the Philhealth Insurance Company if your monthly salary base is 20 thousand?
20,000
700
350
0
As a private employee, you were deducted by your payroll in-charge for the month of October an amount of 135.00 as your mandatory remittance. How much is your salary bracket?
5, 000
300
3,000
20,000
Employee A’s monthly salary is 13 thousand as Real Estate Agent and got a commission of 5,000 pesos this month. How much is his supposed to be duct ion for SSS? PHIC? and HDMF?
810,315,360
360,315,810
315,360,810
810, 360,315
An Excel Workbook is a collection of …….
Workbooks
Worksheets
Worksheets and Charts
Charts
In EXCEL, you can sum a large range of data by simply selecting a tool button called …..
AutoFill
Auto sum
Auto correct
Auto format
Microsoft Excel is powerful……….
Word processing package
DBMS package
Communication S/W Package
Spreadsheet package
How do you rearrange the data in ascending or descending order?
Data, Sort
Data, Form
Data, Table
Data Subtotals
What do you mean by a Workspace?
Group of Workbooks
Group of Rows
Group of Columns
Group of Worksheets
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
FACT ( )
ROUND ( )
MOD ( )
DIV ( )
Which is not the function of the "Edit, Clear" command?
Delete formats
Delete cells
Delete notes
Delete contents
If you choose a larger font size, the height of the row is automatically made taller.
True
false
Either True or False
can be true and can be false
Which button allows you to copy cell formats from one cell to another?
Format painter
Esc
Autofit
Enter
A_______ is a group of cells that form a rectangle on the screen.
Workbook
Worksheet
Column
Range
Multiple calculations can be made in a single formula using:
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Standard Tool Bar
Formula Bar
Which of the following is not a valid data type in Excel?
Character
Label
Date/Time
Number
Mr. ICT salary is 15,000 thousand monthly and a night differential of 500 plus over time of 1,300 for the month of December 2021. How much total deduction were you able to deduct for the month considering with all government mandatory deductions is applied. (like sss, philhealth, pag ibig, withholding tax and Cash advance of 300?) Solve the problem.
500
15,000
1.695
1300
Which of the following Excel features allows you to select/highlight all cells that are formulas?
Replace
Go To Special
Go To
Find
