NEW
Font size
WorksheetsMicrosoft Excel Basics
Total questions: 20
Worksheet time: 13mins
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
An Excel file format extension is
doc
xls
txt
mp3
The numbers in Excel represent the...
Rows
Columns
Cells
Data
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
To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.
&
=
#
*
What function adds all of the numbers in a range of cells?
Calculate
Compute
Sum
Max
To sort data in Excel, go to the __________ ribbon.
Home
Data
Insert
View
What does the mouse look like in a spreadsheet?
Arrow
Pointer
Two headed arrow
Selection cross
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)
What is this icon?
Sum
AutoSum
Insert Function
Object
What is this icon?
Sum
AutoSum
Insert Function
Object
What is this icon?
Zoom
Sort and Filter
Symbol
Merge and Center
Which of the following methods cannot be used to enter data in a cell
a. Pressing an arrow key
b. Pressing the Tab key
c. Pressing the Esc key
d. Clicking on the formula bar
When a label is too long to fit within a worksheet cell, you typically must
a. Shorten the label
b. Increase the column width
c. Decrease the column width
d. Adjust the row height
In MS-Excel numeric value can be treated as a label value if it precedes with
A. Apostrophe (')
B. Exclamation (!)
C. Hash (#)
D. None of these
What is the shortcut key to hide entire column?
A. CTRL + −
B. CTRL + 0
C. CTRL + H
D. CTRL + C
The advantage of using a spreadsheet is:
A. calculations can be done automatically.
B. changing data automatically updates calculations
C. more flexibility
D. All of the above
Numbers down the left side of the spreadsheet.
Status Bar
Formula Bar
Column Labels
Row Labels
What is the icon for Microsoft Excel?
