wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Quiz - P7

Total questions: 69

Worksheet time: 47mins

Name
Class
Date
1.
How do you insert a new row?
a)
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
b)
Select the row heading where you want to insert the new row and select Edit >Row from the menu
c)
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
d)
All of the above
2.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
3.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
4.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
5.
Each Excel file is called a workbook because
a)
It can contain text and data
b)
It can be modified
c)
It can contain many sheets including worksheets and chart sheets
d)
You have to work hard to create it
6.
You can edit a cell by...
a)
Clicking the formula button
b)
Double clicking the cell
c)
Selecting Edit>Edit Cell from the menu
d)
None of above
7.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
8.
Columns go...
a)
Across
b)
Down
9.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
10.

Which of these symbols is used for divide on a computer?

a)

\

b)

*

c)

/

d)

|

11.
A cell name contains
a)
Cell name
b)
Column numbers and row letters
c)
Column letters and row numbers
d)
Cell locator coordinates
12.
Which of these formulas will find the correct average of the cells?
a)
=AVERAGE(A1:A10)
b)
=MEAN(A1:A10)
c)
AVERAGE(A1:A10)
d)
=(A1+A2+A3+A4+A5+A6+A7+A8+A9+A10)/10
13.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
14.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
15.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
16.

What can you do with the mouse to rename a sheet?

a)

Double Click on worksheet tab

b)

Right Click on the worksheet tab

c)

Both double click and right click the worksheet tab

17.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
18.
What kind of chart should you use to show the pieces (percentages) of a whole
a)
Bar Chart
b)
Column Chart
c)
Pie Chart
19.
Can you format text with Excel
a)
Yes
b)
No
20.
You can do other functions (besides addition) with the auto sum button ∑ such as average, max, min
a)
True
b)
False
21.
You can use the Auto Sum Key ∑ to subtract numbers.
a)
True
b)
False
22.

What is the "Active Cell" in Excel?

a)

The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

b)

The current cell in a worksheet. It is indicated by a dark border onscreen.

c)

The top cell in a worksheet. It is indicated by a dark border onscreen.

d)

The past cell in a worksheet. It is indicated by a dark border onscreen.

23.

Define Cell?

a)

The dark bordered box in excel.

b)

A box in Excel that has formulas.

c)

The intersection of a column or row in a worksheet or table.

d)

Fx Bar where you input data.

24.

Define Formula Bar?

a)

I don't know

b)

I don't care

c)

Don't miss this one!

d)

An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

25.

What is a spreadsheet?

a)

An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.

b)

An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.

c)

An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.

d)

An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.

26.

What is a sheet in Excel?

a)

A single document that typically contains labels, values, formulas, functions, and graphical representations of data.

b)

A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.

c)

A single template that typically contains labels, values, formulas, functions, and graphical representations of data.

d)

A single file that typically contains labels, values, formulas, functions, and graphical representations of data.

27.

What is the green bar at the top of Excel referred to as?

a)

the data bar

b)

the function bar

c)

the ribbon

d)

the row

28.

The letters in Excel represent the _______?

a)

columns

b)

rows

c)

data

d)

functions

29.

The numbers in Excel represent the _____?

a)

columns

b)

rows

c)

data

d)

functions

30.

What version of Excel are we using in class?

a)

Excel 2016

b)

Excel 2017

c)

Excel 2018

d)

Excel 2015

31.

Excel allows you to work with?

a)

Sentences

b)

Paragraphs

c)

data

32.
True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?
a)
false
b)
true
33.

Excel would be the ideal program to type a book report?

a)

False

b)

True

34.
How do you make a cell the active cell?
a)
Click the ACTIVE button
b)
Click INSERT CELL
c)
Click on the cell
d)
Cells are always active
35.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
36.

Define Cell?

a)

The dark bordered box in excel.

b)

A box in Excel that has formulas.

c)

The intersection of a column or row in a worksheet or table.

d)

Fx Bar where you input data.

37.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
38.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
39.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
40.
Rows in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside Down
d)
Right Side
41.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
42.
Cells are identified by the following:
a)
Column Letter followed by their Row Number
b)
Row Number followed by their Column Letter
c)
Row Number Only
d)
Column Letter Only
43.
What is another term for an Excel spreadsheet?
a)
Worksheet
b)
Workbook
c)
File
d)
Magazine
44.
The active cell is the same thing as the ____
a)
Cell box
b)
Sheet 1
c)
Name box
d)
Selected cell
45.
The cell reference and the cell name are the same things.
a)
True
b)
False
46.
When the cell is not wide enough to hold a number, which symbols appear in the cell?
a)
????????
b)
#######
c)
/\/\/\/\/\/\/\
d)
=======
47.
What is required to store a formula in a cell?
a)
equal sign
b)
plus sign
c)
command
d)
a slash
48.
An arrow in the bottom-right corner of a group on the ribbon tells you that which of the following is available?
a)
dialog box
b)
additional workbook
c)
list of worksheets
d)
additional part of the current range
49.
Which feature enables you to preview headers and footers, page breaks, and other features that will print?
a)
Page preview
b)
Print Layout
c)
Synchronous Scrolling
d)
Window View
50.
Which of the folowing starts off with open, undo, and can be customized to contain the commands you use most frequently?
a)
a worksheet
b)
the help window
c)
the quick access toolbar
d)
the ribbon
51.
How many worksheets does a new Excel 2013 workbook open with?
a)
one
b)
two 
c)
three
d)
four
52.
 Click the FILE tab to get to Backstage view.
a)
true
b)
false
53.
. Page Layout view is useful when preparing your data for printing.
a)
true
b)
false
54.
When numbers are added together the answer is called the
a)
Product
b)
Sum
c)
Quotient
55.
What format is used for dollar amounts?
a)
Normal
b)
Date
c)
Accounting
d)
Time
56.
This icon is called the what?
a)
Arrow
b)
Fill handle
c)
Pointer
57.
For which of the following tasks would you use the fill handle?
a)
to apply shading 
b)
to apply a border
c)
to copy a formula from cell A2 to cell A3
58.
What is the formula for =sum(B2:B9)
a)
B1+B2+B3+B4
b)
=B2+B3+B4+B5+B6+B7+B8+B9
c)
B2+B3+B4+B5+B6+B7+B8+B9
d)
=B1+B2+B3+B4
59.
What is the formula to find the lowest number in cells C1:C4?
a)
=average(C1:C4)
b)
=max(C1:C4)
c)
=min(C1:C4)
d)
=sum(C1:C4)
60.
What would I use to combine cells A1:A9?
a)
adjust column width
b)
merge
c)
wrap text
61.

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

62.

To quickly add a set of number you can use the ____ feature?

a)

Plus Sum Button

b)

Add Sum Button

c)

Quick Add Button

d)

Auto Sum Button

63.

What is the green bar at the top of Excel referred to as?

a)

the data bar

b)

the function bar

c)

the ribbon

d)

the row

64.

When starting a formula what is the first thing you type in the cell?

a)

+

b)

-

c)

%

d)

=

65.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

66.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
67.
Gerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?
a)
=(C3+C5+C9)/3
b)
=SUM(C2:C10)
c)
=AVERAGE(C2:C10)
d)
=(C3+C5+C9)
68.
This icon is called the what?
a)
Arrow
b)
Fill handle
c)
Pointer
69.

Which of the following formulas is correctly written for Excel?

a)

=5B*4

b)

5+8=

c)

D3/4=

d)

=B1-D23

Similar Resources on Wayground

Latihan Soal TIK_8

70 questions

Latihan Soal TIK_8

quiz

Worksheet

•

8th Grade

Grade 7 - Class Test Revision Chapter 1

65 questions

Grade 7 - Class Test Revision Chapter 1

quiz

Worksheet

•

7th Grade

Latihan PTS Ganjil 2023/2024 Informatika Kelas 7

67 questions

Latihan PTS Ganjil 2023/2024 Informatika Kelas 7

quiz

Worksheet

•

7th Grade

Kuis Algoritma dan Struktur Data

64 questions

Kuis Algoritma dan Struktur Data

quiz

Worksheet

•

7th Grade

J04 互联网及其应用

70 questions

J04 互联网及其应用

quiz

Worksheet

•

7th Grade

ANALISIS DATA KELAS 7G 2023

70 questions

ANALISIS DATA KELAS 7G 2023

quiz

Worksheet

•

7th Grade

Chrome & Parts & Tech

70 questions

Chrome & Parts & Tech

quiz

Worksheet

•

5th - 7th Grade

Kuis Informatika Kelas 8

70 questions

Kuis Informatika Kelas 8

quiz

Worksheet

•

8th Grade