1) - Philadelphia University
|Philadelphia University | |Faculty of information Technology |
|Coordinator: Mrs. Eman Alnaji | |Department of Computer Science |
|Internal Examiner: Dr. Maram Bani Younis | |Examination Paper |
|Computer Skills (9761111) |First Exam |First Semester of Academic Year 2015/2016 |
|Computer Skills – Humanities (0710103) | | |
|Date: 14 November 2015 | |Time: 50 minutes A |
| | | |
Information for candidates
1. This examination paper contains 20 questions, totaling 20 marks
2. Marks of Each Question is 1.
Advice to Candidates
1. You should attempt all questions.
2. You should write your Answers clearly in the specified place in the first page.
|Question |Answer |
|1 | |
|2 | |
|3 | |
|4 | |
|5 | |
|6 | |
|7 | |
|8 | |
|9 | |
|10 | |
|11 | |
|12 | |
|13 | |
|14 | |
|15 | |
|16 | |
|17 | |
|18 | |
|19 | |
|20 | |
Q1: In Excel 2010, the name of the part displayed in the following image is:
[pic]
A) Cell
B) Ribbon
C) Tab
D) Quick Access Toolbar
Q2: In the image below; the cell reference of the selected cells is:
[pic]
A) B2:B7
B) 7B:7C
C) B2:C7
D) B7:C7
Q3: In the image below, the active sheet is:
[pic]
A) Section1
B) Section2
C) Section6
D) IS
Q4: You can use the options displayed below for:
[pic]
A) Changing a cell style
B) Removing a cell style
C) A + B
D) Applying Conditional Formatting
Q5: To display your table as shown in the image below, you should use:
[pic]
A) Conditional Formatting
B) Format as Table
C) Cell Styles
D) Format Cells
Q6: The following dialog box is used for:
[pic]
A) Sorting
B) Filtering
C) Conditional formatting
D) All of the above
Q7: In the image below, we can refer to the selected range with:
[pic]
A) C2:C8
B) numbers
C) quantity
D) A + B
Q8: In the image below; the operation in the displayed paste special dialogue box that is used to paste row data in a column or column data in a row is:
[pic]
A) Formulas
B) Skip blanks
C) Column widths
D) Transpose
Q9: In the image below, if we click on Sort oldest to newest, the first cell well be:
[pic]
A) 22/10/2012
B) 11/11/2011
C) 1/2/2003
D) 12/12/2011
Q10: After applying the sorting displayed in the following image, the last row in the table will be:
[pic]
A) lemon, yellow, 10
B) blueberry, blue, 20
C) banana, yellow, 20
D) orange, orange, 30
Q11: If you press OK in the dialog below, then:
[pic]
A) You can delete columns from the sheet but you cannot insert columns
B) You can insert columns in the sheet but you cannot delete columns
C) You can insert columns and rows to the sheet
D) You cannot delete neither columns nor rows from the sheet
Q12: In the image below, selecting the option "Structure" from the dialog will:
[pic]
A) Prevent users from moving windows
B) Prevent users from deleting, copying, moving or inserting worksheets
C) Prevent users from resizing windows
D) Prevent users from closing windows
Q13: In the image below, selecting the option "Hidden" and then protecting the sheet means:
[pic]
A) The formula will be displayed in the cell
B) The formula will be deleted from the cell, and not be applied
C) The formula will still be applied in the cell, but not displayed in the formula bar.
D) Cell A4 will become empty
Q14: In the image below; the small triangle in the top right corner of cell A2 (usually colored by red) means:
[pic]
A) There is an error in the cell
B) The cell can be used only to insert a formula
C) The font color of the cell is red
D) There is a comment inserted into the cell
Q15: Which of the following functions will return number 9?
A) TODAY()
B) MONTH("5-Sep-99")
C) DAY("9-Nov-99")
D) B + C
Q16: To display the current date and time in a cell, you use the function:
A) TODAY()
B) NOW()
C) DAY()
D) MONTH()
Q17: The result of the formula =LEFT(RIGHT("this is skills exam";19);19) :
A) this is skills exam
B) THIS IS SKILLS EXAM
C) this is skill
D) this is
Q18: In the image below, after applying the formula in A3, the resulted value will be:
[pic]
A) AM S
B) I AM
C) Am s
D) AM ST
Q19: What is the output of the following formula =LOWER("this is A final test") ?
A) THIS IS A FINAL TEST
B) This Is A Final Test
C) This is a final test
D) this is a final test
Q20: The result of the formula =UPPER(PROPER("IT faculty is the best")), is:
A) it faculty is the best
B) It Faculty Is The Best
C) IT FACULTY IS THE BEST
D) iT fACULTY iS tHE bEST
Good Luck
(
-----------------------
Student No.: ...................................... Student Name: .............................................................
Lecturer: .......................................... Section No.: ..................................................................
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- university physics volume 1 pdf
- minecraft university map 1 12 2
- philadelphia 1 3 fat cream cheese nutrition
- university penn philadelphia pa
- philadelphia high school philadelphia ms
- hilton philadelphia at penn s landing philadelphia pa
- vna philadelphia philadelphia pa
- university of penn philadelphia pa
- 1 or 2 374 374 1 0 0 0 1 168 1 1 default username and password
- 1 or 3 374 374 1 0 0 0 1 168 1 1 default username and password
- 1 or 2 711 711 1 0 0 0 1 168 1 1 default username and password
- 1 or 3 711 711 1 0 0 0 1 168 1 1 default username and password