wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

E-TECH Long Exam for G11

Total questions: 102

Worksheet time: 49mins

Name
Class
Date
1.
a)
Save
b)
Undo
c)
Redo
d)
Underline
2.
Microsoft Word and Google Docs are examples of what?
a)
Word processors
b)
Spreadsheets
c)
Presentations
d)
Databases
3.
Google Docs or Microsoft Word allows to you to:
a)
create, edit, share and store forms for user input.
b)
create, edit, share and store webpages and sites
c)
create, edit, share and store spreadsheet documents
d)
create, edit, share and store word-processing documents.
4.
Which of the following commands appears in the Insert menu or tab?
a)
Table
b)
Undo/Redo
c)
Bold
d)
Line Spacing
5.
Left, Center, Right,and Justify are options for which tool located on the toolbar or ribbon?
a)
Zoom
b)
Line Spacing
c)
Bulleted Lists
d)
Text Alignment
6.
In Microsoft Word, what do you use to show a spreadsheet of data?
a)
Table
b)
menu
c)
toolbar
d)
copy
7.
In Microsoft Word, what is a "menu"?
a)
a spreadsheet
b)
a list of options available to a user
c)
row of buttons on a display screen with a variety of functions
8.
"Ctrl + c" is a shortcut that means to...
a)
copy
b)
paste
c)
cut
9.
"Ctrl + x" is a shortcut that means to... 
a)
paste
b)
copy
c)
cut
10.
"Ctrl + v" is a shortcut that means to...
a)
cut
b)
copy
c)
paste
11.

What is this button used for?

a)

Creating a new document

b)

Opening a document

c)

Saving a document

d)

Inserting a picture

12.

Which tab would you need to click if you wanted to add a photograph to your document?

a)

Home

b)

Insert

c)

Format

d)

Page Layout

13.

Which tab would you click to change the page to landscape?

a)

Home

b)

Format

c)

View

d)

Page Layout

14.

What is the opposite of landscape?

a)

Horizontal

b)

Vertical

c)

Portrait

d)

Upright

15.

Which of these buttons will let you change CAPITALS to lower case?

a)
b)
c)
d)
16.

Saving your work regularly is not really needed these days.

a)

True

b)

False

17.

Letter A on this Table image is referring to a...

a)

Column

b)

Table

18.

Calibri, Times New Roman, Comic Sans are all examples of...

a)

Header styles

b)

Font sizes

c)

Font Styles

19.
Columns run horizontally in tables, and rows run from left to right.
a)
True
b)
False
20.
Q12. Which tab to you click to save ?
a)
Home
b)
Insert
c)
File
d)
View
21.

If you click on a letter at the top of an Excel spreadsheet, what have you done?

a)

selected a cell

b)

selected a range of cells

c)

selected a row of data

d)

selected a column of data

22.

A four-sided arrow does what in Excel?

a)

copies the contents of one cell to others around it

b)

moves the contents of one cell to another location

c)

selects the cell

23.

Every formula starts with what?

a)

=

b)

+

c)

-

d)

( )

24.

What is the name of the bar above the worksheet that always shows the content of a cell as is denoted by the symbol fx?

a)

cell bar

b)

formula bar

c)

status bar

d)

name box

25.

If you click a number at the left of an Excel spreadsheet, what have you done?

a)

selected a cell

b)

selected a range of cells

c)

selected a row of data

d)

selected a column of data

26.

Where are the two places to find the autosum feature?

a)

Home ribbon

b)

Insert ribbon

c)

Function ribbon

d)

Formulas ribbon

27.

To exit an active formula, you always click out of the current cell?

a)

True

b)

False

28.

If the following was entered into a cell, what would appear in that cell? sum(A1:B3)

a)

the sum of A1 through B3

b)

sum(A1:B3)

c)

nothing

29.

If you see the following, what does it mean? ######

a)

the formula has an error

b)

the contents are too large to display

c)

text was entered where numbers should be

30.

If you change the value in a cell then the associated graph will NOT change.

a)

True

b)

False

31.

Select all of the following that are available under the Autosum button:

a)

sum

b)

minimum

c)

average

d)

maximum

e)

division

32.

What are the two (2) ways to display a spreadsheet in Microsoft Excel?

a)

fixed

b)

value

c)

variable

d)

formula

33.

If you center or merge and center it does exactly the same thing.

a)

True

b)

False

34.

What tool allows you to capture the formatting in one location and easily format other cells the same way?

a)

copy and paste

b)

cut and paste

c)

format painter

d)

alignment tool

35.

What is the difference in the following numbers: 1/3, .33, 33%

a)

the value

b)

the format

c)

the function

36.

What happens to a spreadsheet when you use the Ctrl~ command on a PC?

a)

calculates the values in formulas

b)

autofits the columns and rows

c)

displays the formulas

d)

nothing

37.

Which page orientation makes the sides longer than the top and bottom?

a)

landscape

b)

portrait

c)

fixed

d)

variable

38.

Margins are the white space on the spreadsheet where nothing prints.

a)

True

b)

False

39.

If you selected (A1:B5) what is this called?

a)

row

b)

column

c)

cell range

d)

cell grouping

40.

To arrange data in alphabetical or numerical order is what?

a)

coding

b)

sorting

c)

graphing

d)

grouping

41.

Microsoft program that allows you to create and make a presentation is called as .............................

a)

MS PowerPoint

b)

MS Word

c)

MS Excel

d)

MS Paint

42.

Which is the MS PowerPoint application logo?

a)
b)
c)
43.

MS PowerPoint Presentation consists of ....................

a)

Pages

b)

Worksheets

c)

Slides

44.

.................... has minimize, maximize and close options.

a)

Title bar

b)

Ribbon

c)

Office button

45.

Quick Access toolbar is present on the title bar. You can perform many tasks with just one click.

a)

True

b)

False

46.

................. is present at the bottom of PowerPoint, it displays the current slide number and view buttons.

a)

Title bar

b)

Ribbon

c)

Status bar

d)

Placeholder

47.

A ...................... is a rectangular box in a slide. You can click on it to add text or pictures.

a)

Ribbon

b)

Placeholder

c)

Status bar

48.

The ribbon consists of two parts: tabs and groups.

a)

True

b)

False

49.

Which one of the programs below is the PowerPoint presentation?

a)
b)
c)
50.

You can create only 9 slides in a presentation.

a)

True

b)

False

51.

Which group of the Insert tab contains the slide number facility?

a)

  Symbols

b)

Image

c)

Text

52.

  In which group of the Insert Tab does shapes fall in?

a)

Images

b)

Text

c)

Illustrations

53.

  In which group of the Home Tab is slide Layout contained in?

  

a)

Slides

b)

Drawing

c)

Font

54.

   To add a theme to the slide, you will click ______________________ tab.

    

a)

Insert

b)

Home

c)

Design

55.

   ____________________ view shows the slides in miniature form.

a)

Slide Show

b)

Slide Sorter

c)

Normal

56.

  _______________ key is used to stop the slide show.

a)

Ctrl

b)

Alt

c)

ESC

57.

  Viewing a presentation means to see your slides on a full computer screen.          

a)

True

b)

False

58.

MS word is software of ____

a)

Apple

b)

Android

c)

Google

d)

Microsoft

59.

Which is the word processing software?

a)

Avast

b)

MS Word 2010

c)

Google Chrome

d)

Mozilla Firefox

60.

The valid format of MS Word is ___

a)

.exe

b)

.doc

c)

.png

d)

.ppt

61.

 How can you create a new folder in your OneDrive?

a)

Click the "+ New" button and select folder

b)

Click the hamburger and select folder

c)

Click the waffle and select folder

d)

Click the cog wheel and select folder

62.

OneDrive lets you keep your files in ...

a)

On your C Drive

b)

Your flash drive

c)

The cloud

d)

On the common drive

63.

One of the benefits of OneDrive is that ...

a)

It lets you access your files anywhere.

b)

It gives you more space than your C drive (the drive on your laptop).

c)

It lets you share files with other users.

d)

All of the above

64.

How can you open a document from Office Online in the desktop application?  

a)

Click the "Open in" or "Edit in" button

b)

Start from the desktop application and then link to O365

c)

Download the document onto the desktop

d)

Drag and drop the document onto the desktop

65.

True or False:

You can ONLY upload documents onto your OneDrive by clicking on the "upload" button.

a)

True

b)

False

66.

How can you find documents that have been shared with you?

a)

In the waffle

b)

In files 

c)

In "Shared with me"

d)

In "Recent"    

67.

True or False:

Documents you create online in Office 365 MUST be "saved" before you exit the program.

a)

True

b)

False

68.

A cell is the intersection of a row and column?

a)

True

b)

False

69.

Displays the both name of application and the name of the spreadsheet.

a)

Name Box

b)

Spreadsheet Area

c)

Worksheet Tabs

d)

Title Bar

70.

A grid of cells organized into rows and columns in which we enter and store our data.

a)

Spreadsheet Area

b)

Name Box

c)

Insert Function

d)

All of the above

71.

Are rectangular tabs visible on the bottom left of the excel workbook.

a)

Worksheet tabs

b)

Title Bar

c)

Row Headers

d)

Scroll Bar

72.

In excel and other spreadsheet applications, the _____ is the colored row of letters used to identify each column within the sheet, or workbook. This is located above the row one.

a)

Formula Bar

b)

Active Cell

c)

Status Bar

d)

Column Header

73.

The ___ is located at the bottom of the screen, below the working area. It displays information about the current activities in the worksheet.

a)

Active Cell

b)

Status Bar

c)

Insert Function

d)

Dialog Launcher

74.

It is a section in Microsoft Excel and other spreadsheet applications. It shows the contents of the current cell and allow you to create and view formulas.

a)

Active Cell

b)

Formula Bar

c)

Command Buttons

d)

Ribbon Group

75.

This excel buttons are located at the extreme right-top corner of the excel window.

a)

Window Control Bottons

b)

Select Buttons

c)

Command Buttons

d)

None of the above

76.

Alternatively referred to as a cell pointer, current cell, or selected cell, a ______ is a rectangular box that highlights the cell in a spreadsheet.

a)

Formula Bar

b)

Dialog Launcher

c)

Ribbon Group

d)

Active Cell

77.

A small arrow in the lower- right corner of a group brings up more related commands.

a)

Formula Bar

b)

Dialog Launcher

c)

Ribbon Group

d)

Active Cell

78.

The function that lets you add up a range of cells or values

a)

SUM

b)

AVERAGE

c)

MIN

d)

MAX

79.

In computing for the % equivalent of Q1 and Q2 the following operators were used ________.

a)

addition and multiplication

b)

division and multiplication

c)

addition and subtraction

d)

subtraction and division

80.

CS or Class Standing is the ___________ of Q1%, Q2% and EXER

a)

sum

b)

min

c)

max

d)

average

81.

What function was used to find the lowest grade?

a)

average

b)

sum

c)

min

d)

max

82.

For the highest grade, this remark can be seen __________.

a)

Superior

b)

Excellent

c)

Very Good

d)

Good

83.

Passing grades are __________.

a)

75 and above

b)

70 and above

c)

69 and above

d)

60 and above

84.

What function was used to find the highest grade?

a)

average

b)

min

c)

sum

d)

max

85.

The Count column found on the Grade Count table, can be computed by this function.

a)

counta

b)

countif

c)

count

d)

countblank

86.

SUM, AVERAGE, IF, MIN and MAX are examples of _______.

a)

user-defined functions

b)

online functions

c)

table functions

d)

predefined functions

87.

All formulas used within the table are seen on the __________

a)

cells

b)

cell reference

c)

name box

d)

formula bar

88.

The function COUNT is specific for ___________

a)

counting cells

b)

counting numbers

c)

counting text

d)

counting tables

89.

To sort names in a worksheet, we can use this button.

a)
b)
c)
d)
90.

To display the Letter Grade Equivalent, we can use the ___ function.

a)

if

b)

count

c)

average

d)

sum

91.

What Font type was used for the table?

a)

Calibri

b)

Times New Roman

c)

Arial

d)

San Serif

92.

The exercise was named __________.

a)

DRILL1

b)

DRILL2

c)

DRILL3

d)

DRILL4

93.

In a worksheet, the vertical spaces with the headings A, B, C and so on

a)

Cell

b)

Column

c)

Row

d)

Data

94.

In a worksheet, the horizontal spaces with the headings 1, 2, 3 and so on

a)

Column

b)

Label

c)

Row

d)

Cell Address

95.

To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula

a)

&

b)

#

c)

=

d)

*

96.

The function that lets you add up a range of cells or values

a)

AVERAGE

b)

SUM

c)

MIN

d)

MAX

97.

What function was used to find the highest data ?

a)

AVERAGE

b)

MIN

c)

SUM

d)

MAX

98.

In Excel, the name of the bar where information appears as you input data in called ?

a)

File Bar

b)

Help Bar

c)

Formula Bar

d)

Window Bar

99.

Microsoft Excel is categorize as ?

a)

Word Processing Software

b)

Database Software

c)

Spreadsheet Software

d)

Presentation Software

100.

What function was used to find the lowest data ?

a)

AVERAGE

b)

MIN

c)

MAX

d)

SUM

101.

The function COUNT is specific for _________________

a)

Counting cells

b)

Counting text

c)

Counting number

d)

Counting tables

102.

The function COUNTA is specific for _________________

a)

Counting text

b)

Counting cells

c)

Counting number

d)

Counting tables

Similar Resources on Wayground

Tin 11 (KNTT- THUD)

100 questions

Tin 11 (KNTT- THUD)

quiz

Worksheet

•

11th Grade

Pemrograman Web

100 questions

Pemrograman Web

quiz

Worksheet

•

11th Grade

JS- Animation Basics - Intro to Programming - KhanAcademy

100 questions

JS- Animation Basics - Intro to Programming - KhanAcademy

quiz

Worksheet

•

9th - 12th Grade

HTML 2 - Dhony - SMA Xaverius 3 Palembang

100 questions

HTML 2 - Dhony - SMA Xaverius 3 Palembang

quiz

Worksheet

•

11th Grade

Computer Science Principals Final

102 questions

Computer Science Principals Final

quiz

Worksheet

•

9th - 12th Grade

pre uas blender

100 questions

pre uas blender

quiz

Worksheet

•

11th Grade

Python List

100 questions

Python List

quiz

Worksheet

•

8th Grade - University

Computer Science Vocabulary Practice

100 questions

Computer Science Vocabulary Practice

quiz

Worksheet

•

9th - 12th Grade