Logo
미로
quiz thumbnail
Freestyle
Middle 6
Tech

EXCEL QUIZ

avatar

LUKAS SETYO WI

58

20 questions

Allow incorrect answer

Hide answer

public quiz

# 1Multiple Choice

Microsoft Excel is what kind of software?

Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
# 2Multiple Choice

An Excel file format extension is

doc
xls
txt
mp3
# 3Multiple Choice

The numbers in Excel represent the...

Rows
Columns
Cells
Data
# 4Multiple Choice

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

Select the data to be graphed.
Select the Insert Tab
Choose a chart from the ribbon
Double click the active cell
# 5Multiple Choice

To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.

&
$
=
+
# 6Multiple Choice

What function adds all of the numbers in a range of cells?

AVERAGE
MIN
MAX
SUM
# 7Multiple Choice

To add chart data in Excel, go to the __________ ribbon.

Home
Data
Insert
View
# 8Multiple Choice

What does the mouse look like in a spreadsheet?

Arrow
Pointer
Two headed arrow
Selection cross
# 9Multiple Choice

If I want to find an average of cells A1 through A25, which formula would I use?

=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
# 10Multiple Choice

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? 

=(A1+A2+A3)/4
A1+A2+A3/4
=A1+A2+A3^4
(A1+A2) + A3/4
# 11Multiple Choice

What is this icon?

Question image
Sum
AutoSum
Insert Function
Object
# 12Multiple Choice

What is this icon?

Question image
Sum
AutoSum
Insert Function
Object
# 13Multiple Choice

What is this icon?

Question image
Zoom
Sort and Filter
Symbol
Merge and Center
# 14Multiple Choice

Which of the following methods cannot be used to enter data in a cell

Pressing an arrow key
Pressing the Tab key
Pressing the Esc key
Clicking on the formula bar
# 15Multiple Choice

When a label is too long to fit within a worksheet cell, you typically must

Shorten the label
Increase the column width
Decrease the column width
Adjust the row height
# 16Multiple Choice

In MS-Excel numeric value can be treated as a label value if it precedes with

Apostrophe (")
Exclamation (!)
Hash (#)
None of these
# 17Multiple Choice

What is the shortcut key to hide entire column?

CTRL + −
CTRL + 0
CTRL + H
CTRL + C
# 18Multiple Choice

The advantage of using a spreadsheet is:

calculations can be done automatically.
changing data automatically updates calculations
more flexibility
All of the above
# 19Multiple Choice

Numbers down the left side of the spreadsheet.

Question image
Status Bar
Formula Bar
Column Labels
Row Labels
# 20Multiple Choice

What is the icon for Microsoft Excel?

A
Choice 0
B
Choice 1
C
Choice 2
D
Choice 3
Share to Google Classroom

This quiz was created using a premium map. Access is restricted due to plan expiration.