Microsoft Office

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

The first generation of computers used which technology?

2 Mark(s)

Transistors
Vacuum tubes
Vacuum tubes
Vacuum tubes

Which view in PowerPoint displays only the text (title and bullets) of your presentation?

2 Mark(s)

Normal view
Slide Sorter view
Outline view
Notes Page view

What is the purpose of the "Slide Master" in PowerPoint?

2 Mark(s)

To create custom layouts for individual slides
To add animations to all slides at once
To set a consistent look and feel for the entire presentation
To insert speaker notes

What is a "transition" in PowerPoint?

2 Mark(s)

A sound effect added to a slide
The movement of an object on a slide
The visual effect when moving from one slide to another
A type of animation

Which tab in PowerPoint allows you to insert pictures?

2 Mark(s)

Home
Insert
Design
View

What does the IF function do?

2 Mark(s)

Formats cells
Performs logical tests
Finds average values
Sorts data

What happens if you press Ctrl + Shift + L in Excel?

2 Mark(s)

A new worksheet is created
Filters are applied or removed
A new row is added
The worksheet is saved

What does the Ctrl + D shortcut do in Excel?

2 Mark(s)

Deletes the selected ro
Creates a chart
Duplicates the worksheet
Fills down data or formula from the cell above

. How do you select the entire row in Excel using a shortcut?

2 Mark(s)

Ctrl + A
Ctrl + Spacebar
Alt + Spacebar
Shift + Spacebar

How do you open the “Go To” dialog box in Excel using a shortcut?

2 Mark(s)

Ctrl + H
Ctrl + G
Ctrl + N
Ctrl + F

. 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

. What does HTTP stand for?

2 Mark(s)

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

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

Which of the following is classified as volatile memory?

2 Mark(s)

ROM
Flash Memory
RAM
Hard Drive

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

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

2 Mark(s)

EDIC
ASCII
BCD
EBCDIC

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

2 Mark(s)

Bit
KB
Nibble
Byte

What does SSD stand for?

2 Mark(s)

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

How do you select the entire column in Excel using a shortcut?

2 Mark(s)

Ctrl + A
Ctrl + P
Shift + Spacebar
Ctrl + Spacebar

How can you quickly insert the current date in a cell?

2 Mark(s)

Ctrl + Shift + ;
Ctrl + ;
Ctrl + D
Ctrl + T

. 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

How can you quickly repeat your last action in MS Word?

2 Mark(s)

Ctrl + Y
Ctrl + Z
Ctrl + P
Ctrl + R

is an Excel Cell?

2 Mark(s)

A chart type in Excel
A toolbar in Excel
A type of formula
An individual box in a worksheet for data entry View Answer

function is used to count the number of numerical values in a range?

2 Mark(s)

COUNT()
COUNTBLANK()
COUNTIF()
COUNTA()

What is the function of “Table Styles” in Microsoft Word?

2 Mark(s)

Insert charts
Highlight text
Align text to the center
Quickly apply predefined formatting to tables

How do you start a formula in Excel?

2 Mark(s)

By typing @
By typing #
By typing +
By typing =

Who invented MS Excel and in which year?

2 Mark(s)

Richard Brodie, 1985
Steve Jobs, 1985
Bill Gates, 1983
Gary Kildall, 1980

Which shortcut allows you to delete the word to the right of the cursor?

2 Mark(s)

Shift + Delete
Ctrl + Delete
Alt + Backspace
Ctrl + Backspace

How do you open the “Help” pane in Microsoft Word?

2 Mark(s)

Ctrl + F1
Ctrl + Shift + H
F1
Ctrl + P

Where is the Excel Solver?

2 Mark(s)

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

What is the Excel formula for calculating percentage?

2 Mark(s)

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

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

2 Mark(s)

TEXTJOIN
CONCATENATE
MERGE
JOIN

Which key is used to edit the content of a cell?

2 Mark(s)

F2
F1
F4
F3

. Which shortcut is used to open the Format Cells dialog box?

2 Mark(s)

Ctrl + 1
Ctrl + Shift + F
Ctrl + F
Ctrl + Alt + C

What does the Ctrl + Z shortcut do in Excel?

2 Mark(s)

Save the workbook
Undo the last action
Close the workbook
Redo the last action

How can you sort data in Excel?

2 Mark(s)

Use the Sort option in the Data tab
Use the Wrap Text option
Use Ctrl + S
Use the Format menu

What does the IF function do?

2 Mark(s)

Formats cells
Performs logical tests
Finds average values
Sorts data

Which MS Word feature allows you to restrict formatting and editing of a document?

2 Mark(s)

Digital Signature
Developer Mode
Protect Document
Content Control

Which function is used to find the largest value in a range?

2 Mark(s)

MIN()
AVERAGE()
MAX()
LARGE()

How do you remove duplicate values in a range?

2 Mark(s)

Delete manually
Use Data -> Remove Duplicates
Use Sort
Use Filter

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 feature in MS Word allows you to combine multiple revisions into one document?

2 Mark(s)

Track Changes
Compare
Merge Documents
Combine

What is the shortcut to open an existing document in Word?

2 Mark(s)

Ctrl + F12
Ctrl + P
Ctrl + N
Ctrl + O

Microsoft Office : Question 1 of 50

The first generation of computers used which technology?

The first generation of computers used which technology?

. What is a 'bit'?

. What is a 'bit'?

. What is a 'bit'?

. What is a 'bit'?

. What does HTTP stand for?

. What does HTTP stand for?

Which of the following is classified as volatile memory?

Which of the following is classified as volatile memory?

What does SSD stand for?

What does SSD stand for?