Font size
WorksheetsMS Excel Quizz
Total questions: 20
Worksheet time: 9mins
Formula in MS Excel starts with __________
*
-
?
=
Which of the following keyboard shortcuts is used 'Autosum', a quick and easy way of adding multiple values?
Ctrl + =
Shift + =
Tab + =
Ctrl + 1
Alt + =
What is the shortcut to enable filtering of selected cells in MS Excel?
Ctrl + F
Alt + Click + L
Ctrl + Shift + L
Shift + F
In MS Excel, to add numeric values in column D, from rows D10 to D15, the formula that should be used is :
=SUM (D10, D15)
=COUNT (D10, D15)
=SUM (D10:D15)
=COUNT (D10:D15)
Gridlines and formula bar which tab in MS Excel?
Home Tab
Insert Tab
Data Tab
View Tab
Page Layout
When you right-click and select the 'Format Cells' option in MS Excel 2010, which of the following Tab is NOT visible
Font
Sheet
Border
Alignment
Fill
To multiply items in Excel, you would use:
/
-
*
X
=
A program using a table comprising of rows, columns and cells.
MS Word
MS Excel
MS Outlook
MS PowerPoint
You are not able to open, save, rename and close a file in Excel the way you would in MS Word.
TRUE
FALSE
The first cell in a worksheet is what?
1A
FX
A1
Cell Name
This is the:
entry bar
group
name box
insert function
The letters in Excel represent the...
Rows
Cells
Columns
Data
An Excel file format extension is
doc
xls
txt
csv
What are lines that can be applied around worksheet cells or objects?
Borders
Gridlines
Underlines
Boundaries
Letters of the alphabet going across the top of the spreadsheet.
Title Bar
Status Bar
Column Bar
Row Bar
The intersection of a column and a row is called a __________.
Template
Four-way Stop
Formula Bar
Cell
Template
What icon do you choose to align the text at the top, middle, or bottom of a cell?
What is this icon?
Fill
Merge and Center
Alignment
Sort and Filter
Numbers down the left side of the spreadsheet.
Status Bar
Formula Bar
Column Bar
Row Bar
The numbers in Excel represent the...
(a)
