WorksheetsSemi-Final Exam in Empowerment Technology
Total questions: 50
Worksheet time: 25mins
Microsoft Excel is what type of software?
Word Processing
Drawing
Presentation
Spreadsheet
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
Cell address
Worksheet
Formula
None of these
Which symbol must you use to begin a formula?
=
+
-
/
How do you make a cell the active cell?
Click INSERT CELL
Click INSERT CELL
Click the ACTIVE button
Click on the cell
Excel allows you to...
Work with data
read stories
invent ideas
write stories
A selection of two or more cells is called a ________. Example A1:A4
cells
Table
range
collective cells
Columns in a spreadsheet are identified by?
Numbers
Symbols
Letters
NameBox
Rows in a spreadsheet are identified by?
Numbers
Symbols
Letters
NameBox
What does this icon do?
Change the font color
Center the text
Change the font size
Fill the cell with color
What does this icon do?
Change the font color
Center the text
Change the font size
Fill the cell with color
Sort
AutoSum
Borders
Merge & Center
When you double click on the line between two column names to make the column width automatically fit the longest piece of text.
AutoFill
AutoFix
AutoFit
AutoFax
When you click on the green square at the bottom of a formula cell, then drag it down the column or across the row to copy the relative formula.
AutoFill
AutoFix
AutoFit
AutoFax
Numbers in Excel is automatically aligned ____.
Right
Left
Center
Justify
Intersection of a row and a column is called a _____.
Row
Column
Cell
Worksheet
What is a file which contains one or more spreadsheets?
spreadsheet
workbook
cell
cell range
Which is an example of a cell address?
126
A9
=SUM
75/65
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
Insert
Formula bar
Tables
Textbox
What would be a correct formula for sum in excel?
=SUM(B3:B9)
=SUMB3+B9
SUM(B3:B9)
=ADD(B3:B9)
What is a worksheet?
A "page" within an Excel workbook that contains columns rows and cells
Homework
Something you get at school
None of these
The function that lets you add up a range of cells or values.
AVERAGE()
SUM()
MIN()
MAX()
What function was used to find the highest data?
AVERAGE()
MIN()
SUM()
MAX()
What function was used to find the lowest data?
AVERAGE()
MIN()
SUM()
MAX()
The function COUNT is specific for _________________.
Counting cells
Counting text
Counting number
Counting tables
What function in excel that joins the text from two or more cells?
Concatenate()
Proper()
Left()
Mid()
Which formula will calculate the average based on a condition? (return the average of sales if over Php20)
average()
countif()
averageif()
sumif()
Which formula would you use to calculate how many sales are over Php20 from a series?
sum()
sumif()
count()
countif()
A_________ is a built-in mathematical formula included in excel.
Function
Cell
Formula
A4:A16 refers to a group of adjacent cells.
Cell range
Cell
Value
label
The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____.
A1 - J15
A1 ; J15
A1 : J15
A1 , J15
What function will tell you the current date AND time?
=DATE()
=DAYS360()
=NOW()
=CURRENT()
Which function will only add up the numbers of a range if they match a logical test?
=ADDIF()
=IF()
=SUMIF()
=SUM()
When number signs (#####) are displayed in the cell, it means:
The formula in the cell is wrong
There are too many characters in the cell to be displayed with the current cell width.
The decimal point placement in the cell is wrong
In the formula
=SUMIF(D5:D14,"Pumpkin",E5:E14),
which of the following is the range of cells to be added?
D5:D14
"Pumpkin"
E5:E14
None of these
What does criteria range in a formula refer to?
The worksheet data to be included in the formula's results
The range containing a condition that must be met in order for data to be included in the result
The type of formula being used for the calculation
The type of data contained in the cells to be included in the formula
This function is used to count the number of empty cells.
COUNT()
COUNTA()
COUNTEMPTY()
COUNTBLANK()
This function is used to count the number of cells that have text in them.
COUNT()
COUNTA()
COUNTEMPTY()
COUNTBLANK()
This function is used to determine the length of a text string.
STRING()
LENGTH()
COUNT()
LEN()
If cell A2 contains “Today is Monday” the result of the function =LEN(A2) would be....
3
7
10
15
Find the total January revenue.
=SUM(B2,B3)
=SUMIF(B2:B3)
=TOTAL(B2:B3)
=PRODUCT(B2,B3)
What do you need to include when you are entering text into your formula?
' '
( )
" "
{ }
The arithmetic mean is one of the descriptive statistics measures, in MS-Excel the function is called_____.
Median()
Rank()
Average()
Sum()
Data in a spreadsheet table can be sorted by single or multiple columns and alphabetically and numerically.
True
False
SUM, AVERAGE, MAX and VLOOKUP are examples of what?
Functions
Tables
Formula
Statistical tools
Which formula would display "Yes" if D13 is greater than 0?
=IF(D13>0,"Yes","No")
=IF(D13<0,"Yes","No")
=IF(D13>0:"Yes","No")
=IF(D13<0:"Yes","No")
Which formula would subtract D12 from D13?
=D13-D12
=sum(D12-D13)
=D12-D13
=sum(D13-D12)
A grid of cells organized into rows and columns in which we enter and store our data.
Spreadsheet Area
Name Box
Insert Function
All of the above
This excel buttons are located at the extreme right-top corner of the excel window.
Window Control Bottons
Select Buttons
Command Buttons
None of these
Are rectangular tabs visible on the bottom left of the excel workbook.
Worksheet tabs
Row Headers
Title Bar
Scroll Bar
Cell orientation allows you to _____.
change cell contents from number to text
color the text under condition
change the direction of the text
change the appearance of the cell
