COMPUTER LITERACY QUIZ 2
Which of the following is NOT a feature of Microsoft Word?
Mail Merge
Spell Check
Track Changes
Data Analysis
Which ribbon tab in Microsoft Word contains options for formatting text?
Home
Insert
Page Layout
References
Which of the following is a valid file format for saving a Microsoft Word document?
.docx
.pdf
.xlsx
.pptx
Which ribbon tab in Microsoft Word contains options for inserting tables?
Insert
Home
Page Layout
References
What is the shortcut key to select all cells in a Microsoft Excel worksheet?
Ctrl+A
Ctrl+C
Ctrl+V
Ctrl+X
Which function is used to find the highest value in a range of cells in Microsoft Excel?
MAX
SUM
AVERAGE
COUNT
Which ribbon tab in Microsoft Excel contains options for formatting cells?
Home
Insert
Page Layout
Formulas
How do you freeze panes in Microsoft Excel?
View > Freeze Panes
Format > Freeze Panes
Insert > Freeze Panes
Data > Freeze Panes
Which function is used to count the number of cells in a range that meet a specific condition in Microsoft Excel?
COUNTIF
SUMIF
AVERAGEIF
MAXIF
How do you insert a new worksheet in Microsoft Excel?
Home > Insert > Worksheet
File > New > Worksheet
View > Insert > Worksheet
Data > Insert > Worksheet
Which ribbon tab in Microsoft Excel contains options for sorting and filtering data?
Data
Review
Formulas
View
Which of the following is NOT a valid chart type in Microsoft Excel?
Line Chart
Bar Chart
Pie Chart
Image Chart
Column Chart
How do you apply conditional formatting to a range of cells in Microsoft Excel?
Home > Conditional Formatting
Format > Conditional Formatting
Insert > Conditional Formatting
Data > Conditional Formatting
What is the shortcut key to insert a new row in Microsoft Excel?
Ctrl + Shift + +
Ctrl + R
Ctrl + N
Ctrl + A
Which function is used to calculate the average of a range of cells in Microsoft Excel?
AVERAGE
SUM
MAX
COUNT
Which of the following is NOT a valid data validation option in Microsoft Excel?
Allow Decimal
Allow Text Length
Allow Date
Allow Time
How do you merge cells in Microsoft Excel?
Select the cells to be merged, right-click, and choose 'Merge Cells'
Press Ctrl + M
Go to the Home tab and click on 'Merge & Center'
Use the formula =MERGE()
What is the shortcut key to open the 'Format Cells' dialog box in Microsoft Excel?
Ctrl + 1
Ctrl + F
Ctrl + Shift + F
Ctrl + Alt + F
How do you insert a new column in Microsoft Excel?
Right-click on the column header and choose 'Insert'
Press Ctrl + C
Go to the Home tab and click on 'Insert'
Use the formula =INSERT()
Which function is used to calculate the sum of a range of cells in Microsoft Excel?
COUNT
AVERAGE
MAX
SUM
How do you insert a new worksheet in Microsoft Excel?
Right-click on a sheet tab and select 'Insert'
Press Ctrl+C
Go to File > New Worksheet
Press F2
Which ribbon tab in Microsoft Excel contains options for sorting and filtering data?
Formulas
Data
Review
View
How do you apply a border to a range of cells in Microsoft Excel?
Right-click and select 'Format Cells'
Go to Home > Font
Go to Home > Alignment
Go to Home > Border
Press Ctrl+B
Which ribbon tab in Microsoft PowerPoint contains options for inserting images?
Insert
Design
Home
Animations
How do you apply a transition to a slide in Microsoft PowerPoint?
Select the slide and go to the 'Transitions' ribbon tab
Right-click on the slide and choose 'Apply Transition'
Click on the 'Transition' button in the toolbar
Press Ctrl + T on the keyboard
What is the default slide layout in Microsoft PowerPoint?
Title Slide
Blank Slide
Content Slide
Two Content Slide
Which of the following is NOT a valid slide transition in Microsoft PowerPoint?
Spin
Fade
Zoom
Print
Wipe
How do you add animation to an object in Microsoft PowerPoint?
Select the object and go to the 'Animations' ribbon tab
Right-click on the object and choose 'Add Animation'
Click on the 'Animation' button in the toolbar
Press Ctrl + A on the keyboard
Which ribbon tab in Microsoft PowerPoint contains options for designing slide layouts?
Design
Insert
Home
Transitions
How do you duplicate a slide in Microsoft PowerPoint?
Right-click on the slide and choose 'Duplicate Slide'
Select the slide and press Ctrl + D on the keyboard
Go to the 'Home' ribbon tab and click on the 'Duplicate Slide' button
Press Ctrl + C to copy the slide, then Ctrl + V to paste it
{"name":"COMPUTER LITERACY QUIZ 2", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"What is the default file extension for a Microsoft Word document?, Which of the following is NOT a feature of Microsoft Word?, How do you change the page orientation to landscape in Microsoft Word?","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}