Font size
WorksheetsMicrosoft Excel
Total questions: 46
Worksheet time: 32mins
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
The letters in Excel represent the...
Rows
Columns
Cells
Data
The numbers in Excel represent the...
Rows
Columns
Cells
Data
Letters of the alphabet going across the top of the spreadsheet.
Title Bar
Column Labels
Row Labels
Status Bar
Numbers down the left side of the spreadsheet.
Status Bar
Formula Bar
Column Labels
Row Labels
These items allow you to move up & down or left & right in a worksheet that is to large to fit on the screen at once.
Row Bars
Column Bars
Scroll Bars
Home Bars
What icon do you choose to align the text at the top, middle, or bottom of a cell?
What is this icon?
Zoom
Sort and Filter
Symbol
Merge and Center
The cell address of the highlighted cell is
C
4
A4
C4
These are known as
workbooks
worksheets
formula bar
cell
What does the indicated icon do in the red box?
Apply underline
Apply italic
Make text bigger
Apply bold
What does the indicated icon in the red box do?
Change number of active cells
Change font colour
Change font size
Change the number of calculations
Excel refers to files as...
Presentations
Databases
Workbooks
Documents
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
What is the cell in the worksheet in which you can type data?
Main cell
Open cell
Active cell
Absolute cell
Text in Excel is automatically aligned _____________.
Right
Left
Center
Justify
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)
Numbers in Excel are automatically aligned ____________?
Left
Right
Center
Justified
Which of these would multiply the numbers from A3 to A6
*(A3:A6)
=Multiplay(A3:A6)
=A3*A4*A5*A6
=Sum(a3*a6)
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
What do you call the blank boxes on a excel sheet
cell
info
Squares
Spots
How do you make a cell into the active cell
Cells are always active
Click INSERT Cell
Click on the Cell
Click the ACTIVE button
What is the name of this Cell ?
6B
A5
6A
B6
To sort names in a worksheet, we can use ____ button
Here in Excel, Which button will you select to calculate total marks ?
What is the cell address of the pink cell?
A1
1A
D3
3D
An Excel file format extension is
doc
xls
txt
mp3
What is this icon?
Sum
AutoSum
Insert Function
Object
What is this icon?
Sum
AutoSum
Insert Function
Object
What is this button used for?
Creating a new document
Opening a document
Saving a document
Inserting a picture
Which of these is the PASTE button?
True/ False? The sum function is easier to use when your'e working with more than a few numbers.
(a)
The (a) function returns the smallest numeric value in the data provided.
The (a) function in Excel is the simplest form of a mathematical function, which just returns the maximum values out of the selected values or array.
Which of the following formulas below illustrates the correct function to create the Sum (Range)?
=SUM(
=SUM(Range)
SUM=(Range)
(a) function measures central tendency, which is the location of the center of a group of numbers in a statistical distribution.
_____ (Range) function in Excel returns the number of cells that contain numbers in a given range.
COUNTA
COUNT
COUNTBLANK
COUNTIFS
True/False? You can also use other functions to count different types of values in a range.
(a)
______ counts all values in a range, including numbers and text?
COUNTBLANK (Range)
COUNTIFS (Range. Criteria)
COUNT (Range)
COUNTA (Range)
Write down the format used to create the MAX formula in Excel below.
(a)
