wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel2016Quiz

Total questions: 70

Worksheet time: 47mins

Name
Class
Date
1.
The _______ displays the location, or name, of a selected cell.
a)
Name Box
b)
Status Bar
2.
If you frequently work with the same workbook, you can _______ it to Backstage view for faster access.
a)
Save
b)
Pin
3.
Sometimes you may need to work with workbooks that were created in earlier versions of Microsoft Excel, such as Excel 2003 or Excel 2000. When you open these types of workbooks, they will appear in _____________ Mode.
a)
Read-Only
b)
Compatibality
4.
To access Excel templates from the backstage view click ________.
a)
Open
b)
New
c)
Save
d)
Save As
5.
Select a template to review it. A ________ of the template will appear, along with additional information on how the template can be used.
a)
Copy
b)
Preview
6.
You can browse templates by category or use the__________ bar to find something more specific.
a)
Tell Me
b)
Search
7.
____________ Mode disables certain features, so you'll only be able to access commands found in the program that was used to create the workbook. 
a)
Safe
b)
Compatibility
8.
When You locate and select Convert command. The __________ _______ will appear
a)
Dialog Box
b)
Save As
9.
 Excel is capable of _________1048576 rows, and _________ Columns.
a)
1048576, 16384
b)
65536, 296
10.
1. In the formula bar, you can enter or edit ________, a _______, or a _________ that will appear in a specific cell.
a)
data, formula, function
b)
workbooks, worksheet, cell
11.
The ______________ box works like a search bar to help you quickly find tools or commands you want to use.
a)
Tell Me
b)
Search
12.
Each rectangle in a workbook is called a Cell. A Cell is the intersection of a row and a column. Simply click to select a ___________.
a)
Cell
b)
Row
c)
Column
d)
Worksheet
13.
Each rectangle in a workbook is called a Cell. A Cell is the intersection of a row and a column. Simply click to select a ___________.
a)
Cell
b)
Row
c)
Column
d)
Worksheet
14.
A _______ is a group of cells that runs from the left of the page to the right. In Excel, ___________ are identified by numbers.
a)
Column, Columns
b)
Row, Rows
c)
Cell, Cells
d)
Worksheet, Worksheets
15.
A ___________ is a group of cells that runs from the top of the page to the bottom. In Excel, ___________ are identified by letters.
a)
Row, rows
b)
Column, Columns
16.
Excel files are called a _________. Each __________ holds one or more __________. Click the tabs to switch between them, or right-click for more options.
a)
Worksheets, Columns
b)
Workbook, worksheets
17.
There are _______ ways to view a worksheet. Simply click a command to select the desired view. 
a)
One
b)
Two
c)
Three
d)
Four
18.
The _____________________ lets you access common commands no matter which tab is selected. You can customize the commands depending on your preference.
a)
Quick Access Tool Bar
b)
BackStage View
c)
Home Tab
d)
View Tab
19.
The _____________________ lets you access common commands no matter which tab is selected. You can customize the commands depending on your preference.
a)
Quick Access Tool Bar
b)
BackStage View
c)
Home Tab
d)
View Tab
20.
Excel 2016 uses a ______ Ribbon system instead of traditional menus. Each _____ will have one or more groups.
a)
Tabbed, Tab
b)
Quick Access, Ribbon
21.
Some _________ will have an ________ you can click for more options.
a)
Groups, arrow
b)
Tabs, Arrow
22.
You can add any feature of Excel to the ______________  so that you can easily access it from anywhere 
a)
Ribbon
b)
Quick Access Tool Bar
23.
When you create or edit a workbook, you'll use the Save command to save your changes.
a)
Save
b)
Save As
24.
Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?
a)
Hyperlink
b)
Web link
25.
Alicia needs to delete the data in cell B5.  Which command would she select?
a)
Clear
b)
Copy
26.
Where can you find the Insert Function button in Microsoft Excel?
a)
Formula bar
b)
Status bar
27.
Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?
a)
Cell box
b)
Address box
c)
Name box
28.
In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
a)
AutoFit
b)
Smart Fit
29.
Joan has a table that includes demographic information about her employees.  What does all the information about one employee represent?
a)
Row
b)
Column
30.
Jennifer needs to identify the values in column B for a statistics report.  Which type of entry should she use in the column header?
a)
Values
b)
labels
31.
Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?
a)
Format cells
b)
Number
32.
The drop-down menu in the Number group is called the __________ drop-down.
a)
Number Format
b)
General
33.
To insert a new ________: Locate and select the New _____ button near the bottom-right corner of the Excel window.
a)
Worksheet
b)
Workbook
34.

Which of the following is not an arithmetic operator?

a)

+

b)

-

c)

*

d)

]

35.

Per the order of operations, what is the answer to this formula: =2*(2+2)?

a)

6

b)

8

c)

4

d)

2

36.

Per the order of operations, what is the answer to this formula: =2*2+2?

a)

6

b)

8

c)

4

d)

2

37.

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

a)

A9

b)

A$9

c)

$A$9

d)

A9:E9

38.

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

a)

A9

b)

A$9

c)

$A$9

d)

A9:E9

39.

To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).

a)

TRUE

b)

FALSE

40.

The order of operations determines which parts of a formula are calculated before other parts of the formula.

a)

TRUE

b)

FALSE

41.

The formula = 6 * 2 + 3 produces the same result as = 6 * (2 + 3).

a)

TRUE

b)

FALSE

42.

Pre-designed and formatted files called ______ help to create new worksheets quickly.

a)

Documents

b)

Templates

c)

Folders

d)

Cell Reference

43.

The electronic spreadsheet made of cells and organized by rows and columns is known as the _____.

a)

Document

b)

Presentaion

c)

Publicaiton

d)

Worksheet

44.

Letters of the alphabet going across the top of the spreadsheet.

a)

Title Bar

b)

Column Labels

c)

Row Labels

d)

Status Bar

45.

Numbers down the left side of the spreadsheet.

a)

Status Bar

b)

Formula Bar

c)

Column Labels

d)

Row Labels

46.

The intersection of a column and a row is called a __________.

a)

Four-way Stop

b)

Formula Bar

c)

Cell

d)

Template

47.

A cell that has a dark border around it.

a)

Jail Cell

b)

Sleepy Cell

c)

Active Cell

d)

Stem Cell

48.

The ________ contains a grid of columns and rows, the formula bar and the ribbon.

a)

Worksheet Window

b)

Document Window

c)

Presentation Window

d)

Publication Window

49.

The area is located at the bottom of the Excel window and provides information and options for your worksheet project.

a)

Scroll Bars

b)

Status Bar

c)

Salad Bar

d)

Formula Bar

50.

A selection of two or more cells is known as a ____.

a)

Cluster

b)

Range

c)

Conglomorate

d)

Big mess

51.

A ____ is another name for an equation used in Excel.

a)

Formula

b)

Calculation

c)

Mode Indicator

d)

Template

52.

Every Excel formula/equation must begin with _____.

a)

an equal sign

b)

please and thank you

c)

cell reference

d)

a prayer

53.

The ____ performs the arithmetic calculations in a formula.

a)

Calculator

b)

Grid-lines

c)

Status Bar

d)

Operator

54.

Numerical data entered into the spreadsheet cells will appear _____ according to place-value.

a)

Magically

b)

Right Aligned

c)

Left Aligned

d)

Centered

55.

Any data (text or numerical) entered into a cell will appear in the active cell as well as in the ____ ____.

a)

Status Bar

b)

Scroll Bar

c)

Outside Window

d)

Formula Bar

56.

Which function calculates the TOTAL (adds all the cells in the range together)?

a)

SUM

b)

AVERAGE

c)

MAX

d)

MIN

57.

Which function calculates the MEAN of a range of cells (adds all the cells together and then divides by the number of cells)?

a)

MIN

b)

AVERAGE

c)

COUNT

d)

MAX

58.

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

a)

SUM

b)

COUNTA

c)

MIN

d)

MAX

59.

Which function returns the highest value in a range?

a)

SUM

b)

AVERAGE

c)

MAX

d)

MIN

60.

Which function returns the lowest value in a range?

a)

SUM

b)

AVERAGE

c)

MAX

d)

MIN

61.

Which function would you use instead of this formula: =B1+B2+B3+B4+B5+B6+B7?

a)

=SUM(B1:B7)

b)

=COUNT(B1:B7)

c)

=AVERAGE(B1:B7)

d)

=MAX(B1:B7)

62.

Which function would you use instead of this formula: =(B1+B2+B3+B4)/4?

a)

=SUM(B1:B4)/4

b)

=COUNT(B1:B4)/4

c)

=AVERAGE(B1:B4)/4

d)

=MAX(B1:B4)/4

63.

Which function was used in E1?

a)

=COUNT(A1:A9)

b)

=COUNTA(A1:A9)

c)

=COUNTBLANK(A1:A9)

64.

Which function was used in E2?

a)

=COUNT(B1:B9)

b)

=COUNTA(B1:B9)

c)

=COUNTBLANK(B1:B9)

65.

Which function was used in E3?

a)

=COUNT(B1:B9)

b)

=COUNTA(B1:B9)

c)

=COUNTBLANK(B1:B9)

66.

Which function was used in E5?

a)

=SUM(B1:B9)

b)

=COUNT(B1:B9)

c)

=AVERAGE(B1:B9)

67.

Which function was used in E6?

a)

=SUM(B1:B9)

b)

=MIN(B1:B9)

c)

=MAX(B1:B9)

68.

Which function was used in E7?

a)

=SUM(B1:B9)

b)

=MIN(B1:B9)

c)

=MAX(B1:B9)

69.

Which of the following will return your worksheet to 100% with one click?

a)

A

b)

B

c)

C

d)

D

70.

Which cell would you click to freeze Rows 1-5 and Column A?

a)

A5

b)

B5

c)

A6

d)

B6

Similar Resources on Wayground

Всё об Excel

72 questions

Всё об Excel

quiz

Worksheet

•

1st - 12th Grade

Bedir Grade 5 ICT

68 questions

Bedir Grade 5 ICT

quiz

Worksheet

•

5th Grade

Quis B-CONFIG

70 questions

Quis B-CONFIG

quiz

Worksheet

•

1st - 10th Grade

KT LỚP 3_HĐH _TT VÀ TM

74 questions

KT LỚP 3_HĐH _TT VÀ TM

quiz

Worksheet

•

3rd - 6th Grade

ICDL - LỚP 5 - Kết nối với mạng máy tính

68 questions

ICDL - LỚP 5 - Kết nối với mạng máy tính

quiz

Worksheet

•

5th Grade

Lesson 1+2 Theme 2 Grade 5

70 questions

Lesson 1+2 Theme 2 Grade 5

quiz

Worksheet

•

5th Grade

Latihan Soal Microsoft Word

68 questions

Latihan Soal Microsoft Word

quiz

Worksheet

•

KG - 12th Grade

TES PAS INF SUSULAN

71 questions

TES PAS INF SUSULAN

quiz

Worksheet

•

1st - 5th Grade