Font size
WorksheetsExcel exam
Total questions: 16
Worksheet time: 25mins
Which of the following is a correctly named cell?
8B
B8
8-B
BB-8
A-------------------- is where a row and column meet
sheet
formula
blank
cell
Which symbol tells the computer you want to create an formula?
$
+
-
=
Select----------------- from the functions drop-down menu to add a set of numbers.
average
sum
count
max
What is the cell in the worksheet in which you can type data?
Active cell
Main cell
Open cell
Absolute cell
Rows are labeled by-------------------------.
numbers
letters
symbols
colors
The contents in cell A1 through A5 are 6,3,4,7,9 .What function would return the answer 9?
=MAX(A1:A5)
=AVG(A1:A5)
=SUM(A1:A5)
MIN(A1:A5)
To make borders around data that you entered using :
A command line above the worksheet where text ,numbers, and formula are entered into a worksheet.
Insert
Formula bar
Tables
Multiplication symbol in Microsoft Excel
$
*
x
&
###### means
You've misspelled something.
The cell is not wide enough.
To delete data from your spreadsheet
Under which menu and grouping of commands will you find the Merge& center tool?
Insert>Table>Merge & center
Home>Editing>Merge & center
Home>Alignment>Merge & center
What is a worksheet?
A "page" within an Excel workbook that contains columns rows and cells
Homework
Something you get at school
Use the following screen to answer the questions. 1- The content of (B3) cell is ……………..….…
2- The active cell reference is ……………..….…
3- The highlighted column’s name is……………..….…
(a)
4- The cell reference for these cells : (The weight, Ali, 45,Nawal)
(a)
Mention two types of Data we can use in MS Excel:
