Informatics Final Exam Questions
Translated by
ScribdTranslationsInformatics Final Exam Questions
Translated by
ScribdTranslationsInformatics
FINAL EXAM
Informatics
LAST NAMES AND FIRST NAMES: ___________________________________
INSTRUCTOR: ___________________________________
CLASSROOM: __________ FECHA: _______________________
No. A B C D No. A B C D
1 31
2 32
3 33
4 34
5 35
6 36
7 37
8 38
9 39
10 40
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Informatics
FINAL EXAM
Please read each question carefully and mark the corresponding answer.
answer sheet box attached to this exam
Duration: 1 hour
Microsoft Windows
1. What output device projects data and images from a conventional monitor to
a wider screen that can be viewed by a group of people?
microcomputer
b) A tracer
c) The Scanner
a projector
2. Which of the following pointer shapes indicates the possibility of resizing?
a window?
3. What services does the Internet provide?
a) Windows Explorer
b) Control Panel
c) Email
d) Screen Properties
4. What is the keyboard shortcut that allows you to switch between Active Applications?
a) Ctrl + Esc
Alt + F4
c) F5
d) Alt + Tab
5. It is an information input device:
I. The plotter
II. The scanner
III. The webcam
IV. The printer
a) Solo II
b) I and III
c) II and IV
d) II and III
6. If you have a hard drive with folders that contain files and you want to
users of a network access them, then you must:
a) Save the files on a diskette.
b) Share the folder where your files are.
c) Notify the network users to share their hard drives.
d) Share the hard drives of all users on the network.
7. What is the main function of the central processing unit (CPU)?
a) Host the different types of memories
b) Allow for rapid data entry.
c) Carry out operations and calculations of the equipment
d) Store instructions for the equipment operations
8. What type of storage media allows for data rewriting?
a) CD-R
December 13, 2012 2
Informatics
b) CD-ROM
c) CD-RW
d) DVD-R
9. When entering your data by tapping on a screen, you are using a type of screen:
a) LCD
b) Screen reader
c) Digital
TouchScreen
10. Those applications that allow creating the necessary material for a presentation before a
public is called
a) Graphing programs
b) Spreadsheets
c) Presentation programs
d) Word processors.
Microsoft Word
11. They are elements of the main screen of Word
Slides and presentations
b) The title bar and the ribbon
c) The ruler and the sheet
d) Columns and rows
12. The line spacing is used for:
a) Increase the distance between the paragraphs
Increase the distance between the lines
c) Increase the indentation
d) Increase the font size
13. Indentation is referred to as:
a) Space from the margin
b) Space from the rule
c) Space between lines
d) Space between paragraphs
It is a text with artistic formatting.
a) ImagtText
b) Textimg
c) TextArt
d) WordArt
15. What action should I take to select a paragraph using the mouse?
a) Click
b) Ctrl + E
c) Triple click
N.A.
13/12/2012 3
INFORMATICS
16. It allows you to structure a flowchart quickly and professionally.
WordArt
b) Image
c) Basic shapes (squares, circles, lines)
d) SmartArt
17. It allows you to format a document to give it a more professional appearance:
a) Header and footer
b) Page header and headline
c) Membretes y pie de pagina
N.A.
18. If you want to select all the text of a document, you must use the combination of
keys:
a) [Ctrl] [A]
[Shift] [E]
[Alt] [E]
d) [Ctrl] [E]
19. I need to send an email to the following email accountcorreosenati@[Link] and the
keyboard does not contain the at symbol (@). What is the Word tool that allows me to
Does it allow inserting special characters?
a) Character Map
b) Symbols
c) Language
d) Autocorrection
20. If you have the following table and wish to obtain an average in the shaded area of a
queue. Which function should be used?
NOTE1 NOTE2 NOTE3 AVERAGE
115 18 16 49.67
a) =AVG
=AVERAGE
c) = PROM
d) =PRODUCT
Microsoft Excel
A book is:
a cell
b) A Range
an XLS file
A single sheet
22. Excel functions:
a) Sum, division, max, min and count
b) Sum, average, max, min and count
c) Suma, promedio, máximo, mínima y contara
d) Subtract, average, max, min, and count
13/12/2012 4
Informatics
23. The following cells contain the sales of a certain company, the ranges are: Month, Type
Sale, Sale Amount and it is desired to determine the amount of type C sales in cell D13.
To calculate these sales, the formula should be used?
a) [Link](B13:B16, C12:C16, "C")
b) [Link](B13:B16,C12:C16, "C")
c) [Link](B13:B16,"C",C12:C16)
SUMIF(B13:B16, "C", C12:C16)
24. Carry out the result of the following data:
A=30 B=20 c=10=A+(B*C)
a) 220
b) 240
c) 230
d) 210
25. What is the symbol used to indicate an absolute cell in Excel?
a) $
b)“ “
S/.
N.A.
26. Spreadsheets are made up of:
a) Sheets and books
b) Rows and Columns
c) Rows, sheets, and columns
d) Rows and documents
27. What is the name of the area where the formulas entered in a cell are displayed.
a) Formula
b) Formula bar
c) Cuadro de nombre
Formula bar
28. What is the key that we can use to enter the cell and modify the data:
a) Alt+F2
b) F2
c) Click F2
N.A.
29. Which of the following formulas is not correct?
=SUM(A1:F5)
=B23/SUM(A1:B5)
=AVERAGE(A1:B5,D1:E5)
=SUM(AVERAGE(A1:C3),D3,F3)
13/12/2012 5
Informatics
30. A cell is:
a) The intersection between rows and cells
b) The intersection between columns and rows
c) Conditional Format
N.A.
Microsoft PowerPoint
31. Name the three types of object animations in PowerPoint
a) _______________
b) _______________
c) _______________
d) _______________
32. The animation effects are granted to:
a) Any object from the Slide.
b) Any slide of the Presentation.
c) Only to the Images.
d) Only the texts.
33. The type of view that allows you to see the slides in thumbnail is:
a) Slide sorter view
b) Slide presentation view
c) Normal view
d) View diagram
34. The PowerPoint workspace is
a slide
b) Rows and columns
a sheet
A presentation
35. When printing the Presentation as a document. What is the maximum number of slides?
per page?
a) 4
b) 6
c) 9
d) 12
36. The tab used to apply transition effects to a slide is:
a) Animations
b) Transitions
c) Start
d) Insert
37. What is the alternative that allows changing the background of a slide?
Love Design
b) Love animation
c) Fund format
d) Love to insert
38. If you want to apply an effect when transitioning from one slide to another, you must use:
a) Transition of the presentation
b) Slide effect
c) Slide transition
d) Effects cannot be applied
13/12/2012 6
Informatics
39. Key combination to justify text
a) Ctrl + J
b) Ctrl + Z
c) Ctrl + N
d) Ctrl + Y
40. Mark the correct alternative
The most used spreadsheet programs are Word and Excel.
The most used word processor is Ms Word.
c) The most used spreadsheet program is Windows
d) Word processors allow for calculations
13/12/2012 7