Share MS Excel Game 2
Save to Folder
Can you form ONE WORD with the following letters? T-E-E-H-S-K-R-O-W
WORKSHEET
Which of the following represents a cell in MS Excel? 1C5, 15C, A15, CC, AA
A15 is a cell. A cell has the column before the row.
What is the main difference between these TWO formulas. =AVERAGE(A1 : E1) and = AVERAGE(A1,E1) ?
=AVERAGE(A1 : E1) used the values from cells A1 through E1, whereas =AVERAGE(A1,E1) used the values in A1 and E1 only.
List at least 2 functions or formulas we learned today in MS Excel.
SUM,AVERAGE, MAX, MIN, COUNT, AVERAGE, LEN, ADDITION OPERATION, ...
One method to create table in MS Excel. Remember the key word in your answer.
HIGHLIGHT the data and choose "All Borders" in the Ribbon. Or, HIGHLIGHT the data and choose "Format Cells" from the Ribbon or from the right click menu.
What is the difference between "Portrait Orientation" and "Landscape Orientation"
Landscape images are captured in a horizontal layout while portrait images are captured in a vertical layout.
In the "Ribbon" what B,I, and U are used for?
B is for Bold, I for Italic. and U for Underline.
In MS Excel, how Bold, Italic, and Underline are applied to the text or data? Remember the key word.
Highlight the cells and click B, I, or U for Bold, Italic, and Underline respectively.
How to recognize the formula bar in MS Excel?
The long bar on top of columns or fx bar.
Find the 4 missing letters to complete the word. "_PER_T_O_S"
The missing letters are: O, A, I, N The word is "OPERATIONS"
Open MS Excel worksheet, and write a simple formula to list the first 10 counting numbers.
Your teacher will solve this question in MS Excel.
Open MS Excel worksheet, and write a simple formula to list the first 10 even numbers.
Your teacher will go over this question in MS Excel.
Open MS Excel worksheet, and write a simple formula to list the first 10 odd numbers.
Your teacher will check your work.
What language did we use in MS Excel Programming/Coding
VBA = Visual Basic for Applications
Name at least 1 tool used in VBA or MS Excel Programming/Coding
CommandButton, OptionButton, CheckBox, Label, TextBox, ListBox, DropBox,..
What tool is best used in MS Excel Form for Gender (Male, Female)
OptionButton.
