NEW
Font size
Worksheetspractice quiz
Total questions: 12
Worksheet time: 6mins
What does it mean when you do Photo manipulation?
changing the theme
noise reduction
adjusting the settings
none of the above
Modern definitions describe ICT as the convergence of technologies, focusing primarily on:
time travel
access and sharing of information
teleportation
automation
In the Ribbon where can you find the Table of Contents command?
home tab
review tab
layout tab
reference tab
What is the primary function of the VLOOKUP?
to search horizontally
to search vertically
to count
to merge cells
What does “$” symbol mean when used in a cell reference such as $A$1?
cell is absolute
cell is protected
cell contains formula
cells contains monetary value
What is a Pivot Table used for?
to format cells
to create charts
to summarize and analyze data
to protect worksheets
“This content might be harmful to your computer, do you want to continue?”. What could be the possible internet threat described?
spamming
pharming
malware
phishing
Morse Type: I. Human to Machine focuses on how humans interact with their wearable.
II. Wearable Technology refers to the direct exchange of data and instructions
between the various sensors and device sets.
Statement I is TRUE, and statement II is FALSE
Statement I is FALSE, and statement II is TRUE
Both statements are TRUE
Both statements are FALSE
In MS Excel where can one find the Conditional Formatting options?
insert
home
review
page layout
To highlight cells with green color that have REMARKS of PASSED, what are the steps?
Home Tab> Styles Group> Conditional Formatting>Highlight Cells Rules> Greater Than
Home Tab> Styles Group> Conditional Formatting>Highlight Cells Rules> Equal To
Home Tab> Styles Group> Conditional Formatting>Highlight Cells Rules> Text that Contains
Home Tab> Styles Group> Conditional Formatting>Highlight Cells Rules> Between
To highlight cells with green text color in column that are above 89, what are the steps?
Home Tab> Styles Group> Conditional Formatting>Highlight Cells Rules> Greater Than
Home Tab> Styles Group> Conditional Formatting>Highlight Cells Rules> Equal To
Home Tab> Styles Group> Conditional Formatting>Highlight Cells Rules> Text that Contains
Home Tab> Styles Group> Conditional Formatting>Highlight Cells Rules> Between
To highlight cells with red color that have AVERAGE of below 74.00 what are the steps?
Home Tab> Styles Group> Conditional Formatting>Highlight Cells Rules> Greater Than
Home Tab> Styles Group> Conditional Formatting>Highlight Cells Rules> Equal To
Home Tab> Styles Group> Conditional Formatting>Highlight Cells Rules> Text that Contains
Home Tab> Styles Group> Conditional Formatting>Highlight Cells Rules> Less Than
