wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS Excel Quiz

Total questions: 50

Worksheet time: 48mins

Name
Class
Date
1.

Combining two or more cells into one cell uses a Word feature called:

a)

Merge All Cells

b)

Merge Selected Cells

c)

Merge Split

d)

Split Cells

e)

Merge Cells

2.

Using the Sort feature in a table sorts selected content in what order?

a)

Ascending

b)

Descending

c)

AtoZ

d)

All of the above

e)

ZtoA

3.

Which of the following contains the commands you use most often, such as Save, Undo, and Repeat?

a)

Quick Access Toolbar

b)

Quick Access

c)

Quick command

d)

Quick toolbar

e)

Quick Access Screen

4.

The headings that appear on the Ribbon, such as File, Home, and Insert, are called:

a)

tabs

b)

groups

c)

insert

d)

menus

e)

shortcuts

5.

To preview a style or a theme, you must do which of the following?

a)

Print the document

b)

Set up the document properties

c)

Print Preview the document

d)

It is not possible to preview a style or theme

e)

Place your mouse pointer over the choice

6.

WordArt can be accessed by clicking on which of the following buttons?

a)

Drawing Tools

b)

Insert

c)

Design

d)

Picture Tools

e)

Layout Desain

7.

A document theme includes sets of which of the following?

a)

Colors

b)

Al of the above

c)

Fonts

d)

Size

e)

Effects

8.

Which of the following features removes all formatting from the selected text?

a)

Clear All Formatting

b)

Erase All Formatting

c)

Remove All Formatting

d)

Decrease Indent

e)

All Formatting Cleared

9.

Changing font size of selected text can be completed using which of the following?

a)

The Font group of the Home tab

b)

The Font Size

c)

All of the above

d)

The Font dialog box.

e)

The Mini toolbar

10.

Edit many cells with a text and change to another text by command?

a)

Replace All

b)

Change All

c)

Find All

d)

Manage All

e)

Create All

11.

Sorted data can consist of which of the following?

a)

dates

b)

text

c)

numbers

d)

eitheraorb

e)

All of the above

12.

Which of the following options would you use when saving a document with a new filename?

a)

Save As

b)

Ctrl+1+S

c)

Either a or b

d)

Save to

e)

Save

13.

Hyperlinks can be linked to which of the following locations?

a)

From one sheet to another sheet

b)

To a website

c)

To an email

d)

All of the above

e)

To a Message

14.

Per the order of operations, which of the following is calculated first?

a)

Negative number (-)

b)

Addition (+) and subtraction (-) (left to right)

c)

Percent (%)

d)

Exponentiation (*)

e)

Positive number (+)

15.

Which of the following commands is used to insert a cell into a worksheet?

a)

The Format Painter command in the Clipboard group on

b)

The Insert command in the Cells group on the Home tab

c)

the Home tab

d)

The Insert command in the Row group on the Home tab

e)

The Format command in the Cells group on the Home tab

16.

Which of the following can you not copy using Format Painter?

a)

Font color

b)

Italic

c)

Bold

d)

Font size

e)

Cell content

17.

Which of the following is an acceptable name for a named range?

a)

c7

b)

subtotal_west

c)

subtotal west

d)

Cc8

e)

subtotal/west

18.

Which of the following is not useful for changing the font size?

a)

Increase Font Size button

b)

Font Size drop-down list

c)

Decrease Font Size button

d)

Increase Indent button

e)
19.

Which of the following is not an arithmetic operator?

a)

]

b)

*

c)

+

d)

%

e)

-

20.

The COUNT and MIN functions are examples of which category of functions?

a)

Text

b)

logical

c)

Picture

d)

statistical

e)

financial

21.

Which of the following statements describes how you unhide a hidden row or column?

a)

Select a range of cells in the row or column, right-click,

b)

Remove the page

c)

Select the rows/columns before and after the hidden

d)

Use the Page Setup dialog box

e)

Remove all page breaks

22.

Which of the following is where you can save, select a template, change document properties, and close or exit Excel?

a)

Windows

b)

Save

c)

Edit

d)

Print

e)

Backstage

23.

An arrow in the lower-right corner of a group on the ribbon tells you that which of the following is available?

a)

An additional part of the current range

b)

Alist of workbook

c)

An additional workbook

d)

Alist of worksheets

e)

A dialog box or task pane

24.

Which feature enables you to preview headers and footers, page breaks, and other features that will print?

a)

ScreenTips

b)

Page Layout

c)

Synchronous Scrolling

d)

Print Layout

e)

Desain Layout

25.

Which of the following dialog boxes is used to transpose rows and columns?

a)

Page Setup

b)

Cells Width

c)

Column Width

d)

Row Height

e)

Paste Special

26.

You want to calculate the number of nonblank cells in your worksheet. Which function should be used?

a)

MIN

b)

MAX

c)

AutoSum

d)

SUM

e)

COUNTALL

27.

Which of the following statements accurately describes the default selection for AutoSum?

a)

By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content.

b)

AutoSum does not have a default selection.

c)

By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell

d)

You must make the selection before selecting AutoSum.

e)

AutoSum does have a default selection

28.

Which of the following is an example of a mixed cell reference?

a)

$AS$9

b)

A$9

c)

A9

d)

A9/E9

e)

AY/E9

29.

How to highlight many column with below average of the column

a)

Format Table As, top/bottom rules, Below Average

b)

Conditional Formatting, Higlight Cell Rules, Between

c)

Conditional Formatting, top/bottom rules, Below Average

d)

Conditional Formatting, Data Bars, Below Average

e)

Conditional Formatting, top/bottom rules, Top 10%

30.

Which command is used to insert a cut or copied selection to a cell or range of cells?

a)

Copy

b)

Range

c)

Duplicate

d)

Document properties

e)

Paste

31.

A tool that allows you to automatically fill cell contents based on the starting content.

a)

Backstage

b)

Name Range

c)

Autofill

d)

Go To

e)

Sortir

32.

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?

a)

AutoSum

b)

AVERAGE

c)

COUNT

d)

MAX

e)

MIN

33.

You want to format a cell, so the text is spread evenly throughout the cell, wrapping automatically and adjusting the row height, if necessary. Which of the following alignment options should be used?

a)

Justify

b)

Middle Align

c)

Center

d)

Center button

e)

Top Align

34.

Which of the following consists of details that describe or identify a file, including the author?

a)

Document properties

b)

Paste

c)

Copy

d)

Cut

e)

Range

35.

Special formatting applied to cells to display various criteria. This topic will be covered in detail in a later module.

a)

Go To

b)

Name Range

c)

Autofill

d)

Conditional Formatting

e)

Sortir

36.

When you modify the ribbon, which of the following is created?

a)

tab

b)

worksheet

c)

button

d)

command

e)

Enter

37.

Which of the following is an example of an absolute cell reference?

a)

A$9

b)

A9

c)

A9/E9

d)

A9E9

e)

A9

38.

Which is the correct formula and referencing to add bonus mark for Hairul below:

a)


=B6+$B$8

b)


=C6+$B$8

c)


=D6+B8

d)


=C6+B6

e)

=B6+$D$6

39.

................................. enables you to quickly format a chart with different colors, effects, and background.

a)

SmartArt

b)

Master Themes

c)

WordArt

d)

A Chart Style

e)

Text Box

40.

Text that identifies information about the values on an axis is called a(n)

a)

plot title

b)

legend

c)

Quick layout

d)

charttitle

e)

axis label

41.

How do you change the user name that will appear on each comment?

a)

Select the Manage Comments button on the Review tab

b)

Manually type your name into each comment

c)

Select File > Options and type a different User Name

d)

Select the Change User button on the Home tab

e)

Select the Change User button on the Home tab

42.

You can select a different font from the tab on the Ribbon.

a)

Review

b)

Home

c)

Font

d)

Layout

e)

Font Color

43.


Which of the following methods can be used to delete column D in a worksheet?

a)

Select column D, right-click, and choose the "Delete" option from the context menu.

b)

Go to the "Home" tab, click on the "Delete" dropdown in the Cells group, and choose "Delete Sheet Columns."

c)

Press "Ctrl" + "Space" to select the entire column D, then right-click and choose "Delete."

d)

Select column D, go to the "Layout" or "Page Layout" tab, and click on "Delete" in the Cells group.

e)

Access the "Data" tab, click on "Sort," and choose to sort by column D, then delete the sorted column D.

44.

Which of the following is not a paragraph alignment type?

a)

Right

b)

Left

c)

Center

d)

All

e)

Justify

45.

User written mathematical expressions in Excel are called

a)

Values

b)

Formula

c)

Numbers

d)

Differential

e)

Equation

46.

The formula =E7+(F7-G7) directs the spreadsheet to ___________.

a)

Multiply two numbers first, then subtract the first number.

b)

Subtract two numbers first, then add them with the first number.

c)

Subtract the first number and add the following two numbers.

d)

Divide the first number by the sum of the second two numbers.

e)

Add the first numbers, then add the second numbers

47.

When selecting a color, such as from the Font Color button’s palette, the colors on the top row are:

a)

shades

b)

theme colors

c)

row colors

d)

tints

e)

standard colors

48.

The Advanced Properties sheet enables you to add which of the following?

a)

category

b)

keywords

c)

All of the above

d)

comment

e)

author’s name

49.

Which of the following statements describes how you to create a chart?

a)

Click insert, Choose Chart

b)

Select a range of cells in the row or column, Click insert, Choose chart

c)

Click Chart, Choose Chart Design, Select Data

d)

Right Click , Add Chart

e)

Click Chart, Choose Chart Design, Add Chart Element

50.

1. The following that can only be used to run excel are?

a)

Start Menu

b)

Word Shortcuts on Desktop

c)

Powerpoint files

d)

formula

e)

WordArts

Similar Resources on Wayground

CAD ASSESSMENT PART 1

45 questions

CAD ASSESSMENT PART 1

quiz

Worksheet

•

University

EPA-11-DEC-2021 On Java

50 questions

EPA-11-DEC-2021 On Java

quiz

Worksheet

•

University

Grade 5 IT Quiz

50 questions

Grade 5 IT Quiz

quiz

Worksheet

•

5th Grade - University

Ngôn ngữ lập trình C/C++

50 questions

Ngôn ngữ lập trình C/C++

quiz

Worksheet

•

University

HTML Y CSS

50 questions

HTML Y CSS

quiz

Worksheet

•

University

Comptia Network+ chapter 1-3 exam

45 questions

Comptia Network+ chapter 1-3 exam

quiz

Worksheet

•

11th Grade - University

Networking - Practice Test #1

47 questions

Networking - Practice Test #1

quiz

Worksheet

•

9th Grade - University

KUIS Jaringan Komputer dan Internet

50 questions

KUIS Jaringan Komputer dan Internet

quiz

Worksheet

•

7th Grade - University