WorksheetsMicrosoft Office_DPM1A
Total questions: 57
Worksheet time: 34mins
PowerPoint is a:
presentation application
spreadsheet application
word processing application
none of the above
In PowerPoint you create:
slide shows
documents
spreadsheets
none of the above
Excel is a:
database application
spreadsheet application
word processing application
none of the above
In Excel you create:
spreadsheets
documents
slide shows
none of the above
The file extension for Excel:
.pptx
.docx
.xlsx
none of the above
The file extension for PowerPoint:
.pptx
.xlsx
.mdbx
none of the above
What URL do you use to access Office 365?
microsoft.com
portal.office.com
google.com
dave
The "boxes" in Microsoft Excel are called...
Griddies
Boxes
Cells
Spreadsheets
In Excel, the heading "boxes" going from left to right are called...
Rows
Columns
Letters
Headers
Word processing, spreadsheets, and presentation software are examples of what?
Collaboration software
Productivity software
Utility software
Operating System add-ins
In Excel, the heading "boxes" going from top to bottom are called...
Rows
Columns
Numbers
Headers
In which Microsoft Office product can you work with animations?
Excel
Word
Outlook
PowerPoint
In which core Office product can you use the Find and Replace function?
Word
Excel
PowerPoint
Word, Excel, and PowerPoint.
Under which tab in Microsoft Word would you look under to change the page orientation?
Insert
Page Layout
File
View
Animations in PowerPoint are the same thing as transitions.
True
False
(a) is the best Microsoft Office product to use to create a graph.
Word
Keyboard shortcut "Ctrl-V" does what?
Copy
Delete
Paste
Keyboard shortcut "Ctrl-P" does what?
Delete
Paste
Copy
untuk membuat teks menjadi rata tengah . . .
align left
Center
align right
Justify
Shortcut untuk membuat file dokumen baru adalah
ctrl + N
ctrl + M
ctrl + EN
ctrl + EM
Max berfungsi untuk ...
menghitung penjumlahan
menghitung nilai terkecil
menghitung nilai terbesar
menghitung rata-rata
Langkah pertama membuat file baru presentasi adalah....
Klik File - New
Klik File - Save as
Klik File - Save
Klik File - Close
Tampilan gambar diatas terdapat pada menu.....
Insert
Design
Format
Home
Defined sequence of steps that achieve an identified goals refers to
Project goal
Work Breakdown Structure.
Network Diagram.
Project Management
An employee who plans and organizes the resources necessary to complete a project.
Resource Manager
Project Manager
Workflow Manager
Microsoft Project will assist the project manager to
allocate the time for site visit.
manage the rules of the project.
communicate the status of the project easily
The Standard calendar specifies all of the following EXCEPT
2 hours of lunch break.
Monday through Friday are working days.
Saturday and Sunday are nonworking days.
8 hours of work completed each day.
The project manager can view the list of employees working in the project together with their salary per hour at the
task view.
Gantt chart
resource sheet
project information
Milestone is represented by the heart shape.
True
False
The primary purpose of “Gantt chart” is to display resource sheet task
True
False
A milestone is assign by entering duration of zero days for a task.
True
False
The following are the correct units of measure abbreviations EXCEPT
m = min
h = hour
w = week
mon = month
The standard working time starts from 8:00 a.m. to 5:00 p.m.
True
False
Select TWO (2) types of task dependencies.
Start-to-Start (SS)
Fast-to-Fast (FF)
Start-to-Finish (SF)
Too Fast Too Furious (2F2F)
The letters in Excel represent the...
Rows
Columns
Cells
Data
The numbers in Excel represent the...
Rows
Columns
Cells
Data
An Excel file format extension is
doc
xls
txt
mp3
The intersection of a column and a row is called a __________.
Four-way Stop
Formula Bar
Cell
Template
These items allow you to move up & down or left & right in a worksheet that is to large to fit on the screen at once.
Row Bars
Column Bars
Scroll Bars
Home Bars
What icon do you choose to align the text at the top, middle, or bottom of a cell?
What is this icon?
Zoom
Sort and Filter
Symbol
Merge and Center
The cell address of the highlighted cell is
C
4
A4
C4
These are known as
workbooks
worksheets
formula bar
cell
What does the indicated icon do in the red box?
Apply underline
Apply italic
Make text bigger
Apply bold
What does the indicated icon in the red box do?
Change number of active cells
Change font colour
Change font size
Change the number of calculations
