Font size
WorksheetsSHAHHEN's MSOffice
Total questions: 124
Worksheet time: 2hrs 4mins
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
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.
Word
What is Microsoft Excel designed for?
creating presentations
store formulas
storing, organizing, and manipulating data using spreadsheets.
create documents
Which tab is the default active tab?
The Tools tab
The Home tab
the Insert tab
The File tab
Keyboard shortcut "Ctrl-V" does what?
Copy
Delete
Paste
Keyboard shortcut "Ctrl-P" does what?
Delete
Paste
Copy
Keyboard shortcut "Ctrl-C" does what?
Copy
Delete
Paste
What does PDF stand for?
Portable Document Files
Printed Document Files
Put Dem Far
Portable Document Format
What is the name of the marked cell in the image?A7
C1
B3
B2
What is shown in the following image?TRANSITIONSANIMATIONSVIDEOS
soundsDESIGN
What is shown in the following image?
TRANSITIONSANIMATIONSVIDEOS
SOUNDSDESIGNWhat is shown in the following image?TRANSITIONSANIMATIONSVIDEOS
SOUNDSDESIGNWhich formula is correctly written?B3+C1
=SUMAG2:G7)
=A7+D2
H2/F1*J8
Keyboard shortcut to copy and pasteCtrl+C , Ctrl+V
Ctrl+X , Ctrl + V
Ctrl+ Z + Ctrl+ C
None of the aboveShort Key for copy
Ctrl+X
Ctrl+C
Ctrl+V
Ctrl+N
Short Key for cut
Ctrl+X
Ctrl+C
Ctrl+V
Ctrl+N
Short Key for paste
Ctrl+X
Ctrl+C
Ctrl+V
Ctrl+N
Short Key for undo
Ctrl+Z
Ctrl+Y
Ctrl+V
Ctrl+N
Short Key for new document
Ctrl+Z
Ctrl+Y
Ctrl+V
Ctrl+N
Short Key for right alignment
Ctrl+R
Ctrl+L
Ctrl+E
Ctrl+U
Short Key for underline
Ctrl+R
Ctrl+L
Ctrl+E
Ctrl+U
Short Key for bold
Ctrl+R
Ctrl+L
Ctrl+E
Ctrl+B
Short Key for center alignment
Ctrl+R
Ctrl+L
Ctrl+E
Ctrl+C
Short key for replace is
Ctrl+H
Ctrl+F
Ctrl+I
Ctrl+B
Short key for find
Ctrl+Y
Ctrl+F
Ctrl+H
Ctrl+Z
A ......... is made up of rows and columns.
Power point
Word
Table
Format
To draw your own table, select
Table > Insert
Insert > Table > Insert Table
Insert > Table
Insert > Table > Draw Table
To save a file, Select
Insert > Save
File > Save
View > Save
Review > Save
The ........ sends the cursor to the beginning of the next line or executes a command or operation.
Shift key
Tab key
Enter key
Backspace key
To select all text in a Word document, press ..........
Ctrl + V
Ctrl + B
Ctrl + C
Ctrl + A
The .......... key erases the text to the left of the insertion point one character at a time.
Backspace
Delete
Enter
Shift
The ......... at the top of a window displays an application-defined icon and line of text.
Title bar
Menu bar
Taskbar
Tool box
On the ........., Microsoft Word displays the name of the document you are currently using.
Tool box
Taskbar
Menu bar
Title bar
A .......... is a graphical control element which contains drop-down menus.
Taskbar
Title bar
Menu bar
Tool box
The icon of left alignment is
The icon of right alignment is
The icon of center alignment is
The icon of justify alignment is
Shortcut key to start a presentation from the beginning is
F1
F2
F5
F7
Shortcut key for End the presentation is
ESC
Shift
Control
Enter
Shortcut key to align the selected text in left
Ctrl + L
Ctrl + R
Ctrl + S
Ctrl + U
.......... is a feature included in Microsoft PowerPoint software that allows the user to see all the slides in a presentation at one time.
Normal view
Slide sorter view
View
Slide show view
............ is the main editing view, which is used to write and design a presentation.
Normal View
Slide show view
Slide sorter view
View
......... View takes up the full computer screen, like an actual slide show presentation.
Slide Show
Normal
Slide sorter
Views
To save an existing file with new location we should........command.
Save
Save and replace
Save as
New file
We have two kinds of view in Access. Datasheet view and (a) view.
A table is divided into __________________
field and form
fields and records
datasheet and design
record and form
One example of a database would be ...
grocery list
stamp collection
movie collection
cell phone contact list
Access offers different views of objects. Which view do you use to edit a table?
Datasheet View
Design View
Table View
Print View
What software do you use to make databases?
Access
Excel
PowerPoint
Word
These sort, filter, and summarize data.
Tables
Forms
Queries
Reports
Which of these options is the best to use for a primary key?
Number
Currency
Short Text
Autonumber
In Microsoft Access, a field labelled “Price” must be created as
Currency
Primary Key
Number
Short Text
A __________ helps us to keep the information in our database structured
Primary Key
Record
Autonumber
Field
To delete or rename a field in Microsoft Access, the first thing to do is _________
Right click on the field
Delete the field
Double Click on the field
Open the field
Which view can be used to enter data into the database?
Design View
Record View
Field View
Form View
Which of these is not an example of a field type?
Picture
Short Text
Date and Time
Yes/No
Microsoft Excel uses columns while Microsoft Access uses _________
Fields
Records
Tables
Movement
These provide printable views of table or query data that you can share.
Tables
Forms
Queries
Reports
What software do you use to make databases?
Access
Excel
PowerPoint
Word
In your database, information is stored in the ...
Table
Report
Query
Form
Records in a table can be updated any time.
True
False
Which object would you create to share the data from your database with others?
Form
Report
Query
Table
The most common way to look at a table in Access is ...
Datasheet View
Design View
Table View
Print View
Multiple tables that are related to each other is known as ...
Access Database
Relational Database
Database Tables
Informational Database
These are key objects in a database. They contain the data that is stored in the database and are made up of rows and columns.
Table
Report
Query
Form
A request for data results from a database or for action on the data.
query
table
file
record
A database object that you can use to create a user interface for a database application.
form
report
record
field
This can offer a way to view, format, and summarize the information in your Microsoft Access database.
query
table
form
report
record
A group of fields, such as a telephone number, address and name, which are pertinent to a particular item. These are also known as rows.
query
field
report
records
A piece of information related to a single person or thing; also known sometimes as columns.
table
query
form
field
A field or set of fields with values that are unique throughout a table.
primary key
foreign key
database
record
The properties of a field describe the characteristics and behavior of data added to that field.
database
data type
field
record
An organized collection of structured information, or data, typically stored electronically in a computer system.
database
record
primary key
foreign key
In a database, the rows are also known as
fields
records
tables
forms
What extension is the data file created in Microsoft Access program?*.acd
*.doc
*.accdb
*.mdb
Division symbol in spreadsheet.
/
+
=
Which page orientation makes the sides longer than the top and bottom?
landscape
portrait
fixed
variable
If you selected (A1:B5) what is this called?
row
column
cell range
cell grouping
If you see a series of "######" in a cell, that means the following:
Row height is too high
Column width is not wide enough
To sort names in a worksheet, we can use ____ button
Excel refers to files as
Databases
Workbook
Document
To arrange data in alphabetical or numerical order is what?
coding
sorting
graphing
grouping
When inserting a formula, always start with
-
*
+
=
___ are vertical
Row
Column
Identify the name of the red cell
A11
A10
A12
