empowerment technology Flashcards by Suziene Tiu

You will be able to
create a spreadsheet application using the following; (9)

Cell Formatting
Conditional Formatting
Advance Formulas
Linked Tales.
Microsoft Excel
Google
Slides
OpenOffice and Libre Office

How well did you know this?

Not at all

Perfectly

Based on the activities, what is the use of a Spreadsheet software?

A. It allows the data to be stored, organized and analyzed.
B. It gives the user the ability to create tables.
C. It enables users to record words and numbers.
D. It is a software that allows input, editing, formatting and output of text

A. It allows the data to be stored, organized and analyzed

How well did you know this?

Not at all

Perfectly

How can you create a new tab in Windows Excel?

A. In the ribbon, select Home>Tabs>Add Tabs then input how many tab you like to add.
B. In lower portion of the work area, press the plus button besides the tabs.
C. Press Ctrl + A then press Ctrl + Shift + N.
D. You can’t add tabs in Microsoft Excel.

B. In lower portion of the work area, press the plus button besides the tabs.

How well did you know this?

Not at all

Perfectly

Harold wants to drag select cells A1 to D7. How can he accomplish this?

A. Long press Alt then click A1 then click D7.
B. While pressing shift select the A1 then D7
C. In the formula bar type A1:D7
D. Press Ctrl + A.

B. While pressing shift select the A1 then D7

How well did you know this?

Not at all

Perfectly

What is the formula that will subtract the contents of the cells A7 and A8?
A. A7 - A8
B. = A7 - A8
C. A7 - A8 =
D. =SUM (A7:A8)

B. = A7 - A8

How well did you know this?

Not at all

Perfectly

How to format a cell that will automatically add a peso sign?

A. Select the cell or cells you want to edit then press Insert > Symbol > More Symbols.
Scroll down and look for the peso sign then press insert.
B. Select the cell or cells you like to add formatting. Press right click then click Symbol >
More Symbols. Scroll down and look for the peso sign then press insert.
C. In the ribbon, select the Home tab then click Format Cells. In the Number tab, click
Currency then in the dropdown box search for the peso sign symbol.
D. Select the cell or cells you like to add formatting press right click then Format Cells.
Then in the Number tab, click Currency then in the dropdown box search for the peso
sign symbol.

D. Select the cell or cells you like to add formatting press right click then Format Cells.
Then in the Number tab, click Currency then in the dropdown box search for the peso
sign symbol.

How well did you know this?

Not at all

Perfectly

How do you resize a column or width?

A. Select the cell the press right click, select format cell then change height and width
values.
B. In the Formula bar type (h[value]:w[value]).
C. Click the cell then in the ribbon select format cell then change height and width values.
D. Click and drag the column or row heading.

D. Click and drag the column or row heading.

How well did you know this?

Not at all

Perfectly

What is the formula that will add the contents of the cells C1 and C10?
A. C1 + C10
B. = C1 + C10
C. C1 + C10 =
D. SUM (C1:C3)

B. = C1 + C10

How well did you know this?

Not at all

Perfectly

How do you resize a graph?

A. Click the graph then click and drag any of the eight handles in the edges of the graph.
B. Select the table then press right click, a window will appear, select the Width change
the value desired then select height change the value desired.
C. Select the table the press Ctrl + Arrow Keys.
D. You can’t change the size of graphs.

A. Click the graph then click and drag any of the eight handles in the edges of the graph

How well did you know this?

Not at all

Perfectly

How do you resize a graph?

A. Click the graph then click and drag any of the eight handles in the edges of the graph

How well did you know this?

Not at all

Perfectly

How do you rename a graph into “First Data” in Microsoft Excel?

A. Press right click then select rename, a window will appear then type “First Data”.
B. Press Ctrl + A then Ctrl + R, rename the chart to “First Data”
C. Double click the name of the chart and type “First Data”.
D. Graph names can’t be changed as they follow the name from the selected data

C. Double click the name of the chart and type “First Data”.

How well did you know this?

Not at all

Perfectly

What is the purpose of the Formula Bar?

A. It allows an easy to see input box for formula in a cell
B. It is a selection of shortcuts different formula in Microsoft Excel
C. It is the formula that allows computation of values from different cells.
D. The Formula Bar is a label below the cell that indicates the result of a formula

A. It allows an easy to see input box for formula in a cell

How well did you know this?

Not at all

Perfectly

Which Ribbon Menu is needed to be selected to change the font?
A. Home
B. Insert
C. Page Layout
D. Cell Formatting

A. Home

How well did you know this?

Not at all

Perfectly

How do you assign which cell the formula = (A1 + A2) + A3 will be displayed on?

A. On the formula bar type cell address
B. Press right click then select Cell Format then click on the Formula tab, type which cell
you want that formula will be displayed
C. In the ribbon click Cell Formatting then select the formula then type where it will
displayed.
D. Type the formula where you want it to be displayed on

D. Type the formula where you want it to be displayed on

How well did you know this?

Not at all

Perfectly

Which Ribbon Menu is needed to add a Chart?
A. Home
B. Insert
C. Page Layout
D. Cell Formatting

B. Insert

How well did you know this?

Not at all

Perfectly

With this formula = Expense!C12, what does the Expense! part means?

A. It a variable that allows quick reference of a value.
B. It is formula label, allowing the user to manage all the formula.
C. It indicates that the c12 to be displayed is on the sheet Expense
D. This is not a proper use of the formula.

C. It indicates that the c12 to be displayed is on the sheet Expense

How well did you know this?

Not at all

Perfectly

How do you change formula style in a sheet?

A. Click Insert > Cell Formatting > Table Format > Table Style
B. Click Home > Format as Table > Table Style
C. Click Cell Formatting > Format Table > Table Style
D. You have to select each cell then add cell borders to each of them

B. Click Home > Format as Table > Table Style

How well did you know this?

Not at all

Perfectly

Rich Content

consists of different media formats (sound, video
and images) used at same time and place.

How well did you know this?

Not at all

Perfectly

User Experience

the overall experience of a person using a product
such as a website or computer application,
especially in terms of how easy or pleasing it is to
use.

Online
Environment

characterized on the basis of how the person
experiences and perceives something specific

Semantic Web

a component of Web 3.0

User
Participation

other users can contribute to content of the
website through comments

Web 3.0

-a semantic web
-the portable personal
web

Web 2.0

-1 billion + global user (2016)
-the wildly read-write
web

Web 1.0

-45 million global users (1996) -the mostly read only web

Rich media content

used advanced technology of immediate user interaction

usability

the quality or state of being usable

Which of the following is the integration of text, sound, graphics, animation and video into a single unit? a. website b. webpage c. multimedia d. presentation

c. multimedia

What is defined as the behaviors shown by the person or individual that uses the application or product over the net? a. user demand b. user experience c. user participation d. user as a contributor

c. user participation

Which system enables users to select video and audio content when they want it? a. Video on demand b. Online environment c. Online participation d. Online courseware and tutorials

a. Video on demand

In which field does multimedia play a vital role as it encourages the learners to interact inside the class? a. Industrial b. Education c. Entertainment d. Advertisement

b. Education

What is considered as one of the most popular multimedia applications because of its movies and video games? a. Advertisement b. Entertainment c. Education d. Industrial

b. Entertainment

Which of the following BEST describes the presentation? a. a speech b. a television interview or news report c. information presented using more text than graphics and animation d. a sequence of slides that usually incorporate text, sound, graphics, and animation

a. a speech

Web servers and web browsers rely on the SSL protocol to help users protect their data during transfer by creating a uniquely encrypted channel for private communications over the public internet. What does SSL stand for? a. saving sharing and limits b. safe secured and locked c. secure socket limbs d. secure socket layers

d. secure socket layers

Multimedia play’s important role today. Which of the following BEST describes multimedia? a. images and audio b. moving images and text c. programs that combine text and images on a television screen d. integration of still and moving images, text, and sounds by means of technology

c. programs that combine text and images on a television screen

It is a good way for communication and helps us to understand the messages that someone’s trying to convey because of the combination of text, graphics, audio, video, and animation using computers. It is called ____________. a. media b. newspaper c. multimedia d. hypermedia

c. multimedia

In the 1980s, ISP was a company that provided individuals and other companies access to the internet and other related services such as Web site building and virtual hosting. What does ISP stand for? a. International Service Protocol b. Internal Services Protection c. Internet Service Provider d. Internet Search Program

c. Internet Service Provider

Which of the following advances in multimedia were made in the early 1970’s? a. Advances in the ability to fit more text in a presentation b. Advances in making supercomputers c. Advances in integrating computers with CD’s d. Advances in graphics, movies, and audio

d. Advances in graphics, movies, and audio

Educational websites help make the process of learning entertaining and attractive to the audience, especially in today’s generation. Which of the following BEST describe computer-based training? a. a video game b. a method of training a computer to reject viruses. c. a method of education that allows people to learn at their own pace, using interactive software. d. a method of training the computer to perform routine tasks

c. a method of education that allows people to learn at their own pace, using interactive software.

Businessmen use online platforms for promotion purposes; therefore, Ecommerce websites are for ____________. a. business to business transactions and business to consumer transactions b. getting money from your computer online c. selling your home on the net d. a revolution in business practices

a. business to business transactions and business to consumer transactions

The Cold War is the major reason why the United States formed a new way of communication, now commonly known as ______________. a. platform b. software c. website d. internet

d. internet

Each webpage has its own unique _____________. a. database connection b. personal search engine c. animation scheme d. universal resource locator (URL)

d. universal resource locator (URL)

are used for enhancing the experience with webpages.

Audio and Video

allows users to communicate and collaborate with each other virtually

Web 2.0

that relies on the use of machine learning and artificial intelligence.

web 3.0

assist self-paced learning.

course ware