Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel MCQ Quiz

Total questions: 118

Worksheet time: 59mins

Name
Class
Date
1.

What is the default file extension for Excel 2016 and later versions?

a)

.xls

b)

.xlsx

c)

.xlsm

d)

.csv

2.

In Excel, what is the term used to describe a single cell's location?

a)

Range

b)

Reference

c)

Address

d)

Cell Number

3.

Which menu in Excel provides options for formatting cells?

a)

Home

b)

Insert

c)

Data

d)

View

4.

What does the 'Save As' option do in Excel?

a)

Saves the current file with the same name

b)

Saves a copy of the file with a different name or format

c)

Closes the current file

d)

Deletes the current file

5.

How can you add a new worksheet in an Excel workbook?

a)

Right-click on an existing sheet tab and select "Add"

b)

Use the 'Insert' tab and choose 'Worksheet'

c)

Click the '+' icon next to the sheet tabs

d)

Press 'Ctrl + N'

6.

Which function is used to find the average of a range of cells in Excel?

a)

AVERAGE

b)

SUM

c)

MEDIAN

d)

MEAN

7.

What formula would you use to add the numbers in cells A1 through A10?

a)

=SUM(A1)

b)

=ADD(A1)

c)

=TOTAL(A1)

d)

=SUM(A1:A10)

8.

Which function would you use to find the highest number in a range of cells?

a)

MAX

b)

HIGH

c)

TOP

d)

HIGHEST

9.

To calculate the number of cells containing numbers in a range, which function should you use?

a)

COUNT

b)

COUNTA

c)

COUNTIF

d)

SUM

10.

How would you reference cell B2 in another formula as an absolute reference?

a)

B2

b)

$B$2

c)

B$2

d)

$B2

11.

What is the function of the 'Sort' feature in Excel?

a)

To arrange data in a specific order

b)

To delete unnecessary data

c)

To filter data based on criteria

d)

To highlight important data

12.

Which option would you use to sort data in ascending order?

a)

Sort Largest to Smallest

b)

Sort A to Z

c)

Sort by Color

d)

Sort Smallest to Largest

13.

How can you apply a filter to a range of cells?

a)

Use the 'Data' tab and click 'Filter'

b)

Right-click the range and select 'Filter'

c)

Use the 'View' tab and click 'Filter'

d)

Use the 'Home' tab and click 'Filter'

14.

What symbol is used to denote a filter in the column header?

a)

A funnel icon

b)

A downward arrow

c)

A filter icon

d)

A check mark

15.

Which function allows you to remove duplicates from a dataset?

a)

Remove Duplicates

b)

Find Duplicates

c)

Filter Duplicates

d)

Delete Duplicates

16.

What does the 'Merge & Center' option do in Excel?

a)

Combines multiple cells into one and centers the content

b)

Merges cells but does not center the content

c)

Splits a cell into multiple cells

d)

Centers the content in a single cell

17.

Which tab in Excel contains options to change the font size and style?

a)

Home

b)

Insert

c)

Review

d)

Formulas

18.

To set a cell's background color, which option would you use?

a)

Font Color

b)

Fill Color

c)

Border Color

d)

Cell Style

19.

How can you adjust the width of a column to fit the content?

a)

Double-click the column border

b)

Right-click and select 'AutoFit'

c)

Drag the column border to resize

d)

Use the 'Format' tab to adjust column width

20.

What feature would you use to add a border around a cell?

a)

Fill Color

b)

Border

c)

Font Style

d)

Cell Alignment

21.

Which key do you press to move to the next cell while entering data?

a)

Enter

b)

Tab

c)

Arrow keys

d)

Shift

22.

What is Data Validation used for in Excel?

a)

To restrict the type of data that can be entered into a cell

b)

To check for errors in formulas

c)

To validate the format of data

d)

To ensure data consistency

23.

Which function allows you to create a drop-down list in a cell?

a)

Data Validation

b)

Conditional Formatting

c)

Data Consolidation

d)

Data Analysis

24.

To quickly copy data from one cell to another, which feature can you use?

a)

Paste Special

b)

Fill Handle

c)

Cut and Paste

d)

Drag and Drop

25.

How can you ensure that a cell always contains a date and not text?

a)

Use Data Validation to set a date format

b)

Format the cell as Text

c)

Use a custom function to check for dates

d)

Apply Conditional Formatting

26.

Which type of chart is best used to show trends over time?

a)

Pie Chart

b)

Bar Chart

c)

Line Chart

d)

Scatter Plot

27.

How can you change the chart type in Excel?

a)

Right-click on the chart and select 'Change Chart Type'

b)

Use the 'Design' tab and select 'Change Chart Type'

c)

Use the 'Insert' tab to select a new chart type

d)

Click the chart and choose 'Chart Options'

28.

Which chart type displays parts of a whole?

a)

Pie Chart

b)

Histogram

c)

Bar Chart

d)

Line Chart

29.

What feature allows you to add data labels to a chart?

a)

Chart Elements

b)

Data Labels

c)

Chart Layout

d)

Axis Titles

30.

Which option would you use to add a trendline to a chart?

a)

Chart Tools - Layout

b)

Chart Tools - Design

c)

Right-click on the chart data series

d)

Use the 'Insert' tab and select 'Trendline'

31.

What does the term "cell" refer to in Excel?

a)

A single block in a worksheet

b)

A group of blocks in a worksheet

c)

A single sheet in a workbook

d)

A tab in the ribbon

32.

What does the 'Ribbon' in Excel provide?

a)

A way to save files

b)

Navigation between sheets

c)

A set of toolbars with various commands

d)

A list of recent documents

33.

Which area of Excel shows the formula or content of the currently selected cell?

a)

Status Bar

b)

Formula Bar

c)

Name Box

d)

Sheet Tab

34.

In Excel, what is a workbook?

a)

A single sheet

b)

A collection of sheets

c)

A template

d)

A cell reference

35.

How can you quickly open a new workbook in Excel?

a)

Press Ctrl + N

b)

Press Ctrl + O

c)

Click File > Save As

d)

Click File > New

36.

What is the correct formula to calculate the sum of cells A1 through A5?

a)

=SUM(A1)

b)

=ADD(A1)

c)

=TOTAL(A1)

d)

=SUM(A1+A2+A3+A4+A5)

37.

Which function calculates the average of a range of cells?

a)

AVERAGE

b)

MEAN

c)

MEDIAN

d)

SUM

38.

What does the MAX function do?

a)

Finds the highest value in a range

b)

Finds the lowest value in a range

c)

Calculates the average value

d)

Sums the values in a range

39.

What formula would you use to find the smallest number in cells B1 to B10?

a)

=MIN(B1)

b)

=SMALLEST(B1)

c)

=LEAST(B1)

d)

=LOWEST(B1)

40.

To count the number of cells that contain numbers in a range, which function is used?

a)

COUNT

b)

COUNTA

c)

COUNTIF

d)

SUM

41.

Which command is used to sort data in ascending order?

a)

Sort A to Z

b)

Sort Smallest to Largest

c)

Sort Z to A

d)

Sort Largest to Smallest

42.

To apply a filter to a data range, which tab should you use?

a)

Data

b)

Home

c)

Insert

d)

Review

43.

What does 'Merge & Center' do in Excel?

a)

Combines multiple cells into one and centers the content

b)

Merges cells but does not center the content

c)

Splits a cell into multiple cells

d)

Centers the content within a single cell

44.

To change the font size of a cell, which tab would you use?

a)

Home

b)

Insert

c)

Page Layout

d)

Formulas

45.

Which option is used to change the background color of a cell?

a)

Font Color

b)

Fill Color

c)

Border Color

d)

Cell Style

46.

What action would you use to adjust the width of a column to fit the content?

a)

Double-click the column header boundary

b)

Right-click the column and select 'AutoFit'

c)

Use the 'Format' tab and select 'AutoFit'

d)

Drag the column border to resize

47.

How can you add a border around a cell?

a)

Use the 'Borders' option in the 'Home' tab

b)

Use the 'Fill Color' option in the 'Home' tab

c)

Right-click and select 'Add Border'

d)

Use 'Cell Style' from the 'Format' tab

48.

Which is not in MS Word?

a)

Italic

b)

Font

c)

Bold

d)

Magic tool

49.

What is the blank space outside the printing area on a page?

a)

Margins

b)

Clipart

c)

Footer

d)

Header

50.

Select all the text in MS Word document by

a)

Ctrl +S

b)

Ctrl + A

c)

Ctrl + V

d)

Ctrl + 1

51.

Which is not an edition of MS Word?

a)

MS Word 2007

b)

MS Word 2003

c)

MS Word 2200

d)

MS Word 2010

52.

Ctrl + I command is used for what purpose?

a)

Save Document

b)

Left Indent

c)

Italic

d)

Close Document

53.

Which of the following tools can be used in MS Word?

a)

Hyperlinks

b)

Bullets

c)

Highlight

d)

All of the above

54.

What is the function of the spelling and grammar tool?

a)

Corrects Spelling Errors As You Type

b)

Indicates Grammatical Errors

c)

Identifies Words With Capitalization Problems

d)

All Of Above

55.

Formatting is performed on

a)

Table

b)

Text

c)

Menu

d)

Both (a) and (b)

56.

What is landscape?

a)

Page Orientation

b)

Paper Size

c)

A Font Style

d)

Page Layout

57.

Which function key is used to spell check?

a)

F6

b)

F7

c)

F8

d)

F5

58.

What is the maximum number of columns that can be inserted in MS Word?

a)

55

b)

65

c)

50

d)

45

59.

Numbers or letters that appear below the normal text are called?

a)

Subscript

b)

Toptext

c)

Supertext

d)

Superscript

60.

Ctrl + N is used to

a)

Close the Document

b)

Create a New Document

c)

Open the Document

d)

Save the Document

61.

The name of a MS Word document is displayed in ____.

a)

Title bar

b)

Ribbon

c)

Home tab

d)

Status bar

62.

What is the smallest and largest font size in MS Word?

a)

5 and 72

b)

8 and 68

c)

8 and 72

d)

6 and 72

63.

What is the function of ruler in MS Word?

a)

to change page margins

b)

to set indents

c)

to set tabs

d)

All of the above

64.

Which feature of Microsoft Word helps in creating list?

a)

Bullets and Numbering

b)

Word Wrap

c)

Scaling

d)

Word Art

65.

Help window can be opened by?

a)

F2

b)

F9

c)

F1

d)

F11

66.

Gutter margin refers to?

a)

Margin that is added to the binding side of page when printing

b)

Margin that is added to the left margin when printing

c)

Margin that is added to the outside of the page when printing

d)

Margin that is added to right margin when printing

67.

MS Word is ____ software?

a)

Presentation tool

b)

Spreadsheet program

c)

Word Processing tool

d)

None of these

68.

Shortcut key for “Subscript” is?

a)

Ctrl + Shift + –

b)

Ctrl + Shift + =

c)

Ctrl + =

d)

Ctrl + –

69.

What is the default file extension for all MS Word documents?

a)

.word

b)

.txts

c)

.docx

d)

.docs

70.

What is a Document Outline View?

a)

A preview in a full screen

b)

A view with a structure of heading at various levels

c)

A preview with margins

d)

A View with a margins and gutter

71.

What is the shortcut key for “Find and Replace” dialog box?

a)

Ctrl + H

b)

Ctrl + Shift + F

c)

Ctrl + R

d)

Ctrl + F

72.

What shortcut key is used to split a table in MS Word?

a)

Ctrl + Shift + Enter

b)

Alt + Space + Enter

c)

Ctrl + Alt + Enter

d)

Alt + Shift + Enter

73.

You can combine the name and addresses with a standard document using?

a)

Database management

b)

Mail merge

c)

Document formatting

d)

Form letters

74.

What is the use of a word processor?

a)

Track and list monetary expenses

b)

Make a presentation

c)

Type a biography

d)

Maintain an inventory

75.

Ctrl + Pagedown command is used for?

a)

Move the cursor one Paragraph Down

b)

Move the cursor one Screen Down

c)

Move the cursor one Line Down

d)

Move the cursor one Page Down

76.

Section Break option does not consist which of the following?

a)

Previous Page

b)

Odd Page

c)

Next Page

d)

Even Page

77.

Section Break option does not consist which of the following?

a)

Previous Page

b)

Odd Page

c)

Next Page

d)

Even Page

78.

What is the function of Ctrl + G in MS Word?

a)

Open Paragraph Dialog box activating Goto Tab

b)

Open Goto Dialog box

c)

Open, Find, and Replace Dialog box with activating Goto Tab

d)

Open Page Setup Dialog box activating Goto Tab

79.

What is the use of End Key?

a)

Moves the cursor to the end of document

b)

Moves the cursor to the end of paragraph

c)

Moves the cursor to the end of screen

d)

Moves the cursor to the end of line

80.

You can change vertical alignment from?

a)

Page Setup dialog box

b)

Formatting toolbar

c)

Standard toolbar

d)

Paragraph dialog box

81.

Which of the following is NOT present in MS Word?

a)

Font Size

b)

Word Count

c)

Page Margin

d)

Brush

82.

When was Microsoft Word released?

a)

1991

b)

1981

c)

1983

d)

1980

83.

The 2nd tab in the Ribbon is?

a)

Home

b)

Page Layout

c)

Insert

d)

References

84.

The keyboard shortcut used to select text in the direction of the arrow key is?

a)

Ctrl + Arrow

b)

Ctrl + Shift

c)

Ctrl + S

d)

Shift + Arrow

85.

The original name of Microsoft Word was?

a)

Multi-Tool Word

b)

Multi-Technique Word

c)

Multi-Type Word

d)

Multi-Transition Word

86.

The Justify option in MS Word is used for?

a)

Aligning the text to center

b)

Aligning the text to left margin

c)

Aligning the text to both left and right margin

d)

Aligning the text to right margin

87.

To underline the text, use the command

a)

Ctrl + U

b)

Ctrl + T

c)

Ctrl + J

d)

Ctrl + A

88.

The commands present in Quick Access Toolbar include which of the following?

a)

Save

b)

Redo

c)

Undo

d)

All of the above

89.

A picture or a graphic that can be added to MS Word is called?

a)

Clickart

b)

Clipart

c)

Coldart

d)

Clusterart

90.

The type of Border that can be added in MS Word is?

a)

Text

b)

Colourful

c)

Picture

d)

All of the above

91.

What is a Document Outline View in MS Word?

a)

A view with a structure of heading at various levels

b)

A preview with margins

c)

A View with a margins and gutter

d)

A preview in a full screen

92.

The symbol for Subscript and Superscript are ____ and ____

a)

X2 and X2

b)

X2 and 2X

c)

X2 and X2

d)

2X and X2

93.

Page layout tab can change which of the following in MS Word?

a)

Theme

b)

Arrange

c)

Page Setup

d)

All of the above

94.

To adjust the document margin in MS Word, we use which of the following?

a)

Indent

b)

Margin

c)

Space

d)

Border

95.

The function of bold option is?

a)

Italicizing the selected text

b)

Bolding the selected text

c)

Bolding all of the text

d)

None of the above

96.

Pressing F8 key for three times selects

a)

A word

b)

Entire document

c)

A paragraph

d)

A sentence

97.

The paragraph formatting is carried forward to the next paragraph by pressing the _____ key

a)

Shift

b)

Enter

c)

Ctrl

d)

Alt

98.

What is the default font used in MS Word 2007 document?

a)

Calibri

b)

Arial

c)

Times New Roman

d)

Monotype Corsiva

99.

In MS PowerPoint presentations, the designs regulate the layout and formatting for the slide. These are commonly known as:

a)

Blueprints

b)

Placeholders

c)

Templates

d)

Design Plates

100.

The Handout Master consists of placeholders for all of these except the:

a)

title

b)

slide number

c)

header

d)

footer

101.

Which of these PowerPoint features would allow any user to create a given simple presentation quicker?

a)

Animations

b)

Chart Wizard

c)

Transition Wizard

d)

AutoContent Wizard

102.

The File that consists of readymade styles that we can easily use for our presentation is known as:

a)

Pre formatting

b)

Template

c)

Wizard

d)

AutoStyle

103.

What is the max Zoom percentage in MS PowerPoint?

a)

400%

b)

300%

c)

200%

d)

100%

104.

A PowerPoint design template is stored in any file with __________ extensions.

a)

.pot

b)

.ptt

c)

.dtp

d)

.ppt

105.

Which of these options in PowerPoint would allow us to carry any set of slides from a given computer to another one?

a)

Web and Go

b)

Pack and Go

c)

Save and Go

d)

Save As

106.

Which of these is a type of sound file?

a)

DAT files

b)

LOG files

c)

DRV files

d)

WAV files

107.

In the current presentation, if we want to insert a new slide, we can choose which of these?

a)

Ctrl + F

b)

Ctrl + O

c)

Ctrl + M

d)

Ctrl + N

108.

Which of these terms do we use when an image in a clip art changes the direction that it was originally facing?

a)

Mirror

b)

Rotate

c)

Flip

d)

Group

109.

Which of these refers to the PowerPoint view used for displaying only the text (title and bullets)?

a)

Slide sorter show

b)

Slide view

c)

Outline view

d)

Notes page view

110.

Which toolbar provides various options in different master views?

a)

Standard toolbar

b)

Formatting toolbar

c)

Drawing toolbar

d)

Common tasks toolbar

111.

We can find any and every command on the:

a)

Menu bar

b)

Standard toolbar

c)

Formatting toolbar

d)

Drawing toolbar

112.

Which of these features should one use when we want to type in the text box for notes?

a)

Insert

b)

Slide shows

c)

Zoom

d)

Slide master

113.

Which of these is the page setup orientation by default of the slides in PowerPoint?

a)

Landscape

b)

Portrait

c)

Vertical

d)

None of the above

114.

From which of these menus can we access a Text Box, Picture, Chart etc.?

a)

View

b)

Insert

c)

Edit

d)

File

115.

Which of these font effects is NOT available in the PowerPoint Font dialogue box?

a)

Shadow

b)

Underline

c)

Strikethrough

d)

Emboss

116.

Which of these sections does a slide layout NOT have?

a)

Lists

b)

Animations

c)

Titles

d)

Charts

117.

What do we use if we want to add texts in a given slide?

a)

Comment Box

b)

Text Layer

c)

Note Box

d)

Text Box

118.

Which types of templates provides all the users with a design concept, colour scheme, and fonts for presentation?

a)

Content

b)

Format

c)

Normal

d)

Design

Similar Resources on Wayground

PTS PAI KELAS 4 SEMESTER 2

120 questions

PTS PAI KELAS 4 SEMESTER 2

quiz

Worksheet

•

Professional Development

Praxis 5412 Practice

120 questions

Praxis 5412 Practice

quiz

Worksheet

•

Professional Development

Page 1

120 questions

Page 1

quiz

Worksheet

•

Professional Development