Font size
WorksheetsEmpowerment Technologies
Total questions: 25
Worksheet time: 10mins
A function used to count the number of cells in a range if a certain condition is met.
AVERAGEIF
COUNTIF
AVERAGE
RANGE
The act of using a computer to create, edit, save, and print documents is called _______.
Word processing
Data encoding
File management
Desktop publishing
Microsoft Word was first released on (a) .
Select ALL the spreadsheet skills.
Custom Filtering
Sort by Column
Manual computation
Macros and Scripts
Combine Multiple Functions
Which term refers to the selected cell in a worksheet?
Formula Bar
Column Heading
Cell Reference
Active Cell
The (a) displays the contents or formula of a selected cell.
The feature used to replace words throughout a document is called Search and Find.
TRUE
FALSE
Identify the Quick Access Toolbar
Which spreadsheet program is commonly used to store, organize, and analyze information?
Microsoft PowerPoint
Microsoft Word
Microsoft Excel
Microsoft Access
What feature allows you to create personalized letters for multiple recipients at once?
Mail Merge
Headers and Footers
Templates
Macros
Match the following
Ctrl+Shift+A
All Caps
Ctrl+Page Up
Previous Page
Ctrl+W
Close Document
Ctrl+Q
Remove Paragraph Formatting
Ctrl+=
Subscript
The shortcut keys Windows Logo + R, then typing (a) opens MS Word.
What does the =AVERAGE(x,y) function do?
Returns the total value
Returns the product
Returns the difference
Returns the average value
What symbol must every Excel formula begin with?
+
@
#
+
Which tab in MS Word allows you to insert tables, pictures, and charts?
Home
Insert
Page Layout
View
Which of these shows the text wrapping "TIGHT"
Which Excel function joins two text strings together?
=COUNT(range)
=SUM(x,y)
=CONCATENATE(x,y)
=AVERAGE(x,y)
What is the purpose of protecting a worksheet in Excel?
To increase file size
To prevent unauthorized changes
To add formulas automatically
To filter data quickly
A cell reference usually consist of TWO NUMBERS
YES
NO
The image format that supports transparency and simple animation is (a) .
Which feature allows users to look for alternative words without leaving the program?
AutoCorrect
Grammar Checker
Spell Check
Thesaurus
Which function determines whether a number is even?
=ISODD(x)
=ISEVEN(x)
=COUNT(x)
=ABS(x)
What will Excel display in the cell after entering a formula?
The formula text only
An error message always
The calculated result
The cell reference
Which tab in MS Word is used to change margins, page size, and orientation?
Page Layout
View
Home
Insert
Which term refers to the box at the top of a column containing letters?
Row Heading
Active Cell
Column Heading
Cell Reference
