wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Solon Microsoft Excel Quiz

Total questions: 50

Worksheet time: 28mins

Name
Class
Date
1.

What is the difference between Workbook and a worksheet?

a)

A workbook is the actual file that contains the worksheets, which turn contain the data.

b)

The worksheets contain the data and the workbook contains the tabs for each data type.

c)

A workbook is a section that contains the worksheet reports; both are contained in a spreadsheet.

d)

There is no difference other than which term you prefer to use for spreadsheets.

2.

When you insert a row, where does Excel place it in relation to the cursor position?

a)

Above the current row

b)

Below the current row.

c)

You must select the row before you can insert a new row.

d)

You must copy and paste any existing data down one row to have a blank row at the cursor position.

3.

Which character automatically indicates the contents of a cell are a formula?

a)

$

b)

=

c)

‘

d)

“

4.

How can data be aligned within a cell?

a)

Horizontally

b)

Horizontal and Vertical

c)

Vertically

d)

Horizontally, vertically, or rotated

5.

Why might you want to apply borders to a cell instead of just using the gridlines on the worksheet?

a)

Borders can help to separate and identify specific cells.

b)

You can highlight a row by clicking one button for outside borders.

c)

To emphasize specific cells in the gridline.

d)

To mark the print area of the worksheet.

6.

Why might you prefer to apply a background color to a cell instead of applying a pattern

a)

There is a limited number of patterns to choose.

b)

Patterns can make it harder to read the data than using a solid color.

c)

You can choose a lighter color whereas all patterns are dark in design.

d)

Patterns should only be used with cells that have formulas.

7.

All formulas begin with a

a)

&

b)

=

c)

%

d)

-

8.
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
9.
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
10.
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)
11.
How can you find specific information in a list?
a)
Select Tools > Finder from the menu
b)
Click the Find button on the standard toolbar
c)
Select Insert > Find from the menu
d)
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
12.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
13.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
14.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
15.
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
16.

Columns go...

a)

Across or Horizontally

b)

Down or Vertically

17.

Rows go...

a)

Across or Horizontally

b)

Down or Vertically

18.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
19.

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

a)

\

b)

*

c)

/

d)

|

20.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
21.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
22.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
23.

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.

24.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

25.
The name of the cell located at the intersection of column F and row 223 is:
a)
223F
b)
F223
c)
F222
d)
22F3
26.

_______________ involves creating a single cell by combining two or more selected cells.

a)

Cut and paste

b)

Merging cells

c)

Delete

d)

None of these answers

27.

A _______________, which appears when you right-click an object, is a list of frequently used commands that relate to the right-clicked object.

a)

Page layout

b)

Data

c)

Cell style

d)

Shortcut menu

28.

The horizontal and vertical lines on the worksheet itself are called.

a)

Excel window

b)

Status bar

c)

Gridlines

d)

Worksheet

29.

The ____________ presents information about the worksheet, the function of the button the mouse pointer is pointing to, or the mode of Excel.

a)

Page layout

b)

Status bar

c)

Page break view

d)

None of these answers

30.

How should you name a cell?

a)

Number + Letter

b)

Letter + Number

31.

What 3 types of data can be entered in a spreadsheet?

a)

Texts, numbers, charts

b)

Text, Colors, Pictures

c)

Text, numbers, formulas

32.

Which formula below finds the average of the cells?

a)

=AVERAGE(A1:A3)

b)

=AVERSGE(A1-A3)

33.
What is Microsoft Excel? 
a)
Spreadsheet Software
b)
Word Processing Software
c)
Audio Editing Software
d)
Presentation Software
34.
What is the purpose of a spreadsheet? 
a)
Store large amount of data
b)
Process and manipulate data
c)
perform calculation
d)
All of the above
35.
What is an example of a cell reference.
a)
8B
b)
B8
c)
BB
d)
88
36.
What is the term used to describe the symbols in a formula?
a)
Symbols
b)
Operators
c)
Formulas
d)
Functions
37.
What is a formula?
a)
Perform calculations in a spreadsheet.
b)
Is a predefined calculation.
c)
a tool to create a graph
d)
a tool to create a table
38.
A graph of plotted points that show the relationship between two sets of data.
a)
Pie Chart
b)
Scatter Graph
c)
Line Graph
d)
Bar Graph
39.
These graphs are usually used to show dependent data, and to display data which changes over time.
a)
Pie Chart
b)
Scatter Graph
c)
Line Graph
d)
Bar Graph
40.
With this type of graph, you can compare numbers between different categories which are independent so that if one changes it will not affect the others.
a)
Pie Chart
b)
Scatter Graph
c)
Line Graph
d)
Bar Graph
41.
This Graph shows a percentage of a whole. Your total is therefore 100% and the segments are proportionally sized to represent the percentage of the total. 
a)
Pie Chart
b)
Scatter Graph
c)
Line Graph
d)
Bar Graph
42.
Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this? 
a)
=(A1+A2+A3)/4
b)
A1+A2+A3/4
c)
=A1+A2+A3^4
d)
(A1+A2) + A3/4
43.
Minh wanted to find the average of all of her grades, but can not get her function work. Her spreadsheet is below. What error is Min making?
a)
She has the incorrect arguments
b)
She has the wrong function name
c)
She is missing an equal sign at the beginning of her formula
d)
The colon should be replaced with a dash (-)
44.
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)
45.

What is a bar graph used for?

a)

Showing differing values of data

b)

Showing parts of a whole

c)

Organizing data

46.

What is a pie chart used for?

a)

Showing differing values of data points

b)

Showing parts of a whole

c)

Organizing data points

47.

What tab do you click to find the charts and graphs?

a)

Home

b)

Insert

c)

Page Layout

d)

Formulas

48.

When creating a chart in Excel, what is the first thing you need to do?

a)

Select the data to be graphed.

b)

Select the Insert Tab

c)

Choose a chart from the ribbon

d)

Double click the active cell

49.

What does the mouse look like in a spreadsheet?

a)

Arrow

b)

Pointer

c)

Two headed arrow

d)

Selection cross

50.

The ability to quickly add a formula, set of number, months or day of the week down a column or across a row.

a)

Autofill

b)

Copy and Paste

c)

Drag and Drop

d)

Typing

Similar Resources on Wayground

Penilain Harian 2

50 questions

Penilain Harian 2

quiz

Worksheet

•

9th Grade - University

Ujian IoT PTS 2024 45 Soal

45 questions

Ujian IoT PTS 2024 45 Soal

quiz

Worksheet

•

11th Grade - University

PAS SIMDIG KELAS X (SMK IPTEK 56) 2019

50 questions

PAS SIMDIG KELAS X (SMK IPTEK 56) 2019

quiz

Worksheet

•

10th Grade

E-TECH Long Quiz

50 questions

E-TECH Long Quiz

quiz

Worksheet

•

11th Grade

SKD001

52 questions

SKD001

quiz

Worksheet

•

10th Grade

Simulasi Bahasa Indonesia Ke-1 (Paragraf)

50 questions

Simulasi Bahasa Indonesia Ke-1 (Paragraf)

quiz

Worksheet

•

9th Grade

EVALUACIÓN PARCIAL DE INFORMÁTICA

50 questions

EVALUACIÓN PARCIAL DE INFORMÁTICA

quiz

Worksheet

•

9th - 12th Grade

UH App inventor Kelas XI

50 questions

UH App inventor Kelas XI

quiz

Worksheet

•

12th Grade