wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Computer - 2nd Periodcal Exam

Total questions: 43

Worksheet time: 23mins

Name
Class
Date
1.

There are several options when formatting numbers, which you can see under

a)

Home Tab > Formatting > Numbers

b)

Home Tab > Number Group > Number Drop-down List

c)

Formatting > Number Group > Number Drop-down List

d)

Number Drop-down List > Formatting > Numbers

2.

What are the different form of numbers in excel. Choose all possible answers.

a)

Fraction

b)

Date

c)

Decimal

d)

Currency

e)

Roman Numerals

3.

Options has no specific format, and just display the original number you have inoutted

a)

Number

b)

Currency

c)

Accounting

d)

General

4.

Option adds 2(two) decimal places

a)

Number

b)

General

c)

Accounting

d)

Currency

5.

Option adds a default dollar sign on the left of the number

a)

Number

b)

General

c)

Currency

d)

Accounting

6.

Option adds a default dollar sign which is aligned left, and two decimal places.

a)

Number

b)

General

c)

Currency

d)

Accounting

7.

Option changes the number you have inputted into "mm/dd/yyyy"

a)

Short Date

b)

Date and Time

c)

Date

d)

Long Date

8.

Option changes the number you have inputted into "days of the week, month day, year"

a)

Short Date

b)

Date and Time

c)

Time

d)

Long Date

9.

Option changes the number you have inputted into "Hours:Min:Sec AM/PM"

a)

Short Date

b)

Date and Time

c)

Time

d)

Long Date

10.

Option adds two more zeros after the number, two decimal places and a percent (%) sign.

a)

Fraction

b)

Precentage

c)

Scientific

d)

Text

11.

Option turns your number into _______. This is only visible if the number you have inputted is a decimal. If not, it just display the number.

a)

Fraction

b)

Precentage

c)

Scientific

d)

Text

12.

Option makes the number looks like a ___________ Formula.

a)

Fraction

b)

Precentage

c)

Scientific

d)

Text

13.

Option recognize the number you have inputted as ____. You can see that it is aligned left just like texts.

a)

Fraction

b)

Precentage

c)

Scientific

d)

Text

14.

Arranging the contents of the columns in Excel makes searching for information easier.

a)

True

b)

False

15.

You can sort columns in Ascending or Descending order.

a)

True

b)

False

16.

To start filtering Data, uncheck first the "Select All". Then, tick the check boxes of the contents you want to remain visible.

a)

True

b)

False

17.

Sort from A to Z

a)

Ascending

b)

Descending

18.

Sort from Z to A

a)

Ascending

b)

Descending

19.

Which describes Ascending order. Choose all possible answers.

a)

From A to Z

b)

Smallest to Largest Number

c)

From Z to A

d)

Largest to Smallest Number

20.

Which describes Descending order. Choose all possible answers.

a)

From A to Z

b)

Smallest to Largest Number

c)

From Z to A

d)

Largest to Smallest Number

21.

To sort columns, select cells you want to sort, then go to the. . .

a)

Home Tab > Formatting > Sort & Filter

b)

Home Tab > Number > Sort & Filter

c)

Home Tab > Formulas > Sort & Filter

d)

Home Tab > Editing Group > Sort & Filter

22.

To filter data, select the cells you want to filter then go to the. . .

a)

Home Tab > Formatting > Sort & Filter > Filter

b)

Home Tab > Number > Sort & Filter ? Filter

c)

Home Tab > Formulas > Sort & Filter > Filter

d)

Home Tab > Editing Group > Sort & Filter > Filter

23.

This sorting offers more options like adding a level to make sorting more specific.

a)

Specific Sort

b)

Custom Sort

c)

General Sort

d)

Format Sort

24.

It has the option to hide contents from the worksheet.

a)

Filtering Data

b)

Sorting Data

c)

Editing Data

d)

Formatting Data

25.

Excel is only used in mathematical computations.

a)

True

b)

False

26.

The highlighted cell in your worksheet is called _________. It is where you can add contents such as text, images, diagrams and formulas.

a)

Highlighted Cell

b)

Perfect Cell

c)

Active Cell

d)

Super Cell

27.

You can select a cell by? Choose all possible answers.

a)

Pointing a cursor to your desired cell

b)

Use arrow keys on you keyboard

c)

Use control + v

d)

Pointing to home tab

28.

Which is used for customizing borders on cells.

a)

Border Tab

b)

Border Button

c)

Ribbon

d)

Menu

29.

The ribbon found above the worksheet contains different formatting tools.

a)

True

b)

False

30.

This used for coloring the background of selected cells.

a)

Border Color

b)

Color Tool

c)

Color Button

d)

Fill Color

31.

It is used to insert tables, illustrations, charts, spark lines, links, text and symbols.

a)

Insert Tab

b)

Edit Tab

c)

Format Tab

d)

Formulas Tab

32.

Text, numbers and formulas are the ONLY components that can be placed on work sheets.

a)

True

b)

False

33.

What are the different options under Illustration tools? Choose all possible answers.

a)

Pictures/Online Pictures

b)

Shapes

c)

SmartArt

d)

Screenshot

e)

Borders

34.

To add pictures in excel from your computer, select?

a)

Pictures tool

b)

Online Pictures tool

c)

SmartArt tool

d)

Screenshot tool

e)

Shapes Tool

35.

Once you inserted a picture a new tab will appear. It is called?

a)

Edit Tab

b)

Color Tab

c)

Format Tab

d)

Picture Tab

36.

It is where different tools for adjusting, editing picture styles, arranging and resizing the image can be found.

a)

Picture Tool

b)

Edit Tab

c)

Style Tab

d)

Format Tab

37.

What are the options NOT included in Picture Style group?

a)

Picture Border

b)

Picture Color

c)

Picture Layout

d)

Picture Effect

38.

Tools for editing font can found in?

a)

Home Tab > Allignment

b)

Home Tab > Styles

c)

Home Tab > Font

d)

Home Tab > Editing

39.

Font Group consist of changing font or typeface, font size, font style, font color, fill color and borders.

a)

True

b)

False

40.

What are the font styles you can use?

a)

Highlight

b)

Bold

c)

Italic

d)

Underline

41.

Remember to always put the _____ sign at the start of the formula in order for computations to work.

a)

  • + (Plus)

b)

  • - (Minus)

c)

X (Multiply)

d)

= (Equal)

42.

The formula used to multiply two numbers

a)

=<cell1>*<cell2>

b)

x<cell1>x<cell2>

c)

*<cell1>*<cell2>

d)

=<cell1>x<cell2>

43.

It is the formula used to divide two numbers.

a)

/<cell1>/<cell2>

b)

=<cell1>/<cell2>

c)

/<cell1><cell2>

d)

/<cell1><cell2>