Microsoft Office

In Excel, how do you reference a cell from another worksheet in the same workbook?

2 Mark(s)

=Sheet1(A1)
=A1(Sheet1)
=Sheet1.A1
=Sheet1!A1

What is the shortcut to create a new PowerPoint presentation?

2 Mark(s)

Ctrl + N
Ctrl + S
Ctrl + P
Ctrl + O

Which shortcut is used to move to the next slide in PowerPoint’s slideshow mode?

2 Mark(s)

Arrow Right
Spacebar
Enter
All of the mentioned

What does the “Slide Layout” feature in PowerPoint allow you to do?

2 Mark(s)

Change the background
Choose a design for a slide
Apply slide transitions
Insert a video

What is the default view when you first open PowerPoint?

2 Mark(s)

Outline View
Reading View
Slide Show Vie
Normal View

What is the default font size for text on a slide in PowerPoint?

2 Mark(s)

16 pt
18 pt
24 pt
28 pt

What is the purpose of the “Notes” section in PowerPoint?

2 Mark(s)

To insert images
To add speaker notes for reference during the presentation
To change slide backgrounds
To add hyperlinks

What does the “Slide Show” tab in PowerPoint allow you to do?

2 Mark(s)

Change slide layouts
Edit text on slides
Insert media files
Start and control the presentation

What is the shortcut key for adding a new slide in PowerPoint?

2 Mark(s)

Ctrl + T
Ctrl + N
Ctrl + Shift + N
Ctrl + M

How do you delete a slide in PowerPoint?

2 Mark(s)

Press Ctrl + D
Use the Insert tab
Go to the View tab
Right-click on the slide and select Delete Slide

Which of the following can be added to a PowerPoint slide?

2 Mark(s)

Text
Images
Charts
All of the mentioned

What is the shortcut to duplicate a slide in PowerPoint?

2 Mark(s)

Ctrl + D
Ctrl + X
Ctrl + C
Ctrl + V
Ctrl + X

The CEO of your company just sent mail to all 10,000 of your fellow employees. You want to reply to her and say, "Thanks!". Which button should you click?

2 Mark(s)

Reply
Reply All
Reply with Meeting
Forward

How can you tell the email that you have read from the email that you have not read?

2 Mark(s)

The unread mail will be on top
The unread mail will be on bottom
The unread mail will be bold
The unread mail will be blue

Which type of chart is best for showing trends over time in Excel?

2 Mark(s)

Scatter chart
Bar chart
Line chart
Pie chart

Which Excel function is used to join two or more text strings?

2 Mark(s)

TEXTJOIN
CONCATENATE
MERGE
JOIN

What is the Excel formula for calculating percentage?

2 Mark(s)

=A1*100/B1
=A1/B1
=A1*B1
=A1+B1

Where is the Excel Solver?

2 Mark(s)

In the View tab
In the Insert tab
In the Formulas tab
In the Home tab

. Which shortcut key is used to save an Excel workbook?

2 Mark(s)

Ctrl + S
Ctrl + P
Ctrl + C
Ctrl + V

What is an Excel Graph?

2 Mark(s)

A type of worksheet
A table of numbers
A visual representation of data (similar to a chart)
A tool for creating formulas

Which field type will you select if you need to enter long text in that field?

2 Mark(s)

text
memo
currency
hyperlink

You can set your work week to be:

2 Mark(s)

Monday to Friday
any set of 5 consecutive days
any set of 1-6 consecutive days
any set of consecutive or non-consecutive days

MailTips can provide you with the following pieces of information, except for:

2 Mark(s)

a warning that you are about to write a large number of people
a warning that your mail is too large to send
a warning that your mail contains misspellings
a warning that the recipient’s mailbox is full

MailTips can provide you with the following pieces of information, except for:

2 Mark(s)

a warning that you are about to write a large number of people
a warning that your mail is too large to send
a warning that your mail contains misspellings
a warning that the recipient’s mailbox is full

Where is the Slide Master located in PowerPoint?

2 Mark(s)

Under the “Design” tab
Under the “View” tab
Under the “Insert” tab
Under the “Animations” tab

Which tab would you use to add animations to your slides?

2 Mark(s)

Design
Animations
Insert
Home

What does SSD stand for?

2 Mark(s)

Solid State Drive
Simple Storage Device
Simple Storage Device
Solid Storage Device

. What does HTTP stand for?

2 Mark(s)

Hyper Text Transfer Protocol
High Text Transfer Protocol
Hyper Text Transmission Protocol
Hyper Text Transmission Protocol

. What is a 'bit'?

2 Mark(s)

A basic unit of data in computing
A type of software
A hardware component
A programming language

. What is a 'bit'?

2 Mark(s)

A basic unit of data in computing
A type of software
A hardware component
A programming language

The first generation of computers used which technology?

2 Mark(s)

Transistors
Vacuum tubes
Vacuum tubes
Vacuum tubes

What is the full form of CPU?

2 Mark(s)

Computer Processing Unit
Computer Principle Unit
Central Processing Unit
Control Processing Unit

Who is the father of Computers?

2 Mark(s)

James Gosling
Charles Babbage
Dennis Ritchie
Bjarne Stroustrup

How can you insert a page break in a Word document?

2 Mark(s)

Ctrl + P
Ctrl + Enter
Ctrl + A
Ctrl + S

How do you save a document in Microsoft Word?

2 Mark(s)

Ctrl + S
Ctrl + P
Ctrl + F
Ctrl + A

What is the default file extension for a Word document?

2 Mark(s)

.pdf
.docx
.xls
.txt

Which of the following is classified as volatile memory?

2 Mark(s)

ROM
Flash Memory
RAM
Hard Drive

. Which of the following is the smallest unit of data in a computer?

2 Mark(s)

Bit
KB
Nibble
Byte

. Which of the following is not a type of computer code?

2 Mark(s)

EDIC
ASCII
BCD
EBCDIC

What is the default file extension for a PowerPoint presentation?

2 Mark(s)

.ppt
.pptx
.pp
.slide

What is the full form of PPT?

2 Mark(s)

PowerPoint Presentation
Public Presentation Tool
Personal Presentation Template
Professional Presentation Template

Who invented PowerPoint?

2 Mark(s)

Alan Turing
Alan Turing
Robert Gaskins and Dennis Austin
Steve Jobs

What is MS PowerPoint?

2 Mark(s)

A video editing software
A spreadsheet software
A word processing software
A presentation software used to create slideshows

Which block is used to make a sprite say something in Scratch?

2 Mark(s)

Show
Green Flag Clicked
Speak
Mouse Clicked

What type of programming model does Scratch use?

2 Mark(s)

Object-oriented programming
Functional programming
Procedural programming
Event-driven programming

Which block is used to move a sprite forward in Scratch?

2 Mark(s)

Glide
Jump
Move
Go to

What is Scratch?

2 Mark(s)

A programming language for professionals
A drag-and-drop visual programming language for beginners
A hardware device for advanced coders
A word processing software

Which of the following are physical devices of a computer?

2 Mark(s)

Hardware
Software
System Software
Package

Which of the following is used in EBCDIC

2 Mark(s)

Super Computers
Mainframes
Super Computers
Programming

What is Microsoft Word software?

2 Mark(s)

A web browser
A word processing program
A video editing software
A spreadsheet program

Microsoft Office : Question 1 of 50

Which field type will you select if you need to enter long text in that field?

Which field type will you select if you need to enter long text in that field?

What does SSD stand for?

What does SSD stand for?

. What does HTTP stand for?

. What does HTTP stand for?

. What is a 'bit'?

. What is a 'bit'?

. What is a 'bit'?

. What is a 'bit'?

The first generation of computers used which technology?

The first generation of computers used which technology?

Which of the following is classified as volatile memory?

Which of the following is classified as volatile memory?