wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

SECOND REVIEWER | EMPOWERMENT TECHNOLOGIES

Total questions: 60

Worksheet time: 40mins

Name
Class
Date
1.

I need to know if Benzar is qualified to be a Scholar in our University. The requirements is an Average of >=88, and a > 22 grade in English. What is the right formula for me to be able to know if Benzar is qualified or not?

a)

=if(F6>=85,if(C6>22,"Qualified","Not Qualified"),"Not Qualified")

b)

=if(F6>=85,(C6>22,"Qualified","Not Qualified"),"Not Qualified")

c)

=if(F6>=85,if(C6>22,"Qualified","Not Qualified")

d)

=if(F6>=85,if(C6>22,"Qualified"),"Not Qualified")

2.

It is a software program produced by Microsoft that allows users to organize, format and calculate data with formulas using a spreadsheet system

(a)  

3.

It is the process of naming, editing, storing and sharing files. With a proper file folder naming scheme and the use of an understandable hierarchy, you can make of the most images and file collection.

(a)  

4.

It is a file storage and synchronization service developed by Google. Launched on April 24, 2012,

(a)  

5.

It is a file hosting service and synchronization service operated by Microsoft as part of its web version of Office.

(a)  

6.

It is the standard markup language for documents designed to be displayed in a web browser

(a)  

7.

Also known as a spreadsheet, It Manages spreadsheets, tables, and workbooks attached

(a)  

8.

Which symbol must all formula begin with?

(a)  

9.

In Excel, (a)   are vertical.

10.

In Excel, (a)   are horizontal

11.

A combination of numbers and symbols used to express a calculation. Always begins with an = sign.

(a)  

12.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
13.
What is the term used where a column and row intersect?
a)
Toolbar
b)
Cell
c)
Name Box
d)
Formula Bar
14.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
15.
___________ are often the best way to define which calculations will be performed first in Excel.
a)
Parentheses
b)
Forumlas
16.
By default, all cell references are _________ references. 
a)
Absolute
b)
Relative
17.
Unlike _________ references, _________ references do not change when copied or filled. 
a)
Absolute, Relative
b)
Relative, Absolute
18.

An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.

a)

%

b)

$

c)

&

d)

#

19.
In order to create a single formula to copy to the other rows, use ______ references so the formula calculates the total for each item correctly.
a)
relative
b)
relational
20.
If you don't want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
relative
21.
The most common way to identify a cell reference is 
a)
$D2
b)
$D$2
c)
D$2
d)
D2$
22.
The four arguments used in the VLookUp function are: Name of Item, _________, column index number, look for approximate match.
a)
range containing data
b)
Price of the item being looked for
23.
When using VLookUp, use _______________ if you want to look for approximate matches rather than an exact match.
a)
True
b)
False
24.
The LOOKUP function in Excel is used to search one column of data and find data in the _______ row
a)
Corresponding
b)
Value
25.
The LookUp function has three arguments. First ___________ then data to search and finally, results column
a)
Value to Look Up
b)
Value to Calculate
26.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
27.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
28.

Which formula will automatically capitalize the first letter of a word?

a)

abra-ka-dabra

b)

proper

c)

capitalize

d)

upper-case

29.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
30.
What does HTML stand for?
a)
Hypertext Making Language
b)
Hyper Transfer Markup Language
c)
Hypertext Markup Language
d)
Hyper Transfer Making Language
31.
HTML Language uses
a)
Tabs
b)
Tags
c)
Punctuation
d)
Quotations
32.
<h> is
a)
Header Tag
b)
Headline Tag
c)
Half of a tag
d)
Closing header tag
33.
Body tags are used;
a)
Used for only the header
b)
Used only for the paragraph
c)
element that wraps everything that is visible on the page.
d)
Not used in HTML
34.
<img> tag finds;
a)
finds the image located at the a URL and the src attribute and then displays it.
b)
finds the image located at the SRC in the URL attribute and then displays it.
c)
Adds a cool picture
d)
Does not work in HTML coding
35.

What does a opening tag look like?

a)

< >

b)

</ >

c)

<< >>

d)

<

36.

What does a closing tag look like?

a)

< >

b)

<\ >

c)

</ >

d)

<< >>

37.

What should a HTML web page start with?

a)

<b>

b)

<li>

c)

<html>

d)

<start>

38.

What is the difference between <h1> and <h2>?

a)

<h1> is larger in size than <h2>

b)

<h2> is larger in size than <h1>

c)

both are the same size but different headings

d)

none of the above

39.

Which tag would you use to insert a image?

a)

<marquee>

b)

< a href>

c)

<br>

d)

<img src>

40.
the tag <IMG> would insert what into a web page?
a)
Insert a title
b)
Insert a link
c)
Insert an image
41.
Which format usually works best for photos?
a)

JPEG

b)

DOC

c)

GIF

d)

WAV

42.
Which is NOT a web browser?
a)
Chrome
b)
Internet explorer
c)
FireFox
d)
Yahoo
43.
What does the <HTML> tag tell the browser
a)
that it is an HTML document
b)
defines the documents body
c)
that it contains all the head elements
44.
How would you set the height of a cell to 170 in a HTML table?
a)
Height="170"
b)
Ht="170"
45.
You should save HTML files with which file extension?
a)
.htm
b)
.index
c)
.webpage
d)
.html
46.
What is the correct HTML element for inserting a line break?
a)
<lb>
b)
<br>
c)
<break><bk>
47.
What HTML element defines the title of the document?
a)
<title>
b)
<head>
c)
<meta>
d)
<chicken>
48.
Which of the following is the smallest heading? 
a)
H3
b)
H4
c)
H5
d)
H6
49.

To create the largest possible "Heading" in HTML, which tag is correct?

a)

<HeadingLarge>

b)

<Head>

c)

<h1>

d)

<h+>

50.

Which comes first in your HTML document?

a)

<html>

b)

<doctype>

c)

<!DOCTYPE html>

d)

<Title HTML>

51.

Images in your webpage may have the following extensions except

a)

.png

b)

.gif

c)

.jpg

d)

.ocd

52.
Which tool puts text on top of the image?
a)
Spot Healing Brush
b)
Content Aware Move
c)
History Brush
d)
Type Tool
53.

These are your...

a)

Photoshop stuff

b)

Drawings

c)

Layers

d)

Pictures

54.
The undo button lets you undo your mistakes , but only the ones you made today.
a)
True.
b)
False
55.
What does a gray and white checkerboard background mean?
a)
The image is broken.
b)
The background is gray and white.
c)
The background is transparent.
d)
The image will display a white box around it.
56.

If I want to edit my picture with my tools I must be on the correct....

a)

Layer

b)

Tool

c)

quick select

d)

adjustment

57.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
58.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
59.
What is the formula to find the lowest number in cells C1:C4?
a)
=average(C1:C4)
b)
=max(C1:C4)
c)
=min(C1:C4)
d)
=sum(C1:C4)
60.
Which option shows the fill handle?
a)
A
b)
B
c)
C
d)
D

Similar Resources on Wayground

SMK Binaiswa 02 Cililin

55 questions

SMK Binaiswa 02 Cililin

quiz

Worksheet

•

11th Grade - University

Associate Diploma in Software Development Quiz- Set 1 (Amal)

60 questions

Associate Diploma in Software Development Quiz- Set 1 (Amal)

quiz

Worksheet

•

University

ÔN TẬP CUỐI HKI - LỚP 4

55 questions

ÔN TẬP CUỐI HKI - LỚP 4

quiz

Worksheet

•

4th Grade - University

ATM OPERATIONS

59 questions

ATM OPERATIONS

quiz

Worksheet

•

University

CS8392 - Object Oriented Programming - Unit 1

63 questions

CS8392 - Object Oriented Programming - Unit 1

quiz

Worksheet

•

University

Microprocessor & Microcontroller Basics

60 questions

Microprocessor & Microcontroller Basics

quiz

Worksheet

•

University

CD19-MIDTERM EXAM

65 questions

CD19-MIDTERM EXAM

quiz

Worksheet

•

University

Preparing for MTA Certification

60 questions

Preparing for MTA Certification

quiz

Worksheet

•

KG - University