wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

GEELECIT 'Living in the IT Era.' MIDTERM EXAMINATION

Total questions: 80

Worksheet time: 40mins

Name
Class
Date
1.

It is a computerized spreadsheet used to manipulate numerical data with formulas and built-in functions.

a)

Microsoft Excel

b)

Worksheets

c)

PPT

d)

Document

2.

Excel documents are stored as files called.

a)

Workforce

b)

Workgroups

c)

Worksheets

d)

Worktables

3.

Excel is a program that is used to prepare a

a)

Document

b)

Database

c)

Spreadsheet

d)

Presentation

4.

It shows the open program and the name of the open file.

a)

Search Bar

b)

Tab

c)

Tool Bar

d)

Title Bar

5.

It is designed to help users find tools quickly and easily by grouping the items together by tasks.

a)

Ribbon

b)

Sheet

c)

Tab

d)

Tool Bar

6.

Which of the following is not a term pertaining to spreadsheets?

a)

Browser

b)

Character

c)

Cell

d)

Formula

7.

This tab contains the commands most commonly associated with the formatting and editing of cells and their contents.

a)

Home Tab

b)

Insert Tab

c)

File Tab

d)

Review Tabs

8.

This tab contains the commands most commonly associated with the file.

a)

Home Tab

b)

Insert Tab

c)

File Tab

d)

Data Tab

9.

This tab contain the commands most commonly associated with adding something to the document.

a)

Home Tab

b)

Insert Tab

c)

View Tab

d)

Data Tab

10.

It contains the commands most commonly associated with settings that would affect the entire page or worksheet.

a)

Range

b)

Mouse

c)

Page

d)

Page Layout

11.

It is the rectangular area where a column and row intersect.

a)

Cell

b)

Tab

c)

Sheet

d)

Page

12.

The group of selected cells is known as

a)

Range

b)

Sheets

c)

Set

d)

Group

13.

A cell that is selected and defined by a bold border around the cell is called _________?

a)

Active cell

b)

Passive cell

c)

Formula cell

d)

Reference cell

14.

What is the other term for Name Box?

a)

Cell

b)

Cell Reference Area

c)

Area

d)

Active Cell

15.

The area where you can enter, edit text or formula.

a)

Formula Bar

b)

Scroll Bar

c)

Status Bar

d)

Tool Bar

16.

It is an equation that calculates a new value from values currently in a worksheet

a)

Number

b)

Page

c)

Function

d)

Formula

17.

Which of the following is not a term pertaining to Formulas?

a)

Function

b)

Names

c)

Page

d)

Formula

18.

An arrow shape that appears when the mouse is positioned at the top of the worksheet.

a)

Tab

b)

Arrow

c)

Bar

d)

Mouse Pointer

19.

Is used to scroll through the worksheet, allowing you to view the worksheet contents.

a)

Status Bar

b)

Tool Bar

c)

Scroll Bar

d)

Formula Bar

20.

It reports information about the current state of the program or the data contents in the window.

a)

Status Bar

b)

Tool Bar

c)

Scroll Bar

d)

Formula Bar

21.

Which of the following describe a function?

a)

It is a predefined formula that performs calculations

b)

It is a shorthand way to write an equation

c)

It consist of a built-in formula that is a shortcut for commonly used calculation

d)

All of the above

22.

Which of the following is the correct syntax upon using a function?

a)

Equal sign, Function Name, Argument.

b)

Function Name, Equal sign, Argument.

c)

Argument, Equal sign, Function Name.

d)

None of these.

23.

Which of the following does not belong to the group of statistical function?

a)

SQRT

b)

MAX

c)

AVERAGE

d)

COUNT

24.

The function that used to describe quantities of data

a)

statistical function

b)

mathematical function

c)

logical function

d)

power function

25.

The equation used to calculate values based on numbers entered in cells is called?

a)

formula

b)

function

c)

Function Name

d)

Argument

26.

Each formula begins with an

a)

#

b)

=

c)

/

d)

NUM!

27.

It is a constant (text or number) or cell reference used in a formula component.

a)

operand

b)

operator

c)

function

28.

plus sign (+) for addition. In the component formula.

a)

operand

b)

operator

c)

function

29.

Number Symbol means that the width of the cell is not enough to show the whole value or number.

a)

(###)

b)

#VALUE

c)

#REF!

d)

NUM!

30.

This function calculates the sum of the cells and then divides that value by the number of cells in the argument?

a)

SUM

b)

MAX

c)

AVERAGE

d)

COUNT

31.

This function counts the number of cells with numerical data in the argument?

a)

SUM

b)

MAX

c)

AVERAGE

d)

COUNT

32.

This function determines the highest cell value included in the argument?

a)

SUM

b)

MAX

c)

AVERAGE

d)

COUNT

33.

Which of the following is NOT a tab in MS Excel?

a)

Home

b)

Insert

c)

Format

d)

Email

34.

Which tab in MS Excel is used for inserting charts and pictures?

a)

Home

b)

Insert

c)

Page Layout

d)

Review

35.

Which tab in MS Excel is used for applying formatting to cells and data?

a)

Home

b)

Insert

c)

Format

d)

View

36.

Which tab in MS Excel is used for performing calculations and functions?

a)

Home

b)

Formulas

c)

Data

d)

Review

37.

Which tab in MS Excel is used for sorting and filtering data?

a)

Home

b)

Insert

c)

Data

d)

Review

38.

Which tab in MS Excel is used for changing the appearance of the worksheet?

a)

Home

b)

Insert

c)

Page Layout

d)

View

39.

Which tab in MS Excel is used for adding and deleting rows and columns?

a)

Home

b)

Insert

c)

Data

d)

Review

40.

Which tab in MS Excel is used for spell checking and reviewing the worksheet?

a)

Home

b)

Insert

c)

Review

d)

View

41.

Which tab in MS Excel is used for setting page orientation and margins?

a)

Home

b)

Insert

c)

Page Layout

d)

Review

42.

Which tab in MS Excel is used for creating and managing formulas?

a)

Home

b)

Formulas

c)

Data

d)

Review

43.

Which tab in MS Excel is used for printing and previewing the worksheet?

a)

Home

b)

Insert

c)

Page Layout

d)

View

44.

Which tab in MS Excel is used for protecting and securing the worksheet?

a)

Home

b)

Insert

c)

Review

d)

View

45.

Which tab in MS Excel is used for importing and exporting data?

a)

Home

b)

Insert

c)

Data

d)

Review

46.

Which tab in MS Excel is used for creating and managing pivot tables?

a)

Home

b)

Formulas

c)

Data

d)

Review

47.

Which tab in MS Excel is used for customizing the display and settings of the worksheet?

a)

Home

b)

Insert

c)

Page Layout

d)

View

48.

A cell that is selected and defined by a bold border around the cell is called ________?

a)

Active cell

b)

Passive cell

c)

Formula cell

d)

Reference cell

49.

Is the rectangular area where a column and row intersect?

a)

Cell

b)

Sheet

c)

Range

d)

Formula

50.

The group of selected cells is known as ________?

a)

Range

b)

Sheet

c)

Cell

d)

Column

51.

Column Letters or Column Headers are the letters along the top of the worksheet window that identify the different columns. It consisted of ______ columns.

a)

16,384

b)

16,834

c)

16,438

d)

16,843

52.

Rows Numbers or Rows Headers appear horizontally on the worksheet and are identified by numbers. Rows consisted of numeric labels from 1 - ______ rows.

a)

1,048,576

b)

1,048,574

c)

16.384

d)

1,048,567

53.

This function adds all of the values of the cells in the argument.

a)

SUM

b)

AVERAGE

c)

MIN

d)

MAX

54.

This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument. Fill in the blank.

a)

AVERAGE

b)

SUM

c)

COUNT

d)

MAX

55.

This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range. Fill in the blank.

a)

COUNT

b)

SUM

c)

AVERAGE

d)

MAX

56.

This function determines the highest cell value included in the argument. Fill in the blank.

a)

MAX

b)

MIN

c)

SUM

d)

AVERAGE

57.

This function determines the lowest cell value included in the argument. Fill in the blank.

a)

MIN

b)

MAX

c)

SUM

d)

AVERAGE

58.

Enumerate 7 types of function.

a)

Text, Logical, Date and Time, Lookup and Reference, Math and Trigonometry, Statistical, Financial

b)

Text, Image, Audio, Video, Animation, Graphics, Hyperlink

c)

Sum, Average, Count, Min, Max, Median, Mode

d)

Insert, Delete, Update, Select, Join, Group, Order

59.

Enumerate 5 types of statistical functions. List all 5.

a)

AVERAGE, COUNT, MAX, MIN, MEDIAN

b)

SUM, PRODUCT, DIVIDE, SUBTRACT, MULTIPLY

c)

MODE, RANGE, VARIANCE, STANDARD, ERROR

d)

TOTAL, SPLIT, CONCATENATE, REPLACE, FIND

60.

Enumerate 3 parts of a function. List all 3.

a)

Function name, Arguments, Parentheses

b)

Loop, Condition, Output

c)

Variable, Constant, Operator

d)

Class, Object, Method

61.

The full name of your instructor in GEELECIT “Living in the IT Era” is:

a)

Prof. Edwin E. Jambre Jr

b)

Dr. John Michael Santos

c)

Engr. Roberto Dela Cruz

d)

Ms. Angela Reyes

62.

What is the function of the Thick plus shape General Pointer in worksheet grids?

a)

Used in selecting a range of cells by clicking and dragging the mouse over the cells. Appears when the mouse is anywhere over the worksheet grid.

b)

Used to enter data into a cell directly.

c)

Used to resize columns and rows in the worksheet.

d)

Used to open the context menu for a cell.

63.

What is the function of the Thin plus shape cursor in spreadsheet software for Fill/Copy?

a)

Deleting cells

b)

Copying formulas or for creating a series of numbers

c)

Formatting cells

d)

Sorting data

64.

AutoFill in spreadsheet software is used for filling ________, days, or dates or times or a custom-made series. Hover the mouse pointer over the small square in the lower right corner of the cell pointer to get it.

a)

months

b)

colors

c)

fonts

d)

formulas

65.

What is the function of the mouse pointer ?

a)

Selecting text

b)

Moving contents of a cell or range of cells

c)

Formatting cells

d)

Deleting cells

66.

Fill in the blank: To make the mouse pointer for moving contents appear, hover the mouse over the ______ edge of a cell or selected cell range.

a)

black

b)

blue

c)

green

d)

red

67.

Which mouse pointer is used to move the contents of a cell or range of cells?

a)

Arrow pointer

b)

Compass pointer

c)

Hand pointer

d)

I-beam pointer

68.

What is the function of 'Split Screen' in a worksheet?

a)

Used to split the worksheet area into a divided section.

b)

Used to merge two worksheets into one.

c)

Used to delete all data in the worksheet.

d)

Used to change the font style of the worksheet.

69.

What does the arrow symbol shown below indicate in a worksheet?

a)

Used to split the worksheet area into a divided section

b)

Appears when positioned over the split bar directly above the vertical scroll arrow

c)

Used to scroll vertically

d)

Used to zoom in and out

70.

Fill in the blank: An arrow shape that appears when the mouse is positioned at the top of the worksheet, i.e., Office Button, Quick Access Toolbar, and Ribbon, or select an icon/commands is called a _________?

a)

Mouse Pointer

b)

Cursor

c)

Hand Tool

d)

Selection Arrow

71.

What is the function of the 'Cross Bar Resize' cursor?

a)

Making columns or rows wider or narrower. Appears as Column/Row when positioned between row heading and column heading.

b)

Selecting multiple cells at once.

c)

Inserting a new worksheet into the workbook.

d)

Changing the font style of the selected cells.

72.

What is the function of the Double Sided Resize arrow?

a)

To move the window/object

b)

To resize the window/object

c)

To close the window/object

d)

To minimize the window/object

73.

The Double Sided Resize arrow appears when the Arrow Window/Object is positioned on the window's ______ or selected object.

a)

border

b)

center

c)

corner

d)

side

74.

What does the small black arrow do in a spreadsheet application?

a)

Selects a single cell

b)

Selects an entire column or row

c)

Deletes a column or row

d)

Copies a column or row

75.

The small black arrow appears when the mouse is over a ________ or row heading.

a)

column

b)

cell

c)

formula bar

d)

worksheet

76.

What does the I-Beam cursor indicate when editing a cell entry?

a)

It indicates the cursor position when editing a cell entry.

b)

It indicates the cell is locked.

c)

It indicates a formula is being entered.

d)

It indicates the cell contains an error.

77.

Identify the name and function of the MS Excel mouse pointer shape shown in row 1.

a)

(Answer depends on the specific pointer shape shown in row 1, which is not visible in the image.)

b)

Fill Handle - Used to copy cell contents or continue a series.

c)

Move Pointer - Used to move cell contents.

d)

Selection Arrow - Used to select entire rows or columns.

78.

Identify the name and function of the MS Excel mouse pointer shape shown in row 4 (thick white arrow).

a)

Name: Standard Select; Function: Used to select menu items, commands, and other interface elements.

b)

Name: Fill Handle; Function: Used to copy cell contents or continue a series.

c)

Name: Move Pointer; Function: Used to move cells or ranges.

d)

Name: I-beam; Function: Used to edit cell contents.

79.

Identify the name and function of the MS Excel mouse pointer shape shown in row 5 (diagonal arrow).

a)

Name: Move Cursor; Function: Used to move cells or objects.

b)

Name: Fill Handle; Function: Used to copy cell contents or fill series.

c)

Name: Selection Cursor; Function: Used to select multiple cells.

d)

Name: Resize Cursor; Function: Used to resize rows or columns.

80.

Identify the name and function of the MS Excel mouse pointer shape shown in row 6 (horizontal double arrow).

a)

Name: Resize Column; Function: Used to resize column width.

b)

Name: Move Cell; Function: Used to move cell contents.

c)

Name: Select Row; Function: Used to select entire row.

d)

Name: Autofill; Function: Used to fill series of data.

Similar Resources on Wayground

IP Address Quiz

80 questions

IP Address Quiz

quiz

Worksheet

•

University

Computer skills - Chapter 2

82 questions

Computer skills - Chapter 2

quiz

Worksheet

•

University

Introduction to Cloud Computing

77 questions

Introduction to Cloud Computing

quiz

Worksheet

•

University

XML

82 questions

XML

quiz

Worksheet

•

University

Cisco - ITN7 - Module 1 - 3 Review

75 questions

Cisco - ITN7 - Module 1 - 3 Review

quiz

Worksheet

•

9th Grade - University

Sec-I-cquiz1

77 questions

Sec-I-cquiz1

quiz

Worksheet

•

University

SOAL X.E

82 questions

SOAL X.E

quiz

Worksheet

•

10th Grade - University

CHARAN! CHIKA RA GUD

83 questions

CHARAN! CHIKA RA GUD

quiz

Worksheet

•

University