ICF
Directions: Read the questions carefully. Encircle the letter of the correct
answer. (This will serve as your answer sheet). Dinhi kamo pag-answer.
1.
Which of the following command used to create a duplicate copy of the
workbook?
A. Save
B. Save As
C. New
D. Open
2. Ana is creating a new workbook file and wants it to be saved in her computer
for her future use. What saving command is applicable to use?
A. Save B. Save As
C. Close
D. New
3. Which of the following is an equation that calculates a value?
A. Time B. Formula
C. Data
D. Date
4. The following are ways of encoding formulas in excel EXCEPT one.
A. Press F2
C. Copy/fill a formula with values from another cell
geB. Use point and click D. typing the formulas using the cell address
5.
Which among the rules is TRUE in performing order of operations?
A. Perform any calculations inside parenthesis.
B. Perform all multiplications and divisions, working from left to right.
c. Perform all additions and subtractions, working from left to right.
D. All of the above
6.Which function displays the current date in excel?
A =NOWO B. =TODAYO
C. =DAYO D. =DATEO
z. Which function displays the current date and in excel?
A. =NOWO B. =TODAYO
C. =TIMEO D. =DATEO
8. Which of the symbol is used for comparison of logical operators?
А.
B.)
C. <>
D. &
9. How do you remove data that has been entered in a cell?
Α. Click the cell and then choose the arrow down beside the Clear button
in the Editing group or Home Tab. From the list of options, click on Clear
Contents
B. Right-Click on the cell that contains the data that you want to delete.
From the list of options, choose Clear Contents.
C. A and B are correct
D. None of the above
10. How do you edit data in a cell?
A. Double click the cell or Press F2. Press the backspace or delete to erase
the characters. Type in the correction, and then press enter.
B. Click the cell and then click in the formula bar. Press backspace or delete
to erase the characters. Type in the correction, and then press enter.
C. A and B are correct.
D. None of the above​